[BUGS] Error: unknown type 'ame'

[Gabor Z. Papp]

Thats cool, I'm now subscribed to the bug list, and receive
others bug reports, but what is with my problem? No one will
answer at least a "Sorry, we don't know what can be the
problem" mail?

7.0.2

Linux 2.4.0-test7
libc-2.1.3.so
gcc 2.95.3

This database system will be initialized with username "sql".
This user will own all the data files and must also own the server process.

Fixing permissions on pre-existing data directory /var/lib/postgresql
Creating database system directory /var/lib/postgresql/base
Creating database XLOG directory /var/lib/postgresql/pg_xlog
Creating template database in /var/lib/postgresql/base/template1
ERROR:  Error: unknown type 'ame'.

ERROR:  Error: unknown type 'ame'.

Creating global relations in /var/lib/postgresql/base
ERROR:  Error: unknown type 'ame'.

ERROR:  Error: unknown type 'ame'.

Adding template1 database to pg_database
/usr/lib/postgresql/bin/initdb: line 481:  3829 Segmentation fault  
"$PGPATH"/postgres $BACKENDARGS template1 <"$TEMPFILE"

initdb failed.
Removing /var/lib/postgresql.
Removing temp file /tmp/initdb.3796.

[BUGS] views containing aggregates

[pgsql-bugs]

NAGY Andras ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
views containing aggregates

Long Description
Not sure, whether the `Views containing aggregates sometimes fail' and `Allow views of 
aggregate columns' entries from the TODO cover this, therefore the bug report.  An 
aggregate select from a view containing aggregates behaves differently as expected.  
Even if the support for this is on TODO, until fixing this, postgres should print a 
warning or otherwise reject such use of views.

Sample Code
create table example (
   name  text
);
insert into example values('alpha');
insert into example values('alpha');
insert into example values('alpha');
insert into example values('alpha');
insert into example values('beta');
insert into example values('beta');
insert into example values('gamma');

-- the following should always return the number
-- of rows a simple `select * from relation' would return

select count(*) from example;
 count 
---
 7
(1 row)


create view example_view as select name from example group by name;
select * from example_view;
 name  
---
 alpha
 beta
 gamma
(3 rows)

-- however, it is not the case here

select count(*) from example_view;
 count 
---
 4
 2
 1
(3 rows)



No file was uploaded with this report