Opened 17 years ago

Closed 17 years ago

#813 closed defect (fixed)

Postgres db-engine ignores schema information in getDropIndexSql() method

Reported by: Nicklas Nordborg Owned by: everyone
Priority: minor Milestone: BASE 2.5
Component: web Version:
Keywords: Cc:

Description

This causes problem when applying the performance fix in 2.4.4 (#796) since Postgres is not able to find the indexes that are going to be dropped. A possible workaround (submitted by Pawel Sztromwasser) is to extend the search path using the following SQL:

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.

Change History (1)

comment:1 by Nicklas Nordborg, 17 years ago

Resolution: fixed
Status: newclosed

(In [3906]) Fixes #813: Postgres db-engine ignores schema information in getDropIndexSql() method

Note: See TracTickets for help on using tickets.