Re: CREATE RULE may generate duplicate entries in pg_depend

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ashwin Agrawal <ashwinstar(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE RULE may generate duplicate entries in pg_depend
Date: 2020-08-26 21:43:36
Message-ID: 2981628.1598478216@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ashwin Agrawal <ashwinstar(at)gmail(dot)com> writes:
> If action and qual reference same object in CREATE RULE, it results in
> creating duplicate entries in pg_depend for it. Doesn't pose any harm, just
> unnecessarily bloats pg_depend.

Yeah, we generally don't try that hard to prevent duplicate pg_depend
entries. It's relatively easy to get rid of them in limited contexts
like a single expression, but over a wider scope, I doubt it's worth
the trouble.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Anastasia Lubennikova 2020-08-26 22:03:49 Re: [PATCH] Covering SPGiST index
Previous Message Ashwin Agrawal 2020-08-26 21:39:53 CREATE RULE may generate duplicate entries in pg_depend