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 really the most

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. If the

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_rewrite (iirc). Hmm,

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 over,

[GENERAL] ERROR: expected just one rule action

2008-02-10 Thread Dave Livesay
Can anyone interpret this error message? It appears in response to each of the following queries in one instance of PostgreSQL 8.3: SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince FROM pg_user WHERE usename=current_user ; SELECT

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 of

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

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 Leopard,

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: 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 with