Bug in SQL script for indexes

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Bug in SQL script for indexes
Date: 2012-08-27 17:19:17
Message-ID: 503BAC15.7080104@falter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Sachin Srivastava 2012-08-28 12:22:07 Same sub-menu name for disconnectDatabaseFactory and disconnectServerFactory.
Previous Message Erwin Brandstetter 2012-08-27 14:57:37 Re: Items missing from some context menus in object browser of v1.16 beta4