Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE RULE fails with 'ERROR: SELECT rule's target list has too many entries' - Mailing list pgsql-general

From Tom Lane
Subject Re: CREATE RULE fails with 'ERROR: SELECT rule's target list has too many entries'
Date
Msg-id 5272.1354720057@sss.pgh.pa.us
Whole thread Raw
In response to CREATE RULE fails with 'ERROR: SELECT rule's target list has too many entries'  (Henrik Kuhn <henrik.kuhn@origenis.de>)
Responses Re: CREATE RULE fails with 'ERROR: SELECT rule's target list has too many entries'  (Henrik Kuhn <henrik.kuhn@origenis.de>)
List pgsql-general
Tree view 
Henrik Kuhn <henrik.kuhn@origenis.de> writes:
> can somebody give me some insights why the creation of this rule fails
> with 'ERROR:  SELECT rule's target list has too many entries'?

Probably that history_relation has fewer than three columns?  But if
you want something more than guessing, you'd have to provide more
context, such as the definitions of the underlying tables.  Why are
you trying to execute this command anyway?

            regards, tom lane

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: how do I grant select to one user for all tables in a DB?
Next
From: Henrik Kuhn
Date:
Subject: Re: CREATE RULE fails with 'ERROR: SELECT rule's target list has too many entries'