| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, Jim Holliday <jholliday(at)aurigin(dot)com>, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: bug in info.c file - incorrect SQL |
| Date: | 2003-01-03 21:38:42 |
| Message-ID: | 11662.1041629922@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> The attached patch fixes this by creating a pn1 and pn2 alias for
> pg_namespace in FROM. It also improves some of the alias tags. Applied
> to ODBC CVS. Can someone run some tests on these?
I see another bug here:
The 7.3-and-up versions of these queries should explicitly prefix
"pg_catalog." to the names of all system catalogs (and types and
functions) they reference. This will make them bulletproof against
conflicts against user-defined names, which might appear in front of
the system names in the search path.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2003-01-04 00:20:04 | Re: bug in info.c file - incorrect SQL |
| Previous Message | Jim Holliday | 2003-01-03 21:34:45 | Re: bug in info.c file - incorrect SQL |