From viktor@viktor.com.br Mon May  29 10:52:16 2000
Received: from master.MMSANTOS.COM.BR (master.mmsantos.com.br
 [200.197.132.66])
	by hub.org (8.9.3/8.9.3) with ESMTP id GAA27145
	for <pgsql-interfaces@postgresql.org>;
	Mon, 29 May 2000 06:52:16 -0400 (EDT)
	(envelope-from viktor@viktor.com.br)
Received: from freedom (igaw-ba-c4-220.TELEMAR-BA.NET.br [200.217.43.220] (may
	be forged))
	by master.MMSANTOS.COM.BR (2.5 Build 2630 (Berkeley 8.8.6)/8.8.4) with
	SMTP id HAA01773 for <pgsql-interfaces@postgresql.org>;
	Mon, 29 May 2000 07:55:00 -0300
Message-ID: <001201bfc95c$2bdde5c0$6f1dfea9@freedom>
From: =?iso-8859-1?Q?Viktor_de_Souza_Sp=EDnola?= <viktor@viktor.com.br>
To: <pgsql-interfaces@postgresql.org>
Subject: ODBC driver for Windows - Problems
Date: Mon, 29 May 2000 03:50:15 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01BFC920.FFD440E0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Archive-Number: 200005/81

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01BFC920.FFD440E0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi friends!

I'm trying to access a PostgreSQL 7.0 backend from my PowerBuilder client p=
rogram, using the PostODBC (it supports protocols 6.3, 6.4 and 6.5 - how ab=
out 7.0???) driver. It works very good partially, but it's GPF'ing at some =
points - as far as I could understand, when I'm retrieving data.

Are there some kind of "known issues" or incompatibility in this scenario?

I'm really a beginner in PostgreSQL, any appointment would be very helpful!

Please, CC the reply to viktor@viktor.com.br, because I haven't signed the =
list yet.

Thanks,
Viktor.



                       \\|//
                       (o o)
~~~~~~~~~~~~~~~~~~~~oOO~(_)~OOo~~~~~~~~~~~~~~~~~~~
#            Viktor de Souza Sp=EDnola             #
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#
#    e-mail: viktor@viktor.com.br                #
#            viktor@araketu.dcc.ufba.br          #
#                                                #
#    Home Page: http://www.viktor.com.br         #
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#
#  "Para conseguir aprender com os seus erros,   #
#   primeiro voc=EA precisa saber admitir          #
#   que eles existem."                           #
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

------=_NextPart_000_0005_01BFC920.FFD440E0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DCourier size=3D2>Hi friends!</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>I'm trying to access a PostgreSQL 7.0 ba=
ckend=20
from my PowerBuilder client program, using the PostODBC (it supports protoc=
ols=20
6.3, 6.4 and 6.5 -&nbsp;how about 7.0???) driver. It works very good partia=
lly,=20
but it's GPF'ing at some points - as far as I could understand, when I'm=20
retrieving data.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>Are there some kind of "known issues" or=
=20
incompatibility in this scenario?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>I'm really a beginner in PostgreSQL, any=
=20
appointment would be very helpful!</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>Please, CC the reply to <A=20
href=3D"mailto:viktor@viktor.com.br">viktor@viktor.com.br</A>, because I ha=
ven't=20
signed the list yet.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>Viktor.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>&nbsp;&nbsp; &nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A=20
href=3D"file://\\|//">\\|//</A><BR>&nbsp; &nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&n=
bsp;=20
&nbsp;&nbsp; (o=20
o)<BR>~~~~~~~~~~~~~~~~~~~~oOO~(_)~OOo~~~~~~~~~~~~~~~~~~~<BR>#&nbsp;=20
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; Viktor de Souza=20
Sp=EDnola&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;=20
#<BR>#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#<BR>#&nbsp;&nbsp;&nb=
sp;=20
e-mail: <A=20
href=3D"mailto:viktor@viktor.com.br">viktor@viktor.com.br</A>&nbsp;&nbsp;&n=
bsp;&nbsp;=20
&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
#<BR>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <A=20
href=3D"mailto:viktor@araketu.dcc.ufba.br">viktor@araketu.dcc.ufba.br</A>=
=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
#<BR>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
#<BR>#&nbsp;&nbsp;&nbsp; Home Page: <A=20
href=3D"http://www.viktor.com.br">http://www.viktor.com.br</A>&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
#<BR>#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#<BR>#&nbsp; "Para=20
conseguir aprender com os seus erros,&nbsp;&nbsp; #<BR>#&nbsp;&nbsp; primei=
ro=20
voc=EA precisa saber admitir&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;=20
#<BR>#&nbsp;&nbsp; que eles=20
existem."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;=20
#<BR>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</FONT></DIV></BODY>=
</HTML>

