Undeliverable Message

To: ISMTP(at)SFRA0046@Servers[<pgsql-general-digest(at)hub(dot)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(at)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(at)mail1(dot)sfr(dot)fr>
Subject: Undeliverable Message

To: ISMTP(at)SFRA0046@Servers[<pgsql-general-digest(at)hub(dot)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(at)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(at)mail1(dot)sfr(dot)fr>
Subject: Undeliverable Message

To: ISMTP(at)SFRA0046@Servers[<pgsql-general-digest(at)hub(dot)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(at)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)mail1(dot)sfr(dot)fr>
Subject: Undeliverable Message

To: ISMTP(at)SFRA0046@Servers[<pgsql-general-digest(at)hub(dot)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(at)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(at)postgreSQL(dot)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(at)themecca(dot)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(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl ---------/
> // > /----- mailto:kelman(at)alpha(dot)net(dot)pl -----------------------/
> // > /--------------------------------------------------------/
> // >
> // >
> // >
> //
> //
> //
>
> --
> Principal Member Technical Staff, beyond.com The world is watching America,
> pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
> | Key fingerprint > L______________________________________________ and America is watching TV. __
>

- - - ------------------------------

Date: Sat, 22 May 1999 21:05:22 -0700 (PDT)
From: dustin sallings <dustin(at)spy(dot)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(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl ---------/
// > // > /----- mailto:kelman(at)alpha(dot)net(dot)pl -----------------------/
// > // > /--------------------------------------------------------/
// > // >
// > // >
// > // >
// > //
// > //
// > //
// >
// > --
// > Principal Member Technical Staff, beyond.com The world is watching America,
// > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)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(at)spy(dot)net>
| Key fingerprint L______________________________________________ and America is watching TV. __

- - - ------------------------------

Date: Sat, 22 May 1999 21:49:21 -0700
From: ghoffman(at)ucsd(dot)edu (Gary Hoffman)
Subject: To: pgsql-general(at)postgreSQL(dot)org

subscribe
end

- - - ------------------------------

Date: Sat, 22 May 1999 22:48:02 -0700
From: ghoffman(at)ucsd(dot)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(at)ucsd(dot)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(at)godzone(dot)net(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)ucsd(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)oumail(dot)openu(dot)ac(dot)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(at)oumail(dot)openu(dot)ac(dot)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(at)oumail(dot)openu(dot)ac(dot)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(at)godzone(dot)net(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)themecca(dot)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(at)lan2wan(dot)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(dot)scemama(at)gesnet(dot)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(at)daj(dot)co(dot)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(at)hotmail(dot)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(at)fanthom(dot)math(dot)put(dot)poznan(dot)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(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl ---------/
/----- mailto:kelman(at)alpha(dot)net(dot)pl -----------------------/
/--------------------------------------------------------/

- - ------------------------------

Date: Mon, 24 May 1999 07:01:36 -0400 (EDT)
From: "Brett W. McCoy" <bmccoy(at)lan2wan(dot)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(at)themecca(dot)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(at)foxlink(dot)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(at)foxlink(dot)net

- - ------------------------------

Date: Mon, 24 May 1999 09:37:08 -0400 (EDT)
From: Simon Drabble <simond(at)foxlink(dot)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(at)foxlink(dot)net

- - ------------------------------

Date: Mon, 24 May 1999 09:45:27 -0400 (EDT)
From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)lan2wan(dot)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(at)ncsa(dot)uiuc(dot)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(at)ncsa(dot)uiuc(dot)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(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl ---------/
> // > /----- mailto:kelman(at)alpha(dot)net(dot)pl -----------------------/
> // > /--------------------------------------------------------/
> // >
> // >
> // >
> //
> //
> //
>
> --
> Principal Member Technical Staff, beyond.com The world is watching America,
> pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
> | Key fingerprint > L______________________________________________ and America is watching TV. __
>
>

- - ------------------------------

Date: Mon, 24 May 1999 09:42:53 -0500 (CDT)
From: reedstrm(at)wallace(dot)ece(dot)rice(dot)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(at)rice(dot)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(at)rice(dot)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(at)rice(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(dot)bitmead(at)bigfoot(dot)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(at)ncsa(dot)uiuc(dot)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(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl ---------/
> > // > /----- mailto:kelman(at)alpha(dot)net(dot)pl -----------------------/
> > // > /--------------------------------------------------------/
> > // >
> > // >
> > // >
> > //
> > //
> > //
> >
> > --
> > Principal Member Technical Staff, beyond.com The world is watching America,
> > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
> > | Key fingerprint > > L______________________________________________ and America is watching TV. __
> >
> >

- - - --
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris(dot)bitmead(at)bigfoot(dot)com

- - ------------------------------

Date: Mon, 24 May 1999 14:31:36 -0400 (EDT)
From: "Brett W. McCoy" <bmccoy(at)lan2wan(dot)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(at)webline(dot)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(at)cs(dot)man(dot)ac(dot)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(at)lan2wan(dot)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(at)ludwig(dot)ucl(dot)ac(dot)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(at)ncsa(dot)uiuc(dot)edu
>>
>> >
<snip>
>> >
>
>--
>Chris Bitmead
>http://www.bigfoot.com/~chris.bitmead
>mailto:chris(dot)bitmead(at)bigfoot(dot)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(at)ludwig(dot)ucl(dot)ac(dot)uk |
+-------------------------+--------------------------------------+

- - ------------------------------

End of pgsql-general-digest V1 #326
***********************************

- ------------------------------

End of pgsql-general-digest V1 #327
***********************************

------------------------------

End of pgsql-general-digest V1 #328
***********************************