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.
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 feel
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 thou
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
http://www.postgresql.o
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 thing
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 cach
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 p
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-m
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 i
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 t
"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.
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
>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 descr
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 de
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
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statem
> > 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
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
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
