Re: ordering of results returned from
От | Dave Cramer |
---|---|
Тема | Re: ordering of results returned from |
Дата | |
Msg-id | 1072907556.1946.12.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: ordering of results returned from DatabaseMetaData.getImportedKeys() (Kris Jurka <books@ejurka.com>) |
Список | pgsql-jdbc |
From the javadocs: Retrieves a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). They are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ. so what you are seeing is correct according to the docs. Dave On Wed, 2003-12-31 at 16:33, Kris Jurka wrote: > On Wed, 31 Dec 2003, peter royal wrote: > > > Here's the situation: > > > > I have a table that has multiple foreign keys to another table, and the > > key is a composite key (ie multiple fields). > > > > The results returned from DatabaseMetaData.getImportedKeys() seem > > "wrong" in that all the KEY_SEQ 1's are returned first and then all the > > 2's > > > > What version of the JDBC driver and what version of the database server > are you using? It should report results as you expect. > > Kris Jurka > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Dave Cramer 519 939 0336 ICQ # 1467551
В списке pgsql-jdbc по дате отправления: