Re: [HACKERS] Runtime accepting build discrepancies

2005-03-11 Thread Thomas Hallgren
Laszlo Hornyak wrote: The default should be the default used by PostgreSQL, and the extra ones should be commented out under it. Not the most user friendly solution, but can we do anything else? Yes, we can do as I suggested and select mapping depending on the GUC variable "integer_datetimes".

Re: [HACKERS] Runtime accepting build discrepancies

2005-03-11 Thread Laszlo Hornyak
The default should be the default used by PostgreSQL, and the extra ones should be commented out under it. Not the most user friendly solution, but can we do anything else? Laszlo On Fri, 11 Mar 2005, Thomas Hallgren wrote: > Laszlo Hornyak wrote: > > > IMHO this is why decoupling is good and n

Re: [HACKERS] Runtime accepting build discrepancies

2005-03-10 Thread Thomas Hallgren
Laszlo Hornyak wrote: IMHO this is why decoupling is good and neccesary. If one configures the RDBMS to use different another of data, then I simply replace a couple of lines in the data mapping configuration. In the case of custom datatypes in PostgreSQL, the same happens. This is no code modi

Re: [HACKERS] Runtime accepting build discrepancies

2005-03-10 Thread Laszlo Hornyak
Thomas Hallgren wrote: Laszlo, I worked on this and created some interface for decoupling java datatypes and their representations. In my implementation the mapping is N:N, so it is not directly applicable to your schema, but perhaps you can use some piece of it. I am not ready with all default d

Re: [HACKERS] Runtime accepting build discrepancies

2005-03-10 Thread Thomas Hallgren
Laszlo, I worked on this and created some interface for decoupling java datatypes and their representations. In my implementation the mapping is N:N, so it is not directly applicable to your schema, but perhaps you can use some piece of it. I am not ready with all default data types, but the most i

Re: [HACKERS] Runtime accepting build discrepancies

2005-03-10 Thread Laszlo Hornyak
Thomas, I worked on this and created some interface for decoupling java datatypes and their representations. In my implementation the mapping is N:N, so it is not directly applicable to your schema, but perhaps you can use some piece of it. I am not ready with all default data types, but the most

Re: [HACKERS] Runtime accepting build discrepancies

2005-03-09 Thread Thomas Hallgren
Tom Lane wrote: Why is PL/Java dependent on the internal representation of any particular datatype? Seems like this is a symptom of bad PL design more than anything else. I didn't see any other way of doing it short of using string conversions. That doesn't seem very optimal. Java's internal

Re: [HACKERS] Runtime accepting build discrepancies

2005-03-09 Thread Tom Lane
Thomas Hallgren <[EMAIL PROTECTED]> writes: > A user download a pre-built PostgreSQL 7.4.7 from somewhere and a > pre-built pljava distro from gborg. He gets everything running but > suddenly encounteres problems with the timetz type. PL/Java apparently > return the time as zero. The problem is