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?
----- Original Message ----- From: \"Armin Burger\" <[EMAIL PROTECTED]> To: <carlo.calvino at email.it> Cc: <pmapper-users at faunalia.it> 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, 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 -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: DVD vergini: acquista online a prezzi vantaggiosi! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=4589&d=20060120 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://faunalia.it/pipermail/pmapper-users/attachments/20060120/32ec1a4f/attachment.htm
