Hi,
I got an exception while upgrading from Base 2.4.3 to 2.4.5. It was
during dropping indexes using
"[basedir]/bin/dynamicdb.sh -v -dropindexes" command. The exceptions
message follows:
// some successful droppings
=
Table : D21886Filter
Unique : D21886Filter_pkey [
I found this:
ALTER [base_user_name] SET search_path TO
"$user",public,[base_dynamic_schema_name];
This command executed from psql PostgreSql client adds dynamic schema to
the default search_path.
After this dynamicdb.sh -dropindexes completes with no problems.
Cheers,
Pawel
Pawel Sztromwass
Pawel Sztromwasser wrote:
> I investigated a bit and found out that this index in fact exists. I
> managed to drop it manually using psql with command:
>
> DROP INDEX "dynamic"."D21886Filtercolumn"
>
> Command without schema name prefix (DROP INDEX "D21886Filtercolumn")
> doesn't work. I checke