It seems the problem is that PG will only drop the temporary table in the 
end of the session by default rather than by the end of the transaction.

Is there anyway I can inform Database.create_table to use ON COMMIT DROP?

Em sexta-feira, 8 de novembro de 2013 13h52min46s UTC-2, Rodrigo Rosenfeld 
Rosas escreveu:
>
> PostgreSQL was complaining about existing_references table already 
> existing in the database, even though it's always created as a temp table 
> inside a transaction. I create it like this:
>
> DB.create_table :existing_references, temp: true, as: ...
>
> I switched to use the bang variant until I understand the issue.
>
> After restarting the web server the issue was gone but I don't understand 
> why it happened in the first place. The table wouldn't show up in psql for 
> instance...
>
> Any ideas?
>

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to