From: | bashtanov(at)imap(dot)cc |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #8580: search_path unexpected behavior with pg_temp |
Date: | 2013-11-06 10:42:28 |
Message-ID: | E1Ve0ZA-0006lF-Gz@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 8580
Logged by: Alexey Bashtanov
Email address: bashtanov(at)imap(dot)cc
PostgreSQL version: 9.2.4
Operating system: Linux Centos 6.4
Description:
[STEPS TO REPRODUCE]
CREATE OR REPLACE FUNCTION foo() RETURNS void
AS $$
begin
create temporary table zoo () on commit preserve rows;
delete from zoo;
drop table zoo;
end;
$$ language plpgsql set search_path = pg_catalog, public, pg_temp;
begin;
select foo();
abort;
begin;
select foo();
[EXPECTED]
no errors
[RECEIVED]
ERROR: relation "zoo" does not exist
LINE 1: delete from zoo
[ALSO]
1)reproducibility between 50% and 100%
2)also can be reproduced on pg 9.1.9
3)reproduced if replace delete by perform
4)not reproduced if replace delete by alter
Regards,
Alexey Bashtanov
From | Date | Subject | |
---|---|---|---|
Next Message | Rajagopal C.R | 2013-11-06 12:59:59 | Please send me the steps to install Debugger-Plugin for Postgresql-9.2 |
Previous Message | rgr | 2013-11-06 08:54:43 | BUG #8579: CoreDump of background writer process |