Re: sys column error

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