Re: Changing user - Mailing list pgsql-general

From Tom Lane
Subject Re: Changing user
Date
Msg-id 14492.1071518841@sss.pgh.pa.us
Whole thread Raw
In response to Changing user  ("C G" <csgcsg39@hotmail.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: functions returning sets
Next
From: Markus Rebbert
Date:
Subject: Re: dump and sequence initilizing