To: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>]
Cc:
Subject: pgsql-general-digest V1 #330
Message not delivered to recipients below. Press F1 for help with VNM
error codes.
VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_EST
VNM3043 -- 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 Tuesday, May 25 1999 Volume 01 : Number 330
Index:
Re: [GENERAL] size limits on insert/copy/etc
More pgsql compile problems on BSDi 3.0
Undeliverable Message
Undeliverable Message
----------------------------------------------------------------------
Date: Tue, 25 May 1999 14:31:00 +1000
From: Chris Bitmead <chris.bitmead@bigfoot.com>
Subject: Re: [GENERAL] size limits on insert/copy/etc
Unfortunately tuples cannot be bigger than 8k. Many of us I think look
forward to the day when this restriction doesn't apply (it is on the
to-do list), but at this point in time 8k is the limit.
Large objects will work, but they have other problems that make them
fairly impractical.
John Browning wrote:
>
> I'm trying to add large text items to a table (field declared as type
> text). PQSendQuery can't take more than 8192 bytes.That's OK. But COPY
> also complains that tuples of 29896 bytes are too big (trying to copy
> from a file). So how do I get big text fields into a table? Do I have to
> make them large objects? (And, if so, in what sense is the text field of
> "unlimited size"?) Or am I just missing something simple?
>
> Many thanks in advance for any advice...
>
> bests
>
> --
>
> John Browning // 71 Richmond Ave // London N1 0LX
> t 44 171 700 1230 // f 44 171 700 5255
------------------------------
Date: Mon, 24 May 1999 22:57:32 -0700
From: ghoffman@ucsd.edu (Gary Hoffman)
Subject: More pgsql compile problems on BSDi 3.0
Following up on my compile problem, I've read the list archives for great
clues and had a good reply from Bruce to last night's query. (I hope
someone turns these hints into an FAQ for BSDi users.)
I've overcome the flex problem by renaming lex and then making a link lex
- -> flex.
I also installed bison 1.27 and renamed yacc, making a link yacc -> bison
Now when I run 'gmake all', I get the following error:
- -------------
gmake -C bootstrap all
gmake[2]: Entering directory `/usr2/src/pgsql/src/backend/bootstrap'
/usr/bin/yacc -d bootparse.y
grep -v "^#" boot.sed > sedfile
sed -f sedfile < y.tab.c > bootparse.c
cannot open y.tab.c: no such file
gmake[2]: *** [bootparse.c] Error 2
gmake[2]: Leaving directory `/usr2/src/pgsql/src/backend/bootstrap'
gmake[1]: *** [bootstrap.dir] Error 2
gmake[1]: Leaving directory `/usr2/src/pgsql/src/backend'
gmake: *** [all] Error 2
- -------------
Of course, the subsequent install fails. Is y.tab.c supposed to be created
by the compile process or did I delete it by cleaning up my previous make?
I've done this several times.
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: Tue, 25 May 99 8:21:16 +0100
From: <MAILER-DAEMON@mail1.sfr.fr>
Subject: Undeliverable Message
To: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>]
Cc:
Subject: pgsql-general-digest V1 #329
Message not delivered to recipients below. Press F1 for help with VNM
error codes.
VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_EST
VNM3043 -- 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 329
Index:
Re: [GENERAL] Problems with INSERT INTO?
pg_dump core dumps
Re: [GENERAL] PL/pgSQL - mailng list
size limits on insert/copy/etc
- ----------------------------------------------------------------------
Date: Mon, 24 May 1999 10:34:51 -0700 (PDT)
From: Dustin Sallings <dustin@spy.net>
Subject: Re: [GENERAL] Problems with INSERT INTO?
On Mon, 24 May 1999, Simon Drabble wrote:
# char query[LOTS_OF_ROOM];
# sprintf(query, "INSERT INTO octects VALUES(%d)", a);
#
# PQexec(conn, query);
snprintf would probably be a better choice.
# -or- download my libpq wrapper, which allows you to perform queries without
# using a temporary char array, in a manner similar to printf(). Available via
# anon ftp from
#
# brainkarma.dyndns.org/pub/dblib/
I was about to suggest something like this be part of the core
library. It makes a lot of sense, and that's what vsnprintf is for. :)
- - --
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
| Key fingerprint L_______________________ I hope the answer won't upset her. ____________
- ------------------------------
Date: Mon, 24 May 1999 13:45:24 -0500
From: Ari Halberstadt <ari@shore.net>
Subject: pg_dump core dumps
Using pg_dump with 6.5b1 on solaris sparc, crashes with a core dump.
This means I can't keep backups and I can't upgrade my data model without
being able to export the old data.
If one of the developers wants debug info let me know what you need (e.g.,
what commands to run in gdb--though I'll have to install this or get run
permissions from the sysadmin).
- - -- Ari Halberstadt mailto:ari@shore.net <http://www.magiccookie.com/>
PGP public key available at <http://www.magiccookie.com/pgpkey.txt>
- ------------------------------
Date: Mon, 24 May 1999 11:08:58 -0700 (PDT)
From: Dustin Sallings <dustin@spy.net>
Subject: Re: [GENERAL] PL/pgSQL - mailng list
On Tue, 25 May 1999, Chris Bitmead wrote:
What does this have to do with pl/pgsql?
# 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
# >
# > >
# > > 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 Bitmead
# http://www.bigfoot.com/~chris.bitmead
# mailto:chris.bitmead@bigfoot.com
#
#
- - --
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
| Key fingerprint L_______________________ I hope the answer won't upset her. ____________
- ------------------------------
Date: Mon, 24 May 1999 23:15:21 +0100
From: John Browning <jb@poplar.com>
Subject: size limits on insert/copy/etc
I'm trying to add large text items to a table (field declared as type
text). PQSendQuery can't take more than 8192 bytes.That's OK. But COPY
also complains that tuples of 29896 bytes are too big (trying to copy
from a file). So how do I get big text fields into a table? Do I have to
make them large objects? (And, if so, in what sense is the text field of
"unlimited size"?) Or am I just missing something simple?
Many thanks in advance for any advice...
bests
- - --
John Browning // 71 Richmond Ave // London N1 0LX
t 44 171 700 1230 // f 44 171 700 5255
- ------------------------------
End of pgsql-general-digest V1 #329
***********************************
------------------------------
Date: Tue, 25 May 99 8:31:21 +0100
From: <MAILER-DAEMON@mail1.sfr.fr>
Subject: Undeliverable Message
To: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>]
Cc:
Subject: pgsql-general-digest V1 #328
Message not delivered to recipients below. Press F1 for help with VNM
error codes.
VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_EST
VNM3043 -- 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 328
Index:
Undeliverable Message
- ----------------------------------------------------------------------
Date: Mon, 24 May 99 19:32:39 +0100
From: <MAILER-DAEMON@mail1.sfr.fr>
Subject: Undeliverable Message
To: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>]
Cc:
Subject: pgsql-general-digest V1 #327
Message not delivered to recipients below. Press F1 for help with VNM
error codes.
VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_EST
VNM3043 -- 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 327
Index:
Undeliverable Message
- - ----------------------------------------------------------------------
Date: Mon, 24 May 99 18:45:34 +0100
From: <MAILER-DAEMON@mail1.sfr.fr>
Subject: Undeliverable Message
To: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>]
Cc:
Subject: pgsql-general-digest V1 #326
Message not delivered to recipients below. Press F1 for help with VNM
error codes.
VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_EST
VNM3043 -- 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 326
Index:
Re: [GENERAL] Full Text Searches
Undeliverable Message
Announce: free Perl AddressBook
Date: Mon, 24 May 1999 16:35:45 +0900
Problems with INSERT INTO?
PL/pgSQL - accessing arrays
Re: [GENERAL] Full Text Searches
Re: [GENERAL] Full Text Searches
Re: [GENERAL] Problems with INSERT INTO?
Re: [GENERAL] Problems with INSERT INTO?
Re: [GENERAL] Full Text Searches
Re: [GENERAL] Full Text Searches
Re: [GENERAL] PL/pgSQL - mailng list
Re: [GENERAL] Full Text Searches
Re: [GENERAL] Full Text Searches
Re: [GENERAL] Full Text Searches
Re: [GENERAL] PL/pgSQL - mailng list
Re: [GENERAL] Full Text Searches
Outer joins
JDBC and insert - stack overflow
Re: [GENERAL] Full Text Searches
Re: [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 Searches
We 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 +0100
From: <MAILER-DAEMON@mail1.sfr.fr>
Subject: Undeliverable Message
To: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>]
Cc:
Subject: pgsql-general-digest V1 #325
Message not delivered to recipients below. Press F1 for help with VNM
error codes.
VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_EST
VNM3043 -- 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 325
Index:
Re: [GENERAL] PL/pgSQL - mailng list
Re: [GENERAL] PL/pgSQL - mailng list
To: pgsql-general@postgreSQL.org
Compile problem on BSDi 3.0
Keyed Tables
Re: [GENERAL] Keyed Tables
Re: [GENERAL] Compile problem on BSDi 3.0
Re: [GENERAL] postgres getting slow
Re: [GENERAL] Looking for Mr. Autonum
RE: [GENERAL] For data based web site, which RDBMS is better & wh y ?
RE: [GENERAL] Keyed Tables
Re: [GENERAL] Keyed Tables
Full Text Searches
Re: [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 list
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. __
>
- - - - ------------------------------
Date: Sat, 22 May 1999 21:05:22 -0700 (PDT)
From: dustin sallings <dustin@spy.net>
Subject: Re: [GENERAL] PL/pgSQL - mailng list
On Sat, 22 May 1999, Andy Lewis wrote:
It only took me about three clicks off of the home page to get
this:
http://postgresql.nextpath.com/docs/programmer/xplang.htm
which does a pretty good job of describing it. I thought it did a good
enough job at describing the installation and the language. Enough for me
to get it going, anyway. I'm not sure how you could read anything more
than the documentation (I mean, anything more should also be
documentation). Have you tried it at all yet? Do you have any specific
questions? Are there any things you're trying to do with it that you
haven'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 -0700
From: ghoffman@ucsd.edu (Gary Hoffman)
Subject: To: pgsql-general@postgreSQL.org
subscribe
end
- - - - ------------------------------
Date: Sat, 22 May 1999 22:48:02 -0700
From: ghoffman@ucsd.edu (Gary Hoffman)
Subject: Compile problem on BSDi 3.0
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 *
**************************************************************************
- - - - ------------------------------
Date: Sun, 23 May 1999 17:04:50 +1200
From: Glen and Rosanne Eustace <agree@godzone.net.nz>
Subject: Keyed Tables
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.
- - - - - --
Glen Eustace, on behalf of
GodZone Internet Services, a division of AGRE Enterprises Limited.
176 Te Awe Awe St, Palmerston North, New Zealand
Ph: +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.0
Check 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 +0300
From: Herouth Maoz <herouth@oumail.openu.ac.il>
Subject: Re: [GENERAL] postgres getting slow
At 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 of
information in the logfile, although I must say I've never been happy about
Postgres's logs. If you want to see where an error has occured, the actual
query is buried within many internal messages.
Herouth
- - - - - --
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
- - - - ------------------------------
Date: Sun, 23 May 1999 12:57:05 +0300
From: Herouth Maoz <herouth@oumail.openu.ac.il>
Subject: Re: [GENERAL] Looking for Mr. Autonum
At 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.13
Note that if you want to fill the table from a flat file that doesn't have
the serial numbers, you have to take some steps. Suppose the name of the
serial 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 project
http://telem.openu.ac.il/~herutma
- - - - ------------------------------
Date: Sun, 23 May 1999 13:01:34 +0300
From: 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 be
performing updates at a time. The lack of transactions for MySQL implies
lack of locks, and thus lack of support for concurrent updates.
Herouth
- - - - - --
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
- - - - ------------------------------
Date: Mon, 24 May 1999 07:30:27 +1200
From: 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 I
hesitate 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 Searches
Whats 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 Searches
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
- - - - ------------------------------
End of pgsql-general-digest V1 #325
***********************************
- - - ------------------------------
Date: Mon, 24 May 1999 07:42:41 +0000
From: Fabrice Scemama <fabrice.scemama@gesnet.net>
Subject: Announce: free Perl AddressBook
Hi!
I've writen a very little AddressBook program, which can be
downloaded at http://www.gesnet.net/Alone/AddressBook/ .
It's not very big, nor very featured, but I find it useful
for my personal needs, and just wanted to share it. It was
writen in Perl, and uses DBI, Postgresql, and DBD::Pg,
which gives it nice possibilities (including the one of
dumping the database, and syncing a remote address book
database 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 +0900
From: "Hideyuki Hirauchi" <hirauchi@daj.co.jp>
Subject: Date: Mon, 24 May 1999 16:35:45 +0900
subscribe
end
- - - ------------------------------
Date: Mon, 24 May 1999 02:22:04 PDT
From: "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.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
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
- - - ------------------------------
Date: Mon, 24 May 1999 11:37:33 +0200
From: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
Subject: PL/pgSQL - accessing arrays
I. 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 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.
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 Searches
Its 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 without
using a temporary char array, in a manner similar to printf(). Available via
anon ftp from
brainkarma.dyndns.org/pub/dblib/
Note: it's very alpha right now and possibly quite messy as it's still under
development - 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 a
better 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 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.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
- - - - -----------------------------------------------------------------------
Cabbage, n.:
A familiar kitchen-garden vegetable about as large and wise as
a 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 list
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. __
>
>
- - - ------------------------------
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 the
source distribution, which is at the top level, right beside src
(were the core of postgresql lives). It's pgsql/contrib, if you
do a CVS checkout. I'm not sure where it ends up in various binary
packages. (/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/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
- - - ------------------------------
Date: Mon, 24 May 1999 09:48:40 -0500
From: "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 the
source distribution, which is at the top level, right beside src
(were the core of postgresql lives). It's pgsql/contrib, if you
do a CVS checkout. I'm not sure where it ends up in various binary
packages. (/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/Programmer
Computer and Information Technology Institute
Rice 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 ftp
site. 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 +1000
From: Chris Bitmead <chris.bitmead@bigfoot.com>
Subject: Re: [GENERAL] PL/pgSQL - mailng list
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
>
> >
> > 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 Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto: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 Searches
On 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 joins
Going through the documentation I can only find little about outer
joins. One statement is in the Changes doc about including syntax for
outer joins, but there doesn't seem to be implemented any code after
that.
Is it true that there's no outer joins yet? Any plans? Btw. what is the
syntax for outer joins. I know only Oracle's (+) operator.
- - - ------------------------------
Date: Mon, 24 May 1999 15:09:04 +0100
From: Crispin Miller <crispin@cs.man.ac.uk>
Subject: JDBC and insert - stack overflow
Hi,
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 by
calling 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 default
stack 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 Searches
Hey, found the module. Looks pretty interesting -- even has the
capability 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 +0100
From: Stuart Rison <stuart@ludwig.ucl.ac.uk>
Subject: Re: [GENERAL] PL/pgSQL - mailng list
That's an example of performing procedural tasks using Perl as the
procedural language with access to the database.
I think what Mike is looking for are examples of using PL/pgSQL. Which, as
it where, is a procedural language 'internal' to postgreSQL (well that a
very bad way of putting it but I think you catch my drift).
Plenty of examples of using PL/pgSQL in the docs (as previously pointed
out). I started by looking at:
http://www.postgresql.org/docs/programmer/xplang1290.htm
and at the plpgsql.txt readme which can be found in the 'source' at:
<source_directory>/src/pl/plpgsql/doc
Stuart.
>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
***********************************
- - ------------------------------
End of pgsql-general-digest V1 #327
***********************************
- ------------------------------
End of pgsql-general-digest V1 #328
***********************************
------------------------------
End of pgsql-general-digest V1 #330
***********************************
