Re: alloc error on multiple action-queries within a rule - Mailing list pgsql-bugs

From Tom Lane
Subject Re: alloc error on multiple action-queries within a rule
Date
Msg-id 29396.996947219@sss.pgh.pa.us
Whole thread Raw
In response to alloc error on multiple action-queries within a rule  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.org writes:
> please do not hesitate to contact me if any further information is needed.

Unfortunately your sample code is far from complete --- I got as far as
noticing that there were no declarations for tables  _tax_families,
_tax_orders, _tax_classes, _tax_realms, no ON INSERT rule for view
_tax_genuses, and nothing at all about tax_aliases, before giving up.

Please submit a complete dump script that can be loaded into an empty
database to set up the failure scenario.

It's possible that the problem is the same as one we already noticed
and fixed --- see
http://www.ca.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/rewrite/rewriteHandler.c
You could try replacing rewriteHandler.c with version 1.93.2.1 from that
page and see if your problem goes away.

            regards, tom lane

pgsql-bugs by date:

Previous
From: rychu@sky.pl
Date:
Subject: Odpowied¼ automatyczna
Next
From: Peter Eisentraut
Date:
Subject: Re: help for:FATAL 1: configuration file `postgresql.conf' has wrong permissions