回复: pgsql-general-digest V1 #355 - Mailing list pgsql-general
| From | rongjianwei |
|---|---|
| Subject | 回复: pgsql-general-digest V1 #355 |
| Date | |
| Msg-id | 01beb9e2$8f270880$LocalHost@rongjianwei-h Whole thread Raw |
| List | pgsql-general |
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 >>> >
pgsql-general by date: