Re: drop table in PL/pgSQL

Hmm,

I didn't know that, this general idea from Orcale plsql,
So, I assume that you can
SELECT somefield into a_new_table FROM a_old_table

in pg 7.1???

Thank you.

No DDL can be roll back. 

Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

On Fri, 23 Mar 2001, Roberto Mello wrote:

> 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...
>