Undeliverable Message - Mailing list pgsql-general (2024)

Home>mailing lists

To: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>]Cc:Subject: pgsql-general-digest V1 #326Message not delivered to recipients below. Press F1 for help with VNMerror codes. VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_ESTVNM3043 -- MAILBOX IS FULL The message cannot be delivered because the recipient's mailbox contains the maximum number of messages, as set by the system administrator. The recipient must delete some messages before any other messages can be delivered. The maximum message limit for a user's mailbox is 10,000. The default message limit is 1000 messages. Administrators can set message limits using the Mailbox Settings function available in the Manage User menu (MUSER). When a user's mailbox reaches the limit, the user must delete some of the messages before the mailbox can accept any more incoming messages.---------------------- Original Message Follows ----------------------pgsql-general-digest Monday, May 24 1999 Volume 01 : Number 326Index:Re: [GENERAL] Full Text SearchesUndeliverable MessageAnnounce: free Perl AddressBookDate: Mon, 24 May 1999 16:35:45 +0900Problems with INSERT INTO?PL/pgSQL - accessing arraysRe: [GENERAL] Full Text SearchesRe: [GENERAL] Full Text SearchesRe: [GENERAL] Problems with INSERT INTO?Re: [GENERAL] Problems with INSERT INTO?Re: [GENERAL] Full Text SearchesRe: [GENERAL] Full Text SearchesRe: [GENERAL] PL/pgSQL - mailng listRe: [GENERAL] Full Text SearchesRe: [GENERAL] Full Text SearchesRe: [GENERAL] Full Text SearchesRe: [GENERAL] PL/pgSQL - mailng listRe: [GENERAL] Full Text SearchesOuter joinsJDBC and insert - stack overflowRe: [GENERAL] Full Text SearchesRe: [GENERAL] PL/pgSQL - mailng list----------------------------------------------------------------------Date: Sun, 23 May 1999 23:30:53 -0400 (EDT)From: Bruce Momjian <maillist@candle.pha.pa.us>Subject: Re: [GENERAL] Full Text SearchesWe have a fulltext stuff in the contrib directory.> On Sun, 23 May 1999, Andy Lewis wrote:>> > Whats the possibility of having full text searches added to text fields?> >> > That would be awesome.....>> Unfortunately, full text indexing is a different issue than the kind of> indexing performed on table columns, and if you want to do any kind of> efficient full text searching, you have to index the individual words in> the text or it'd be so slow as to be hardly useful (especially if you're> talking about 600,000 records with 2K of text in each text field).>> Excalibur, for instance, creates its own internal indexing for full text> records, but uses an underlying SQL database for regular fielded data, and> when you design your database, you have to make the distinction about what> kind of indexing you want, stop words (words you don't want indexed, like> 'the' and 'of'), and the way certain fields can or will be searched.>> Brett W. McCoy> http://www.lan2wan.com/~bmccoy/> -----------------------------------------------------------------------> The six great gifts of an Irish girl are beauty, soft voice, sweet speech,> wisdom, needlework, and chastity.> -- Theodore Roosevelt, 1907>>>>- -- 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: Mon, 24 May 99 5:49:15 +0100From: <MAILER-DAEMON@mail1.sfr.fr>Subject: Undeliverable MessageTo: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>]Cc:Subject: pgsql-general-digest V1 #325Message not delivered to recipients below. Press F1 for help with VNMerror codes. VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_ESTVNM3043 -- MAILBOX IS FULL The message cannot be delivered because the recipient's mailbox contains the maximum number of messages, as set by the system administrator. The recipient must delete some messages before any other messages can be delivered. The maximum message limit for a user's mailbox is 10,000. The default message limit is 1000 messages. Administrators can set message limits using the Mailbox Settings function available in the Manage User menu (MUSER). When a user's mailbox reaches the limit, the user must delete some of the messages before the mailbox can accept any more incoming messages.- ---------------------- Original Message Follows ----------------------pgsql-general-digest Sunday, May 23 1999 Volume 01 : Number 325Index:Re: [GENERAL] PL/pgSQL - mailng listRe: [GENERAL] PL/pgSQL - mailng listTo: pgsql-general@postgreSQL.orgCompile problem on BSDi 3.0Keyed TablesRe: [GENERAL] Keyed TablesRe: [GENERAL] Compile problem on BSDi 3.0Re: [GENERAL] postgres getting slowRe: [GENERAL] Looking for Mr. AutonumRE: [GENERAL] For data based web site, which RDBMS is better & wh y ?RE: [GENERAL] Keyed TablesRe: [GENERAL] Keyed TablesFull Text SearchesRe: [GENERAL] Full Text Searches- ----------------------------------------------------------------------Date: Sat, 22 May 1999 22:26:16 -0500 (CDT)From: Andy Lewis <alewis@themecca.net>Subject: Re: [GENERAL] PL/pgSQL - mailng listThe only thing that I know is whats in the docs and whats in the srcdirectory. I'd like to see/read more. I was going to pick up a Oracle bookon it but, I'm afraid that PL/pgSQL and PL/SQL aren't the same.ThanksAndyOn Sat, 22 May 1999, dustin sallings wrote:> On Sat, 22 May 1999, Andy Lewis wrote:>> How can we tell you more if we don't know what you know? It's> usually pretty safe to just go ahead and ask the question. You'll be> redirected if you've posted to the wrong place.>> // I'd just plain would like to know more about PL/pgSQL.> //> // Andy> //> // On Sat, 22 May 1999, Piotr Stelmaszyk wrote:> //> // > I'd like to get to know where should I post messages concerning> // > PL/pgSQL.> // >> // >> // > /--------------------------------------------------------/> // > /- Piotr Stelmaszyk |---- Student of Computer Science ---/> // > /------------------ | at Poznan University of Technology /> // > /----- mailto:kelman@fanthom.math.put.poznan.pl ---------/> // > /----- mailto:kelman@alpha.net.pl -----------------------/> // > /--------------------------------------------------------/> // >> // >> // >> //> //> //>> --> Principal Member Technical Staff, beyond.com The world is watching America,> pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>> | Key fingerprint > L______________________________________________ and America is watching TV. __>- ------------------------------Date: Sat, 22 May 1999 21:05:22 -0700 (PDT)From: dustin sallings <dustin@spy.net>Subject: Re: [GENERAL] PL/pgSQL - mailng listOn Sat, 22 May 1999, Andy Lewis wrote: It only took me about three clicks off of the home page to getthis: http://postgresql.nextpath.com/docs/programmer/xplang.htmwhich does a pretty good job of describing it. I thought it did a goodenough job at describing the installation and the language. Enough for meto get it going, anyway. I'm not sure how you could read anything morethan the documentation (I mean, anything more should also bedocumentation). Have you tried it at all yet? Do you have any specificquestions? Are there any things you're trying to do with it that youhaven't been able to imagine or figure out yet?// The only thing that I know is whats in the docs and whats in the src// directory. I'd like to see/read more. I was going to pick up a Oracle book// on it but, I'm afraid that PL/pgSQL and PL/SQL aren't the same.//// Thanks//// Andy//// On Sat, 22 May 1999, dustin sallings wrote://// > On Sat, 22 May 1999, Andy Lewis wrote:// >// > How can we tell you more if we don't know what you know? It's// > usually pretty safe to just go ahead and ask the question. You'll be// > redirected if you've posted to the wrong place.// >// > // I'd just plain would like to know more about PL/pgSQL.// > //// > // Andy// > //// > // On Sat, 22 May 1999, Piotr Stelmaszyk wrote:// > //// > // > I'd like to get to know where should I post messages concerning// > // > PL/pgSQL.// > // >// > // >// > // > /--------------------------------------------------------/// > // > /- Piotr Stelmaszyk |---- Student of Computer Science ---/// > // > /------------------ | at Poznan University of Technology /// > // > /----- mailto:kelman@fanthom.math.put.poznan.pl ---------/// > // > /----- mailto:kelman@alpha.net.pl -----------------------/// > // > /--------------------------------------------------------/// > // >// > // >// > // >// > //// > //// > //// >// > --// > Principal Member Technical Staff, beyond.com The world is watching America,// > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>// > | Key fingerprint // > L______________________________________________ and America is watching TV. __// >//////- - --Principal Member Technical Staff, beyond.com The world is watching America,pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>| Key fingerprint L______________________________________________ and America is watching TV. __- ------------------------------Date: Sat, 22 May 1999 21:49:21 -0700From: ghoffman@ucsd.edu (Gary Hoffman)Subject: To: pgsql-general@postgreSQL.orgsubscribeend- ------------------------------Date: Sat, 22 May 1999 22:48:02 -0700From: ghoffman@ucsd.edu (Gary Hoffman)Subject: Compile problem on BSDi 3.0I suppose this is an oldie but goodie, but I need a clue.I've got BSDi 3.0 on an i386 platform. Following the installationinstructions for pgsql, I upgraded flex to 2.5.4 using the 2.5.4a downloadfrom prep.ai.mit.edu. However, when I run gmake, I get this failuresequence:- - -----------gmake lexverifygmake[1]: Entering directory `/usr2/src/pgsql/src'gmake -C lextest allgmake[2]: Entering directory `/usr2/src/pgsql/src/lextest'lex scan.lgcc2 -c lex.yy.cgcc2 -c lextest.cgcc2 -o lextest lex.yy.o lextest.ounexpected last match in input()gmake[2]: Leaving directory `/usr2/src/pgsql/src/lextest'You have a buggy version of flex. Read INSTALL and search for flex for afix.gmake[1]: *** [lexverify] Error 1gmake[1]: Leaving directory `/usr2/src/pgsql/src'gmake: *** [all] Error 2- - --------------My gcc is version 2.7.2.1, flex reports version 2.5.4.Can I buy a clue from someone?Thanks,Gary**************************************************************************** Gary B. Hoffman, Computing Services Manager e-mail: ghoffman@ucsd.edu ** Graduate School of International Relations and Pacific Studies (IR/PS) ** University of California, San Diego (UCSD) voice: (619) 534-1989 ** 9500 Gilman Dr., La Jolla, CA 92093-0519 USA fax: (619) 534-3939 ***************************************************************************- ------------------------------Date: Sun, 23 May 1999 17:04:50 +1200From: Glen and Rosanne Eustace <agree@godzone.net.nz>Subject: Keyed TablesI thought I had already posted this query but now I can't remember. IfI have please excuse the repeat. But as I can't remember the answereither can someone please comment.Is there likely to be any attempt to allow a table to be keyed. Itseems that by default a table is created as a heap and in order toimprove access speed, one must create indices on that table.I use Ingres at work and quite like the ability to do a 'modify table tobtree' type of command. When the table concerned is basically only akey plus value, it seems rather inefficient to have to have both theheap and then an index when supposedly one could simply make the tableinto a btree in the first place.- - --Glen Eustace, on behalf ofGodZone Internet Services, a division of AGRE Enterprises Limited.176 Te Awe Awe St, Palmerston North, New ZealandPh: +64 6 356 2562, Fax: +64 6 357 0271, Mobile: 025 416 184,http://WWW.GodZone.Net.NZ- ------------------------------Date: Sun, 23 May 1999 02:32:45 -0400 (EDT)From: Bruce Momjian <maillist@candle.pha.pa.us>Subject: Re: [GENERAL] Keyed Tables[Charset iso-8859-1 unsupported, filtering to ASCII...]> I thought I had already posted this query but now I can't remember. If> I have please excuse the repeat. But as I can't remember the answer> either can someone please comment.>> Is there likely to be any attempt to allow a table to be keyed. It> seems that by default a table is created as a heap and in order to> improve access speed, one must create indices on that table.>> I use Ingres at work and quite like the ability to do a 'modify table to> btree' type of command. When the table concerned is basically only a> key plus value, it seems rather inefficient to have to have both the> heap and then an index when supposedly one could simply make the table> into a btree in the first place.Yes, it is a nice feature, but we don't support it. We do have CLUSTER,but that is not as nice.- - -- 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: Sun, 23 May 1999 02:33:17 -0400 (EDT)From: Bruce Momjian <maillist@candle.pha.pa.us>Subject: Re: [GENERAL] Compile problem on BSDi 3.0Check your path, and delete configure.in so it sees flex, not lex.[Charset ISO-8859-1 unsupported, filtering to ASCII...]> I suppose this is an oldie but goodie, but I need a clue.>> I've got BSDi 3.0 on an i386 platform. Following the installation> instructions for pgsql, I upgraded flex to 2.5.4 using the 2.5.4a download> from prep.ai.mit.edu. However, when I run gmake, I get this failure> sequence:>> ----------->> gmake lexverify> gmake[1]: Entering directory `/usr2/src/pgsql/src'> gmake -C lextest all> gmake[2]: Entering directory `/usr2/src/pgsql/src/lextest'> lex scan.l> gcc2 -c lex.yy.c> gcc2 -c lextest.c> gcc2 -o lextest lex.yy.o lextest.o> unexpected last match in input()> gmake[2]: Leaving directory `/usr2/src/pgsql/src/lextest'>> You have a buggy version of flex. Read INSTALL and search for flex for a> fix.>> gmake[1]: *** [lexverify] Error 1> gmake[1]: Leaving directory `/usr2/src/pgsql/src'> gmake: *** [all] Error 2>> -------------->> My gcc is version 2.7.2.1, flex reports version 2.5.4.>> Can I buy a clue from someone?>> Thanks,> Gary>> ***************************************************************************> * Gary B. Hoffman, Computing Services Manager e-mail: ghoffman@ucsd.edu *> * Graduate School of International Relations and Pacific Studies (IR/PS) *> * University of California, San Diego (UCSD) voice: (619) 534-1989 *> * 9500 Gilman Dr., La Jolla, CA 92093-0519 USA fax: (619) 534-3939 *> **************************************************************************>>>- - -- 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: Sun, 23 May 1999 13:16:26 +0300From: Herouth Maoz <herouth@oumail.openu.ac.il>Subject: Re: [GENERAL] postgres getting slowAt 21:51 +0300 on 20/05/1999, Brian wrote:> What sort of things to do you catch with logging this? I haven't seen a> single thing goto this file since starting it:>> export PGLOGFILE> su postgres -c '/usr/bin/postmaster -B 250 -i -S -D/var/lib/pgsql -o -S>1024 >> ${PGLOGFILE} 2>&1'I usually add "-d 2" to my postmaster invocation. It puts a lot ofinformation in the logfile, although I must say I've never been happy aboutPostgres's logs. If you want to see where an error has occured, the actualquery is buried within many internal messages.Herouth- - --Herouth Maoz, Internet developer.Open University of Israel - Telem projecthttp://telem.openu.ac.il/~herutma- ------------------------------Date: Sun, 23 May 1999 12:57:05 +0300From: Herouth Maoz <herouth@oumail.openu.ac.il>Subject: Re: [GENERAL] Looking for Mr. AutonumAt 23:07 +0300 on 19/05/1999, E Westfield wrote:> Greetings> Looking for how to build a table with a built in unique sequential numeric> key (primary optional) and then copy from a flat file to that same field.> Can not see on the _CREATE TABLE_ nor the _TYPE_ how to do so. Is the OID> mentioned in the _COPY_ a possible.>> I wish to have a new unique ID for any additions to the table without> haveing to programmatically create one. This is done in other databases so> I am sure it is available in Postgresql. Thank you for you help in this> slow learning one.This question is in the FAQ, ITEM 3.13: http://www.postgresql.org/docs/faq-english.shtml#3.13Note that if you want to fill the table from a flat file that doesn't havethe serial numbers, you have to take some steps. Suppose the name of theserial field is "s1", and the other fields are "f1", "f2"... "fn".1) Create your table, say, "table1", with the fields s1, f1, f2... fn.2) Create a temporary table "temp1", with only fields f1, f2... fn.3) Use COPY to copy from the flat file to "temp1".4) Use the following insert command to fill "table1": INSERT INTO table1 (f1, f2, ... fn) SELECT f1, f2,... fn FROM temp1; As you see, there is no mention of the s1 field, and since it has a default, it fills itself automatically.5) Drop the temp1 table.Herouth- - --Herouth Maoz, Internet developer.Open University of Israel - Telem projecthttp://telem.openu.ac.il/~herutma- ------------------------------Date: Sun, 23 May 1999 13:01:34 +0300From: Herouth Maoz <herouth@oumail.openu.ac.il>Subject: RE: [GENERAL] For data based web site, which RDBMS is better & wh y ?At 00:59 +0300 on 20/05/1999, Jackson, DeJuan wrote:> The problem here is to find impartial comparisons.> The question between MySQL and PostgreSQL usually come down to> Do I care most about speed? - usually true for purely Web Apps.> or> Do I need transaction and the other features PostgreSQL offers? -> which tends to only be true if you plan on using the database for things> other than web development.To be more exact, you have to ask yourself whether only one person will beperforming updates at a time. The lack of transactions for MySQL implieslack of locks, and thus lack of support for concurrent updates.Herouth- - --Herouth Maoz, Internet developer.Open University of Israel - Telem projecthttp://telem.openu.ac.il/~herutma- ------------------------------Date: Mon, 24 May 1999 07:30:27 +1200From: Glen and Rosanne Eustace <agree@godzone.net.nz>Subject: RE: [GENERAL] Keyed Tables> Yes, it is a nice feature, but we don't support it. We do> have CLUSTER, but that is not as nice.Any chance of adding it to the list of possible enhancements ?- ------------------------------Date: Sun, 23 May 1999 17:03:05 -0400 (EDT)From: Bruce Momjian <maillist@candle.pha.pa.us>Subject: Re: [GENERAL] Keyed Tables[Charset iso-8859-1 unsupported, filtering to ASCII...]> > Yes, it is a nice feature, but we don't support it. We do> > have CLUSTER, but that is not as nice.>> Any chance of adding it to the list of possible enhancements ?Not sure it is do-able for us. It would require so much work, that Ihesitate to add it.- - -- 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: Sun, 23 May 1999 19:21:08 -0500 (CDT)From: Andy Lewis <alewis@themecca.net>Subject: Full Text SearchesWhats the possibility of having full text searches added to text fields?That would be awesome.....Andy- ------------------------------Date: Sun, 23 May 1999 22:26:08 -0400 (EDT)From: "Brett W. McCoy" <bmccoy@lan2wan.com>Subject: Re: [GENERAL] Full Text SearchesOn Sun, 23 May 1999, Andy Lewis wrote:> Whats the possibility of having full text searches added to text fields?>> That would be awesome.....Unfortunately, full text indexing is a different issue than the kind ofindexing performed on table columns, and if you want to do any kind ofefficient full text searching, you have to index the individual words inthe text or it'd be so slow as to be hardly useful (especially if you'retalking about 600,000 records with 2K of text in each text field).Excalibur, for instance, creates its own internal indexing for full textrecords, but uses an underlying SQL database for regular fielded data, andwhen you design your database, you have to make the distinction about whatkind of indexing you want, stop words (words you don't want indexed, like'the' and 'of'), and the way certain fields can or will be searched.Brett W. McCoy http://www.lan2wan.com/~bmccoy/- - -----------------------------------------------------------------------The six great gifts of an Irish girl are beauty, soft voice, sweet speech,wisdom, needlework, and chastity. -- Theodore Roosevelt, 1907- ------------------------------End of pgsql-general-digest V1 #325***********************************------------------------------Date: Mon, 24 May 1999 07:42:41 +0000From: Fabrice Scemama <fabrice.scemama@gesnet.net>Subject: Announce: free Perl AddressBookHi!I've writen a very little AddressBook program, which can bedownloaded at http://www.gesnet.net/Alone/AddressBook/ .It's not very big, nor very featured, but I find it usefulfor my personal needs, and just wanted to share it. It waswriten in Perl, and uses DBI, Postgresql, and DBD::Pg,which gives it nice possibilities (including the one ofdumping the database, and syncing a remote address bookdatabase that can be used when you're not at home, for e.g).Hope it will be useful to someone (else than myself ;-)Fabrice Scemama- --"Le jour ou les gauloises bleues fusionneront avec les gitanes vertes,l'avenir sera sombre pour le tabac gris." -- Pierre Dac------------------------------Date: Mon, 24 May 1999 16:35:45 +0900From: "Hideyuki Hirauchi" <hirauchi@daj.co.jp>Subject: Date: Mon, 24 May 1999 16:35:45 +0900subscribeend------------------------------Date: Mon, 24 May 1999 02:22:04 PDTFrom: "Anna Langer" <anna_langer@hotmail.com>Subject: Problems with INSERT INTO?Hi!We are not really sure if this question is right for this mailinglist.We have some problem with INSERT INTO and we dont know how to solve it.Weare writing it in a C-program. We are trying to get an integer from a fileand put it into a database. And we are sure that we get a interger into ourprogram.When we created the table in the database we set the attribut to int4.We get the problem when we trying to move the interger to the database.int aP0;PQexec(conn, "INSERT INTO octets VALUES(a)");But the program works when we do like this:PQexec(conn, "INSERT INTO octets VALUES(500)");It feels like we need to convert int a in some way, byt we dont know how. Weare beginners with Postgresql./Anna and Maria______________________________________________________Get Your Private, Free Email at http://www.hotmail.com------------------------------Date: Mon, 24 May 1999 11:37:33 +0200From: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>Subject: PL/pgSQL - accessing arraysI. Is there any way to access arrays in pl/pgsql?II. How to get to know how many elements does the array contain?(in pl/pgsql of course)/--------------------------------------------------------//- Piotr Stelmaszyk |---- Student of Computer Science ---//------------------ | at Poznan University of Technology //----- mailto:kelman@fanthom.math.put.poznan.pl ---------//----- mailto:kelman@alpha.net.pl -----------------------//--------------------------------------------------------/------------------------------Date: Mon, 24 May 1999 07:01:36 -0400 (EDT)From: "Brett W. McCoy" <bmccoy@lan2wan.com>Subject: Re: [GENERAL] Full Text SearchesOn Sun, 23 May 1999, Bruce Momjian wrote:> We have a fulltext stuff in the contrib directory.What's it called? I only see some tcl frontend stuff. Despite mypessimism form the prior message, I am interested in a full text retrievalengine.Brett W. McCoy http://www.lan2wan.com/~bmccoy/- -----------------------------------------------------------------------Lonely is a man without love. -- Englebert Humperdinck------------------------------Date: Mon, 24 May 1999 08:05:22 -0500 (CDT)From: Andy Lewis <alewis@themecca.net>Subject: Re: [GENERAL] Full Text SearchesIts not really, really explanitory.....On Mon, 24 May 1999, Brett W. McCoy wrote:> On Sun, 23 May 1999, Bruce Momjian wrote:>> > We have a fulltext stuff in the contrib directory.>> What's it called? I only see some tcl frontend stuff. Despite my> pessimism form the prior message, I am interested in a full text retrieval> engine.>> Brett W. McCoy> http://www.lan2wan.com/~bmccoy/> -----------------------------------------------------------------------> Lonely is a man without love.> -- Englebert Humperdinck>------------------------------Date: Mon, 24 May 1999 09:25:51 -0400 (EDT)From: Simon Drabble <simond@foxlink.net>Subject: Re: [GENERAL] Problems with INSERT INTO?On Mon, 24 May 1999, Anna Langer wrote:> Hi!> We are not really sure if this question is right for this mailinglist.> We have some problem with INSERT INTO and we dont know how to solve it.We> are writing it in a C-program. We are trying to get an integer from a file> and put it into a database. And we are sure that we get a interger into our> program.>> When we created the table in the database we set the attribut to int4.> We get the problem when we trying to move the interger to the database.>> int aP0;>> PQexec(conn, "INSERT INTO octets VALUES(a)");>>> But the program works when we do like this:>> PQexec(conn, "INSERT INTO octets VALUES(500)");>>> It feels like we need to convert int a in some way, byt we dont know how. We> are beginners with Postgresql.>> /Anna and Maria>Do this:PQexec(conn, "INSERT INTO octets VALUES(%d)", a);and read up on C's printf family of functions.Simon.- -- On October 7, 1998 the routine process of running anti-virus software on a Windows NT server at the Boeing Corporation shut the system down. Evidently, the software identified Windows NT itself as a virus and disabled it. -- http://www.vcnet.com/bmc/departments/nt/bugs.shtml Simon Drabble Somewhere in cyberspace simond@foxlink.net------------------------------Date: Mon, 24 May 1999 09:37:08 -0400 (EDT)From: Simon Drabble <simond@foxlink.net>Subject: Re: [GENERAL] Problems with INSERT INTO?On Mon, 24 May 1999, Simon Drabble wrote:> On Mon, 24 May 1999, Anna Langer wrote:>> > When we created the table in the database we set the attribut to int4.> > We get the problem when we trying to move the interger to the database.> >> > int aP0;> >> > PQexec(conn, "INSERT INTO octets VALUES(a)");> >> >> > But the program works when we do like this:> >> > PQexec(conn, "INSERT INTO octets VALUES(500)");> >> >> > It feels like we need to convert int a in some way, byt we dont know how. We> > are beginners with Postgresql.> >> > /Anna and Maria> >>> Do this:>> PQexec(conn, "INSERT INTO octets VALUES(%d)", a);>> and read up on C's printf family of functions.>>> Simon.>*oops* heh-heh.Do _this_:char query[LOTS_OF_ROOM];sprintf(query, "INSERT INTO octects VALUES(%d)", a);PQexec(conn, query);and read up etc..- -or- download my libpq wrapper, which allows you to perform queries withoutusing a temporary char array, in a manner similar to printf(). Available viaanon ftp frombrainkarma.dyndns.org/pub/dblib/Note: it's very alpha right now and possibly quite messy as it's still underdevelopment - works though :)Simon.- -- On October 7, 1998 the routine process of running anti-virus software on a Windows NT server at the Boeing Corporation shut the system down. Evidently, the software identified Windows NT itself as a virus and disabled it. -- http://www.vcnet.com/bmc/departments/nt/bugs.shtml Simon Drabble Somewhere in cyberspace simond@foxlink.net------------------------------Date: Mon, 24 May 1999 09:45:27 -0400 (EDT)From: Bruce Momjian <maillist@candle.pha.pa.us>Subject: Re: [GENERAL] Full Text Searches> On Sun, 23 May 1999, Bruce Momjian wrote:>> > We have a fulltext stuff in the contrib directory.>> What's it called? I only see some tcl frontend stuff. Despite my> pessimism form the prior message, I am interested in a full text retrieval> engine.It is called contrib/fulltextindex. Does someone want to suggest abetter name?- -- 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: Mon, 24 May 1999 13:34:59 -0400 (EDT)From: "Brett W. McCoy" <bmccoy@lan2wan.com>Subject: Re: [GENERAL] Full Text SearchesOn Mon, 24 May 1999, Bruce Momjian wrote:> > What's it called? I only see some tcl frontend stuff. Despite my> > pessimism form the prior message, I am interested in a full text retrieval> > engine.>> It is called contrib/fulltextindex. Does someone want to suggest a> better name?I didn't see it on the ftp site. I only saw pgv and tcldb in the contribdirectory.Brett W. McCoy http://www.lan2wan.com/~bmccoy- -----------------------------------------------------------------------Cabbage, n.: A familiar kitchen-garden vegetable about as large and wise asa man's head. -- Ambrose Bierce, "The Devil's Dictionary"------------------------------Date: Mon, 24 May 1999 09:23:33 -0500 (CDT)From: Mike Haberman <mikeh@ncsa.uiuc.edu>Subject: Re: [GENERAL] PL/pgSQL - mailng listI too need more info on PL/pgSQL than the docs supply.Is it possible for people to mail me any examples of PL/pgSQL. Ijust need to see examples of the syntax of the various controlsturctures, variable assignment, and the like.From simple to very complex, send anything that might be helpful.thanks a tonmike habermanmikeh@ncsa.uiuc.edu>> On Sat, 22 May 1999, Andy Lewis wrote:>> How can we tell you more if we don't know what you know? It's> usually pretty safe to just go ahead and ask the question. You'll be> redirected if you've posted to the wrong place.>> // I'd just plain would like to know more about PL/pgSQL.> //> // Andy> //> // On Sat, 22 May 1999, Piotr Stelmaszyk wrote:> //> // > I'd like to get to know where should I post messages concerning> // > PL/pgSQL.> // >> // >> // > /--------------------------------------------------------/> // > /- Piotr Stelmaszyk |---- Student of Computer Science ---/> // > /------------------ | at Poznan University of Technology /> // > /----- mailto:kelman@fanthom.math.put.poznan.pl ---------/> // > /----- mailto:kelman@alpha.net.pl -----------------------/> // > /--------------------------------------------------------/> // >> // >> // >> //> //> //>> --> Principal Member Technical Staff, beyond.com The world is watching America,> pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>> | Key fingerprint > L______________________________________________ and America is watching TV. __>>------------------------------Date: Mon, 24 May 1999 09:42:53 -0500 (CDT)From: reedstrm@wallace.ece.rice.edu (Ross J. Reedstrom)Subject: Re: [GENERAL] Full Text Searches> On Mon, 24 May 1999, Bruce Momjian wrote:>> > > What's it called? I only see some tcl frontend stuff. Despite my> > > pessimism form the prior message, I am interested in a full text retrieval> > > engine.> >> > It is called contrib/fulltextindex. Does someone want to suggest a> > better name?>> I didn't see it on the ftp site. I only saw pgv and tcldb in the contrib> directory.Ah, here's the problem. Bruce means the contrib directory in thesource distribution, which is at the top level, right beside src(were the core of postgresql lives). It's pgsql/contrib, if youdo a CVS checkout. I'm not sure where it ends up in various binarypackages. (/usr/lib/postgresql/contrib on my Debian Linux install,for example, has parts of it,m but not the whole thing)Ross- --Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>NSBRI Research Scientist/ProgrammerComputer and Information Technology InstituteRice University, 6100 S. Main St., Houston, TX 77005------------------------------Date: Mon, 24 May 1999 09:48:40 -0500From: "Ross J. Reedstrom" <reedstrm@rice.edu>Subject: Re: [GENERAL] Full Text Searches> On Mon, 24 May 1999, Bruce Momjian wrote:>> > > What's it called? I only see some tcl frontend stuff. Despite my> > > pessimism form the prior message, I am interested in a full text retrieval> > > engine.> >> > It is called contrib/fulltextindex. Does someone want to suggest a> > better name?>> I didn't see it on the ftp site. I only saw pgv and tcldb in the contrib> directory.Ah, here's the problem. Bruce means the contrib directory in thesource distribution, which is at the top level, right beside src(were the core of postgresql lives). It's pgsql/contrib, if youdo a CVS checkout. I'm not sure where it ends up in various binarypackages. (/usr/lib/postgresql/contrib on my Debian Linux install,for example, has parts of it, but not the whole thing.)Ross- --Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>NSBRI Research Scientist/ProgrammerComputer and Information Technology InstituteRice University, 6100 S. Main St., Houston, TX 77005------------------------------Date: Mon, 24 May 1999 10:32:27 -0400 (EDT)From: Bruce Momjian <maillist@candle.pha.pa.us>Subject: Re: [GENERAL] Full Text Searches> On Mon, 24 May 1999, Bruce Momjian wrote:>> > > What's it called? I only see some tcl frontend stuff. Despite my> > > pessimism form the prior message, I am interested in a full text retrieval> > > engine.> >> > It is called contrib/fulltextindex. Does someone want to suggest a> > better name?>> I didn't see it on the ftp site. I only saw pgv and tcldb in the contrib> directory.Sorry, I meant in the distribution's contrib directory, not the ftpsite. I didn't even know we had a contrib directory on the ftp site.- -- 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: Tue, 25 May 1999 01:04:10 +1000From: Chris Bitmead <chris.bitmead@bigfoot.com>Subject: Re: [GENERAL] PL/pgSQL - mailng listIt's extremely straight-forward..$q $q->execute("foo");while (($x, $y, $z) #stuff}$q $q->execute($x,$y,$z);Mike Haberman wrote:>> I too need more info on PL/pgSQL than the docs supply.>> Is it possible for people to mail me any examples of PL/pgSQL. I> just need to see examples of the syntax of the various control> sturctures, variable assignment, and the like.>> >From simple to very complex, send anything that might be helpful.>> thanks a ton>> mike haberman> mikeh@ncsa.uiuc.edu>> >> > On Sat, 22 May 1999, Andy Lewis wrote:> >> > How can we tell you more if we don't know what you know? It's> > usually pretty safe to just go ahead and ask the question. You'll be> > redirected if you've posted to the wrong place.> >> > // I'd just plain would like to know more about PL/pgSQL.> > //> > // Andy> > //> > // On Sat, 22 May 1999, Piotr Stelmaszyk wrote:> > //> > // > I'd like to get to know where should I post messages concerning> > // > PL/pgSQL.> > // >> > // >> > // > /--------------------------------------------------------/> > // > /- Piotr Stelmaszyk |---- Student of Computer Science ---/> > // > /------------------ | at Poznan University of Technology /> > // > /----- mailto:kelman@fanthom.math.put.poznan.pl ---------/> > // > /----- mailto:kelman@alpha.net.pl -----------------------/> > // > /--------------------------------------------------------/> > // >> > // >> > // >> > //> > //> > //> >> > --> > Principal Member Technical Staff, beyond.com The world is watching America,> > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>> > | Key fingerprint > > L______________________________________________ and America is watching TV. __> >> >- --Chris Bitmeadhttp://www.bigfoot.com/~chris.bitmeadmailto:chris.bitmead@bigfoot.com------------------------------Date: Mon, 24 May 1999 14:31:36 -0400 (EDT)From: "Brett W. McCoy" <bmccoy@lan2wan.com>Subject: Re: [GENERAL] Full Text SearchesOn Mon, 24 May 1999, Bruce Momjian wrote:> Sorry, I meant in the distribution's contrib directory, not the ftp> site. I didn't even know we had a contrib directory on the ftp site.Wel, you do now! Thanks! I'll check it out!Brett W. McCoy http://www.lan2wan.com/~bmccoy- -----------------------------------------------------------------------Once, adv.: Enough. -- Ambrose Bierce, "The Devil's Dictionary"------------------------------Date: Mon, 24 May 1999 15:57:13 +0200 (CEST)From: Kaare Rasmussen <kar@webline.dk>Subject: Outer joinsGoing through the documentation I can only find little about outerjoins. One statement is in the Changes doc about including syntax forouter joins, but there doesn't seem to be implemented any code afterthat.Is it true that there's no outer joins yet? Any plans? Btw. what is thesyntax for outer joins. I know only Oracle's (+) operator.------------------------------Date: Mon, 24 May 1999 15:09:04 +0100From: Crispin Miller <crispin@cs.man.ac.uk>Subject: JDBC and insert - stack overflowHi,I am afraid I am a newbie. Forgive me if this is a silly question-I'm trying to create a large database using JDBC to load the tables bycalling executeUpdate with the statement "SQL INSERT INTO" + tableName +" VALUES (" etc...After 14 and a half thousand rows the java virtual machine crashes with:Exception in thread "main" java.lang.StackOverflowError at java.lang.Class.newInstance0(Native Method) at java.lang.Class.newInstance(Compiled Code) at sun.io.Converters.newConverter(Compiled Code) at sun.io.Converters.newDefaultConverter(Compiled Code) at sun.io.ByteToCharConverter.getDefault(Compiled Code) at java.lang.String.<init>(Compiled Code) at postgresql.PG_Stream.ReceiveString(Compiled Code) at postgresql.Connection.ExecSQL(Compiled Code) at postgresql.Statement.execute(Compiled Code) at postgresql.Statement.executeUpdate(Compiled Code)My first question is:Am I doing things in a really stupid way?If not, how do I fix the problem - I have tried increasing the defaultstack and memory size for the JVM...Crispin------------------------------Date: Mon, 24 May 1999 14:39:59 -0400 (EDT)From: "Brett W. McCoy" <bmccoy@lan2wan.com>Subject: Re: [GENERAL] Full Text SearchesHey, found the module. Looks pretty interesting -- even has thecapability of ignoring stopwords. This is just what I am looking for!Brett W. McCoy http://www.lan2wan.com/~bmccoy- -----------------------------------------------------------------------"What's the use of a good quotation if you can't change it?" -- Dr. Who------------------------------Date: Mon, 24 May 1999 16:30:56 +0100From: Stuart Rison <stuart@ludwig.ucl.ac.uk>Subject: Re: [GENERAL] PL/pgSQL - mailng listThat's an example of performing procedural tasks using Perl as theprocedural language with access to the database.I think what Mike is looking for are examples of using PL/pgSQL. Which, asit where, is a procedural language 'internal' to postgreSQL (well that avery bad way of putting it but I think you catch my drift).Plenty of examples of using PL/pgSQL in the docs (as previously pointedout). I started by looking at:http://www.postgresql.org/docs/programmer/xplang1290.htmand at the plpgsql.txt readme which can be found in the 'source' at:<source_directory>/src/pl/plpgsql/docStuart.>It's extremely straight-forward..>$q >$q->execute("foo");>while (($x, $y, $z) > #stuff>}>>$q >$q->execute($x,$y,$z);>>Mike Haberman wrote:>>>> I too need more info on PL/pgSQL than the docs supply.>>>> Is it possible for people to mail me any examples of PL/pgSQL. I>> just need to see examples of the syntax of the various control>> sturctures, variable assignment, and the like.>>>> >From simple to very complex, send anything that might be helpful.>>>> thanks a ton>>>> mike haberman>> mikeh@ncsa.uiuc.edu>>>> ><snip>>> >>>-->Chris Bitmead>http://www.bigfoot.com/~chris.bitmead>mailto:chris.bitmead@bigfoot.com+-------------------------+--------------------------------------+| Stuart Rison | Ludwig Institute for Cancer Research |+-------------------------+ 91 Riding House Street || Tel. (0171) 878 4041 | London, W1P 8BT, UNITED KINGDOM. || Fax. (0171) 878 4040 | stuart@ludwig.ucl.ac.uk |+-------------------------+--------------------------------------+------------------------------End of pgsql-general-digest V1 #326***********************************