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
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 |