Re: ERROR: type "foo_20110307_id_seq" already exists (expected relation "foo_20110307_id_seq" already exists)

From: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: type "foo_20110307_id_seq" already exists (expected relation "foo_20110307_id_seq" already exists)
Date: 2011-03-25 14:48:22
Message-ID: AANLkTims2cYz2drN4GF9mmr4F0HJt9gmE10syyDPEnnZ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think that this blogpost touches upon the issue you're facing:

http://it.toolbox.com/blogs/database-soup/partition-at-insert-time-a-smart-mistake-44294

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-03-25 15:25:26 Re: Need help for constructing query
Previous Message Tom Lane 2011-03-25 14:29:37 Re: ERROR: type "foo_20110307_id_seq" already exists (expected relation "foo_20110307_id_seq" already exists)