------=_NextPart_000_0005_01BFC920.FFD440E0--




From tip@pc10.radnoti-szeged.sulinet.hu Tue May  30 12:39:20 2000
Received: from pc10.radnoti-szeged.sulinet.hu
	(root@pc10.radnoti-szeged.sulinet.hu [195.199.49.170])
	by hub.org (8.9.3/8.9.3) with ESMTP id IAA45569
	for <pgsql-interfaces@postgresql.org>;
	Tue, 30 May 2000 08:39:20 -0400 (EDT)
	(envelope-from tip@pc10.radnoti-szeged.sulinet.hu)
Received: from localhost (tip@localhost)
	by pc10.radnoti-szeged.sulinet.hu (8.8.8/8.8.8) with ESMTP id OAA29753;
	Tue, 30 May 2000 14:37:12 +0200
Date: Tue, 30 May 2000 14:37:11 +0200 (CEST)
From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
To: =?iso-8859-1?Q?Viktor_de_Souza_Sp=EDnola?= <viktor@viktor.com.br>
cc: pgsql-interfaces@postgresql.org
Subject: Re: ODBC driver for Windows - Problems
In-Reply-To: <001201bfc95c$2bdde5c0$6f1dfea9@freedom>
Message-ID: 
 <Pine.LNX.4.05.10005301431270.29724-100000@pc10.radnoti-szeged.sulinet.hu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200005/97

> I'm trying to access a PostgreSQL 7.0 backend from my PowerBuilder
> client program, using the PostODBC (it supports protocols 6.3, 6.4 and
> 6.5 - how about 7.0???) driver. It works very good partially, but it's
> GPF'ing at some points - as far as I could understand, when I'm
> retrieving data.
We are using 7.0, it works well, but the code needs a few improvements
yet. What do you mean about 'GPF'ing'? 

> Are there some kind of "known issues" or incompatibility in this
> scenario?
Referential error reporting is not supported yet but there is an
experimental DLL on our FTP site, if you really need this feature.

Regards,
Zoltan




From viktor@viktor.com.br Wed May  31 03:10:25 2000
Received: from master.MMSANTOS.COM.BR (master.mmsantos.com.br
 [200.197.132.66])
	by hub.org (8.9.3/8.9.3) with ESMTP id XAA17727
	for <pgsql-interfaces@postgresql.org>;
	Tue, 30 May 2000 23:10:25 -0400 (EDT)
	(envelope-from viktor@viktor.com.br)
Received: from freedom (nsdr03-1027.sdr.EMBRATEL.NET.br [200.254.251.27])
	by master.MMSANTOS.COM.BR (2.5 Build 2630 (Berkeley 8.8.6)/8.8.4) with
	SMTP id AAA00866; Wed, 31 May 2000 00:13:25 -0300
Message-ID: <000601bfcaae$086e9b90$0100a8c0@viktor.local>
From: =?iso-8859-1?Q?Viktor_de_Souza_Sp=EDnola?= <viktor@viktor.com.br>
To: "Kovacs Zoltan Sandor" <tip@pc10.radnoti-szeged.sulinet.hu>
Cc: <pgsql-interfaces@postgresql.org>
References: 
 <Pine.LNX.4.05.10005301431270.29724-100000@pc10.radnoti-szeged.sulinet.hu>
Subject: Re: ODBC driver for Windows - Problems
Date: Tue, 30 May 2000 14:38:58 -0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Archive-Number: 200005/102

