Re: Create table doesn't work in plpgsql

Hi,there,

I don't think you can use DDL(data definition language) in PL/SQL.
create table is not DML(data munipulation language) instead
it's a DDL.

Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.ipinc.com

On Tue, 19 Dec 2000, Volker Paul wrote:

> Hi,
>
> can I do some table manipulation in plpgsql?
> Look at only the "create table" line and the error message:
>
> create function plural (text) returns text as '
> begin
> create table tmp (num int4);
> return $1 || ''s'';
> end;' language 'plpgsql';
> select plural('test');
> CREATE
> ERROR: copyObject: don't know how to copy 611
>
> What does the error message mean? Where can I read more about it?
>
> Cheers, Volker
>