On Tue, 27 Jan 2004, Tom Lane wrote:
each candidate. func_select_candidate depends on having some notion of
the same argument position, but what does that mean in such a case?
While it is true that I don't know everything about the current code I
still claim that it can not be such a big
On Wednesday 28 January 2004 00:38, Simon Riggs wrote:
POSTGRESQL: Summary of Changes since last release (7.4.1)
All corrections and changes welcome...if this is well received, then I
will monitor pgsql-commiters to keep track of things.
Speaking as JustAUser (TM) I find this very useful. I
Hello,
I search a way to realize following:
When a user connects to a databse, a function of my should be executed. The
best would be a system table where the active Databaser Users are in, and
creating a Trigger on it. But there is not such a table.
Sometold me to modifying the source, but i
Tom Lane [EMAIL PROTECTED] writes:
In any case, this discussion is predicated on the assumption that the
operations involving the bitmap are a significant fraction of the total
time, which I think is quite uncertain. Until we build it and profile
it, we won't know that.
The other thought I
Dennis Bjorklund [EMAIL PROTECTED] writes:
Now, the above is just my plan before coding and before understanding
everything. It might work and it might not. So far I've got no reason to
thing that it wont work,
Before you start writing anything, I suggest you read
On Wed, 28 Jan 2004, Tom Lane wrote:
when the programmer simply adds names to the parameter declarations
of a function without changing any call sites. If the presence of
parameter names changes the ambiguity resolution rules at all, I'm
doubtful that we could guarantee not to break things.
Hi Simon,
Sorry I couldn't answer sooner.
Hope your daughter is OK by now.
On Wed, 28 Jan 2004, Simon Riggs wrote:
Date: Wed, 28 Jan 2004 14:56:40 -
From: Simon Riggs [EMAIL PROTECTED]
To: [EMAIL PROTECTED], 'pgsql-hackers list' [EMAIL PROTECTED]
Subject: RE: [HACKERS] Write cache
Hi All,
I'm looking for some details on how the locking system works in
relation to transactions dealing with INSERTs and UPDATEs. The version
of PostgreSQL is 7.3.2 and the connections to the database are going
through a JDBC driver. The details of what we are running into are as
follows:
A
Tom Lane [EMAIL PROTECTED] writes:
Greg Stark [EMAIL PROTECTED] writes:
I would see that as the next step, But it seems to me it would be only a small
set of queries where it would really help enough to outweigh the extra work of
the sort.
What sort?
To build the in-memory bitmap
On Wed, 28 Jan 2004 [EMAIL PROTECTED] wrote:
I agree I MAY have an hardware problem. What happens is more a system
freeze than a system crash (there's no panic, no nothing, just freezes, no
disk activity, not network)
I would suspect either bad hardware,a flakey SCSI driver, or a possible
Olivier PRENANT writes...
Because I've lost a lot of data using postgresql (and I know for sure
this
should'nt happen) I've gone a bit further reading documentations on my
disks and...
The bottom line here is that Olivier has lost some data and I'm sure we
all want to know if there is a
Greg Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
What sort?
To build the in-memory bitmap you effectively have to do a sort.
Hm, you're thinking that the operation of inserting a bit into a bitmap
has to be at least O(log N). Seems to me that that depends on the data
Simon Riggs [EMAIL PROTECTED] writes:
In the past, I have used the dd command to squirt data at the disk, then
read it back again - but there may be reasons I don't know why a success on
that test might not be conclusive, so I personally would be happy to defer
to someone that does.
Well
Some potentially helpful background comments on the discussion so far...
Tom Lane writes
Greg Stark writes
Note that the space saving of bitmap indexes is still a substantial
factor.
I think you are still confusing what I'm talking about with a bitmap
index, ie, a persistent structure on-disk.
Chris Bowlby writes
I'm looking for some details on how the locking system works in
relation to transactions dealing with INSERTs and UPDATEs. The version
of PostgreSQL is 7.3.2
p.152 of the 7.3.2 Users Guide, section 9.2.1 Read Committed Isolation
Level applies to your situation as
Hi Simon,
Thanks for the confirmation, I just wanted to make sure I was not going
ape over it and getting confused.
At 08:04 PM 1/28/04, Simon Riggs wrote:
Chris Bowlby writes
I'm looking for some details on how the locking system works in
relation to transactions dealing with INSERTs and
Chris Bowlby wrote:
Hi Simon,
Thanks for the confirmation, I just wanted to make sure I was not
going ape over it and getting confused.
At 08:04 PM 1/28/04, Simon Riggs wrote:
Chris Bowlby writes
I'm looking for some details on how the locking system works in
relation to transactions
Hi,
It seems JDBC driver does not handle if a INSERT SQL statement
performed by executeUpdate() is actually a SELECT, which is rewritten
by the rule system.
Exception in thread main postgresql.stat.result
at
It seems JDBC driver does not handle if a INSERT SQL statement
performed by executeUpdate() is actually a SELECT, which is rewritten
by the rule system.
The JDBC spec says an exception should be thrown if the given SQL
statement produces a ResultSet object which it does. As you note
On Thu, 29 Jan 2004, Tatsuo Ishii wrote:
Hi,
It seems JDBC driver does not handle if a INSERT SQL statement
performed by executeUpdate() is actually a SELECT, which is rewritten
by the rule system.
The JDBC spec says an exception should be thrown if the given SQL
statement produces a
Dear Hackers,
First: I think I have sent out a msg with no body. I'm sorry,
I have to communicate thru a weird Win98 machine, it gets things screwed up
sometimes.
I would like to take up the translation of pgsql msg strings
into slovak (sk_SK). It is fairly similar to czech (cz_CZ), so it
21 matches
Mail list logo