My program is hanging when trying to retrieve some specific DataWindow's,
and this does not happen with other databases (even through ODBC). I'll make
some more test, and try to averiguate more this week.
I'm using the PostODBC driver I've found in postgresql.org FTP site, it
claims to support protocols 6.3, 6.4 and 6.5, and says nothing aboutm 7.0.
Do you use the same driver I have?
I does not support referential error reporting, I can imagine that, by the
way, what happens when one of these errors happen?

Thanks for your help, I'm still studying PostgreSQL, that's why I'm so
insecure... it's good to hear that that PostODBC driver is really reliable,
it gives me hope, at least ;)


Much thanks again! (please forgive my English language poorness, I'm from
Brazil)
Viktor

----- Original Message -----
From: "Kovacs Zoltan Sandor" <tip@pc10.radnoti-szeged.sulinet.hu>
To: "Viktor de Souza Spínola" <viktor@viktor.com.br>
Cc: <pgsql-interfaces@postgresql.org>
Sent: Tuesday, May 30, 2000 9:37 AM
Subject: Re: [INTERFACES] ODBC driver for Windows - Problems


> > I'm trying to access a PostgreSQL 7.0 backend from my PowerBuilder
> > client program, using the PostODBC (it supports protocols 6.3, 6.4 and
> > 6.5 - how about 7.0???) driver. It works very good partially, but it's
> > GPF'ing at some points - as far as I could understand, when I'm
> > retrieving data.
> We are using 7.0, it works well, but the code needs a few improvements
> yet. What do you mean about 'GPF'ing'?
>
> > Are there some kind of "known issues" or incompatibility in this
> > scenario?
> Referential error reporting is not supported yet but there is an
> experimental DLL on our FTP site, if you really need this feature.
>
> Regards,
> Zoltan
>
>




From tip@pc10.radnoti-szeged.sulinet.hu Wed May  31 10:12:09 2000
Received: from pc10.radnoti-szeged.sulinet.hu
	(root@pc10.radnoti-szeged.sulinet.hu [195.199.49.170])
	by hub.org (8.9.3/8.9.3) with ESMTP id GAA30461
	for <pgsql-interfaces@postgresql.org>;
	Wed, 31 May 2000 06:12:09 -0400 (EDT)
	(envelope-from tip@pc10.radnoti-szeged.sulinet.hu)
Received: from localhost (tip@localhost)
	by pc10.radnoti-szeged.sulinet.hu (8.8.8/8.8.8) with ESMTP id MAA00975;
	Wed, 31 May 2000 12:11:16 +0200
Date: Wed, 31 May 2000 12:11:16 +0200 (CEST)
From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
To: =?iso-8859-1?Q?Viktor_de_Souza_Sp=EDnola?= <viktor@viktor.com.br>
cc: pgsql-interfaces@postgresql.org, lockhart@alumni.caltech.edu
Subject: Re: ODBC driver for Windows - Problems
In-Reply-To: <000601bfcaae$086e9b90$0100a8c0@viktor.local>
Message-ID: 
 <Pine.LNX.4.05.10005311152400.925-100000@pc10.radnoti-szeged.sulinet.hu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=X-UNKNOWN
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id GAA37680
X-Archive-Number: 200005/104

On Tue, 30 May 2000, [iso-8859-1] Viktor de Souza Spínola wrote:

> I'm using the PostODBC driver I've found in postgresql.org FTP site, it
> claims to support protocols 6.3, 6.4 and 6.5, and says nothing aboutm 7.0.
> Do you use the same driver I have?
As far as I know, 7.0 uses the same protocol as the 6.5. Most things
should work automatically with 7.0. But... when first beta was released,
the SPI way of the referential integrity (see contrib/spi/refint* for
details) didn't work anymore. It might be corrected since then, but we
found out that the new way of the referential integrity checks (i.e.
FOREIGN KEY and REFERENCES) should be better for future use so we decided
to rewrite all the SQL database code at the server side. It was
successful, but the current driver (which can be found on e.g.
postgresql.org) couldn't report some type of errors, e.g. referential
integrity violations. As far as I know, duplicate unique key violations
were also not reported correctly. Now I have a new version, but we are not
sure, that it will work with all application (e.g. Applixware for Unix or
other Windows database software, e.g. MS Access). Currently the new code
should be checked until it will be forwarded to the CVS tree.

