Re: DB design and foreign keys

Поиск
Список
Период
Сортировка
От Gianluca Riccardi
Тема Re: DB design and foreign keys
Дата
Msg-id 439FF3A3.7080909@moonwatcher.it
обсуждение исходный текст
Ответ на Re: DB design and foreign keys  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список 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 по дате отправления:

Предыдущее
От: Gianluca Riccardi
Дата:
Сообщение: Re: DB design and foreign keys
Следующее
От: Gianluca Riccardi
Дата:
Сообщение: Re: DB design and foreign keys