reassign 522819 rails
thanks
Rupa Schomaker wrote:
> Running rake after that results in:
> r...@shakti:~/src/camera/camera$ rake db:migrate
> (in /home/rupa/src/camera/camera)
> rake aborted!
> PGError: ERROR: relation "schema_migrations" already exists
> : CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)
>
> The problem is in the SQL that is generated to see if the table exists:
>
> 2009-04-06 12:24:33 CDT LOG: duration: 2.893 ms statement:
> SELECT tablename
> FROM pg_tables
> WHERE schemaname IN (E'"$user"',E'public')
>
> there will never be a schemaname $user. The driver gets the schemaname list
> from the SQL: SHOW search_path and then feeds that into the above select.
>
> The $user needs to be expanded to the currently logged in user.
Yes, you are correct. That's a bug in the ActiveRecord's postgresql driver.
Thanks for the report. I'll fix it and/or forward it upstream shortly.
- Adam
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
