On Fri, 22 Nov 2002 15:21:48 -0800
Joe Conway <[EMAIL PROTECTED]> wrote:
> OK. Attached patch removes calls within the function to quote_ident, requiring
> the user to appropriately quote their own identifiers. I also tweaked the
> regression test to deal with "value" becoming a reserved word.
>
Joe Conway <[EMAIL PROTECTED]> writes:
> Joe Conway wrote:
>> Is quote_ident_required incorrectly dealing with schemas?
> Sorry to reply to myself, but another related question; shouldn't the
> following produce "Ms"."Test"?
> test=# select quote_ident('Ms.Test');
> quote_ident
> -
On Fri, 22 Nov 2002, Joe Conway wrote:
> Masaru Sugawara wrote:
> > CREATE SCHEMA ms;
> > CREATE TABLE ms.test (id int4, parent_id int4, t text);
> > INSERT INTO ms.test VALUES(11, null, 'aaa');
> > INSERT INTO ms.test VALUES(101, 11, 'bbb');
> > INSERT INTO ms.test VALUES(110, 11, 'ccc');
> > INS
Joe Conway wrote:
Is quote_ident_required incorrectly dealing with schemas?
Sorry to reply to myself, but another related question; shouldn't the
following produce "Ms"."Test"?
test=# select quote_ident('Ms.Test');
quote_ident
-
"Ms.Test"
(1 row)
Joe
Masaru Sugawara wrote:
CREATE SCHEMA ms;
CREATE TABLE ms.test (id int4, parent_id int4, t text);
INSERT INTO ms.test VALUES(11, null, 'aaa');
INSERT INTO ms.test VALUES(101, 11, 'bbb');
INSERT INTO ms.test VALUES(110, 11, 'ccc');
INSERT INTO ms.test VALUES(111, 110, 'ddd');
SELECT *
FROM connectb
