Re: Updateable Views or Synonyms.

On Wed, 2012-05-30 at 11:16 +1200, Tim Uckun wrote:
> I am wondering if either of these features are on the plate for
> postgres anytime soon? I see conversations going back to 2007 on
> updateable views and some conversations about synonyms but obviously
> they have never been added to the database for some reason or another.

Neither of these has active development right now, as far as I know.
Updatable views will appear sometime, I'm sure, but I don't know when.

Synonyms sound fairly simple, but I believe there are some concerns
around catalog bloat and catalog lookup time. I can't remember the
details.

> With regards to synonyms. It seems to me I could kind of achieve the
> same functionality by creating a dblink into the same database. Would
> that be an insane?

You'd be working outside of the transaction, so it seems like you're
losing a lot there. How does it help you?

Regards,
    Jeff Davis