Re: [sqlite] How to use PRIMARY KEY AUTOINCREMENT when modelling weakentities?

2008-09-05 Thread Dennis Cote
Andreas Ntaflos wrote: > > But it seems I misunderstood the point of AUTOINCREMENT. I am looking for > something like PostgreSQL's SERIAL data type [1] so when creating new rooms I > don't have to manually specify the roomID. Instead the next possible roomID > should be chosen automatically whe

Re: [sqlite] How to use PRIMARY KEY AUTOINCREMENT when modelling weakentities?

2008-09-05 Thread Andreas Ntaflos
On Friday 05 September 2008 21:57:30 Igor Tandetnik wrote: > Andreas Ntaflos > > <[EMAIL PROTECTED]> wrote: > > this question is about the AUTOINCREMENT usage in SQLite when > > modelling weak entities. Suppose there are two tables 'Building' and > > 'Room': > > > > CREATE TABLE Building ( > >b

Re: [sqlite] How to use PRIMARY KEY AUTOINCREMENT when modelling weakentities?

2008-09-05 Thread Igor Tandetnik
Andreas Ntaflos <[EMAIL PROTECTED]> wrote: > this question is about the AUTOINCREMENT usage in SQLite when > modelling weak entities. Suppose there are two tables 'Building' and > 'Room': > > CREATE TABLE Building ( >buildingID INTEGER PRIMARY KEY AUTOINCREMENT, >... > ); > > CREATE TABLE R