CVS as of right now (18:40 pm Central), I can't make(use) sequences, and
initdb puts part of pg_proc in the wrong place.
Redhat Linux 6.0
Linux 2.2.7
glibc 2.1
(SQL below directly from a pg_dump -z):
\connect - postgres
CREATE SEQUENCE "cagedata_id_seq" start 165437 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
SELECT nextval ('cagedata_id_seq');
ERROR: No such function 'nextval' with the specified attributes
I also just ran initdb on a clean install, and pg_proc.1 and
pg_proc_proname_narg_type_index.1 gets put in /home/postgres as well as in
/home/postgres/data/base/template1
-rw------- 1 postgres postgres 131072 May 22 18:38 data/base/template1/pg_proc
-rw------- 1 postgres postgres 8192 May 22 18:40 data/base/template1/pg_proc.1
-rw------- 1 postgres postgres 40960 May 22 18:40 data/base/template1/pg_proc_oid_index
-rw------- 1 postgres postgres 131072 May 22 18:40 data/base/template1/pg_proc_proname_narg_type_index
-rw------- 1 postgres postgres 57344 May 22 18:40 data/base/template1/pg_proc_prosrc_index
-rw------- 1 postgres postgres 40960 May 22 18:38 pg_proc.1
-rw------- 1 postgres postgres 8192 May 22 18:38 pg_proc_proname_narg_type_index.1
Thanks,
Ole Gjerde
