Hannu,
- Original Message -
From: "Hannu Krosing" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 22, 2003 10:00 PM
Subject: Re: [HACKERS] PostgreSQL not ACID compliant?
> Heikki Tuuri kirjutas P, 21.09.2003 kell 12:51:
> > Tom,
Alvaro Herrera writes:
> Are you going to change "relation" to "table"? In most cases that is
> the intended meaning. ISTM in some other cases it refers to anything
> that can appear in pg_class, but I'm not 100% sure.
There are a few cases where it was obvious that only a table could be
meant,
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Are you going to change "relation" to "table"? In most cases that is
> the intended meaning. ISTM in some other cases it refers to anything
> that can appear in pg_class, but I'm not 100% sure.
Quite a lot of the code considers "relation" to mean "any
Zak Greant wrote:
> Thanks for the Cc: and for noticing the fixes!
>
> To be fair, Paul DuBois and Andrey Stroganov did the actual work - I
> only did some pointing and grunting. I am not sure that we have removed
> everything yet - I still need to do a full sweep of the docs. In any
> case, th
On Sun, Sep 21, 2003 at 05:37:59PM +0200, Peter Eisentraut wrote:
> I've looked through the messages in the backend and identified some areas
> that still deserve some cleanup. Below I list some issues that deserve
> some discussion or that deserve being remembered by other developers.
>
> id, oi
[EMAIL PROTECTED] writes:
> On 24 Sep, Greg Stark wrote:
> > [EMAIL PROTECTED] writes:
> >
> >> On 22 Sep, Greg Stark wrote:
> >> > Are those response times in the right unit? 7-10s?
>
> No problem: http://developer.osdl.org/markw/misc/plana.out
Ok, I guess I misunderstood you. These queries are
[EMAIL PROTECTED] wrote:
2. SELECT d_next_o_id
INTO current_o_id
FROM district
WHERE d_w_id = 1
AND d_id = 8
3. UPDATE district
SET d_next_o_id = d_next_o_id + 1
WHERE d_w_id = 1
AND d_id = 8
I don't know exactly what you are trying to do
but usualy in cases like this, in ord
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Wed, 24 Sep 2003, Tom Lane wrote:
>> But I'm wondering why we have to do this at all.)
> I think if you have something like:
> create table test1 (id int primary key, otherid int references test1);
> insert into test1 values (4,4);
> T1: begin;
> T1:
On 24 Sep, Greg Stark wrote:
> [EMAIL PROTECTED] writes:
>
>> On 22 Sep, Greg Stark wrote:
>> > Are those response times in the right unit? 7-10s?
>>
>> The plans (http://developer.osdl.org/markw/74/db/plan0.out) don't show
>> any table scans. They appears to be mostly index scans. There aren't
On Wed, 24 Sep 2003, Tom Lane wrote:
> Wade Klaver <[EMAIL PROTECTED]> writes:
> > OK, I set you up a login on arch.wavefire.com
>
> Okay, what I find is this sequence of events:
>
> 1. delete from te_users where id = 954;
>
> 2. The ON DELETE CASCADE RI constraint propagates this to a delete of
Robert Treat <[EMAIL PROTECTED]> writes:
> Slackware 8.1, linux 2.4.18 i586, gcc version 2.95.3 20010315 (release)
> This is perl, v5.6.1 built for i386-linux (is this too old?)
Hm. On HPUX 10.20, I can report that CVS tip plperl seems to work with
perl 5.8.0 (at least it can execute a simple fun
[EMAIL PROTECTED] writes:
> On 22 Sep, Greg Stark wrote:
> > Are those response times in the right unit? 7-10s?
>
> The plans (http://developer.osdl.org/markw/74/db/plan0.out) don't show
> any table scans. They appears to be mostly index scans. There aren't
> any batch updates.
Would it be eas
I wonder if we should have an auto-responder so when someone says they
are running 6.5, we can reply --- Yikes, upgrade.
In fact, we could go with a little chart:
7.3.4 great
7.3.0-3 please upgrade, it is easy
7.2 consider upgrading
7.1 wow, that is old
On 25 Sep, Peter Eisentraut wrote:
> [EMAIL PROTECTED] writes:
>
>> This only occurs about 1% of the time. I'm not sure how else to analyze
>> the situation. Let me know if I can clarify anything or provide any
>> more information.
>
> Are you running more than one of these transactions in para
[EMAIL PROTECTED] writes:
> This only occurs about 1% of the time. I'm not sure how else to analyze
> the situation. Let me know if I can clarify anything or provide any
> more information.
Are you running more than one of these transactions in parallel,
overlapping?
--
Peter Eisentraut [EM
Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > Indeed, the plain -d dump says that I have a chunk of /var/mail/prlw1
> > in 1000-13ff. No wonder postgres complained!
>
> Yipes. We have seen this sort of thing once or twice in the past.
> I don't know whether you are looking at a
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] writes:
>> As far as the general utility of it goes, I claim that it could be
>> quite valuable. I am thinking of complex new datatypes (that might be
>> dynamically loaded) that could benefit from having some run-time
>> variables s
On 22 Sep, Greg Stark wrote:
>
> [EMAIL PROTECTED] writes:
>
>> http://developer.osdl.org/markw/74/
>
> Are those response times in the right unit? 7-10s?
Yeah, the database really isn't tuned at all. I've gotten some
suggestions off the list that I will be trying. I'll report them as I
compl
Wade Klaver <[EMAIL PROTECTED]> writes:
> OK, I set you up a login on arch.wavefire.com
Okay, what I find is this sequence of events:
1. delete from te_users where id = 954;
2. The ON DELETE CASCADE RI constraint propagates this to a delete of
some row(s) in c_categories.
3. That fires the c
I've been observing a interesting behavior with our DBT-2 workload. It
appears that a commit to a transaction is taking some time to occur.
I'll try to briefly describe what we're seeing. The transaction goes
something like this:
1. BEGIN
2. SELECT d_next_o_id
INTO current_o_id
FROM distr
[EMAIL PROTECTED] writes:
> As far as the general utility of it goes, I claim that it could be
> quite valuable. I am thinking of complex new datatypes (that might be
> dynamically loaded) that could benefit from having some run-time
> variables specify some aspect of their behavior. Currently,
Ruben Safir Secretary NYLXS wrote:
And what is the licensing?
Looking at their web pages, they provide the services, not the software.
On Tue, Sep 23, 2003 at 06:06:00PM -0700, Richard Schilling wrote:
Just wanted to drop you all a quick note that CogBilling, an online billing system which
Joe Conway writes:
> I had a patch about 80% complete to do this, but it was rejected. The
> comment was that I should use a temp table instead. I still think it
> would be useful myself. See this thread:
>
> http://archives.postgresql.org/pgsql-hackers/2002-12/msg00988.php
I'm sorry that
Gottfried F. Zojer writes:
> 1) Did somebody a compile with the Intel ICC inclusive performance logging
There have been varying degrees of success with the Intel compiler suite.
The 7.4 development branch can be compiled with icc, earlier versions not
without extra hacking. Some people have repo
Philip Yarra wrote:
> It's funny timing - I had to prepare a comparison between PostgreSQL and
> MySQL recently, explaining why we would prefer PostgreSQL. I know some
> people here have issues with the MySQL crashme test results, but I have to
> say I found it possibly one of the best postgreSQ
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> In early versions you needed to use it to turn of the header precompiler.
> (The precompiler is apparently buggy.) Now there is a separate flag for
> that.
I just two days ago verified that with Apple's latest compiler release,
you can only build PG
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > Yes, I saw this failure in Atlanta on their Mac's. The compiler is
> > clearly broken with that flag. Why is that flag used anyway? I see it
> > in template/darwin, or it used to be there before the commit.
>
> In early versions you needed
Bruce Momjian writes:
> Yes, I saw this failure in Atlanta on their Mac's. The compiler is
> clearly broken with that flag. Why is that flag used anyway? I see it
> in template/darwin, or it used to be there before the commit.
In early versions you needed to use it to turn of the header precom
On Wed, 24 Sep 2003, Bruce Momjian wrote:
> Nigel J. Andrews wrote:
> >
> >
> > I never knew running indent was so damn complicated. All three of my
> > development systems can not manage it without throughing a fault
> ...
>
> There are about 6 files that can't be run through pgindent, and tse
Tom Lane wrote:
> CVSROOT: /cvsroot
> Module name: pgsql-server
> Changes by: [EMAIL PROTECTED] 03/09/19 17:47:59
>
> Modified files:
> src/template : darwin
>
> Log message:
> Latest version of gcc from Apple does not work well with -traditional-cpp
> (it rejec
Bruce Momjian wrote:
It is actually this code that is causing it:
LOOPBYTE(
if ((sign[i] & 0xff) != 0xff)
PG_RETURN_POINTER(retval);
);
With the macro being:
#define LOOPBYTE(a) \
for(i=0;i
If you ask me, this is just _weird_
Just wanted to drop you all a quick note that CogBilling, an online billing system
which integrates with GnuCash, is now available for review at
http://www.rsmba.biz/download. CogBilling is an online database driven billing system
written entirely on open source products. In its present state
And what is the licensing?
On Tue, Sep 23, 2003 at 06:06:00PM -0700, Richard Schilling wrote:
> Just wanted to drop you all a quick note that CogBilling, an online billing system
> which integrates with GnuCash, is now available for review at
> http://www.rsmba.biz/download. CogBilling is an
I'll be posting the license on our website soon. But, the license for our original
work, prior to an Open Source release, is an open source license except that the end
user cannot distribute the product beyond their immediate control (e.g. their
company). And, the changes one client makes to t
"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes:
> On Tue, 2003-09-23 at 22:40, Greg Stark wrote:
> > [But then I'm not a fan of treating pg_dump files as if they were backups.]
>
> If you don't use pg_dump for backups what do you use? Stop the database
> and copy the data directory? That is n
Tom Lane wrote:
<[EMAIL PROTECTED]> writes:
I take it there is not way to do this dynamically, for example to
support a dynamically loaded function?
Not at the moment, although IIRC the guc.c data structures are designed
to make it possible to add things on-the-fly. (There's a pointer table
that's
Nigel J. Andrews wrote:
>
>
> I never knew running indent was so damn complicated. All three of my
> development systems can not manage it without throughing a fault (I've
> absolutely no idea why indent in the shell works but doesn't in pgindent on
> one).
>
> Anyway, has anyone pgindented the
Wade Klaver <[EMAIL PROTECTED]> writes:
> In trying to come up with a test scenario, I loaded this db into a 7.4 db
> and got a similar message. It shows up as follows:
> ERROR: attempted to mark4update invisible tuple
> CONTEXT: PL/pgSQL function "c_delete_categories" line 14 at SQL stateme
Andreas Pflug writes:
> Maybe you can implement your stuff using a temporary table?
Perhaps, but the runtime variable route is much more natural from a
user interface perspective, as there are strong parallels with
existing variables. I'll see what I can do in that arena first.
Thanks for the id
On Wed, Sep 24, 2003 at 01:18:32PM +0200, Hans-Jürgen Schönig wrote:
> Correct.
> I had the same error on AIX 5.1 last week (see hackers' list).
> As far as 7.4beta is referred two additional patches are needed (see
> postings by Tom Lane on this topics).
So adding $(filter -lssl -lm) does fix th
Hello Tom,
In trying to come up with a test scenario, I loaded this db into a 7.4 db
and got a similar message. It shows up as follows:
dropsites=> begin;
BEGIN
dropsites=> delete from te_users where reseller = 21;
ERROR: attempted to mark4update invisible tuple
CONTEXT: PL/pgSQL function "c
[EMAIL PROTECTED] wrote:
Tom Lane writes:
> The basic thing is to add an appropriate table entry to guc.c.
I take it there is not way to do this dynamically, for example to
support a dynamically loaded function? All runtime variables are
hard-coded into the backend?
Maybe you can implement your s
<[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>>> The basic thing is to add an appropriate table entry to guc.c.
> I take it there is not way to do this dynamically, for example to
> support a dynamically loaded function?
Not at the moment, although IIRC the guc.c data structures are designed
to
Tom Lane writes:
> The basic thing is to add an appropriate table entry to guc.c.
I take it there is not way to do this dynamically, for example to
support a dynamically loaded function? All runtime variables are
hard-coded into the backend?
Thanks for your help.
Cheers,
Brook
---
Slackware 8.1, linux 2.4.18 i586, gcc version 2.95.3 20010315 (release)
This is perl, v5.6.1 built for i386-linux (is this too old?)
parts from config.log
configure:4214: checking for perl
configure:4232: found /usr/local/bin/perl
configure:4244: result: /usr/local/bin/perl
configure:4253: checki
Hello ,
I m new to this list .
Hopefully some feedback is coming to my questions.
1) Did somebody a compile with the Intel ICC inclusive performance logging
2) Is there a hint where to find in the source the REGEX module and is there any
connection to inheritance of table.(module ???).
3)
<[EMAIL PROTECTED]> writes:
> - How can I introduce a new variable (e.g., XXX) to the system so that
> for example SET XXX=1 will work?
The basic thing is to add an appropriate table entry to guc.c. You
might try searching the sources for all references to one of the
lesser-used GUC variables,
On Tue, 2003-09-23 at 22:40, Greg Stark wrote:
> [But then I'm not a fan of treating pg_dump files as if they were backups.]
If you don't use pg_dump for backups what do you use? Stop the database
and copy the data directory? That is not a valid choice for most people.
-
Samuel A Horwitz wrote:
Are these patches going to be applied soon?
Correct.
I had the same error on AIX 5.1 last week (see hackers' list).
As far as 7.4beta is referred two additional patches are needed (see
postings by Tom Lane on this topics).
Adding the linker options will solve your proble
Manfred Koizar <[EMAIL PROTECTED]> writes:
> Cutting down the number of heap page fetches if PF1 * L > P and P <
> effective_cache_size seems like an obvious improvement, but I was not
> able to figure out where to make this change. Maybe it belongs into
> costsize.c near
> run_cost += outer
I am writing a backend C function whose behavior should depend on the
setting of a new runtime parameter that can be set with SET. I have
several questions concerning how to implement this, as I can find no
information in the documentation.
- How can I introduce a new variable (e.g., XXX) to the
Are these patches going to be applied soon?
On Wed, 24 Sep 2003,
[ISO-8859-1] Hans-Jürgen Schönig wrote:
> Date: Wed, 24 Sep 2003 13:18:32 +0200
> From: "[ISO-8859-1] Hans-Jürgen Schönig" <[EMAIL PROTECTED]>
> To: Michael Meskes <[EMAIL PROTECTED]>
> Cc: Samuel A Horwitz <[EMAIL PROTECTED]>,
>
Michael Meskes wrote:
On Tue, Sep 23, 2003 at 04:21:10PM -0400, Samuel A Horwitz wrote:
I am getting Undefined symbols in build ecpg
...
ld: 0711-317 ERROR: Undefined symbol: .PQfinish
ld: 0711-317 ERROR: Undefined symbol: .PQexec
ld: 0711-317 ERROR: Undefined symbol: .PQclear
ld: 0711-317 ERROR:
On Fri, 19 Sep 2003 11:35:35 -0700, Jenny Zhang <[EMAIL PROTECTED]>
wrote:
>I posted more results as you requested:
Unfortunately they only confirm what I suspected earlier:
>> 2) -> Index Scan using i_ps_suppkey on partsupp
>> (cost=0.00..323.16 rows=80 width=34)
>>
On Tue, Sep 23, 2003 at 04:21:10PM -0400, Samuel A Horwitz wrote:
> I am getting Undefined symbols in build ecpg
>...
> ld: 0711-317 ERROR: Undefined symbol: .PQfinish
> ld: 0711-317 ERROR: Undefined symbol: .PQexec
> ld: 0711-317 ERROR: Undefined symbol: .PQclear
> ld: 0711-317 ERROR: Undefined sy
55 matches
Mail list logo
