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

On 12/05/2012 04:58 PM, Tom Lane wrote: Henrik Kuhn writes: On 12/05/2012 04:07 PM, Tom Lane wrote: Henrik Kuhn 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 histo

[GENERAL] ALTER EXTENSION UPDATE: How to update the 'module_pathname'?

Hi, after installing an extension with functions with C bindings - CREATE OR REPLACE FUNCTION ... AS 'MODULE_PATHNAME' LANGUAGE C ... - I like to change the 'module_pathname' upon its update. After reading the docs and especially the section of 'ALTER EXTENSION' I have the feeling, that this

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

On 12/05/2012 04:07 PM, Tom Lane wrote: Henrik Kuhn 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 some

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

Hi, can somebody give me some insights why the creation of this rule fails with 'ERROR: SELECT rule's target list has too many entries'? CREATE RULE "_RETURN" AS ON SELECT TO history_relation DO INSTEAD SELECT history_relation.id, history_relation.relname, pg_attribu