BUG #8580: search_path unexpected behavior with pg_temp

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

Browse pgsql-bugs by date

  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