On 01/14/2014 02:26 PM, Thomas Lohman wrote: > I can't say exactly why it happened to you but my guess would be that > this problem could hit anyone porting from mysql to postgres.
At a guess migration scripts don't translate mysql's "autoincrement" (or "identity" or whatever they call it) to postgres sequences. That would likely be the case with sqlite's rowid/"integer primary key" columns to postgres sequences as well. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users