Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15534: Operators from public schema in trigger WHEN-clauses are silently allowed despite breaking restores - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15534: Operators from public schema in trigger WHEN-clauses are silently allowed despite breaking restores
Date
Msg-id 18136.1543682579@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #15534: Operators from public schema in trigger WHEN-clauses are silently allowed despite breaking restores  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
Tree view 
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> What's happening here is that IS DISTINCT FROM has a hidden search_path
> search in it, that ruleutils doesn't (and can't) handle.

Right.  A few months ago I posted a list of problems of this ilk
(IS DISTINCT FROM is far from the only trouble spot).  Too lazy to
search the archives for it right now, but the discussion kinda went
nowhere AFAIR.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: BUG #15534: Operators from public schema in trigger WHEN-clauses are silently allowed despite breaking restores
Next
From: Ananth Thomas
Date:
Subject: Postgres Sequence issue