Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2NHr3w24248 for ; Fri, 23 Mar 2001 12:53:06 -0500 (EST) (envelope-from jliang@tidal.ipinc.com) Received: from localhost (jliang@localhost) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id JAA29288; Fri, 23 Mar 2001 09:52:56 -0800 (PST) (envelope-from jliang@tidal.ipinc.com) Date: Fri, 23 Mar 2001 09:52:56 -0800 (PST) From: Jie Liang To: datactrl cc: pgsql-sql@postgresql.org Subject: Re: drop table in PL/pgSQL In-Reply-To: <005001c0b346$4d5d0bc0$2400a8c0@hnjack> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200103/465 X-Sequence-Number: 2133 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@ipinc.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@postgresql.org so that your > message can get through to the mailing list cleanly >