[GENERAL] "relation deleted while in use" encountered with Postgresql 8.0.8

Hi, I'm using a python script w/ the PyGreSQL library to insert 1 billion rows into a database table for an experiment (performing a commit every 10K rows). My script failed at about 170M rows with the following exception: File "/usr/lib64/python2.3/site-packages/pgdb.py", line 163, in execute

[GENERAL] Porting MySQL data types to PostgreSQL

Hi, I am in the process of porting a MySQL database to PostgreSQL. I was wondering why PostgreSQL does not support unsigned data types? Does this mean I'd have to essentially double the space occupied by most database columns e.g convert mysql integer to postgresql bigint? thanks, Gautam