Re: [ppa-dev] OCF: Error:

[Russell S. <mr...@pw...>]

On Sat, 22 Jan 2005 04:48 am, santiago wrote:
> 
> i'm getting this error message
> >>>>>>>>>>
> 
> SQL error:
> 
> ERROR:  column pn.nsptablespace does not exist
> 
> In statement:
> 
> SELECT pn.nspname, pu.usename AS nspowner, pg_catalog.obj_description(pn.oid, 'pg_namespace') AS nspcomment,
>         (SELECT spcname FROM pg_catalog.pg_tablespace pt WHERE pt.oid=pn.nsptablespace) AS tablespace
>                         FROM pg_catalog.pg_namespace pn, pg_catalog.pg_user pu
>    WHERE pn.nspowner = pu.usesysid
>    AND nspname NOT LIKE 'pg\\_%' AND nspname != 'information_schema' ORDER BY nspname
> 
> PostgreSQL Version: 8.0
> 
> phpPgAdmin Version: 3.5
> 
> Sent via Contact Form on phppgadmin.sourceforge.net
> 
I believe that PostgreSQL renamed that column late in the release cycle, and only phpPgAdmin 3.5.1 supports it.
Try upgrading to 3.5.1 and see if the problem goes away.

Regards

Russell Smith.
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> phpPgAdmin-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-devel
> 
>