From: | "Vianen, Jeroen van" <jeroen(dot)van(dot)vianen(at)satama(dot)com> |
---|---|
To: | "'Dave(at)micro-automation(dot)net'" <Dave(at)micro-automation(dot)net>, "'Jason Davies'" <jason(at)netspade(dot)com> |
Cc: | "'PostgreSQL JDBC'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Problem with getImportedKeys / getExportedKeys |
Date: | 2002-01-15 13:47:25 |
Message-ID: | F9926D32A30ED511B8E30050044AB52E10152B@ams010.satama.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
> -----Original Message-----
> From: Dave Cramer [mailto:Dave(at)micro-automation(dot)net]
> Sent: Tuesday, January 15, 2002 14:37
> To: 'Vianen, Jeroen van'; 'Jason Davies'
> Cc: 'PostgreSQL JDBC'
> Subject: RE: [JDBC] Problem with getImportedKeys / getExportedKeys
>
>
> So the big question is?
>
> How should postgres be handling this? Should we do a case-insensitive
> search?
Maybe.
Please look closely which columns are reported as PK or as FK in my new
PostgreSQL output, and whether they are reported as imported or exported
keys. There are a lot of differences ;-)
> PostgreSQL says:
>
> # java -classpath jdbc7.2dev-1.2.jar:. TestKeys users
> Imported keys:
> PKTABLE_NAME = users_roles
> PKCOLUMN_NAME = userid
> FKTABLE_NAME = users
> FKCOLUMN_NAME = userid
> Exported keys:
>
> # java -classpath jdbc7.2dev-1.2.jar:. TestKeys users_roles
> Imported keys:
> Exported keys:
> PKTABLE_NAME = users_roles
> PKCOLUMN_NAME = userid
> FKTABLE_NAME = users
> FKCOLUMN_NAME = userid
> PKTABLE_NAME = users_roles
> PKCOLUMN_NAME = userid
> FKTABLE_NAME = users
> FKCOLUMN_NAME = userid
>
>
> Whereas Oracle says:
>
> # java -classpath classes12.zip:. TestKeys USERS
> Imported keys:
> Exported keys:
> PKTABLE_NAME = USERS
> PKCOLUMN_NAME = USERID
> FKTABLE_NAME = USERS_ROLES
> FKCOLUMN_NAME = USERID
>
> # java -classpath classes12.zip:. TestKeys USERS_ROLES
> Imported keys:
> PKTABLE_NAME = ROLES
> PKCOLUMN_NAME = ROLENAME
> FKTABLE_NAME = USERS_ROLES
> FKCOLUMN_NAME = ROLENAME
> PKTABLE_NAME = USERS
> PKCOLUMN_NAME = USERID
> FKTABLE_NAME = USERS_ROLES
> FKCOLUMN_NAME = USERID
> Exported keys:
Cheers,
Jeroen
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-01-15 15:36:20 | Re: Explicit typing of numeric types |
Previous Message | Dave Cramer | 2002-01-15 13:37:17 | Re: Problem with getImportedKeys / getExportedKeys |