pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
drop table in PL/pgSQL
4+ messages / 3 participants
[nested] [flat]

* drop table in PL/pgSQL
@ 2001-03-23 03:06  datactrl <quals@bigfoot.com>
  0 siblings, 1 reply; 4+ messages in thread

From: datactrl @ 2001-03-23 03:06 UTC (permalink / raw)
  To: pgsql-sql

When I use "drop Table ..."  in PL/pgSQL, it always causes an error as
"ERROR copyObject: don't know how to copy 614"

JACK




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: drop table in PL/pgSQL
@ 2001-03-23 17:52  Jie Liang <jliang@ipinc.com>
  parent: datactrl <quals@bigfoot.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Jie Liang @ 2001-03-23 17:52 UTC (permalink / raw)
  To: datactrl <quals@bigfoot.com>; +Cc: 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@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
> 




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: drop table in PL/pgSQL
@ 2001-03-23 18:53  Roberto Mello <rmello@cc.usu.edu>
  parent: Jie Liang <jliang@ipinc.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Roberto Mello @ 2001-03-23 18:53 UTC (permalink / raw)
  To: Jie Liang <jliang@ipinc.com>; +Cc: datactrl <quals@bigfoot.com>; 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...



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: drop table in PL/pgSQL
@ 2001-03-23 19:25  Jie Liang <jliang@ipinc.com>
  parent: Roberto Mello <rmello@cc.usu.edu>
  0 siblings, 0 replies; 4+ messages in thread

From: Jie Liang @ 2001-03-23 19:25 UTC (permalink / raw)
  To: Roberto Mello <rmello@cc.usu.edu>; +Cc: datactrl <quals@bigfoot.com>; 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@ipinc.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...
> 




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-03-23 19:25 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-23 03:06 drop table in PL/pgSQL datactrl <quals@bigfoot.com>
2001-03-23 17:52 ` Jie Liang <jliang@ipinc.com>
2001-03-23 18:53   ` Roberto Mello <rmello@cc.usu.edu>
2001-03-23 19:25     ` Jie Liang <jliang@ipinc.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox