Error: for type 1700
| От | Tomas |
|---|---|
| Тема | Error: for type 1700 |
| Дата | |
| Msg-id | 3923A826.2C0CDE9B@takas.lt обсуждение исходный текст |
| Ответы |
Re: Error: for type 1700
|
| Список | pgsql-interfaces |
I am using postgresql 6.5.2 an new ODBC driver for postgresql. So I create this function ( may be someone can include this function in postgresql for compatibility, becouse it is defined in Microsoft SQL?): create function getdate() returns datetime as 'select datetime(\'now\'::abstime)' language 'sql' And I try to execute this command (this is part of pgodbc drivers log file): conn=34146428, query='BEGIN' conn=34146428, query='CREATE TABLE I03_DKD (I03_KODAS_ZS CHAR( 12) DEFAULT ' ' NOT NULL, I03_KODAS_DH CHAR( 12) DEFAULT ' ' NOT NULL, I03_EIL_NR NUMERIC(6, 0) DEFAULT 0 NOT NULL, I03_KODAS_SSD CHAR( 12) DEFAULT ' ' NOT NULL, I03_KODAS_SSC CHAR( 12) DEFAULT ' ' NOT NULL, I03_VAL_SUMD NUMERIC(18, 2) DEFAULT 0 NOT NULL, I03_VAL_SUMC NUMERIC(18, 2) DEFAULT 0 NOT NULL, I03_SUMA NUMERIC(12, 2) DEFAULT 0 NOT NULL, I03_KODAS_IS CHAR( 12) DEFAULT ' ' NOT NULL, I03_KODAS_OS CHAR( 12) DEFAULT ' ' NOT NULL, I03_KODAS_OS_S CHAR( 12) DEFAULT ' ' NOT NULL, I03_SERIJA CHAR( 12) DEFAULT ' ' NOT NULL, I03_ADDUSR CHAR( 12) DEFAULT ' ' NOT NULL, I03_USERIS CHAR( 12) DEFAULT ' ' NOT NULL, I03_R_DATE datetime DEFAULT getdate() NOT NULL, PRIMARY KEY (I03_KODAS_ZS,I03_KODAS_DH,I03_EIL_NR))' NOTICE from backend during send_query: 'NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'i03_dkd_pkey' for table 'i03_dkd' ' ERROR from backend during clear: 'ERROR: Can't find a default operator class for type 1700. ' conn=34146428, query='COMMIT' Can someone explain me this error? Thanks. Tomas.
В списке pgsql-interfaces по дате отправления: