Re: pre-parser query manipulation - Mailing list pgsql-general

From Tom Lane
Subject Re: pre-parser query manipulation
Date
Msg-id 821.1174017741@sss.pgh.pa.us
Whole thread Raw
In response to Re: pre-parser query manipulation  (Randall Smith <randall@tnr.cc>)
List pgsql-general
Randall Smith <randall@tnr.cc> writes:
> I'm at a loss as to how to remove the OF clause at the server.  It it
> possible to do it with a rule?

No, because the syntax error will occur long before any rule has a
chance to get involved.  You'd have to actually hack the C code
(see transformLockingClause in src/backend/parser/analyze.c).

It's unfortunate that somebody decided to use the standard FOR UPDATE
syntax to mean something that's got nearly 0 to do with what the spec
intends it to mean :-(.

            regards, tom lane

pgsql-general by date:

Previous
From: louis gonzales
Date:
Subject: Practical question.
Next
From: Tom Lane
Date:
Subject: Re: Practical question.