On Tue, Jun 18, 2002 at 03:24:57PM +0200, Michael Meskes wrote:
> On Mon, Jun 17, 2002 at 11:27:45AM -0700, Dann Corbit wrote:
> > Here is the complete NIST regression test:
> > ftp://cap.connx.com/pub/chess-engines/new-approach/nist.ZIP
> >
> > You have to use passive ftp to get files from my si
Gotcha. 'twas the first time I encountered it, I wasn't expecting it.
Thank you for the clarification. I hadn't paid attention to that
paragraph when I read over it.
David
Tom Lane wrote:
>David Ford <[EMAIL PROTECTED]> writes:
>
>
>>heakin=> \z
>>Access privileges for database "heakin"
>
David Ford <[EMAIL PROTECTED]> writes:
> heakin=> \z
> Access privileges for database "heakin"
>Table | Access privileges
> ---+---
> interviewers |
> heakin=> grant select,insert,update on interviewers to heakin;
> GRANT
> heakin=> \z
> Access
On Mon, Jun 17, 2002 at 11:27:45AM -0700, Dann Corbit wrote:
> Here is the complete NIST regression test:
> ftp://cap.connx.com/pub/chess-engines/new-approach/nist.ZIP
>
> You have to use passive ftp to get files from my site because of the
> firewall.
I'm pretty sure my proxy does use passive f
David Ford <[EMAIL PROTECTED]> writes:
> Which btw has a curious grant/revoke bug. create foo; grant select on
> foo to bar; results in all rights being granted. You must revoke and
> grant again in order to get the correct rights set.
I see no bug.
test72=# select version();
pg_auth=# select version();
version
PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 3.0.2
Which btw has a curious grant/revoke bug. create foo; grant select on
foo to bar; resu
David Ford <[EMAIL PROTECTED]> writes:
> I'm using md5 in pg_hba.conf. That is the method, no?
> I'm writing a milter application which instantiates a private resource
> for each thread upon thread startup. I have priv->conn which I
> establish as priv->conn=PQconnectdb(connstr), connstr is co
David Ford wrote:
> I'm using md5 in pg_hba.conf. That is the method, no?
>
> I'm writing a milter application which instantiates a private resource
> for each thread upon thread startup. I have priv->conn which I
> establish as priv->conn=PQconnectdb(connstr), connstr is const char
> *conns
I'm using md5 in pg_hba.conf. That is the method, no?
I'm writing a milter application which instantiates a private resource
for each thread upon thread startup. I have priv->conn which I
establish as priv->conn=PQconnectdb(connstr), connstr is const char
*connstr="host=10.0.0.5 dbname=bmilt
> -Original Message-
> From: Michael Meskes [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 13, 2002 3:06 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] PostGres Doubt
>
>
> On Wed, Jun 12, 2002 at 11:46:47AM -0700, Dann Corbit wrote:
> > I should ap
On Wed, Jun 12, 2002 at 06:19:57PM -0400, Bruce Momjian wrote:
> > I doubt if many people are using it then. There is a NIST SQL suite
> > which should be run against it. Have you heard of it? It is a
> > standardization for embedded SQL [and other facets of the SQL langauge].
> > I think it wo
On Wed, Jun 12, 2002 at 05:42:24PM -0400, Bruce Momjian wrote:
> You are actually the first person to complain about this, as far as I
> can remember.
Yup. I cannot remember any other person either. And since nobody
complained, nobody worked on this. :-)
Michael
--
Michael Meskes
[EMAIL PROTECT
On Wed, Jun 12, 2002 at 11:46:47AM -0700, Dann Corbit wrote:
> I should apologize for being rather harsh about embedded SQL for
> PostgreSQL.
Also about being harsh about the people? Okay, apologies accepted.
> I actually spent a great deal of effort trying to write some tools using
> the Postgr
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
On Wed, 2002-06-12 at 19:38, Tom Lane wrote:
> David Ford <[EMAIL PROTECTED]> writes:
> > So reentrancy in libpq basically is put on hold until 7.3.
>
> Only if you insist on using "crypt", which is deprecated anyway.
> md5 is the preferred encryption method.
>
> My feeling about the proposed pa
Dann Corbit wrote:
> > > So now, I started getting down to the details. One global
> > structure...
> > > I started a major rewrite to repair it. Then (to my abject
> > horror) I
> > > discovered there is no SQLCA at all. Project abandoned
> > (actually, just
> > > switched to libpq and ever
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 3:20 PM
> To: Dann Corbit
> Cc: Michael Meskes; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] PostGres Doubt
>
>
> Dann Corbit
> > > I assume this is
Dann Corbit
> > I assume this is because you wrote your code assuming a feature was in
> > ecpg, but it wasn't, right?
>
> I have written lots of programs that use embedded SQL. I have (for
> instance) several ODBC drivers that use embedded SQL and C++ as part of
> an ODBC driver system. I mer
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 2:42 PM
> To: Dann Corbit
> Cc: Michael Meskes; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] PostGres Doubt
>
>
> Dann Corbit wrote:
> > I should apolo
Dann Corbit wrote:
> I should apologize for being rather harsh about embedded SQL for
> PostgreSQL.
>
> To be fair, it does function and it certainly isn't trivial to
> implement. I am sure that those who have worked on this project have
> invested very many hours of blood, sweat and tears makin
Dann Corbit wrote:
> > -Original Message-
> > From: Michael Meskes [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 12, 2002 5:41 AM
> > To: Dann Corbit
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [HACKERS] PostGres Doubt
> >
> >
&g
...
> 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
-
I should apologize for being rather harsh about embedded SQL for
PostgreSQL.
To be fair, it does function and it certainly isn't trivial to
implement. I am sure that those who have worked on this project have
invested very many hours of blood, sweat and tears making it work.
I actually spent a
> -Original Message-
> From: Michael Meskes [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 5:41 AM
> To: Dann Corbit
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] PostGres Doubt
>
>
> On Mon, Jun 10, 2002 at 02:08:22PM -0700, Dann Corbi
David Ford <[EMAIL PROTECTED]> writes:
> So reentrancy in libpq basically is put on hold until 7.3.
Only if you insist on using "crypt", which is deprecated anyway.
md5 is the preferred encryption method.
My feeling about the proposed patch was that crypt is now a legacy auth
method, and it's no
ge-
>>From: David Ford [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, June 10, 2002 6:16 PM
>>To: Dann Corbit
>>Cc: vikas p verma; [EMAIL PROTECTED]
>>Subject: Re: [HACKERS] PostGres Doubt
>>
>>
>>Is libpq/PQconnectdb() reentrant? I've tried repeated
Good points; not sure why I didn't pick up on this too.
I should point out that I've seen code with heavy Oracle-isms brought
into PostgreSQL using ecpg with amazingly few changes. It is a great
piece of code; any large complaints should perhaps be directed at the
SQL standards themselves...
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?
> using it for any purpose except por
On Mon, Jun 10, 2002 at 08:09:57PM -, vikas p verma wrote:
> this question of mine. I want to insert/update records into the
> postgres database through C or perl code. The only condition is
> that it should be efficient. Can anybody tell me the difference
> between ecpg and libpq and which
On Mon, 10 Jun 2002, Dann Corbit wrote:
> If you are going to completely replace the data in a table, drop the
> table, create the table, and use the bulk copy interface.
Actually, that's a bad habit to get into. Views disappear, as do triggers
or constraints. Better to 'truncate table' or 'd
Are you using crypt on the connection?
Unfortunately, crypt is not reentrant.
> -Original Message-
> From: David Ford [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 10, 2002 6:16 PM
> To: Dann Corbit
> Cc: vikas p verma; [EMAIL PROTECTED]
> Subject: Re: [HACKE
Is libpq/PQconnectdb() reentrant? I've tried repeatedly over time and
it seems to incur segfaults every single time.
-d
Dann Corbit wrote:
>The libpq functions are reentrant. These will be useful for just about
>any project.
>
>
---(end of broadcast)--
> -Original Message-
> From: vikas p verma [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 10, 2002 1:10 PM
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] PostGres Doubt
>
>
> Hi ,
>
> I am extremely new to PostGreSql. If any one can please answer
>
Hi ,
I am extremely new to PostGreSql. If any one can please answer
this question of mine. I want to insert/update records into the
postgres database through C or perl code. The only condition is
that it should be efficient. Can anybody tell me the difference
between ecpg and libpq and which
34 matches
Mail list logo
