From: | Ole Gjerde <gjerde(at)icebox(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Sequence nexvtal() and initdb/pg_proc problem |
Date: | 1999-05-23 00:30:44 |
Message-ID: | Pine.LNX.4.05.9905221828320.326-100000@snowman.icebox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-05-23 00:55:56 | Re: [HACKERS] DEFAULT fixed |
Previous Message | Tom Lane | 1999-05-22 23:48:59 | Re: [HACKERS] GEQO optimizer (was Re: Backend message type 0x44 arrived while idle) |