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

bug in 7.4.2, with Handling of Double Quotation Marks

From: Alexander S <sasha(at)in(dot)crimea(dot)ua>
To: pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: bug in 7.4.2, with Handling of Double Quotation Marks
Date: 2004-03-31 08:39:52
Message-ID: 406A83D8.7050307@in.crimea.ua (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
Bug in 7.4.2.. Concern with handling of Double  Quotation Marks ("). 
Escape of  double quotation marks can't solve the problem.

----------
CREATE TABLE public.test
(
  my_column varchar NOT NULL,
  CONSTRAINT my_primary PRIMARY KEY (my_column)
) WITHOUT OIDS;
-----------
CREATE TABLE public.ref_test
(
  my_column varchar[]
) WITH OIDS;
-----------
CREATE FUNCTION public."t-f_ref_test"()
RETURNS trigger AS
'BEGIN
FOR i IN 1..30 LOOP
    IF NEW."my_column"[i] not in (select "my_column" from public.test) THEN
        RAISE EXCEPTION \'error: my_column[] --> test.my_column \';
    END IF;
END LOOP;
RETURN NEW;
END;'
  LANGUAGE 'plpgsql' VOLATILE;
----------
CREATE TRIGGER t_ref_test
  BEFORE INSERT OR UPDATE
  ON public.ref_test
  FOR EACH ROW
  EXECUTE PROCEDURE public."t-f_ref_test"();
----------
insert into test values (' here \"some_text\" ');
----------
insert into ref_test values (' {here \"some_text\"} ');

But  here  postgres answers:  error: my_column[] --> test.my_column.
So I think this exception should not appear here and this is bug.
Instead I can only insert:
--
insert into ref_test values (' {here \\"some_text\\"} ');       -- but 
this is not exactly that i want to have.
--
Without "" in row of public.test - all works fine, but its important for 
me to use "" in my templates (database public.test).

Responses

pgsql-bugs by date

Next:From: Enke, MichaelDate: 2004-03-31 17:33:13
Subject: Re: BUG #1110: psql -h localhost consults the nameservice
Previous:From: PostgreSQL Bugs ListDate: 2004-03-30 16:02:15
Subject: BUG #1121: JDBC AbstractJdbc2ResultSet.deleteRow()

pgsql-general by date

Next:From: Manfred KoizarDate: 2004-03-31 09:17:35
Subject: Re: Large DB
Previous:From: bwhiteDate: 2004-03-31 08:10:33
Subject: Question about rtrees (overleft replacing left in nodes)

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