ERROR: expected just one rule action

From: Dave Livesay <dlivesay(at)covad(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: expected just one rule action
Date: 2008-02-10 17:27:31
Message-ID: CE111A7E-0D48-49A1-8606-C0761D5AE273@covad.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname =
current_user;
SELECT setting FROM pg_settings WHERE name IN ('autovacuum',
'track_counts');
SELECT oid, *, pg_catalog.shobj_description(oid, 'pg_authid') AS
description FROM pg_roles WHERE NOT rolcanlogin ORDER BY rolname;
SELECT oid, *, pg_catalog.shobj_description(oid, 'pg_authid') AS
description FROM pg_roles WHERE rolcanlogin ORDER BY rolname;

These queries work fine in another instance of 8.3, so it's not the
queries themselves.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-02-10 17:42:41 Re: ERROR: expected just one rule action
Previous Message Andrej Ricnik-Bay 2008-02-10 17:27:23 Re: Where is the system-wide psqlrc on RHEL4?