Re: DB design and foreign keys

[cut]

> Given this table layout, I'm gonna take a wild guess and ask if you're
> coming from MySQL and expecting the second serial order_code to be a
> sub-autoincrement to id?
>
no, always used PostgreSQL, but i'm having a deeper approach now, until 
now i've been using th ORDBMS in a very 'easy' manner :(

>  If so, it won't be.  That's a mysqlism.  If
> you want something similar, you'll have to implement it yourself, and
> note that such a thing tends to be a poor performer with lots of
> parallel updates, and it can also be susceptible to race conditions if
> no locking is used.
>  
>
thank you, regards,
Gianluca Riccardi