Further investigations into this stuff suggests me that my problem with
Postgresql is not related to the uppercase/lowercase syntax, but with
apostrophes.
In fact this query is working:
SELECT PPID,PPNom FROM Anagrafica_Punti_Prelievo WHERE GEOID=1884
Then I think that, by default, pmapper will
: [Pmapper-users] Problems with JOIN
Datum: Fri, 20 Jan 2006 13:10:30 +0100
Further investigations into this stuff suggests me that my problem with
Postgresql is not related to the uppercase/lowercase syntax, but with
apostrophes.
In fact this query is working:
SELECT PPID,PPNom FROM
Sent: Friday, January 20, 2006 1:52 PM
Subject: Re: [Pmapper-users] Problems with JOIN
pmapper works with Postgres 7.3, 7.4, 8.0 and 8.1 and so on. The basic
query
syntax in PG has not changed since eternities. But as I said, PG has a
strange behaviour towards using upper case letters in names
carlo.calvino at email.it wrote:
Dear Armin,
what you say is perfectly right. I switched all the names into
lower-case, and now it works!
About the 1-to-many relation, what do you think to do?
I will fix it, sooner or later...
/a
much for your help.
- Original Message -
From: Armin Burger armin.burger at gmx.net
To: carlo.calvino at email.it
Cc: pmapper-users at faunalia.it
Sent: Wednesday, January 18, 2006 3:30 PM
Subject: Re: [Pmapper-users] Problems with JOIN
Try to write out the SQL string
Hello Armin, hello all
I am having problems with joining. My DBMS is PostgreSQL, and this is the
METADATA line of the layer:
RESULT_JOIN
\pgsql://postgres:miapass at localhost/marco||Anagrafica_Punti_Prelievo at
[EMAIL PROTECTED] at PPID,PPNom||GEOID||0\
That is, I have a layer with a field
: carlo.calvino at email.it
An: pmapper-users at faunalia.it
Betreff: [Pmapper-users] Problems with JOIN
Datum: Wed, 18 Jan 2006 13:03:02 +0100
Hello Armin, hello all
I am having problems with joining. My DBMS is PostgreSQL, and this is the
METADATA line of the layer:
RESULT_JOIN
\pgsql