Lists: | pgsql-sql |
---|
From: | "datactrl" <quals(at)bigfoot(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | drop table in PL/pgSQL |
Date: | 2001-03-23 03:06:45 |
Message-ID: | 005001c0b346$4d5d0bc0$2400a8c0@hnjack |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | 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
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 |
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
>
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 |
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...
From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
Cc: | datactrl <quals(at)bigfoot(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: drop table in PL/pgSQL |
Date: | 2001-03-23 19:25:12 |
Message-ID: | Pine.BSF.4.10.10103231119060.29016-100000@tidal.ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | 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(at)ipinc(dot)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...
>