| 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: | Whole Thread | Raw Message | 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
| 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 |