Bug in SQL script for indexes - Mailing list pgadmin-hackers

From Erwin Brandstetter
Subject Bug in SQL script for indexes
Date
Msg-id 503BAC15.7080104@falter.at
Whole thread Raw
Responses Re: Bug in SQL script for indexes  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-hackers
Aloha!

The SQL script for indexes incorrectly prepends the index name with the table name of the involved table - instead of
theschema name where the index  
lives.

Demo to reproduce:
I say:

     CREATE TABLE x(name text);
     CREATE INDEX name_idx ON x (name);

pgAdmin says:
     -- Index: x.name_idx

     -- DROP INDEX x.name_idx;

     CREATE INDEX name_idx
       ON x
       USING btree
       (name COLLATE pg_catalog."default" );

Must be:

     -- Index: name_idx

     -- DROP INDEX name_idx;
     ...

Or:

     -- Index: public.name_idx

     -- DROP INDEX public.name_idx;
     ...

http://code.pgadmin.org/trac/ is still down, so I did not file a ticket.

Regards
Erwin


pgadmin-hackers by date:

Previous
From: "pgAdmin Trac"
Date:
Subject: Re: [pgAdmin III] #377: Regression in 1.16 b4: missing items from context menu for indexes and pkeys
Next
From: Erwin Brandstetter
Date:
Subject: Items missing from some context menus in object browser of v1.16 beta4