| From: | jack(at)douglastechnology(dot)co(dot)uk |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #9578: Undocumented behaviour for temp tables created inside query language (SQL) functions |
| Date: | 2014-03-15 16:50:11 |
| Message-ID: | 20140315165011.20722.74795@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
The following bug has been logged on the website:
Bug reference: 9578
Logged by: Jack Douglas
Email address: jack(at)douglastechnology(dot)co(dot)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:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Burladyan | 2014-03-15 20:57:20 | Re: BUG #9223: plperlu result memory leak |
| Previous Message | Fujii Masao | 2014-03-15 15:24:02 | Re: BUG #9118: WAL Sender does not disconnect replication clients during shutdown |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2014-03-15 18:40:03 | HEAD seems to generate larger WAL regarding GIN index |
| Previous Message | Fujii Masao | 2014-03-15 15:59:01 | Re: Archive recovery won't be completed on some situation. |