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" <csgcsg39@hotmail.com> 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