Horton

Thread

  1. Sequence nexvtal() and initdb/pg_proc problem

    Ole Gjerde <gjerde@icebox.org> — 1999-05-23T00:30:44Z

    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