Thread

PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-02-20T14:56:36Z

Moritz Gmelin (moritz.gmelin@fzi.de) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description


Long Description
Hi Postgresql developers !

I'm pretty happy with postgres, and am right now testing PSQL 7.1 for
image storage and stuff.
So here's my bug report. pretty simple.
do a


create table test (id int);
insert into test values (1);
insert into test values (2);
insert into test values (3);
select count(id) from test;

You'll get

ERROR:  ExecEvalAggref: no aggregates in this expression context

This is in PSQL 7.1beta4. The latest from your CVS directory.

Thanks for fixing.

Moritz Gmelin

Sample Code
create table test (id int);
insert into test values (1);
insert into test values (2);
insert into test values (3);
select count(id) from test;


No file was uploaded with this report

Re:

Tom Lane <tgl@sss.pgh.pa.us> — 2001-02-20T15:36:26Z

pgsql-bugs@postgresql.org writes:
> create table test (id int);
> insert into test values (1);
> insert into test values (2);
> insert into test values (3);
> select count(id) from test;

> You'll get

> ERROR:  ExecEvalAggref: no aggregates in this expression context

?? I don't:

regression=# create table test (id int);
CREATE
regression=# insert into test values (1);
INSERT 145145 1
regression=# insert into test values (2);
INSERT 145146 1
regression=# insert into test values (3);
INSERT 145147 1
regression=# select count(id) from test;
 count
-------
     3
(1 row)

regression=#

What platform are you on?  How did you build Postgres?  Do the
regression tests pass for you?

			regards, tom lane