Обсуждение: sys column error

Hi,

I made a new build, after an svn checkout, and I am getting an error
with prevent me to open my databases:

ERROR: no existe la columna "sys"

which means

ERROR: column "sys" doesn't exists.

Previous working version was dated JUN-01-2005.

log file says :


2005-06-07 12:45:20 STATUS : Obteniendo Esquemas detalles...
2005-06-07 12:45:20 QUERY  : Set query (mi_servidor:5432): SELECT CASE
WHEN nspname LIKE 'pg\_temp\_%%' THEN 1
             WHEN nsp.oid<17228 OR nspname like 'pg\_%' THEN 0
             ELSE 3 END AS nsptyp,
        nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
   FROM pg_namespace nsp
   LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
 WHERE (nsp.nspname NOT LIKE 'pg\_%' AND nsp.nspname NOT in
('information_schema', sys)) ORDER BY 1, nspname
 2005-06-07 12:45:20 ERROR  : ERROR:  no existe la columna «sys»
 2005-06-07 12:45:26 STATUS : Obteniendo Esquemas detalles... (5,46 seg)

Thanks,
Diego.

Diego Gil wrote:
> Hi,
>
> I made a new build, after an svn checkout, and I am getting an error
> with prevent me to open my databases:
>
> ERROR: no existe la columna "sys"
>
> which means
>
> ERROR: column "sys" doesn't exists.

Gotcha, you're using EDB! :-)
sys should have been quoted.
Fixed in svn, thanks for reporting.

Regards,
Andreas

EDB ?. What is that ?.

Now PgAdmin complains about column "proargmodes" and
"Column not found in pgSetBase: proallargtypes".

I am going to lunch now. If you need more info, please let me know it.

I sended yesterday an updated spanish translation. Do you know something
about it. ?.

Thanks,
Diego.

El mar, 07-06-2005 a las 15:57 +0000, Andreas Pflug escribió:
> Diego Gil wrote:
> > Hi,
> >
> > I made a new build, after an svn checkout, and I am getting an error
> > with prevent me to open my databases:
> >
> > ERROR: no existe la columna "sys"
> >
> > which means
> >
> > ERROR: column "sys" doesn't exists.
>
> Gotcha, you're using EDB! :-)
> sys should have been quoted.
> Fixed in svn, thanks for reporting.
>
> Regards,
> Andreas
>
>

Diego Gil wrote:
> EDB ?. What is that ?.
>
> Now PgAdmin complains about column "proargmodes" and
> "Column not found in pgSetBase: proallargtypes".
>
> I am going to lunch now. If you need more info, please let me know it.

Hm, seems EDB isn'd identified correctly, fixed in svn.


>
> I sended yesterday an updated spanish translation. Do you know something
> about it. ?.

No, maybe it's stuck in a mail queue?

Regards,
Andreas