Create table in functions

From: Andreas Tille <tillea(at)rki(dot)de>
To: PostgreSQL SQL <pgsql-sql(at)hub(dot)org>
Subject: Create table in functions
Date: 2000-08-23 14:49:31
Message-ID: Pine.LNX.4.21.0008231647290.22247-100000@wr-linux02.rki.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I striped down my function up to a strange thing:

web=# create function pHelpTable( )
web-# returns int
web-# As '
web'# Begin
web'# Create Table Temp_NumTable ( Num int ) ;
web'#
web'# return 17 ;
web'# End; '
web-# language 'plpgsql' ;
CREATE
web=#
web=# select pHelpTable( );
ERROR: copyObject: don't know how to copy 611
web=#

What does this mean? The ERROR is caused by the Create Table statement
(when I removed it from my complex function it worked well).
So why doesn't this work and what copy function fails here??

Kind regards

Andreas.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-08-23 15:31:06 Re: Create table in functions
Previous Message Adam Lang 2000-08-23 14:42:50 Re: Copy To - fixed width