Hi,
I've found that B-tree crash recovery in 8.3 beta2 could make some
tuples invisible through B-tree. They're visible if we read using but
Seq-Scan. This happens in 8.3 beta2, but not in 8.2.4. Here's how it
happens.
1. Create b-tree for a text type column.
2. Make B-tree three-story, that
The test runs for me when I change all of the underlying types from bit
to boolean:
create table Bit_Tab (MAX_VAL boolean, MIN_VAL boolean, NULL_VAL boolean
NULL) ;
CREATE OR REPLACE FUNCTION Bit_In_Min (MIN_PARAM boolean) returns void as
'begin update Bit_Tab set MIN_VAL=MIN_PARAM; end;' lan
On Thu, 15 Nov 2007, Lance Andersen wrote:
The following bug has been logged online:
Bug reference: 3751
PostgreSQL version: 8.2.x
Description:Conversion error using PreparedStatement.setObject()
Details:
A PreparedStatement.setObject(1, "1", Types.Bit) will fail with the
follo
Lance J. Andersen wrote:
Thank you for your time, but i think there is still a driver issue here:
If i use the same types as i sent in the email and execute
select * from bit_in_min(1::bit)
I have no problems and the table is correctly updated.
This would lead me to believe that the driver
The following bug has been logged online:
Bug reference: 3751
Logged by: Lance Andersen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.x
Operating system: N/A
Description:Conversion error using PreparedStatement.setObject()
Details:
A PreparedStatement.set
The following bug has been logged online:
Bug reference: 3750
Logged by: Christian Ullrich
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3-beta2
Operating system: Windows Server 2003
Description:Invalid frontend message type 112
Details:
I'm running 8.3-bet
"Blanco, Jose" <[EMAIL PROTECTED]> writes:
> Well, this was running very slowly, so I droped the index and recreated
> it, and then it ran quickly.
Sounds like you had a bloated index.
> I'm running versin 7.3
Consider switching to something more modern --- 7.3 is vastly slower
than current rele
The following bug has been logged online:
Bug reference: 3748
Logged by: Sudarshan V Tantry
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.8.2
Operating system: Redhat Linux
Description:Postmaster Service
Details:
We are supporting a messaging system in whic
A couple things:
On Thu, Nov 15, 2007 at 12:49:40PM +, Sudarshan V Tantry wrote:
> PostgreSQL version: 7.8.2
There is no PostgreSQL version numbered that.
> We are supporting a messaging system in which there are two application
> servers with cluster services.Cluster service does the job o
