Sequence nexvtal() and initdb/pg_proc problem
От | Ole Gjerde |
---|---|
Тема | Sequence nexvtal() and initdb/pg_proc problem |
Дата | |
Msg-id | Pine.LNX.4.05.9905221828320.326-100000@snowman.icebox.org обсуждение исходный текст |
Ответы |
Re: [HACKERS] Sequence nexvtal() and initdb/pg_proc problem
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: