Postgres Pro
Downloads
Home   >   mailing lists

BUG #9578: Undocumented behaviour for temp tables created inside query language (SQL) functions - Mailing list pgsql-bugs

From jack@douglastechnology.co.uk
Subject BUG #9578: Undocumented behaviour for temp tables created inside query language (SQL) functions
Date
Msg-id 20140315165011.20722.74795@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #9578: Undocumented behaviour for temp tables created inside query language (SQL) functions  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      9578
Logged by:          Jack Douglas
Email address:      jack@douglastechnology.co.uk
PostgreSQL version: 9.3.2
Operating system:   Debian Wheezy 64-bit
Description:

A temp table created inside an SQL function does not override existing
permanent tables with the same name as the documentation here indicates it
should:

http://www.postgresql.org/docs/9.3/static/sql-createtable.html#AEN72676

I've reproduced this on the major versions back to 8.4.

More details, test case and investigation here:

http://dba.stackexchange.com/q/60997/1396

pgsql-bugs by date:

Previous
From: Sergey Burladyan
Date:
Subject: Re: BUG #9223: plperlu result memory leak
Next
From: Michael Paquier
Date:
Subject: Re: BUG #9118: WAL Sender does not disconnect replication clients during shutdown