Skip site navigation (1) Skip section navigation (2)

Re: quote_ident and schemas (was Re: [HACKERS] connectby

From: Joe Conway <mail(at)joeconway(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: quote_ident and schemas (was Re: [HACKERS] connectby
Date: 2002-11-23 17:47:57
Message-ID: 3DDFBF4D.6090708@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Joe Conway wrote:
> p.s. There are similar issues in dblink, but they appear a bit more 
> difficult to address. I'll attempt to get them resloved this weekend, 
> again in hopes to get them applied before 7.3 is released.
> 

Attached patch removes most (hopefully just the appropriate ones) calls in 
dblink to quote_ident, requiring the user to quote their own identifiers. I 
also added to the regression test a case for a quoted, schema qualified table 
name.

If it's not too late, I'd like this to get into 7.3, but in any case,
please apply to HEAD.

Thanks,

Joe

Attachment: dblink-fix.2002.11.23.1.patch
Description: text/plain (11.8 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-11-23 18:13:26
Subject: Re: regression failures
Previous:From: Tom LaneDate: 2002-11-23 17:36:57
Subject: Re: regression failures

pgsql-patches by date

Next:From: Tom LaneDate: 2002-11-23 19:02:03
Subject: Re: quote_ident and schemas (was Re: [HACKERS] connectby with schema)
Previous:From: Tom LaneDate: 2002-11-23 17:02:38
Subject: Re: Hierarchical queries a la Oracle. Patch.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group