Strange problems with phpPgAdmin - Mailing list pgsql-general

From Geoff Caplan
Subject Strange problems with phpPgAdmin
Date
Msg-id 1278078065.20010330120102@britishgoldsmiths.com
Whole thread Raw
In response to Trigger using function written in PL/PGSQL returns "Unrecognized language specified"  (Dan B <db@cyclonehq.dnsalias.net>)
List pgsql-general
Hi folks

My installation of phpPgAdmin has suddenly stopped working. I am not
very experienced in this area and have run out of ideas. Any pointers
would be much appreciated.

THE SYMPTOMS:

- To summarise, I get all the forms primed with the initial data
  from the default DB, but it won't run any queries via links or
  fields.

- Either nothing happens, I get a duplicate LH pane, or I get an
  error. For example if I click on "select" I get the message:

  Warning: PostgreSQL query failed:
  ERROR: Relation '' does not exist in /www/htdocs/phpPgAdmin/tbl_select.php on line 12
  PostgreSQL said: ERROR: Relation '' does not exist
  Your query: SELECT * FROM "" LIMIT 1

WHAT I HAVE CHECKED

- I am logging on as the SU who owns all the databases

- PHP/Postgres is working fine - I can access the databases via psql
  and PHP scripts without problems.

- I re-intalled phpPgAdmin from scratch.

So, advice would be very welcome - it's a great app and I am missing
it!

Geoff Caplan
Caplan Associates

PS I did post this to the phpPgAdmin specialist list but without
reply. Sorry for the cross posting, but I am very keen to get this
fixed.



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: database dirs very stange on solaris
Next
From: Marcin Kowalski
Date:
Subject: Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP