Received: from fslc.usu.edu (fslc.usu.edu [129.123.2.40]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2NIrxw78036 for ; Fri, 23 Mar 2001 13:54:11 -0500 (EST) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.usu.edu (8.11.3/8.11.3/Debian 8.11.2-1) id f2NIrjb17807; Fri, 23 Mar 2001 11:53:45 -0700 Date: Fri, 23 Mar 2001 11:53:45 -0700 From: Roberto Mello To: Jie Liang Cc: datactrl , pgsql-sql@postgresql.org Subject: Re: drop table in PL/pgSQL Message-ID: <20010323115345.A17794@cc.usu.edu> References: <005001c0b346$4d5d0bc0$2400a8c0@hnjack> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.15i In-Reply-To: ; from jliang@ipinc.com on Fri, Mar 23, 2001 at 09:52:56AM -0800 X-Archive-Number: 200103/468 X-Sequence-Number: 2137 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...