Thread: Aggregate definition : small oversight ?

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 ?

                    Emmanuel Charpentier
--
Emmanuel Charpentier

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