Re: [GENERAL] Database design confusing pg_restore, and misc pg_restore issues

2010-05-08 Thread Rick Yorgason
On 08/05/2010 10:33 PM, Tom Lane wrote: Since you say that --disable-triggers doesn't help, I guess that you're applying that function not in a trigger but in a CHECK constraint? That's pretty horrid in itself: CHECK is *not* meant to enforce anything except local properties of the newly inserted

[GENERAL] Database design confusing pg_restore, and misc pg_restore issues

2010-05-08 Thread Rick Yorgason
Hey everyone, I run a website that sells videogames, and different games have different registration systems, so I have a database design that goes something like this: registration_type enum('none', 'regtype1', 'regtype2') products(product_id, registration_type) order_item(order_id, produ