Re: [GENERAL] Changing user

[C G]

Thanks for your help but I still have a small problem. I'm try to do as you 
suggested and use prepare/execute but I'm doing something silly.

I'm using:

PREPARE my_prep1(name) AS SET SESSION AUTHORIZATION $1;

and get the error message:
ERROR: syntax error at or near "set" at character 27
I have tried many variations on this theme but have no luck. Suggestions?

Thanks

Colin




"C G" <[EMAIL PROTECTED]> writes:
> SET SESSION AUTHORIZATION username;
> ERROR: syntax error at or near "$1" at character 28
You'll need to use EXECUTE to do this.  Utility statements in general
aren't prepared to deal with parameters.
			regards, tom lane
_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today! 
http://www.msn.co.uk/messenger

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly