| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Tim Uckun <timuckun(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Updateable Views or Synonyms. |
| Date: | 2012-05-30 00:14:32 |
| Message-ID: | 1338336872.28651.24.camel@sussancws0025 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2012-05-30 00:19:49 | Re: Escaping `psql --variable` |
| Previous Message | David Kerr | 2012-05-30 00:05:17 | select current_setting('transaction_isolation') |