Hey, I have read it and current user is 'postgres' and the new_user is also looks fine but still the same error.
techdb=# select current_user; current_user -------------- postgres (1 row) techdb=# CREATE OR REPLACE FUNCTION test_create() RETURNS void AS $BODY$ $cmd = "CREATE TABLE testtable(col varchar not null);"; spi_exec_query("CREATE OR REPLACE FUNCTION myfunc() RETURNS void AS '$cmd' LANGUAGE SQL;"); spi_exec_query("SELECT myfunc();"); $BODY$ LANGUAGE 'plperl'; CREATE FUNCTION techdb=# ALTER FUNCTION test_create() SET OWNER TO user1; ERROR: unrecognized configuration parameter "owner" techdb=# Thanks, Jack On Wed, Feb 24, 2010 at 11:51 AM, A. Kretschmer < andreas.kretsch...@schollglas.com> wrote: > In response to Jignesh Shah : > > Hi, > > > > could you tell me what could be the issue in below command. I could see > that > > there is an option for changing OWNER of function but not sure why it is > giving > > this error. > > > > techdb=# ALTER FUNCTION test_create() SET OWNER TO masanip; > > ERROR: unrecognized configuration parameter "owner" > > test=*# \h alter function > Command: ALTER FUNCTION > Description: change the definition of a function > Syntax: > ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) > OWNER TO new_owner > > Read that and try: > > ALTER FUNCTION test_create() OWNER TO masanip; > > > Regards, Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) > GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 > > -- > Sent via pgsql-novice mailing list (pgsql-nov...@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-novice >