| From: | "And(dot) Andruikhanov" <andy(at)euinf(dot)dp(dot)ua> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | temp table in pl/pgsql language |
| Date: | 2001-05-21 15:47:01 |
| Message-ID: | Pine.BSF.3.96.1010521183319.4668A-100000@euinf.dp.ua |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Good day.
System Configuration
---------------------
Architecture: Intel Pentium
Operating System: FreeBSD 4.2-STABLE
PostgreSQL version: PostgreSQL-7.1RC1
Compiler used: gcc 2.95.2
Description of problem
----------------------
It's may be postgreSQL limitation, but I found nothing information in TODO list
about this subject.
If I use CREATE TEMP TABLE name(col1..) as SELECT query
in pl/pgsql functions - it's all OK. At the end of transaction server droped
this table automatically.
But I can't use this possibility in TRIGGER's functions. Postgres take this
table as "permanent" (not temporary), I think. And on the second transaction
client received message as "ERROR, Relation name already exists". If I drope
this temp table in trigger's function, then error message like this: "ERROR:
Relation 32122 does not exist".
Best regards..
--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | And. Andruikhanov | 2001-05-21 16:06:06 | error in expr. with array or wrong in documentation ? |
| Previous Message | Bob Deblier | 2001-05-21 13:41:34 | dlopen() of libpsqlodbc.so from release 7.1.1 fails on Solaris 2.8 Sparc |