X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A06BF5283A for ; Fri, 27 May 2005 12:58:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23558-10 for ; Fri, 27 May 2005 15:58:20 +0000 (GMT) Received: from extavgw4.ball.com (extavgw4.ball.com [162.18.103.211]) by svr1.postgresql.org (Postfix) with ESMTP id 233175286E for ; Fri, 27 May 2005 12:58:18 -0300 (ADT) Received: from AEROMSG4.AERO.BALL.COM (Not Verified[162.18.82.149]) by extavgw4.ball.com with NetIQ MailMarshal (v6, 0, 3, 8) id ; Fri, 27 May 2005 09:58:45 -0600 Received: from daytonmsg2k3.AERO.BALL.COM ([162.18.199.42]) by AEROMSG4.AERO.BALL.COM with Microsoft SMTPSVC(6.0.3790.211); Fri, 27 May 2005 09:58:09 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C562D4.E1692FA8" Subject: Fw: PgOleDb / PostGis / PostgreSql interface problem Date: Fri, 27 May 2005 11:58:10 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Fw: PgOleDb / PostGis / PostgreSql interface problem Thread-Index: AcVi1OAvTRvIzDtbS/GusuIO6z96og== From: "Clay, Bruce" To: X-OriginalArrivalTime: 27 May 2005 15:58:09.0035 (UTC) FILETIME=[E09495B0:01C562D4] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.049 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200505/60 X-Sequence-Number: 5563 This is a multi-part message in MIME format. ------_=_NextPart_001_01C562D4.E1692FA8 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable The following is a message is one I originally posted on the pgFoundary list. At the bottom of the note is a reply from Shachar Shemesh. I am cross posting it here because there seems to be some concern as to where the issue originates. =20 If anyone has any suggestions I would be happy to experiment to find a valid solution. =20 The gist of what I am trying to do is use PostgreSql as a geospatial database server that can be accessed though a WEB page, a WEB service, ArcMap or any other application that I am called on to write. If this is not the right combination of libraries, please let me know. If this is not the right forum for this question, plaee let me know where I should post this. It seems like it is an interface issue that is why I am posting it here. =20 Thank you for your help. =20 Bruce =20 Clay, Bruce wrote: =20 > I am getting the same message that Uwe Seher mentioned back on 11 May. > > I am using a combination of PostgreSql 8.0.3, postgis (version=20 > provided in the PostgreSql 8.0.3 installer) and what I believe to be=20 > the current PgOleDb dll. > > I have loaded a few databases in PostgreSql and I can see the table=20 > names in ArcCatalog after I make an OLE DB connection. > > Two problems show up but I can not say at which level of the process=20 > they occur. > > The first is as the title says one that says: > > Failed to edit the selected object(s) > > General Function failure > > ERROR: no binary output function available for type geometry > > Fatal error in query. > > The standard tables used by template1 all seem to open ok but the=20 > table that has the actual data fails with the above error message > I'll offer you a deal. You forward the message I tried to send to the=20 postgis mailing list and couldn't (I'm not subscribed, and I don't have=20 the bandwidth to subscribe to yet another mailing list), and to carry=20 out the discussion on my behalf there, and I'll try to solve this one, ok? =20 > The second problem I encountered seems to be one of case sensitivity.=20 > If a table has uppercase letters such as VE_SubProv I get the=20 > following error message > > Failed to edit the selected object(s) > > General Function failure > > ERROR: relation "public.ve_subprov" does not exist. > > Fatal error on query > What usage type? What commands were you using? =20 Please forward the following email to the postgis list. =20 > Hi all, > > Please include me in the CC of all replies, as I'm not subscribed to=20 > the list. > > I am the maintainer of PgOleDb (http://pgfoundry.org/projects/oledb),=20 > the OLE DB provider for PostgreSQL. This driver is beginning to=20 > mature, and we are starting to get questions on the PgOleDb list about > PostGIS support. As I know nothing about it, I'm asking here. > > Personally, I don't really care one way or the other, so if anyone=20 > here wants PostGIS support in PgOleDb, you will have to do at least=20 > some of the work. Most important is giving a concise list of all data=20 > types that PostGIS adds to PG, and how Windows program typically=20 > expect to receive them (when expecting binary returns). If a=20 > translation is required between the way PG usually exports it, and the > way OLE DB is expected to return it, small code doing the actual=20 > translation would be GREATLY appreciated (PgOleDb is under the LGPL,=20 > so whatever code you provide must be under a LGPL compatible license). > > More worrying, I have a question on the list=20 > (http://lists.pgfoundry.org/pipermail/oledb-devel/2005-May/000301.html)=20 > which suggest that some of the GIS types don't have binary exports=20 > functions. This is a bug in the type, and PgOleDb cannot be expected=20 > to solve it. Like I said above, I am not a GIS user myself, and I=20 > therefor don't know anything about it. I tried to find the SQL=20 > instructions for installing support for the GIS type, and couldn't=20 > even locate them (I seem to need to grab lwpostgis.sql from somewhere, > but it doesn't seem to be in neither PostGIS nor PostgreSQL source=20 > distributions). > > Shachar =20 =20 --=20 Shachar Shemesh Lingnu Open Source Consulting ltd ------_=_NextPart_001_01C562D4.E1692FA8 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

