Create table doesn't work in plpgsql

From: Volker Paul <vpaul(at)dohle(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Create table doesn't work in plpgsql
Date: 2000-12-19 17:54:43
Message-ID: 00121919014900.01625@james
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tulassay Zsolt 2000-12-19 17:56:24 Re: Tree structure table normalization problem (do I need atrigger?)
Previous Message Jie Liang 2000-12-19 17:39:49 Re: SQL query not working when GROUP BY / HAVING is used