No title

Started by PostgreSQL Bugs Listabout 25 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re:

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