Thread: iPad and Pg revisited...

I have cleaned up my simple Perl cgi script for accessing Postgresql  db's...

Thanks to Tom Lane's (aka the Wizard) hints the 'describe <table>'  function now works :)

The url:  http://homepage.mac.com/levanj/Perl

I also found a mac php package that has postgresql support ( My mac php systems do *not*  support Pg), grrrr.

The package  is located at: http://taracque.hu/php5/

The installation is basically plug and play ( Just have to add a couple of clauses
to the apache config file). The existing Apple php system is not touched.

phpPgAdmin fires right up after the installation.

 It looks almost as nice as my cgi ( Ok that is a lie....but i am prejudiced :)

I assume that if I were to jump to Pg 9.x.x that phpPgAdmim would die, yes?

Thanks

Jerry

On Jan 24, 2011, at 3:25 PM, Jerry LeVan wrote:

> I assume that if I were to jump to Pg 9.x.x that phpPgAdmim would die, yes?

I have not tried it, but my guess is it will work. I don't recall seeing that there were any major protocol changes for
version9, so I suspect whatever libpq version is linked to PHP should work just fine with Postgres 9. 




John DeSoi, Ph.D.

Trapped in Steve Jobs Reality Distortion Field

On Jan 25, 2011, at 8:21 AM, John DeSoi <desoi@pgedit.com> wrote:

>
> On Jan 24, 2011, at 3:25 PM, Jerry LeVan wrote:
>
>> I assume that if I were to jump to Pg 9.x.x that phpPgAdmim would die, yes?
>
> I have not tried it, but my guess is it will work. I don't recall seeing that there were any major protocol changes
forversion 9, so I suspect whatever libpq version is linked to PHP should work just fine with Postgres 9. 
>
You are correct :)

I upgraded three of my Mac systems to 9.0.2 from 8.4.4. All went smoothly
except that one of my gui apps quit displaying selection results...

It turns out that the status I was checking now returns 'SELECT <rowcnt>'
instead of just 'SELECT'.

It took more than a few minutes to find and fix the problem.

Jerry
>
>
>
> John DeSoi, Ph.D.
>
>
>
>