The following is a message is one I originally posted = on the pgFoundary list.  At the bottom of the note is a reply from = Shachar Shemesh.  I am cross posting it here because there seems to be = some concern as to where the issue originates.

 

If anyone has any suggestions I would be happy to = experiment to find a valid solution.

 

The gist of what I am trying to do is use PostgreSql = as a geospatial database server that can be accessed though a WEB page, a WEB service, ArcMap or any other application that I am called on to = write.  If this is not the right combination of libraries, please let me = know.  If this is not the right forum for this question, plaee let me know where I = should post this.  It seems like it is an interface issue that is why I am posting it here.

 

Thank you for your help.

 

Bruce

 

Clay, Bruce =
wrote:
 
> I am getting the same message that Uwe =
Seher mentioned back on 11 May.
>
> I am using a combination of PostgreSql =
8.0.3, postgis (version 
> provided in the PostgreSql 8.0.3 installer) =
and what I believe to be 
> the current PgOleDb =
dll.
>
> I have loaded a few databases in PostgreSql =
and I can see the table 
> names in ArcCatalog after I make an OLE DB =
connection.
>
> Two problems show up but I can not say at =
which level of the process 
> they =
occur.
>
> The first is as the title says one that =
says:
>
> Failed to edit the selected =
object(s)
>
> General Function =
failure
>
> ERROR: no binary output function available =
for type geometry
>
> Fatal error in =
query.
>
> The standard tables used by template1 all =
seem to open ok but the 
> table that has the actual data fails with =
the above error message
>
I'll =
offer you a deal. You forward the message I tried to send to the =

postgis =
mailing list and couldn't (I'm not subscribed, and I don't have =

the =
bandwidth to subscribe to yet another mailing list), and to carry =

out the =
discussion on my behalf there, and I'll try to solve this one, =
ok?
 
> The second problem I encountered seems to =
be one of case sensitivity. 
> If a table has uppercase letters such as =
VE_SubProv I get the 
> following error =
message
>
> Failed to edit the selected =
object(s)
>
> General Function =
failure
>
> ERROR: relation =
“public.ve_subprov” does not =
exist.
>
> Fatal error on =
query
>
What =
usage type? What commands were you using?
 
Please =
forward the following email to the postgis =
list.
 
> Hi =
all,
>
> Please include me in the CC of all replies, =
as I'm not subscribed to 
> the =
list.
>
> I am the maintainer of PgOleDb (http://pgfoundry.org/project=
s/oledb), 
> the OLE DB provider for PostgreSQL. This =
driver is beginning to 
> mature, and we are starting to get =
questions on the PgOleDb list about =

> PostGIS support. As I know nothing about =
it, I'm asking here.
>
> Personally, I don't really care one way or =
the other, so if anyone 
> here wants PostGIS support in PgOleDb, you =
will have to do at least 
> some of the work. Most important is giving =
a concise list of all data 
> types that PostGIS adds to PG, and how =
Windows program typically 
> expect to receive them (when expecting =
binary returns). If a 
> translation is required between the way PG =
usually exports it, and the 
> way OLE DB is expected to return it, small =
code doing the actual 
> translation would be GREATLY appreciated =
(PgOleDb is under the LGPL, 
> so whatever code you provide must be under =
a LGPL compatible license).
>
> More worrying, I have a question on the =
list 
> (http://lists.pgfoundry.org/pipermail/oledb-devel/2005-May/000301.ht=
ml) 
> which suggest that some of the GIS types =
don't have binary exports 
> functions. This is a bug in the type, and =
PgOleDb cannot be expected 
> to solve it. Like I said above, I am not a =
GIS user myself, and I 
> therefor don't know anything about it. I =
tried to find the SQL 
> instructions for installing support for the =
GIS type, and couldn't 
> even locate them (I seem to need to grab =
lwpostgis.sql from somewhere, 
> but it doesn't seem to be in neither =
PostGIS nor PostgreSQL source 
> =
distributions).
>
> =
Shachar
 
 
-- =

Shachar =
Shemesh

Lingnu Open Source Consulting ltd

------_=_NextPart_001_01C562D4.E1692FA8--