From: | Dave Livesay <dlivesay(at)covad(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: expected just one rule action |
Date: | 2008-02-10 18:16:44 |
Message-ID: | 942EDD57-AC83-4FD0-B3F1-18227B10F8E9@covad.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)covad(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jake Franklin | 2008-02-10 18:37:45 | Change column type to numeric |
Previous Message | Nykolyn, Andrew | 2008-02-10 17:45:11 | Alter Temporary table in Stored Procedure |