Re: function side effects - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: function side effects
Date
Msg-id 3073cc9b1002231946l7d2f2861r3760a4412043c04@mail.gmail.com
Whole thread Raw
In response to Re: function side effects  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Feb 23, 2010 at 10:18 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Personally I find that goal rather suspect anyway.
> I think the chances of determining this reliably in pgpool are
> negligible, even if functions were marked like that.  You would need to
> duplicate *all* of the backend's parsing and all of its state (eg schema
> search path) in order to discover anything.
>

i agree with that, as Alvaro suggested maybe a way to ask the server
about the whole query is the way to go

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: auto_explain log_verbose causes regression failure
Next
From: Fujii Masao
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Move documentation of all recovery.conf option to a new chapter.