Re: drop table in PL/pgSQL

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: Jie Liang <jliang(at)ipinc(dot)com>
Cc: datactrl <quals(at)bigfoot(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: drop table in PL/pgSQL
Date: 2001-03-23 18:53:45
Message-ID: 20010323115345.A17794@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2001-03-23 19:25:12 Re: drop table in PL/pgSQL
Previous Message Jan Wieck 2001-03-23 18:09:49 Re: creating "job numbers"