AFAICS, Peter's recent incomplete updating of error message wording
should have broken every last man jack of 'em. And yet there's still
some green to be seen. I think we are looking at problems in the ecpg
test scaffolding. For instance, dragonfly claims a green build, but
On Sun, Jun 03, 2007 at 11:29:33PM -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
Given this, I propose we simply #ifdef out the SO_REUSEADDR on win32.
Anybody see a problem with this?
(A fairly good reference to read up on the options is at
What happened to the idea to run all tests (including PL, ECPG, contrib(?)) by
default, that is, by the top-level check/installcheck targets. Those who
want to run individual tests could still do so in the respective
subdirectories. What requirements does the buildfarm have?
--
Peter
On Sun, Jun 03, 2007 at 10:44:13PM -0400, Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Magnus Hagander wrote:
Given this, I propose we simply #ifdef out the SO_REUSEADDR on win32.
Anybody see a problem with this?
Is that true even if the backend crashes?
It would take a
Given this, I propose we simply #ifdef out the SO_REUSEADDR on
win32.
I agree, that this is what we should do.
(A fairly good reference to read up on the options is at
http://msdn2.microsoft.com/en-us/library/ms740621.aspx
Hmm ... if accurate, that page says in words barely
FYI, I am attending events in Italy, California, Pennsylvania, Finland,
and Russia in the next few months:
http://momjian.us/main/events.html
Site of russian conference: http://www.highload.ru (sorry, but only russian info
yet)
Bruce's announcement:
Tom Lane napsal(a):
Andrew Dunstan [EMAIL PROTECTED] writes:
Zdenek Kotala wrote:
And what about replace all scripts by one command e.g pg_cmd with
following interface:
Well, I don't think rolling up the miscellaneous commands into a single
binary with behaviour dependent on arg[0] is a bad
Assume the following:
index on: (id, adate)
constraint CHECK(adate '01-01-2007' AND adate '04-01-2007');
Um, the subject is CE, but the question is about an index ? Those are
separate issues.
The planner will not use the index listed above.
For what?
select adate from parent
This makes no difference in terms of the ease of tracking their changes,
of course, but it just feels better to me to be distributing real
source code and not derived files.
Hmm.
1 Compiling from .sbl by original Snowball's makefile requires Perl and doesn't
work cleanly:
% gmake
cc -o
but I'll bet
a nickel your CREATE TYPE says something else --- probably varlena
You win, how can I pay this bet? :)
Very very thanks, I was looking for the error in the wrong place! It was
so simple and works!
But still have another problem, may be related with my output
functions!?!?
Is this a TODO?
---
Zdenek Kotala wrote:
Tom Lane napsal(a):
Andrew Dunstan [EMAIL PROTECTED] writes:
Zdenek Kotala wrote:
And what about replace all scripts by one command e.g pg_cmd with
following interface:
Tom Lane wrote:
AFAICS, Peter's recent incomplete updating of error message wording
should have broken every last man jack of 'em. And yet there's still
some green to be seen. I think we are looking at problems in the ecpg
test scaffolding.
Yes. The buildfarm script uses the same logic as
Bruce Momjian [EMAIL PROTECTED] writes:
Is this a TODO?
I don't think so; there is no demand from anybody but Zdenek to remove
those programs. Has it ever even come up before?
regards, tom lane
---(end of broadcast)---
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Is this a TODO?
I don't think so; there is no demand from anybody but Zdenek to remove
those programs. Has it ever even come up before?
No. Agreed.
--
Bruce Momjian [EMAIL PROTECTED] http://momjian.us
EnterpriseDB
On Mon, Jun 04, 2007 at 03:30:07AM -0400, Tom Lane wrote:
AFAICS, Peter's recent incomplete updating of error message wording
should have broken every last man jack of 'em. And yet there's still
some green to be seen. I think we are looking at problems in the ecpg
test scaffolding. For
Peter Eisentraut wrote:
I notice that in 8.3, when I kill the postmaster process with SIGKILL or
SIGSEGV, the child processes writer and stats collector go away
immediately, but the autovacuum launcher hangs around for up to a
minute. (I suppose this has to do with the periodic wakeups?).
Peter Eisentraut wrote:
What happened to the idea to run all tests (including PL, ECPG, contrib(?)) by
default, that is, by the top-level check/installcheck targets. Those who
want to run individual tests could still do so in the respective
subdirectories. What requirements does the
Michael Meskes wrote:
On Mon, Jun 04, 2007 at 03:30:07AM -0400, Tom Lane wrote:
AFAICS, Peter's recent incomplete updating of error message wording
should have broken every last man jack of 'em. And yet there's still
some green to be seen. I think we are looking at problems in the ecpg
First of all, apologies if this was not meant to be a feedback/wishlist
mailing list.
Binary formats in libpq has been (probably) a long
issue (refer to the listings below) and I want to express my hope that the
next revision of PostgreSQL would have better support for binary data types
in
Wilhansen Li wrote:
First of all, apologies if this was not meant to be a feedback/wishlist
mailing list.
Binary formats in libpq has been (probably) a long
issue (refer to the listings below) and I want to express my hope that the
next revision of PostgreSQL would have better support for
Hi
I'm currently working on splitting StartupXLog into smaller
parts, because I need to reuse some of the parts for concurrent
wal recovery (for my GSoC project)
The function recoveryStopsHere in xlog.c checks if we should
stop recovery due to the values of recovery_target_xid and
On Mon, 4 Jun 2007, Andrew Dunstan wrote:
turnip_moth is also a Solaris 9 box and doesn't seem have the same issue.
Kris, is there anything unusual installed on the box that would make it
behave like this?
Not sure what's going on here. I did a manual run of the ecpg tests and
it
Basically, better support for binary formats which includes, but not limited
to:
1) functions for converting to and from various datatypes
2) reducing the need to convert to and from network byte order
3) better documentation
My suggestion on using ASN.1 was merely a naive suggestion on how in
On Mon, 2007-06-04 at 18:26 +0200, Florian G. Pflug wrote:
The function recoveryStopsHere in xlog.c checks if we should
stop recovery due to the values of recovery_target_xid and
recovery_target_time. For recovery_target_xid, we stop if
we see a commit or abort record for the given xid.
On Mon, 2007-06-04 at 14:41 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
One of the main reasons for the implementation was to allow larger
queries to work faster by utilising multiple temp tablespaces for the
same query.
The original ideal implementation was to use
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2007-06-04 at 14:41 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
The original ideal implementation was to use round-robin/cyclic
selection, which allows much better usage in the above case.
Really? What if multiple backends are
On Mon, 2007-06-04 at 15:34 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2007-06-04 at 14:41 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
The original ideal implementation was to use round-robin/cyclic
selection, which allows much better usage in
I tried to repeat the DBT-2 runs with the oldestxmin refresh patch,
but to my surprise the baseline run with CVS head, without the patch,
behaved very differently than it did back in March.
I rerun the a shorter 1h test with CVS head from May 20th, and March 6th
(which is when I ran the
Awhile back, I wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
I've looked into cutting back on the implicit casts to text, which
exposed the following little gem.
The expressions
'abc' || 34
34 || 'abc'
would no longer work, with the following error message:
ERROR: 22P02: array value
Tom Lane [EMAIL PROTECTED] writes:
So after reflecting on all that, it doesn't seem like a good idea to
hack the type-coercion code to discriminate against matching unknown
to anyarray. It looks to me like we have a very narrow problem and
we should tailor a very narrow solution. What I am
On Fri, Jun 01, 2007 at 01:50:12PM -0400, Bruce Momjian wrote:
I think the long-term solution is to go to a 2k/8k fragment/block model,
but that isn't going to happen for 8.3.
There might well have been lessons learned since UFS (anyone know what
ZFS does in this regard?), but I agree that we
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Tom Lane wrote:
+1 on that. The problem of ensuring atomic output remains though
(see nearby complaints from George Pavlov and others).
Is that the one you suggested trying to fix by calling write() instead
of
I wrote:
It looks to me like we have a very narrow problem and
we should tailor a very narrow solution. What I am currently thinking
we should do is make oper() specifically test for the case of operator
349 with UNKNOWN left input, or operator 374 with UNKNOWN right input,
and throw a
Heikki Linnakangas [EMAIL PROTECTED] writes:
I tried to repeat the DBT-2 runs with the oldestxmin refresh patch,
but to my surprise the baseline run with CVS head, without the patch,
behaved very differently than it did back in March.
I rerun the a shorter 1h test with CVS head from May
It's always seemed a little odd to me that Postgres should install a
command called createuser or createlang, because it's entirely
non-obvious on first examination that these commands (which often live
in /usr/bin) have any connections with PostgreSQL. Shouldn't there be
at least be a pg in the
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
we should do is make oper() specifically test for the case of operator
349 with UNKNOWN left input, or operator 374 with UNKNOWN right input,
and throw a custom error message hinting that the other operand
needs to be
Jim C. Nasby [EMAIL PROTECTED] writes:
On Fri, Jun 01, 2007 at 01:50:12PM -0400, Bruce Momjian wrote:
The big question is do we want to drop the target tuple size down to
512, and increase the chunk size to 8k for 8.3?
If we do that people could see their disk space usage increase by up to
Simon Riggs wrote:
Assuming, that is, that you think this point is important enough to
drive the whole design; which I find rather questionable in view of the
fact that the submitted patch contained no mention whatever of any such
consideration. Or is this just another way in which its
Hello
I'm one of the Google SoC's students for PostgreSQL. While reading sql92
standard, I found something like this:
11.36 grant statement
General Rules
3) For every identified privilege descriptor whose action is
SELECT, INSERT, UPDATE, or REFERENCES without a
On 6/5/07, Bruce Momjian [EMAIL PROTECTED] wrote:
Simon Riggs wrote:
Assuming, that is, that you think this point is important enough to
drive the whole design; which I find rather questionable in view of the
fact that the submitted patch contained no mention whatever of any such
40 matches
Mail list logo