[basedb-devel] Index dropping fails with Postgres 7.3.19

2007-11-05 Thread Pawel Sztromwasser
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 [

Re: [basedb-devel] Index dropping fails with Postgres 7.3.19

2007-11-05 Thread Pawel Sztromwasser
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

Re: [basedb-devel] Index dropping fails with Postgres 7.3.19

2007-11-05 Thread Nicklas Nordborg
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