Re: drop table in PL/pgSQL

From: Jie Liang <jliang(at)ipinc(dot)com>
To: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
Cc: datactrl <quals(at)bigfoot(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: drop table in PL/pgSQL
Date: 2001-03-23 19:25:12
Message-ID: Pine.BSF.4.10.10103231119060.29016-100000@tidal.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)ipinc(dot)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...
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Perrin 2001-03-23 19:53:47 Re: trigger output to a file
Previous Message Roberto Mello 2001-03-23 18:53:45 Re: drop table in PL/pgSQL