Re: ERROR: expected just one rule action

The history is rather interesting. :-)

This is the first version of PostgreSQL provided by a certain very
helpful fellow, who has been making PostgreSQL binaries available for
us Mac users for years, since he upgraded to Mac OS X 10.5 (aka
Leopard). I have not yet upgraded to Leopard, due to some serious
compatibility problems it introduced, so I am testing this build for
compatibility with Mac OS X 10.4 (aka Tiger). It is working
flawlessly on my Intel Mac, but I'm encountering the errors
previously mentioned on an older G4 Mac.

Since there are so many variables involved--major PostgreSQL upgrade,
major Mac OS X upgrade (yes, 10.4 -> 10.5 is a major upgrade ;-) ),
support for two different processor families--I'm just trying to
narrow down what he needs to look at, and your suggestions are very
helpful.

I hadn't tried any backslash commands, but someone else with a
similar configuration said he was seeing errors with \du and other
psql commands. I first noticed the problem when connecting to
databases in PGAdmin3. (I'm a GUI-oriented user.)

"SELECT * FROM pg_rewrite" seems to work fine.

Thank you very much for your help!

On Feb 10, 2008, at 12:42 PM, Tom Lane wrote:

> Dave Livesay <dlivesay@covad.net> writes:
>> Can anyone interpret this error message?
>
> Something's whacked out about your ON SELECT rules for these views.
> Further than that is harder to say --- have you tried looking at
> \d output for them, or looked into pg_rewrite?
>
>> It appears in response to each of the following queries in one
>> instance of PostgreSQL 8.3:
>
> What's the history of that instance?
>
>             regards, tom lane
>