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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Henrik Kuhn <henrik(dot)kuhn(at)origenis(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CREATE RULE fails with 'ERROR: SELECT rule's target list has too many entries'
Date: 2012-12-05 15:07:37
Message-ID: 5272.1354720057@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Henrik Kuhn <henrik(dot)kuhn(at)origenis(dot)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

In response to

Responses

Browse pgsql-general by date

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