Re: DB design and foreign keys - Mailing list pgsql-sql

From Gianluca Riccardi
Subject Re: DB design and foreign keys
Date
Msg-id 439FF3A3.7080909@moonwatcher.it
Whole thread Raw
In response to Re: DB design and foreign keys  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-sql
[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


pgsql-sql by date:

Previous
From: Gianluca Riccardi
Date:
Subject: Re: DB design and foreign keys
Next
From: Gianluca Riccardi
Date:
Subject: Re: DB design and foreign keys