No other drawbacks are known for us yet, but we decided to use both
Borland C++ Builder and PostgreSQL, so we MUST support client and server
side improvements for a longer time...

Regards, Zoltan





From raanders@altoplanos.net Fri Jun  2 23:05:52 2000
Received: from asgard.altoplanos.net (IDENT:root@asgard.altoplanos.net
	[207.170.216.2]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA58110
	for <pgsql-interfaces@postgresql.org>;
	Fri, 2 Jun 2000 19:05:52 -0400 (EDT)
	(envelope-from raanders@altoplanos.net)
Received: from asgard.altoplanos.net (raanders@asgard.altoplanos.net
	[207.170.216.2])
	by asgard.altoplanos.net (8.8.7/8.8.7) with ESMTP id QAA20259;
	Fri, 2 Jun 2000 16:05:14 -0700
Date: Fri, 2 Jun 2000 16:05:14 -0700 (PDT)
From: "Roderick A. Anderson" <raanders@altoplanos.net>
To: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
cc: =?iso-8859-1?Q?Viktor_de_Souza_Sp=EDnola?= <viktor@viktor.com.br>,
	pgsql-interfaces@postgresql.org
Subject: Re: ODBC driver for Windows - Problems
In-Reply-To: 
 <Pine.LNX.4.05.10005301431270.29724-100000@pc10.radnoti-szeged.sulinet.hu>
Message-ID: <Pine.LNX.4.04.10006021603490.20181-100000@asgard.altoplanos.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200006/12

On Tue, 30 May 2000, Kovacs Zoltan Sandor wrote:

> > I'm trying to access a PostgreSQL 7.0 backend from my PowerBuilder
> > client program, using the PostODBC (it supports protocols 6.3, 6.4 and
> > 6.5 - how about 7.0???) driver. It works very good partially, but it's
> > GPF'ing at some points - as far as I could understand, when I'm
> > retrieving data.
> We are using 7.0, it works well, but the code needs a few improvements
> yet. What do you mean about 'GPF'ing'? 

General Protection Fault.  Core dump without protection.  Love those
Windows!

Rod
-- 
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814




From tip@pc10.radnoti-szeged.sulinet.hu Mon Jun  5 08:53:55 2000
Received: from pc10.radnoti-szeged.sulinet.hu (pc10.radnoti-szeged.sulinet.hu
	[195.199.49.170])
	by hub.org (8.10.1/8.10.1) with ESMTP id e558rYO49111
	for <pgsql-interfaces@postgresql.org>;
	Mon, 5 Jun 2000 04:53:55 -0400 (EDT)
Received: from localhost (tip@localhost)
	by pc10.radnoti-szeged.sulinet.hu (8.8.8/8.8.8) with ESMTP id KAA19926;
	Mon, 5 Jun 2000 10:46:32 +0200
Date: Mon, 5 Jun 2000 10:46:31 +0200 (CEST)
From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
To: "Roderick A. Anderson" <raanders@altoplanos.net>,
	=?X-UNKNOWN?Q?Viktor_de_Souza_Sp=EDnola?= <viktor@viktor.com.br>,
	Laszlo Tibor <ltibor@mail.tiszanet.hu>
cc: pgsql-interfaces@postgresql.org
Subject: Re: ODBC driver for Windows - Problems
In-Reply-To: <Pine.LNX.4.04.10006021603490.20181-100000@asgard.altoplanos.net>
Message-ID: 
 <Pine.LNX.4.05.10006051042460.19686-100000@pc10.radnoti-szeged.sulinet.hu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200006/18

> > > GPF'ing at some points - as far as I could understand, when I'm
> > > retrieving data.
> > We are using 7.0, it works well, but the code needs a few improvements
> > yet. What do you mean about 'GPF'ing'? 
> General Protection Fault.  Core dump without protection.  Love those
> Windows!
Oh, I see... Viktor, could you please write exactly where and when did you
realize GPF? I don't remember we had such an error. (We had others, e.g.
Access violation, but not GPF.) Tibor, did we?

Regards, Zoltan