I am not an expert for PostgreSQL but may be following link can help and “CREATE TEMP TABLE ……*ON COMMIT DROP* AS” may do the job
*http://www.postgresql.org/docs/8.2/static/sql-createtableas.html <http://www.postgresql.org/docs/8.2/static/sql-createtableas.html>* On Friday, 8 November 2013 21:22:46 UTC+5:30, Rodrigo Rosenfeld Rosas wrote: > > 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.
