|
3 | 3 | * |
4 | 4 | * Copyright (c) 2000-2003, PostgreSQL Global Development Group |
5 | 5 | * |
6 | | - * $Header: /cvsroot/pgsql/src/bin/psql/describe.c,v 1.86 2003/10/17 00:57:04 tgl Exp $ |
| 6 | + * $Header: /cvsroot/pgsql/src/bin/psql/describe.c,v 1.87 2003/10/26 02:53:45 momjian Exp $ |
7 | 7 | */ |
8 | 8 | #include"postgres_fe.h" |
9 | 9 | #include"describe.h" |
@@ -549,7 +549,7 @@ objectDescription(const char *pattern) |
549 | 549 |
|
550 | 550 | appendPQExpBuffer(&buf, |
551 | 551 | ") AS tt\n" |
552 | | -" JOIN pg_catalog.pg_description d ON (tt.oid = d.objoidand tt.tableoid = d.classoidand d.objsubid = 0)\n"); |
| 552 | +" JOIN pg_catalog.pg_description d ON (tt.oid = d.objoidAND tt.tableoid = d.classoidAND d.objsubid = 0)\n"); |
553 | 553 |
|
554 | 554 | appendPQExpBuffer(&buf,"ORDER BY 1, 2, 3;"); |
555 | 555 |
|
@@ -1028,7 +1028,7 @@ describeOneTableDetails(const char *schemaname, |
1028 | 1028 | "SELECT t.tgname, pg_catalog.pg_get_triggerdef(t.oid)\n" |
1029 | 1029 | "FROM pg_catalog.pg_trigger t\n" |
1030 | 1030 | "WHERE t.tgrelid = '%s' " |
1031 | | -"and (not tgisconstraint " |
| 1031 | +"AND (not tgisconstraint " |
1032 | 1032 | " OR NOT EXISTS" |
1033 | 1033 | " (SELECT 1 FROM pg_catalog.pg_depend d " |
1034 | 1034 | " JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) " |
|