Re: drop table in PL/pgSQL - Mailing list pgsql-sql

From Roberto Mello
Subject Re: drop table in PL/pgSQL
Date
Msg-id 20010323115345.A17794@cc.usu.edu
Whole thread Raw
In response to Re: drop table in PL/pgSQL  (Jie Liang <jliang@ipinc.com>)
Responses Re: drop table in PL/pgSQL  (Jie Liang <jliang@ipinc.com>)
List pgsql-sql
On Fri, Mar 23, 2001 at 09:52:56AM -0800, Jie Liang wrote:
> 
> You cannot CREATE|DROP ALTER table in PL/pgSQL, 
> in general, plsql can only take DML(i.e. SELECT|
> INSERT|UPDATE..)
You can't? I just did (on PG 7.1). AFAIK, you _can_ CREATE/DROP, but you can't roll back.
-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club|------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net     http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer    
 
"Carrier detected." Go to the dentist...


pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: trigger output to a file
Next
From: Jie Liang
Date:
Subject: Re: drop table in PL/pgSQL