Re: Changing user

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "C G" <csgcsg39(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Changing user
Date: 2003-12-15 20:07:21
Message-ID: 14492.1071518841@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"C G" <csgcsg39(at)hotmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Markus Rebbert 2003-12-15 20:24:36 Re: dump and sequence initilizing
Previous Message Tom Lane 2003-12-15 19:59:02 Re: functions returning sets