PostgreSQL -- Drop index is missing schema declaration.

28 views
Skip to first unread message

Faron Dutton

unread,
Apr 1, 2012, 11:02:48 AM4/1/12
to DB Solo
An index belongs to the same schema as its associated table so a
schema specifier is not necessary on the index name when creating it
since the table name contains a schema specifier. However, the index
name must contain a schema specifier when dropping the index since the
table name is not referenced.

Marko Hantula

unread,
Apr 3, 2012, 6:15:11 PM4/3/12
to db-...@googlegroups.com
This issue should be fixed now. The drop index is qualified with the schema
name, as long as the 'Include schema name in statements' option is
selected.

You can find the fixed version in dbsolo.com/preview.

Marko

> --
> You received this message because you are subscribed to the Google Groups "DB Solo" group.
> To post to this group, send email to db-...@googlegroups.com.
> To unsubscribe from this group, send email to db-solo+u...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/db-solo?hl=en.
>

Reply all
Reply to author
Forward
0 new messages