<?xml version="1.0" encoding="UTF-8"?><!-- generator="wordpress/2.2.3" -->
<rss version="0.92">
<channel>
	<title>Dryice Liu's Blog</title>
	<link>http://dryice.name/blog</link>
	<description></description>
	<lastBuildDate>Tue, 31 Aug 2010 12:01:11 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>sqlite doesn&#8217;t support more than one primary key in one table</title>
		<description>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, ...</description>
		<link>http://dryice.name/blog/postgresql/sqlite-doesnt-support-more-than-one-primary-key-in-one-table/</link>
			</item>
</channel>
</rss>

