Re: [HACKERS] PG 7.3: Query Meta Data with the JDBC-driver

2002-12-02 Thread Rod Taylor
> We need contrib/array in 7.4 and unique name in pg_constraint Whelp. I'd like to make the constraint name unique too, but how do you coax everyone into renaming their existing constraints -- especially when there isn't an ALTER CONSTRAINT ... RENAME type statement? -- Rod Taylor <[EMAIL PROTEC

Re: [HACKERS] PG 7.3: Query Meta Data with the JDBC-driver

2002-12-02 Thread snpe
Query in getImportedKey work bad in postgresql. I ask on PostgreSQLlists for query like : SELECT DISTINCT n.nspname as pnspname,n2.nspname as fnspname, c.relname as prelname, c2.relname as frelname, t.tgconstrname, a.attnum as keyseq, ic.relname as fkeyname, t.tgdeferrable, t.tgini

Re: [HACKERS] PG 7.3: Query Meta Data with the JDBC-driver

2002-12-02 Thread Kris Jurka
On Mon, 2 Dec 2002, Henner Zeller wrote: > > Hi, > Just compiled the 7.3 branch from source and made some tests using the > JDBC driver coming with it. I did some tests with the henplus > JDBC-shell and noticed some problems quering the database meta data: > >o the foreign key name is 'wierd

[HACKERS] PG 7.3: Query Meta Data with the JDBC-driver

2002-12-02 Thread Henner Zeller
Hi, Just compiled the 7.3 branch from source and made some tests using the JDBC driver coming with it. I did some tests with the henplus JDBC-shell and noticed some problems quering the database meta data: o the foreign key name is 'wierd' --- DatabaseMetaData meta = conn.getMeta