pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedError: for type 1700
2+ messages / 2 participants
[nested] [flat]
* Error: for type 1700
@ 2000-05-18 08:21 Tomas <merkurit@takas.lt>
2000-05-18 14:37 ` Re: Error: for type 1700 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Tomas @ 2000-05-18 08:21 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Error: for type 1700
2000-05-18 08:21 Error: for type 1700 Tomas <merkurit@takas.lt>
@ 2000-05-18 14:37 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2000-05-18 14:37 UTC (permalink / raw)
To: Tomas <merkurit@takas.lt>; +Cc: pgsql-interfaces
Tomas <merkurit@takas.lt> writes:
> ERROR from backend during clear: 'ERROR: Can't find a default operator
> class for type 1700.
6.5 doesn't have any support for indexes on NUMERIC columns. This
is fixed in 7.0 ... in the meantime I would think an integer column
would be a perfectly good substitute for NUMERIC(6,0) ...
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-05-18 14:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-18 08:21 Error: for type 1700 Tomas <merkurit@takas.lt>
2000-05-18 14:37 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox