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)3
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.
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
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Fri, 23 Mar
