quoting bug?

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: quoting bug?
Date: 2008-02-09 16:50:57
Message-ID: 20080209165057.GD6126@quartz.itdept.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Given the following trivial trigger example:

-- create language plpgsql;

create table foo (a integer, b text, c timestamp);

create function foo_insert() returns trigger as $$
begin
raise notice '%', new;
return null;
end;
$$ language plpgsql;

create trigger foo_ins before insert on foo
for each row execute procedure foo_insert();

insert into foo values (1, 'two', current_timestamp);

I am surprised to see

NOTICE: (1,two,"Sat 09 Feb 16:47:44.514503 2008")
INSERT 0 0

I would have expected
NOTICE: (1,'two','Sat 09 Feb 16:47:44.514503 2008')
INSERT 0 0

i.e., a row whose columns look as though they went through quote_literal
rather than through quote_ident.

This is with yesterday's 8.3.0 (Feb 8 17:24 GMT)

Thoughts?

Cheers,

Patrick

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brendan Jurd 2008-02-09 17:12:18 Re: quoting bug?
Previous Message Alvaro Herrera 2008-02-09 16:25:05 Re: PostgreSQL 8.4 development plan