| From: | Ian Barwick <barwick(at)gmx(dot)net> |
|---|---|
| To: | Database Administrator <dba(at)vilaj(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: PL/PgSQL Create/Drop Table Issue |
| Date: | 2003-05-15 16:16:15 |
| Message-ID: | 200305151815.54787.IanBarwick<> |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Friday 09 May 2003 16:26, Database Administrator wrote:
> I believe I've found a problem in creating and dropping tables within
> PL/PgSQL functions. If you create a table, do some work with it, then
> drop it from within a PL/PgSQL function, it will work correctly the
> first time through. On subsequent executions of the function, however,
> attempting to insert data into the table will result in an error. The
> error report follows as does a script which demonstrates the issue clearly.
See:
http://www.postgresql.org/docs/faqs/FAQ.html#4.26
Ian Barwick
barwick(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-05-15 17:10:05 | Re: segfault in postmaster (pg 7.3.2 & FreeBSD) |
| Previous Message | Bruce Momjian | 2003-05-15 16:12:42 | Re: PL/PgSQL Create/Drop Table Issue |