Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id BC7E061AFBB for ; Fri, 20 Jan 2012 10:15:58 -0400 (AST) Received: from pp-ag1.abag.ca.gov ([198.31.87.11]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RoFFx-0004S4-SH for pgsql-admin@postgresql.org; Fri, 20 Jan 2012 14:15:57 +0000 Received: from pps.filterd (pp-ag1 [127.0.0.1]) by pp-ag1.abag.ca.gov (8.14.4/8.14.4) with SMTP id q0KEEvl7016018 for ; Fri, 20 Jan 2012 06:15:38 -0800 Received: from gwia1.abag.ca.gov ([172.16.1.27]) by pp-ag1.abag.ca.gov with ESMTP id 12en4889ga-1 for ; Fri, 20 Jan 2012 06:15:38 -0800 Received: from d02-MTA by gwia1.abag.ca.gov with Novell_GroupWise; Fri, 20 Jan 2012 06:15:38 -0800 Message-Id: <4F190689020000A70001AF6F@gwia1.abag.ca.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Fri, 20 Jan 2012 06:15:37 -0800 From: "Fred Parkinson" To: , Subject: Re: help with Postgres forms (Pfm) References: <1024253310.896552.1327038181121.JavaMail.root@sz0007a.emeryville.ca.mail.comcast.net> In-Reply-To: <1024253310.896552.1327038181121.JavaMail.root@sz0007a.emeryville.ca.mail.comcast.net> Mime-Version: 1.0 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.6.7361, 1.0.211, 0.0.0000 definitions=2012-01-20_03:2012-01-20, 2012-01-20, 1970-01-01 signatures=0 X-Pg-Spam-Score: -4.2 (----) Content-Type: multipart/alternative; boundary="=__Part507E0B19.3__=" X-Archive-Number: 201201/112 X-Sequence-Number: 39024 This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__Part507E0B19.2__= Content-Type: multipart/alternative; boundary="=__Part507E0B19.3__=" --=__Part507E0B19.3__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable I have been using M$ Access for about 12 years now to create forms to = update postgresql data. I use the postgresql odbc driver to establish a connection There were a few issues to be worked out, for example getting Access and = postgresql to agree on how to handle boolean fields, how to fetch the key = field from postgresql after it adds a record (I think that has improved = since I started with ver. 7.x), but really not much else. =20 If you are interested I can post a few details. =20 Fred Parkinson Application Programmer Association of Bay Area Governments 510-464-7931 >>> 01/19/2012 9:43 PM >>> Am trying to come up with a forms based front end (windows 7 localhost) = to enter and update a lot of data in several related tables within 9.1. I have tried to install Postgres Forms (PFM), but the app won'tconnect to = my DP instance, it gives me a message that it: " couldn't execute = psql.exe; no such file or directory exists.' Well of course it exists, I see the executable in the 9.1 directory. so how could I get PFM to read the psql.exe file?=20 I suspect i could in some directory within the Postgres structure, but am = hesitant to just blindly throw installs around in my production evironment.= =20 Any suggestions would be greatly appreciated! even, is there another = forms app I could use? wavemaker doesnt work either- it wont import my 9.1 database Thanks very much for any assistance you all could offer. --=__Part507E0B19.3__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML
I have been using M$ Access for about 12 years now to create forms to = update postgresql data.
I use the postgresql odbc driver to establish a connection
There were a few issues to be worked out, for example getting Access = and postgresql to agree on how to handle boolean fields, how to fetch the = key field from postgresql after it adds a record (I think that has = improved since I started with ver. 7.x), but really not much else.
 
If you are interested I can post a few details.

 
Fred Parkinson
Application Programmer
Association of Bay Area Governments
510-464-7931
>>> <brooks.glenn@comcast.net> = 01/19/2012 9:43 PM >>>
Am trying to come up with a forms based front end =  (windows 7 localhost) to enter and update a lot of data in several = related tables within 9.1.

<= /DIV>
I = have tried to install Postgres Forms (PFM), but the app won'tconnect to my = DP instance, it gives me a message that it:  " couldn't execute = psql.exe; no such file or directory exists.'

<= /DIV>
Well = of course it exists, I see the executable in the 9.1 directory.

<= /DIV>
so = how could I get PFM to read the psql.exe file? 

<= /DIV>
 = ;I suspect i could in some directory within the Postgres structure, but am = hesitant to just blindly throw installs around in my production evironment.=  

<= /DIV>
Any = suggestions would be greatly appreciated!  even, is there another = forms app I could use?

<= /DIV>
wavem= aker doesnt work either- it wont import my 9.1 database

<= /DIV>
Thank= s very much for any assistance you all could offer.
--=__Part507E0B19.3__=-- --=__Part507E0B19.2__=--