Re: mysql-pgsql comparison

From: Justin Clift <justin(at)postgresql(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: mysql-pgsql comparison
Date: 2002-01-13 22:19:01
Message-ID: 3C4207D5.622C7D32@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi Tom,

It definitely works under Linux for PostgreSQL 7.1.x. BUT, as you can
see the code is fairly simple and I don't believe it would be too hard
to make it far more cross-platform. In fact, with OSDB this is what is
wanted.

BTW - If anyone has patches for it they'd like to have committed, I'm an
official developer for it (username "Vapour") with CVS commit access.

Andy Riebs, the guy who is in charge of it is a nice guy and I'm sure
would allow you and experienced others to commit to CVS. He's just
short of time, the same as I.

:-)

Regards and best wishes,

Justin Clift

Tom Lane wrote:
>
> Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> > On Sun, 13 Jan 2002, Tom Lane wrote:
> > 3. Check out the OSDB benchmark more closely.
>
> > I tried it with current CVS and make test fails (didn't tried
> > to find what's the problem). Also, you have to edit configure script -
> > it tries to find postgres_fe.h in include directory, which now lives under
> > include/internal directory.
>
> I tried to build it on HPUX just now, and was rather sadly disillusioned
> about its portability. After fixing several problems in the configure
> script, removing hard-coded references to include files and libraries
> that don't exist here, etc, I ended up with
>
> make[2]: Entering directory `/home/tgl/tmp/osdb/src/callable-sql/postgres-call'
> gcc -L/home/postgres/testversion/lib -lpq -g osdb-pg.o ../callable-sql.o ../../program-control.o ../../osdb.o -o osdb-pg
> /usr/ccs/bin/ld: Unsatisfied symbols:
> forkpty (code)
> collect2: ld returned 1 exit status
>
> Anybody know what forkpty() does? I see it exists in libutil.a on Linux,
> but there's no man page for it.
>
> Oh, OSDB also seems to assume that ecpg is in your $PATH. In general,
> it's not prepared to deal with a Postgres that's not installed in the
> "standard" place.
>
> This thing needs some work :-(
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

In response to

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2002-01-13 23:46:23 Re: using EXPLAIN in postgresql RULES?
Previous Message Justin Clift 2002-01-13 22:10:49 Re: mysql-pgsql comparison

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-01-14 01:29:18 Re: mysql-pgsql comparison
Previous Message Justin Clift 2002-01-13 22:10:49 Re: mysql-pgsql comparison