[BioSQL-l] Help with load_seqdatabase.pl

[Yves Bastide]

[duh. silly mozilla key bindings]

Hilmar Lapp wrote:
> Jansen, sorry for the late response. The problem is due to PostgreSQL 
> handling failures within a transaction differently (than MySQL/InnoDB 
> and Oracle). The way the adaptor layer works is that those entities 
> which are practically infinite in number are not looked up before 
> insert, but instead their presence is detected by an insert failing the 
> UK constraint. Comment is such an entity. PostgreSQL, however, aborts 
> the entire transaction upon such a (handled or not) failure. I have yet 
> to write certain functions in PL/PgSQL that will get around that problem.
> 
[...]

I've not yet been using bioperl for filling my databases, but my plan
was to replace these tables by views with controlled INSERTs.  (Views
are not strictly necessary; but we may have cases were inserting dups
must raise an exception).

> 
>     -hilmar
> 
yves