Lists: | pgadmin-hackers |
---|
From: | Diego Gil <diego(at)adminsa(dot)com> |
---|---|
To: | PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | sys column error |
Date: | 2005-06-07 15:51:12 |
Message-ID: | 1118159474.20510.6.camel@roadwarrior.adminsa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-hackers |
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.
From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Diego Gil <diego(at)adminsa(dot)com> |
Cc: | PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: sys column error |
Date: | 2005-06-07 15:57:15 |
Message-ID: | 42A5C3DB.9080501@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-hackers |
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
From: | Diego Gil <diego(at)adminsa(dot)com> |
---|---|
To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
Cc: | PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: sys column error |
Date: | 2005-06-07 16:20:41 |
Message-ID: | 1118161241.20510.19.camel@roadwarrior.adminsa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-hackers |
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
>
>
From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Diego Gil <diego(at)adminsa(dot)com> |
Cc: | PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: sys column error |
Date: | 2005-06-07 18:25:59 |
Message-ID: | 42A5E6B7.4020604@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-hackers |
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