| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "C G" <csgcsg39(at)hotmail(dot)com>, tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Changing user |
| Date: | 2003-12-16 10:54:25 |
| Message-ID: | 200312161054.25639.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday 16 December 2003 10:12, C G wrote:
> 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
You want EXECUTE. Something like:
DECLARE
set_qty text;
...
set_qry := ''SET SESSION AUTHORIZATION '' || $1;
EXECUTE set_qry;
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | K. Deepa | 2003-12-16 11:25:39 | passing array as argument and returning an array in plpgsql |
| Previous Message | Marek Lewczuk | 2003-12-16 10:27:40 | UTF support in WIN32 native and Lower/Upper in 7.5 release |