Request a Demo
Home   >   mailing lists

Re: Missing pg_depend entries for constraints created by extensions (deptype 'e') - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Missing pg_depend entries for constraints created by extensions (deptype 'e')
Date
Msg-id 3008018.1748728572@sss.pgh.pa.us
Whole thread Raw
In response to Missing pg_depend entries for constraints created by extensions (deptype 'e')  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
Tree view 
"Joel Jacobson" <joel@compiler.org> writes:
> Foreign key constraints created during CREATE EXTENSION
> lack a pg_depend entry with deptype='e'.

Why would it be a sensible thing for an extension to create a
foreign-key constraint on table(s) that it didn't itself create?
(If it did create them, the indirect dependency seems sufficient.)

            regards, tom lane

pgsql-hackers by date:

Previous
From: "Joel Jacobson"
Date:
Subject: Missing pg_depend entries for constraints created by extensions (deptype 'e')
Next
From: Tom Lane
Date:
Subject: Re: tighten generic_option_name, or store more carefully in catalog?