Skip site navigation (1) Skip section navigation (2)

Error: for type 1700

From: Tomas <merkurit(at)takas(dot)lt>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Error: for type 1700
Date: 2000-05-18 08:21:59
Message-ID: 3923A826.2C0CDE9B@takas.lt (view raw or flat)
Thread:
Lists: 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.

Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 2000-05-18 14:37:21
Subject: Re: Error: for type 1700
Previous:From: S.F. LeeDate: 2000-05-18 08:07:47
Subject: Postmaster is getting bigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group