Re: Possible SET SESSION AUTHORIZATION bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Ochs" <chris(at)paymentonline(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Possible SET SESSION AUTHORIZATION bug
Date: 2004-06-21 16:25:04
Message-ID: 3467.1087835104@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Chris Ochs" <chris(at)paymentonline(dot)com> writes:
> Ok this probably isn't a bug but a side affect of how functions are cached.
> Changing the function to use EXECUTE to perform the query works. I don't
> know if this particular scenario was ever even though of before, or if in
> the future it would make sense to have the query planner not cache the
> session user/current user?

It doesn't cache that. I'm not sure what's going on here ... could you
provide a self-contained test script?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-06-21 16:26:59 Re: New to the list; would this be an okay question?
Previous Message Dave Cramer 2004-06-21 16:13:15 Re: JDBC driver inserting into a table with Bytea type