Hi all, is it possible to drop primary key indexes from within SA? I already found the table.indexes set, but it does not contain the primary key index. I can therefore drop all indexes for a table except the primary key one.
It seems to me as if SA relies on a strict naming scheme for primary key
indexes in the form of "tablename_pkey" is this correct and could i rely
on that if i want to drop the index manually? What happens if there
already is a table with that name prior to table creation?
As you might have guessed i also would like to recreate this index later
on. Is there a automatic way to do so, or do i have to define the index
by myself?
with kind regards
Wolodja Wentland
signature.asc
Description: Digital signature
