Re: setCatalog
От | Dave Cramer |
---|---|
Тема | Re: setCatalog |
Дата | |
Msg-id | 1050324333.30093.308.camel@inspiron.cramers обсуждение исходный текст |
Ответ на | Re: setCatalog ("Patrik Lundgren" <patrik@mensa.se>) |
Ответы |
Re: setCatalog
|
Список | pgsql-jdbc |
Patrick, Ok, I don't have a problem putting in the foreign key stuff, as it is above and beyond the spec, and also something postgres supports. Kris Jurka did most of the work on the imported/exported keys, he may have an opinion as well? As far as the setCatalog goes, this is probably OK too, if you get it working, I would support it. Dave On Mon, 2003-04-14 at 08:04, Patrik Lundgren wrote: > >> Another question I have asked about earlier is about > >> DatabaseMetaData.getExportedKey(). I got the answer that it only > works > >> if one of the columns in a constraint is a primary key. My problem is > > >> that I get an empty resultSet when asking for keys I know exist. > >> Someone else beside me who thinks this is wrong, even though the jdbc > > >> spec might say otherwise? > > >Can you define how you expect this to work? What are you looking for; > Foreign Keys that are related to non-primary keys in another table? > > Well since a can create a foreign key that is related to a non-primary > key in another table it only seems natural that I should be able to find > out if it's there also...? The only demand from postgres seems to be > that the column in the other table is unique, not a primary key also. > > jxDBCon returns the foreign keys, pgAdminII does also... By the way, > jxDBCon has a working setCatalog. Don't ask me how it's done, but it > works. It does have some other big problems though that makes it nearly > unusable for my cause, like getting 4096 as the length of all arrays. > > In MSSQL for example I don't think you can create a foreign key if one > of the columns isn't a primary key, but in postgres I know it's > possible, therefore I think they should be able to be gotten as well, > please correct me if I'm wrong. > > /Patrik > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html -- Dave Cramer <Dave@micro-automation.net>
В списке pgsql-jdbc по дате отправления: