Foreign key referencing a VIEW - Mailing list pgsql-general

From Laurent Martelli
Subject Foreign key referencing a VIEW
Date
Msg-id CAP-_FZH_8qs=bm0V+s+osZnVnLOSu_ZqzSMfe74vOUeGCw=c2g@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi all,

I have a feature request for our dear fellow developpers : I would like to be able to create a foreign key constraint that references a view (or anything that looks like a table, as a function returning a table for instance) instead of a table.

Does that look doable ? The trickiest part is probably to ensure the constraint when the tables the view is built on are modified...

Cheers,
Laurent

pgsql-general by date:

Previous
From: CS DBA
Date:
Subject: Re: Partitioning and ORM tools
Next
From: "David G. Johnston"
Date:
Subject: Re: Only owners can ANALYZE tables...seems overly restrictive