Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: type "foo_20110307_id_seq" already exists (expected relation "foo_20110307_id_seq" already exists) - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: ERROR: type "foo_20110307_id_seq" already exists (expected relation "foo_20110307_id_seq" already exists)
Date
Msg-id AANLkTims2cYz2drN4GF9mmr4F0HJt9gmE10syyDPEnnZ@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: type "foo_20110307_id_seq" already exists (expected relation "foo_20110307_id_seq" already exists)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: type "foo_20110307_id_seq" already exists (expected relation "foo_20110307_id_seq" already exists)
Next
From: Marco
Date:
Subject: Re: Need help for constructing query