Re: Problem with getImportedKeys / getExportedKeys

> -----Original Message-----
> From: Dave Cramer [mailto:Dave@micro-automation.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