Hmm, your using ColdFusion, so that goes through the ODBC driver, which
picks up the 'primary key' by looking for an index named 'foo_pkey',
I think. Ah, here it is:
in interfaces/odbc/info.c:
sprintf(tables_query, select ta.attname, ia.attnum
from pg_attribute ta, pg_attribute ia,
Tom Lane wrote:
[EMAIL PROTECTED]">After fixing the several obvious syntax errors, it works fine for me:regression=# CREATE TABLE messageregression-# (regression(# msgid int4 not null,regression(# msgtext text,regression(# CONSTRAINT cons_001_pk PRIMARY KEY (msgid)regression(# );NOTICE:
Thomas Swan [EMAIL PROTECTED] writes:
AFIAK, it's a legal table creation statement.
The variant I showed is. The original one had an extraneous ON in the
FOREIGN KEY clause, and even more to the point all the column
declarations had column name and type name reversed. That's why I was
