From 3cec5b804de3d4ce79c71c63787a92c5e7ed3015 Mon Sep 17 00:00:00 2001 From: Kris Jurka Date: Fri, 18 Jun 2004 05:29:11 +0000 Subject: [PATCH] Foreign key information results should have column name FKTABLE_CAT instead of FK_TABLE_CAT. From jeff@bonevich.com. --- .../org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/interfaces/jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java b/src/interfaces/jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java index c608ae1e347..7a49878b1c5 100644 --- a/src/interfaces/jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java +++ b/src/interfaces/jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java @@ -2977,7 +2977,7 @@ public abstract class AbstractJdbc1DatabaseMetaData if (connection.haveMinimumServerVersion("7.4")) { String sql = "SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, "+ - "NULL::text AS FK_TABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, "+ + "NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, "+ "pos.n AS KEY_SEQ, "+ "CASE con.confupdtype "+ " WHEN 'c' THEN " + DatabaseMetaData.importedKeyCascade + -- 2.39.5