How to stop the list of pgsql
-----Original Message-----
发件人: pgsql-general@hub.org <pgsql-general@hub.org>
收件人: Rongjwrs <Rongjwrs>
日期: 1999年6月17日 12:31
主题: pgsql-general-digest V1 #355
>
>pgsql-general-digest Wednesday, June 16 1999 Volume 01 : Number 355
>
>
>
>Index:
>
>initdb in 6.5 not creating 'postgres' db
>oid in PL/pgSQL
>oid in PL/pgSQL
>HELP needed : COPY datas from file
>Re: [GENERAL] Fw: Can't even specify template
>HELP needed : COPY datas from file
>Notes for SGI Irix users
>Re: [GENERAL] Notes for SGI Irix users
>HELP needed : COPY datas from file
>[GENERAL] HELP needed : COPY datas from file
>Re: [GENERAL] HELP needed : COPY datas from file
>Re: [GENERAL] Fw: Can't even specify template
>Postgresql v6.5 changes
>Update of bitmask type
>Re: [GENERAL] Postgresql v6.5 changes
>Re: [GENERAL] Postgresql v6.5 changes
>Re: [GENERAL] initdb in 6.5 not creating 'postgres' db
>Re: [GENERAL] initdb in 6.5 not creating 'postgres' db
>Success in upgrading to 6.5
>Re: [GENERAL] Postgresql v6.5 changes
>Database retreival time
>Re: [GENERAL] initdb in 6.5 not creating 'postgres' db
>Re: [GENERAL] initdb in 6.5 not creating 'postgres' db
>Rebuilding Primary Key???
>Old Versions?
>Re: [GENERAL] Rebuilding Primary Key???
>
>----------------------------------------------------------------------
>
>Date: Wed, 16 Jun 1999 15:20:11 +1000
>From: "Robert Chalmers" <robert@chalmers.com.au>
>Subject: initdb in 6.5 not creating 'postgres' db
>
>Just installed 6.5, all seems well, but it wont start - claims initdb
didn't
>creat the database 'postgres' ...
>
>whats happening here ?
>
>thanks
>Bob
>
>- --- http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive!
>4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some of
>the
>original DJ's - back on air - and supporting not only the original Vets, in
>comprehensive AFVN Archives, but putting together segments for the fighting
>men and
>women of todays services all around the world. World Music, for people of
>the world.
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 10:15:48 +0200
>From: Peter Keller <kel@bvv.bayern.de>
>Subject: oid in PL/pgSQL
>
>- --------------33F446CFB216C1E85AFFF536
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Hi,
>I need the row oid of an insert in an PL/pgSQL function.
>For explanation: After an insert I call a PL/pgSQL function (by a
>trigger) and I like to insert into an other table the row oid of the
>first insert. But I don't know how to get the oid.
>Thank you for helping,
>Peter
>
>- --
>CREATE FUNCTION func1() RETURNS OPAQUE AS '
>BEGIN
>dummy := new.name;
>dummy1 := new.oid;
>INSERT INTO table VALUES (dummy,dummy1);
>RETURN new;
>END;'
> language 'plpgsql';
>- --
>CREATE TRIGGER test1 AFTER INSERT OR UPDATE OR DELETE
>ON person for each row execute procedure pro1('name','oid');
>- --
>begin;
>insert into person values ('.........');
>end;
>
>=> ERROR: record new has no field oid
>
>
>- --
> Peter Keller Tel: (+49) 089-2190-2594
> Fax: (+49) 089-2190-2459
> mailto:Peter.Keller@bvv.bayern.de
>..............................................................
> Bezirksfinanzdirektion Muenchen - Vermessungsabteilung
> Alexandrastr. 3
> 80538 Muenchen
> Zimmer: 404
> www: http://www.bayern.de/vermessung/
>- --
>
>- --------------33F446CFB216C1E85AFFF536
>Content-Type: text/html; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
><html>
>Hi,
><br>I need the row oid of an insert in an PL/pgSQL function.
><br>For explanation: After an insert I call a PL/pgSQL function (by a
trigger)
>and I like to insert into an other table the row oid of the first insert.
>But I don't know how to get the oid.
><br>Thank you for helping,
><br>Peter
><p>--
><br>CREATE FUNCTION func1() RETURNS OPAQUE AS '
><br>BEGIN
><br>dummy := new.name;
><br>dummy1 := new.oid;
><br>INSERT INTO table VALUES (dummy,dummy1);
><br>RETURN new;
><br>END;'
><br> language 'plpgsql';
><br>--
><br>CREATE TRIGGER test1 AFTER INSERT OR UPDATE OR DELETE
><br>ON person for each row execute procedure pro1('name','oid');
><br>--
><br>begin;
><br>insert into person values ('.........');
><br>end;
><p>=> ERROR: record new has no field oid
><br>
><pre>--
> Peter
Keller &nbs
p; Tel: (+49) 089-2190-2594
> &nb
sp; &
nbsp; Fax: (+49) 089-2190-2459
> &nb
sp; &
nbsp; <A
HREF="mailto:Peter.Keller@bvv.bayern.de">mailto:Peter.Keller@bvv.bayern.de</
A>
>..............................................................
> Bezirksfinanzdirektion
Muenchen - Vermessungsabteilung
> Alexandrastr. 3
> 80538 Muenchen
> Zimmer: 404
> www: <A
HREF="http://www.bayern.de/vermessung/">http://www.bayern.de/vermessung/</A>
>- --</pre>
></html>
>
>- --------------33F446CFB216C1E85AFFF536--
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 10:27:41 +0200
>From: Peter Keller <peter.keller@bvv.bayern.de>
>Subject: oid in PL/pgSQL
>
>Hi,
>I need the row oid of an insert in an PL/pgSQL function.
>For explanation: After an insert I call a PL/pgSQL function (by a
>trigger) and I like to insert into an other table the row oid of the
>first insert. But I don't know how to get the oid.
>Thank you for helping,
>Peter
>
>- --
>CREATE FUNCTION func1() RETURNS OPAQUE AS '
>BEGIN
>dummy := new.name;
>dummy1 := new.oid;
>INSERT INTO table VALUES (dummy,dummy1);
>RETURN new;
>END;'
> language 'plpgsql';
>- --
>CREATE TRIGGER test1 AFTER INSERT OR UPDATE OR DELETE
>ON person for each row execute procedure pro1('name','oid');
>- --
>begin;
>insert into person values ('.........');
>end;
>
>=> ERROR: record new has no field oid
>
>- --
> Peter Keller Tel: (+49) 089-2190-2594
> Vermessungsrat z.A. Fax: (+49) 089-2190-2459
> mailto:Peter.Keller@bvv.bayern.de
>..............................................................
> Bezirksfinanzdirektion Muenchen - Vermessungsabteilung
> Alexandrastr. 3
> 80538 Muenchen
> Zimmer: 404
> www: http://www.bayern.de/vermessung/
>- --
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 11:54:00 +0200
>From: "Ming-Hung Eng" <mheng@hachette-multimedia.fr>
>Subject: HELP needed : COPY datas from file
>
>Hi
>
>I have a problem to copy datas from unix file, I get the following message
>when I try to import
>a file with more 200000 lines :
>
>pgReadData() -- backend closed the channel unexpectedly
> This probably means the backend terminated abnormally before or while
>processing the request.
>We have lost the connection to the backend, so further processing is
>impossible. Terminating.
>
>I use postgres 6.4.2 on solaris.
>
>Thanks for your help!
>
>- --
>ENG Ming Hung
>mheng@hachette-multimedia.fr
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 14:41:14 +0300
>From: Herouth Maoz <herouth@oumail.openu.ac.il>
>Subject: Re: [GENERAL] Fw: Can't even specify template
>
>At 01:32 +0300 on 16/06/1999, Dan Wilson wrote:
>
>
>> I even tried to specify the template with --with-template=linux_i386, but
I
>> get the same exact error message:
>> ./configure --with-template=linux_i386
>> loading cache ./config.cache
>> checking host system type... configure: error: can not guess host type;
you
>> must specify one
>>
>> I ran ./config.guess and that didn't output anything.
>>
>> Does anyone know how to specify this in Linux to auto detect or how can I
>> get it to recognize the parameter?
>>
>> I'm at a loss.
>
>It's not my strong side, but on the face of it, I think that your cache
>contains the decisions config made in the previous installation. So now it
>does not fit your current setup.
>
>I would delete te config cache and try again if I were you.
>
>Herouth
>
>- --
>Herouth Maoz, Internet developer.
>Open University of Israel - Telem project
>http://telem.openu.ac.il/~herutma
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 13:56:00 +0200
>From: "Ming-Hung Eng" <mheng@hachette-multimedia.fr>
>Subject: HELP needed : COPY datas from file
>
>Hi
>
>I have a problem to copy datas from unix file, I get the following message
>when I try to import
>a file with more 200000 lines :
>
>pgReadData() -- backend closed the channel unexpectedly
> This probably means the backend terminated abnormally before or while
>processing the request.
>We have lost the connection to the backend, so further processing is
>impossible. Terminating.
>
>I use postgres 6.4.2 on solaris.
>
>Thanks for your help!
>
>- --
>ENG Ming Hung
>mheng@hachette-multimedia.fr
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 14:22:16 +0200
>From: Alessandro Baldoni <abaldoni@racine.ra.it>
>Subject: Notes for SGI Irix users
>
>Dear SGI friends,
> Please try NOT to compile PostgreSQL (any version) with gcc on Irix.
>
>Due to a problem in the generation of the code of semaphors and other
>structs, any PgSQL binary produced with gcc will be buggy.
>More information on this subject at
> http://reality.sgi.com/ariel/freeware/howto.html
>Look for the section "gcc vs. cc" (I fought with gcc and PgSQL one month
>before discovering this page...)
>Try instead to use the native cc compiler: I compiled PgSQL 6.5
>yesterday (Irix 6.3 on O2 R10000, cc 7.1, gmake 3.77) and lo'! amazing
>performance increase!! I still think the large object subsystem to be
>broken, but since I don't use it anymore, I didn't try it out.
>
>Bye
>Alessandro
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 08:21:52 -0400 (EDT)
>From: Bruce Momjian <maillist@candle.pha.pa.us>
>Subject: Re: [GENERAL] Notes for SGI Irix users
>
>> Dear SGI friends,
>> Please try NOT to compile PostgreSQL (any version) with gcc on Irix.
>>
>> Due to a problem in the generation of the code of semaphors and other
>> structs, any PgSQL binary produced with gcc will be buggy.
>> More information on this subject at
>> http://reality.sgi.com/ariel/freeware/howto.html
>> Look for the section "gcc vs. cc" (I fought with gcc and PgSQL one month
>> before discovering this page...)
>> Try instead to use the native cc compiler: I compiled PgSQL 6.5
>> yesterday (Irix 6.3 on O2 R10000, cc 7.1, gmake 3.77) and lo'! amazing
>> performance increase!! I still think the large object subsystem to be
>> broken, but since I don't use it anymore, I didn't try it out.
>
>Can you contact the Irix FAQ maintainer and make sure this is in there?
>If you can't get it done, let me know and I will try to get it in there.
>
>- --
> Bruce Momjian | http://www.op.net/~candle
> maillist@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 14:37:12 +0200
>From: "Ming-Hung Eng" <mheng@hachette-multimedia.fr>
>Subject: HELP needed : COPY datas from file
>
>Hi
>
>I have a problem to copy datas from unix file, I get the following message
>when I try to import
>a file with more 200000 lines :
>
>pgReadData() -- backend closed the channel unexpectedly
> This probably means the backend terminated abnormally before or while
>processing the request.
>We have lost the connection to the backend, so further processing is
>impossible. Terminating.
>
>I use postgres 6.4.2 on solaris.
>
>Thanks for your help!
>
>- --
>ENG Ming Hung
>mheng@hachette-multimedia.fr
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 14:44:05 +0200
>From: "Ming-Hung Eng" <mheng@hachette-multimedia.fr>
>Subject: [GENERAL] HELP needed : COPY datas from file
>
>Hi
>
>I have a problem to copy datas from unix file, I get the following message
>when I try to import
>a file with more 200000 lines :
>
>pgReadData() -- backend closed the channel unexpectedly
> This probably means the backend terminated abnormally before or while
>processing the request.
>We have lost the connection to the backend, so further processing is
>impossible. Terminating.
>
>I use postgres 6.4.2 on solaris.
>
>Thanks for your help!
>
>- --
>ENG Ming Hung
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 16:54:37 +0400 (MSD)
>From: Oleg Broytmann <phd@emerald.netskate.ru>
>Subject: Re: [GENERAL] HELP needed : COPY datas from file
>
>Hi!
>
>On Wed, 16 Jun 1999, Ming-Hung Eng wrote:
>> I have a problem to copy datas from unix file, I get the following
message
>> when I try to import
>> a file with more 200000 lines :
>>
>> pgReadData() -- backend closed the channel unexpectedly
>> This probably means the backend terminated abnormally before or while
>> processing the request.
>> We have lost the connection to the backend, so further processing is
>> impossible. Terminating.
>>
>> I use postgres 6.4.2 on solaris.
>
> There is a memory leak in 6.4.2. Split your data into smaller chunks...
>
>> Thanks for your help!
>>
>> --
>> ENG Ming Hung
>
>Oleg.
>- ----
> Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net
> Programmers don't die, they just GOSUB without RETURN.
>
>------------------------------
>
>Date: Wed, 16 Jun 1999 07:53:05 -0600
>From: "Dan Wilson" <dan_wilson@geocities.com>
>Subject: Re: [GENERAL] Fw: Can't even specify template
>
>joel reed wrote:
>> try configure --host=i686-pc-linux-gnu
>>
>> change i686 as needed
>
>OK, cool, that worked ... but ... here's what happened next.
>
>$ ./configure --host=i586-pc-linux
>creating cache ./config.cache
>checking host system type... i586-pc-linux-gnu
>checking echo setting...
>checking setting template to... linux_i386
>checking setting USE_LOCALE... disabled
>checking setting CYR_RECODE... disabled
>checking setting MULTIBYTE... disabled
>checking setting DEF_PGPORT... 5432
>checking setting DEF_MAXBACKENDS... 32
>checking setting USE_TCL... disabled
>checking setting USE_PERL... disabled
>checking setting USE_ODBC... disabled
>checking setting ASSERT CHECKING... disabled
>checking for gcc... gcc
>checking whether the C compiler (gcc -O2 ) works... no
>configure: error: installation or configuration problem: C compiler cannot
>create executables
>
>I check for gcc. It's there, but it doesn't accept a parameter of -02. Is
>this because of a newer version of the compiler or something.
>
>What I don't get is that this all worked just fine the other day. Am I
>missing some libraries or something. This is a fresh install after a
>reformat, and I think pgsql was installed with an RPM the very first time
>before.
>
>Any ideas would be great,
>- -Dan Wilson
>
>>
>> --- Dan Wilson <dan_wilson@geocities.com> wrote:
>
><<< Continued to next message >>>
>
