From: filip.hrbek at plz.comstar.cz (Filip Hrbek)
Date: Tue, 22 Nov 2005 13:05:30 +0100
Subject: [Pljava-dev] JarOwner problem
References: <200511122229.09406.dgovoni@metadapt.com>
	<43770FA4.9040608@tada.se>
Message-ID: <002601c5ef5d$0a23ea10$1e03a8c0@fhrbek>

Thomas,

I found a problem when using PostgreSQL 8.1 with pljava. PostrgreSQL 8.1 hid 
the user system id from SQL interface, and consequently from a pg_dumpall 
output as well.
It results in the fact that a database being dumped and reloaded does not 
work properly because of the broken jarowner reference in 
sqlj.jar_repository (a user who should own the jar has a different system id 
after the reload).

I think we should find a solution for this problem. Unfortunately, this will 
probably lead to a database table structure change (user name instead of the 
system id). Or do you have any better idea?

Regards
  Filip