Re: [GENERAL] ERROR: expected just one rule action

2008-02-11 Thread Tom Lane
"Dave Page" <[EMAIL PROTECTED]> writes: > On Feb 11, 2008 4:28 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >> "Dave Page" <[EMAIL PROTECTED]> writes: >>> If the endianess isn't corrected for the non-native platform at build >>> time, I've seen initdb leave a cluster with a completely broken >>> pg_rewr

Re: [GENERAL] ERROR: expected just one rule action

2008-02-11 Thread Dave Page
On Feb 11, 2008 4:28 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Dave Page" <[EMAIL PROTECTED]> writes: > > If the endianess isn't corrected for the non-native platform at build > > time, I've seen initdb leave a cluster with a completely broken > > pg_rewrite (iirc). > > Hmm, but is pg_rewrite real

Re: [GENERAL] ERROR: expected just one rule action

2008-02-11 Thread Tom Lane
"Dave Page" <[EMAIL PROTECTED]> writes: > If the endianess isn't corrected for the non-native platform at build > time, I've seen initdb leave a cluster with a completely broken > pg_rewrite (iirc). Hmm, but is pg_rewrite really the most obvious symptom? In 8.3 I would expect massive breakage all

Re: [GENERAL] ERROR: expected just one rule action

2008-02-11 Thread Dave Page
On Feb 10, 2008 10:51 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > If these are "universal" (Intel+PPC) binaries, that could be an issue > too. There's been some discussion recently about how to build universal > binaries for PG, but I don't think anyone's figured out a really nice > way to do it. I

Re: [GENERAL] ERROR: expected just one rule action

2008-02-10 Thread Tom Lane
Dave Livesay <[EMAIL PROTECTED]> writes: > I'm sure it has something to do with the complex build environment > and getting up to speed with the new tools. FWIW, I just verified that your queries work fine for me in CVS HEAD on a G4, under both 10.4 (building with Xcode 2.5) and 10.5 (building w

Re: [GENERAL] ERROR: expected just one rule action

2008-02-10 Thread Dave Livesay
On Feb 10, 2008, at 2:21 PM, Tom Lane wrote: Dave Livesay <[EMAIL PROTECTED]> writes: 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)

Re: [GENERAL] ERROR: expected just one rule action

2008-02-10 Thread Tom Lane
Dave Livesay <[EMAIL PROTECTED]> writes: > 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 Leopar

Re: [GENERAL] ERROR: expected just one rule action

2008-02-10 Thread Dave Livesay
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 t

Re: [GENERAL] ERROR: expected just one rule action

2008-02-10 Thread Tom Lane
Dave Livesay <[EMAIL PROTECTED]> 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