From: thomas at tada.se (Thomas Hallgren)
Date: Tue, 22 Nov 2005 13:14:08 +0100
Subject: [Pljava-dev] Re: JarOwner problem
In-Reply-To: <002601c5ef5d$0a23ea10$1e03a8c0@fhrbek>
References: <200511122229.09406.dgovoni@metadapt.com>
	<43770FA4.9040608@tada.se> <002601c5ef5d$0a23ea10$1e03a8c0@fhrbek>
Message-ID: <43830B90.2050302@tada.se>

Filip,
I wasn't aware of this and I agree, we need to change the table 
structure as per your suggestion. Ouch! The 1.2 release would have been 
the perfect time. Now it's too late. I guess we must do a 1.3 with this 
change since it will be incompatible with prior releases.

Regards,
Thomas Hallgren

Filip Hrbek wrote:
> 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
>