Re: [GENERAL] [8.1] drop table in plpgsql function

2005-11-14 Thread John DeSoi
Sergey, On Nov 14, 2005, at 2:03 AM, Sergey Karin wrote: I have found a strange error. Perhaps your f_is_table_exist function is not working correctly. Using variables for table references is not supported in plpgsql (any version). You must use execute. Here is my test on 8.0.4: create

[GENERAL] [8.1] drop table in plpgsql function

2005-11-13 Thread Sergey Karin
-- Forwarded message -- From: Sergey Karin [EMAIL PROTECTED] Date: 11.11.2005 13:59 Subject: [8.1] drop table in plpgsql function To: pgsql-general@postgresql.org hi all! I have found a strange error. panorama2=# select version(); version

[GENERAL] [8.1] drop table in plpgsql function

2005-11-11 Thread Sergey Karin
hi all! I have found a strange error. panorama2=# select version(); version PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 (1 row) I have next function in file