> -----Original Message-----
> From: Michael Meskes [mailto:meskes@postgresql.org]
> Sent: Wednesday, June 12, 2002 5:41 AM
> To: Dann Corbit
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] PostGres Doubt
> 
> 
> On Mon, Jun 10, 2002 at 02:08:22PM -0700, Dann Corbit wrote:
> > ECPG is single threading.  Hence, tools written in ECPG are 
> a pain in
> > the neck if you want multiple threads of execution.  I 
> recommend against
> 
> Did he say he wants to write a multi-threaded app?

Or run concurrent queries queries at the same time?  Or later discover
the need to do so?
 
> > using it for any purpose except porting a single threading 
> project that
> > already uses embedded SQL.  The embedded SQL interface for 
> PostgreSQL is
> > a disaster.
> 
> Oh, that's what I call constructive critizism. I cannot remember you
> filing any bug reports or asking for some special features. Wouldn't
> that be the first step? And not calling other people's work a 
> disaster.

I posted the problems to this list long ago.  I wanted to use ECPG and
discovered it was a joke.  Do a search through the list and you will
find a half dozen complaints.
 
> > The libpq functions are reentrant.  These will be useful 
> for just about
> > any project.
> 
> Well if they are (I never checked myself) it shouldn't be too 
> difficult
> to make ecpg reentrant too.

Then why not do it.  I looked at doing it myself, but the implementation
of embedded SQL is totally nonstandard and uses global structures and
fails to use the SQLCA and SQLDA structures properly.  It would be a
nightmare to try and fix it.
 
> > If you are going to completely replace the data in a table, drop the
> > table, create the table, and use the bulk copy interface.
> 
> Oh great! Talking about valuable comments. Ever bothered to 
> even ask if
> they are using triggers, constraints, etc. before coming with such a
> proposal?

I would assume that they would use their brain. 

Wed, 12 Jun 2002 11:00:26 -0700
"Dann Corbit" <DCorbit@connx.com>
Re: PostGres Doubt
...
> I would assume that they would use their brain.

Way uncalled for. You must have some other underlying issues to get this
bad 'tude, but please note that ad hominum attacks are *never* welcome
on this or any other PostgreSQL mailing list.

Regards.

                   - Thomas

Wed, 12 Jun 2002 12:13:50 -0700
Thomas Lockhart <lockhart@fourpalms.org>
Re: PostGres Doubt
Dann Corbit wrote:
> > -----Original Message-----
> > From: Michael Meskes [mailto:meskes@postgresql.org]
> > Sent: Wednesday, June 12, 2002 5:41 AM
> > To: Dann Corbit
> > Cc: pgsql-hackers@postgresql.org
> > Subject: Re: [HACKERS] PostGres Doubt
> > 
> > 
> > On Mon, Jun 10, 2002 at 02:08:22PM -0700, Dann Corbit wrote:
> > > ECPG is single threading.  Hence, tools written in ECPG are 
> > a pain in
> > > the neck if you want multiple threads of execution.  I 
> > recommend against
> > 
> > Did he say he wants to write a multi-threaded app?
> 
> Or run concurrent queries queries at the same time?  Or later discover
> the need to do so?
...
> 
> I posted the problems to this list long ago.  I wanted to use ECPG and
> discovered it was a joke.  Do a search through the list and you will
> find a half dozen complaints.
,..
> 
> Then why not do it.  I looked at doing it myself, but the implementation
> of embedded SQL is totally nonstandard and uses global structures and
> fails to use the SQLCA and SQLDA structures properly.  It would be a
> nightmare to try and fix it.
>  
> > > If you are going to completely replace the data in a table, drop the
> > > table, create the table, and use the bulk copy interface.
> > 
> > Oh great! Talking about valuable comments. Ever bothered to 
> > even ask if
> > they are using triggers, constraints, etc. before coming with such a
> > proposal?
> 
> I would assume that they would use their brain. 

If you think ecpg is a joke, I think you will find PostgreSQL is a joke
too.  I suggest you find another database.

In fact, you may find all other databases to be a joke.  I suggest you
write your own.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@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

Wed, 12 Jun 2002 17:33:52 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: PostGres Doubt
On Wed, Jun 12, 2002 at 11:00:26AM -0700, Dann Corbit wrote:
> Or run concurrent queries queries at the same time?  Or later discover
> the need to do so?

I didn't say multi-threading is bad. I just don't think your answer
helped him much.

> I posted the problems to this list long ago.  I wanted to use ECPG and
> discovered it was a joke.  Do a search through the list and you will
> find a half dozen complaints.

If you use this kind of language I wonder if anyone ever reacted on any
complaint you send.

> Then why not do it.  I looked at doing it myself, but the implementation

Gotta like that attidude. Did you read aynthing about us not wanting to
make ecpg multi-threaded?

> of embedded SQL is totally nonstandard and uses global structures and

What's that about? Our parser is nonstandard? Please if you expect any
more answers, how about adding some facts and not just talking badly
about people.

> > Oh great! Talking about valuable comments. Ever bothered to 
> > even ask if
> > they are using triggers, constraints, etc. before coming with such a
> > proposal?
> 
> I would assume that they would use their brain. 

Why? You don't use it either. I'm sorry, but I cannot stand this kind of
behaviour.

Michael

-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

Thu, 13 Jun 2002 12:01:14 +0200
Michael Meskes <meskes@postgresql.org>
Re: PostGres Doubt