Sequence nexvtal() and initdb/pg_proc problem

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

Browse pgsql-hackers by date

  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)