agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] JarOwner problem
2+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] JarOwner problem
@ 2005-11-22 12:05 
  2005-11-22 12:14 ` [Pljava-dev] Re: JarOwner problem 
  0 siblings, 1 reply; 2+ messages in thread

From:  @ 2005-11-22 12:05 UTC (permalink / raw)

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* [Pljava-dev] Re: JarOwner problem
  2005-11-22 12:05 [Pljava-dev] JarOwner problem 
@ 2005-11-22 12:14 ` 
  0 siblings, 0 replies; 2+ messages in thread

From:  @ 2005-11-22 12:14 UTC (permalink / raw)

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
>





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2005-11-22 12:14 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-22 12:05 [Pljava-dev] JarOwner problem 
2005-11-22 12:14 ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox