[pgadmin-hackers] Bug in SQL script for indexes

[Erwin Brandstetter]

Aloha!

The SQL script for indexes incorrectly prepends the index name with the table name of the involved table - instead of the schema 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


--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers