Thread: Bug report

Hello pgadmin-support,

I'm using pgAdminIII Version 1.1.0 Devel (Aug 9 2004) on Windows XP SP2.

I found a bag:

When pgAdmin generates sql query for create (or replace) function
it does not quote the name of returning type e.g.

CREATE OR REPLACE FUNCTION "AreasThemesStatistics_Get4Area"("areaId" int4) RETURNS SETOF
AreasThemesStatistics_Get4AreaTypeAS ...
 

where

CREATE OR REPLACE FUNCTION "AreasThemesStatistics_Get4Area"("areaId" int4) RETURNS SETOF
"AreasThemesStatistics_Get4AreaType"AS ...
 

should be.

So in the function definition dialog i can't create the function
because of error 'type "areasthemesstatistics_get4areatype" does not exist"


bug #2
in table editor (view) dialog i can't insert a row in the table which
does not contain oid field (created without oids)

thank you for support.

-- 
Best regards,Ivan                          mailto:Ivan-Sun1@mail.ru

Ivan-Sun1@mail.ru wrote:

> 
> When pgAdmin generates sql query for create (or replace) function
> it does not quote the name of returning type e.g.

Fixed in cvs, thanks for reporting.

> bug #2
> in table editor (view) dialog i can't insert a row in the table which
> does not contain oid field (created without oids)

The table probably has no PK. Editing is disabled then.

Regards,
Andreas