Aggregate definition : small oversight ?

On Tue, Feb 18, 2003 at 09:26:10 +0100,
Emmanuel Charpentier <charpent@bacbuc.dyndns.org> wrote:

Dear list,

7.3.x has CREATE OR REPLACE { VIEW | FUNCTION | TABLE ... }, but it lacks
CREATE OR REPLACE AGGREGATE, which may be a boon to ten-thumbed users like
me ...

I think you are mistaken. While there are create or replace commands for
functions and views, there isn't one for tables.

Emmanuel Charpentier <charpent@bacbuc.dyndns.org> writes:

Dear list,
7.3.x has CREATE OR REPLACE { VIEW | FUNCTION | TABLE ... }, but it lacks
CREATE OR REPLACE AGGREGATE, which may be a boon to ten-thumbed users like
me ...

Is that an oversight, or is there deeper reasons to this omission ?

Lack of implementation effort; lack of demand for feature. Is it really
that useful, as compared to dropping and remaking the aggregate?

regards, tom lane

Tom Lane wrote:

Emmanuel Charpentier <charpent@bacbuc.dyndns.org> writes:

Dear list,
7.3.x has CREATE OR REPLACE { VIEW | FUNCTION | TABLE ... }, but it lacks
CREATE OR REPLACE AGGREGATE, which may be a boon to ten-thumbed users like
me ...

Is that an oversight, or is there deeper reasons to this omission ?

Lack of implementation effort; lack of demand for feature. Is it really
that useful, as compared to dropping and remaking the aggregate?

Avoiding errors aborting scripts. Not really a point, but ...

Emmanuel Charpentier

--
Emmanuel Charpentier