Port Bug Report: After creating a rule it is not possible to read the rule by pg_dump or select * from pg_rules - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: After creating a rule it is not possible to read the rule by pg_dump or select * from pg_rules
Date
Msg-id 199905260607.CAA42300@hub.org
Whole thread Raw
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Jochen Schroer
Your email address      : schroer@hummel.k-town.de

Category                : runtime: back-end
Severity                : serious

Summary: After creating a rule it is not possible to read the rule by pg_dump or select * from pg_rules

System Configuration
--------------------
  Operating System   : Linux 2.2.6 ELF

  PostgreSQL version : 6.4.2

  Compiler used      : PostgreSQL 6.4.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66

Hardware:
---------
AMD K6-2 350MHz, 128 MB Ram, 256 MB Swap, Linux SQL 2.2.6 #1 SMP Sun May 23 03:10:54 MEST 1999 i586 unknown

Versions of other tools:
------------------------
unknown

--------------------------------------------------------------------------

Problem Description:
--------------------
After this I define a rule I can�t read the ruledefinition
again.
The only result I get is that postgres eat all my memory.
(I have try it with up to 128 MB Ram and 768 MB Swap and I
have killed postmaster after he used more then 85% of this
memory)

If I only make an simple rule it work, but if I add an
more complicate rule it crash again.

The reason why I select the severity serious and not
critical is, that the rules work, my only problem is that
I can�t read them but they work.




--------------------------------------------------------------------------

Test Case:
----------
I have make the following testdatabase:

CREATE TABLE "test1" (
        "field1" int4,
        "field2" text);
CREATE TABLE "test2" (
        "field1" int4,
        "field2" text);
COPY "test1" FROM stdin;
\.
COPY "test2" FROM stdin;
\.
CREATE RULE rule1 AS ON UPDATE TO test1 DO INSERT INTO test2 SELECT * FROM
test1 WHERE oid=current.oid;

After this I can�t read the ruledefinition.
The only result I get is that postgres eat all my memory.
(I have try it with up to 128 MB Ram and 768 MB Swap and I
have killed postmaster after he used more then 85% of this
memory)

If I only make an simple rule like
CREATE RULE rule1 AS ON UPDATE TO test1 DO INSTEAD NOTHING;
it work, but if I add an more complicate rule like above
it crash again.

The reason why I select the severity serious and not
critical is, that the rules work, my only problem is that
I can�t read them but they work.


--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date:

Previous
From: "Wheeler, Alfred"
Date:
Subject: unsubscribe pgsql-ports
Next
From: Thomas Lockhart
Date:
Subject: Re: Compiling PostgresSQL 6.4.2 on Indigo2