[ADMIN] unsubscribe

2005-04-26 Thread Rob Anderson
approve ErbNNx unsubscribe pgsql-admin [EMAIL PROTECTED]

[ADMIN] PostgreSQL in FreeBSD jails

2005-04-26 Thread Alexander Rusinov
Hi, I need to run a number of PostgreSQL servers in different FreeBSD jails. I managed to run a first instance of PostgreSQL server in a jail, but after I launch a new server in another jail the first one starts to return an error messages like the following: semctl(1507328, 4, SETVAL, 0) faile

[ADMIN] FW: pg_dump not in object dependency order for sequences used for primary keys

2005-04-26 Thread Garris, Nicole
Quite right, "create sequence" occuring after the "create table" is not the cause of the problem. Thanks, Tom. (Now I'm suspecting a character translation problem, most likely with the line feed character.) -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, April

Re: [ADMIN] PostgreSQL in FreeBSD jails

2005-04-26 Thread Mario Soto Cordones
2005/4/26, Alexander Rusinov <[EMAIL PROTECTED]>: > Hi, > > I need to run a number of PostgreSQL servers in different FreeBSD jails. > I managed to run a first instance of PostgreSQL server in a jail, but > after I launch a new server in another jail the first one starts to > return an error messa

[ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Mario Soto Cordones
Hello list, there is migrate to postgreSQL 8.0. and I have begun to have some errors, before had the 7.4.5: For example I have the following function: CREATE OR REPLACE FUNCTION "public"."find_observaciones_activos" (integer, integer, text) RETURNS SETOF "public"."finddoc_t" AS $body$ select se

Re: [ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Oleg Bartunov
How did you migrate to 8.0 ? Have you read about regprocedure patch from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ? Oleg On Tue, 26 Apr 2005, Mario Soto Cordones wrote: Hello list, there is migrate to postgreSQL 8.0. and I have begun to have some errors, before had the 7.4.5: For e

Re: [ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Mario Soto Cordones
Hi I migrate the database according to the procedure indicated in the documentation of 8.0.2 , but I have not read the documentation of the patch of the tsearch, but my others functions make in pl/pgsql make for me work fine thank 2005/4/26, Oleg Bartunov : > How did you migrate to 8.0 ? > Hav

Re: [ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Mario Soto Cordones
Hi I am trying to apply the following patches to solve my problem tsearch2_stat.patch.gz and regprocedure_7.4.patch.gz , but I don't understand that it is what it is necessary to make thank you 2005/4/26, Mario Soto Cordones <[EMAIL PROTECTED]>: > Hi > I migrate the database according to the p

Re: [ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Oleg Bartunov
On Tue, 26 Apr 2005, Mario Soto Cordones wrote: Hi I migrate the database according to the procedure indicated in the documentation of 8.0.2 , but I have not read the documentation of the patch of the tsearch, but my others functions make in pl/pgsql make so you have two choices - if you have 7.4.5

Re: [ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Mario Soto Cordones
OK thank you for your help 2005/4/26, Oleg Bartunov : > On Tue, 26 Apr 2005, Mario Soto Cordones wrote: > > > Hi > > I migrate the database according to the procedure indicated in the > > documentation of 8.0.2 , but I have not read the documentation of the > > patch of the tsearch, but my other

Re: [ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Oleg Bartunov
On Tue, 26 Apr 2005, Mario Soto Cordones wrote: Hi I am trying to apply the following patches to solve my problem tsearch2_stat.patch.gz and regprocedure_7.4.patch.gz , but I don't understand that it is what it is necessary to make Mario, read http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2