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
[EMAIL PROTECTED]
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...
>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
