Re: drop table in PL/pgSQL

From: Jie Liang <jliang(at)ipinc(dot)com>
To: datactrl <quals(at)bigfoot(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: drop table in PL/pgSQL
Date: 2001-03-23 17:52:56
Message-ID: Pine.BSF.4.10.10103230950290.29016-100000@tidal.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


You cannot CREATE|DROP ALTER table in PL/pgSQL,
in general, plsql can only take DML(i.e. SELECT|
INSERT|UPDATE..)

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, datactrl wrote:

> When I use "drop Table ..." in PL/pgSQL, it always causes an error as
> "ERROR copyObject: don't know how to copy 614"
>
> JACK
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2001-03-23 18:02:31 Re: trigger output to a file
Previous Message Tom Lane 2001-03-23 16:29:56 Re: Btree index on varchar