Re: Pet Peeves? - Mailing list pgsql-general

From Christopher Browne
Subject Re: Pet Peeves?
Date
Msg-id d6d6637f0902021354o5b7050ebv8e236b7d7c460856@mail.gmail.com
Whole thread Raw
In response to Pet Peeves?  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Pet Peeves?  (Gregory Stark <stark@enterprisedb.com>)
Re: Pet Peeves?  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
On Thu, Jan 29, 2009 at 8:16 AM, Gregory Stark <stark@enterprisedb.com> wrote:
> So, what do people say? Is Postgres perfect in your world or does it do some
> things which rub you the wrong way?

Things I'd particularly like to have that aren't entirely on the map yet:

- In place upgrade
- Stored procedures that can manage transactions (e.g. - contrast with
present stored functions that forcibly live *inside* a transaction
context; the point isn't functions vs procedures, but rather to have
something that can do txn management)

I'd expect that txn-managing procedures could then enable various
sorts of usages involving other interesting bits:
- Managing 2PC
- Managing NOTIFY/LISTEN
- Managing jobs (e.g. - "pgcron")
- Using dblink()/SQL-MED to manage cross-DB work

I'd expect these all to be the sorts of side-effects enabled by the
one change...
--
http://linuxfinances.info/info/linuxdistributions.html
Calvin Trillin  - "Health food makes me sick."

pgsql-general by date:

Previous
From: "Eric Brown"
Date:
Subject: Is dropping pg_ts_* harmful?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: plpgsql and control structures