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, it's a bit like UNIX style naming applied to a DB. I would not recomment anybody using upper case names in PG, because having to put all names in double quotes makes things a bit annoying.
Try renaming table and column names to full lower case and run the query SELECT ppid,ppnom FROM anagrafica_punti_prelievo WHERE geoid=1884 It will then also work to have SELECT PPID,PPNOM FROM ANAGRAFICA_PUNTI_PRELIEVO WHERE GEOID=1884 The important thing is just to have columns and tables in PG defined in lower case. Sorry, but I have not defined this behaviour. Armin > --- Urspr?ngliche Nachricht --- > Von: carlo.calvino at email.it > An: pmapper-users at faunalia.it > Betreff: Re: [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 "Anagrafica_Punti_Prelievo" WHERE "GEOID"=1884 > Then I think that, by default, pmapper will not work with Postgresql 8.0 > > > > if you get the error > > "Relation Anagrafica_Punti_Prelievo does not exist" > > then the table is definitively not existing. Postgres supports this kind > > of query for sure. But PG has sort of strange behaviour when using upper > > case characters for tables or columns. Try converting everything in > > lower case and run it again. > > I use both versions 1.9.4 and 1.1.0, and 1-to-1 relation works, but the > name > of the joined fields is not displayed. > Now I am also able to make a 1-to-many relation, but as you say, there are > some problems resulting in a confused graphical rapresentation. > When do you think you will adjust this part of code? I could also be > available to restructuring the code on my own, and obvioulsy give the mods > to all other users :) There is an interest in such a feature? > > > > I checked the code and for 1-to-1 relations it works without problems. > > For 1-to-many there is a slight problem that would need some > > re-structuring of the code. The data are displayed, but just everything > > in one row. In your case you do not get a query result (which would be > > an array) but either an error object or error code (what you can print > > out, eg. with "print_r($data);" in line 216. > > > > In general it's always a bit difficult to find errors without having the > > data and the map file available. I even do not know the version or build > > of pmapper you are using. > > > -- > Email.it, the professional e-mail, gratis per te: http://www.email.it/f > > Sponsor: > Proteggi al tua casa:con FULL CASA di RAS bastano anche solo 50 Cent. al > giorno. Fai subito il tuo preventivo online! > Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=4026&d=20060120 > > > > _______________________________________________ > Pmapper-users mailing list > Pmapper-users at faunalia.it > http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users > -- Telefonieren Sie schon oder sparen Sie noch? NEU: GMX Phone_Flat http://www.gmx.net/de/go/telefonie
