From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(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-03-21 20:02:57 |
Message-ID: | 200303212002.h2LK2vF04668@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
This patch adds catalog prefixes to system catalog references for the
queries that assume schema support.
What I did not do was to duplicate other queries that reference system
tables that _don't_ assume schema code.
Comments?
---------------------------------------------------------------------------
Tom Lane wrote:
> 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
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 15.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2003-03-21 21:41:31 | Re: ODBC driver settings for BLOBs |
Previous Message | pg | 2003-03-21 17:10:17 | Re: password leak in mylog thru win odbc |