| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Toni Casueps <casueps(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: accessing text of the query in a rule |
| Date: | 2005-12-02 18:32:55 |
| Message-ID: | 43909357.6020608@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Toni Casueps wrote:
> I am making rules for a table and I want to know what values or
> variables can I use apart from the "new..." and old... fields, for
> example I would like to read the SQL query that the user wrote that
> caused this rule to execute. Can this be done?
No. And there's isn't necessarily an original query that's relevant.
What about a rule activated due to actions taken by a trigger. Are you
still interested in the user's query, or the query the trigger issued?
If there's a particular problem you're trying to solve, the details
might well give someone enough info to help.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-12-02 18:36:37 | Re: createuser ignores stdin in 8.1.0? |
| Previous Message | Tom Lane | 2005-12-02 18:21:05 | Re: Numeric 508 datatype |