Skip to content

sqlite doesn’t support more than one primary key in one table

This cost me several hours today.
Postgresql support multiple primary keys in one table, and I took granted that sqlite does the same thing when I did some prototype today.
And they have a good reason explained in the SQLite CVSTrac.
The odd thing is, if I specify two primary keys in sqlite, it won’t complain when creating […]

Posted 28 August 2006 § postgresql ‡ Comments (0)

don’t create table with name ends "_seq"

postgresql use this kind of table to keep track of sequence.

Share This

Posted 14 June 2004 § postgresql ‡ Comments (0)
Close
E-mail It