diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-01-23 20:36:30 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-01-23 20:36:30 +0000 |
| commit | edfca4b98b44f336ca88b2adf4dfbe6b59d7b146 (patch) | |
| tree | 2bcc7fa39bf826c07fbd978c21f813289d8f1f17 /src/interfaces/odbc/pgtypes.c | |
| parent | 3de8407ea7d3c6d3343242ed72cefd4a51373861 (diff) | |
| download | postgresql-edfca4b98b44f336ca88b2adf4dfbe6b59d7b146.tar.gz postgresql-edfca4b98b44f336ca88b2adf4dfbe6b59d7b146.zip | |
Subject: Bug in SQLForeignKeys()
Query used for checking foreign key triggers
returns too many results when there're more than one foreign
key in a table. It happens because only table's oid is used to
link between pg_trigger with INSERT check and pg_trigger with
UPDATE/DELETE check.
I think there should be enough to add following conditions
into WHERE clause of that query:
AND pt.tgconstrname = pg_trigger.tgconstrname
AND pt.tgconstrname = pg_trigger_1.tgconstrname
/Constantin
Diffstat (limited to 'src/interfaces/odbc/pgtypes.c')
| -rw-r--r-- | src/interfaces/odbc/pgtypes.c | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/interfaces/odbc/pgtypes.c b/src/interfaces/odbc/pgtypes.c index 4263eea7b85..ebee8ab262f 100644 --- a/src/interfaces/odbc/pgtypes.c +++ b/src/interfaces/odbc/pgtypes.c @@ -217,7 +217,9 @@ Int2 pgtype_to_sqltype(StatementClass *stmt, Int4 type) case PG_TYPE_XID: case PG_TYPE_INT4: return SQL_INTEGER; - case PG_TYPE_INT8: return SQL_BIGINT; + /* Change this to SQL_BIGINT for ODBC v3 bjm 2001-01-23 */ + case PG_TYPE_INT8: return SQL_CHAR; + case PG_TYPE_NUMERIC: return SQL_NUMERIC; case PG_TYPE_FLOAT4: return SQL_REAL; |