If I can ask a further question here... I'm moving towards Pg myself (from MySQL) and one "gotcha" that I've come across is getting the insertid from the previously-inserted record. In MySQL, it was something like:

$sth_insert->execute( $chain, 'chain' );
push @relationship_ids, $dbh->{'mysql_insertid'};
[download]

In Postgres, I have to do something like this (b/c I don't know any better {yet}):

$sth_insert->execute( $chain, 'chain' );
push @relationship_ids, ( $dbh->selectrow_array( 'SELECT last_value FR
+OM entities_id_seq' ) );
[download]

Thanks!

Jason