Looks like the tsearch2 update yesterday broke something :-(
Regards, Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 02:20
To: [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: PGBuildfarm member snake Branch HEAD Status changed
Sorry, I'm working on it
Dave Page wrote:
Looks like the tsearch2 update yesterday broke something :-(
Regards, Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 02:20
To: [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: PGBuildfarm
Gevik babakhani wrote:
I would like to compile the code on windows. I understand I need mingw.
on the mingw site there are may packages to download and install.
Does anyone know which ones to download install in order to compile pg.
Hi Gevik,
When I last installed mingw I've downloaded
On Tue, Nov 08, 2005 at 04:06:32PM -0800, daveg wrote:
I think this wait with an exponentially rising delay hurts not helps. If the
stricter lock can be granted in a short time, ie the dalay could be small,
then there is no problem. If the lock cannot be granted and the delay expires
the
On Wed, Nov 09, 2005 at 09:41:49AM +0100, Martijn van Oosterhout wrote:
On Tue, Nov 08, 2005 at 04:06:32PM -0800, daveg wrote:
I think this wait with an exponentially rising delay hurts not helps. If the
stricter lock can be granted in a short time, ie the dalay could be small,
then there
Hi Hackers,
After the subtransaction had been added,
the size of HeapTupleHeader became 27 bytes.
This consumes extra bytes per tuple for the alignment padding,
especially on systems where MAXIMUM_ALIGNOF is 8.
This patch optimizes the location of the first field,
and reduces the padding. I
Hi,
In function IndexSupportInitialize, for each attribute , we call a
function LookUpOpClassInfo(...) and then we find opcentry object which
contain supportProcs pointer which contain the Oid of the function to be
called at the run time.
I am not getting How to find out that Oid from
On 11/8/05, Alvaro Herrera [EMAIL PROTECTED] wrote:
Jaime Casanova wrote:
On 11/8/05, Alvaro Herrera [EMAIL PROTECTED] wrote:
Jaime Casanova wrote:
make[3]: *** No rule to make target `SPI.xs', needed by `SPI.c'.
Stop.
Did you delete that file? It's part of the sources.
No...
Gevik babakhani wrote:
I would like to compile the code on windows. I understand I need mingw.
on the mingw site there are may packages to download and install.
Does anyone know which ones to download install in order to compile pg.
MingW-x.x.x.exe
and MSYS-x.x.x.exe
and you have to
Jaime Casanova wrote:
On 11/8/05, Alvaro Herrera [EMAIL PROTECTED] wrote:
Jaime Casanova wrote:
On 11/8/05, Alvaro Herrera [EMAIL PROTECTED] wrote:
Jaime Casanova wrote:
make[3]: *** No rule to make target `SPI.xs', needed by `SPI.c'.
Stop.
Did you delete that file? It's
ITAGAKI Takahiro wrote:
After the subtransaction had been added,
the size of HeapTupleHeader became 27 bytes.
This consumes extra bytes per tuple for the alignment padding,
especially on systems where MAXIMUM_ALIGNOF is 8.
There was a discussion during the 8.1 devel cycle about shortening
When grilled further on (Wed, 09 Nov 2005 10:54:12 +0300),
Teodor Sigaev [EMAIL PROTECTED] confessed:
So, I'm as sure as I can be right now. How can I check the .so files
installed
by the build? Do they reference an absolute path for their dependent .so
files
(postgres), or will
Petr Jelinek wrote:
Gevik babakhani wrote:
I would like to compile the code on windows. I understand I need mingw.
on the mingw site there are may packages to download and install.
Does anyone know which ones to download install in order to compile pg.
MingW-x.x.x.exe
and
Robert Creager wrote:
Yup. You're right. So, what is happening here? It will be kind of hard to do
a live dump/restore on 1 machine if I cannot have two versions running. Is
something not set up correctly on my machine, or in the build (pg_sphere or
postgresql) that is preventing two
On 11/8/05, Tom Lane [EMAIL PROTECTED] wrote:
Teodor Sigaev [EMAIL PROTECTED] writes:
Layout of GIST_SPLITVEC struct has been changed from 8.0, I'm afraid that
old
.so is used. spl_(right|left)valid fields was added to GIST_SPLITVEC.
Does look a bit suspicious ... Robert, are you *sure*
Alvaro Herrera [EMAIL PROTECTED] writes:
Jaime Casanova wrote:
ok, i execute 'make distclean' and then get the same error when making
after configuring with --with-perl
Is this a clean source tree? Try cvs update -C (beware it'll destroy
all your local changes)
I'm wondering about a clock
Robert Creager [EMAIL PROTECTED] writes:
CREATE FUNCTION sbox_in(cstring) RETURNS sbox
AS '/usr/local/pgsql802/lib/pg_sphere', 'spherebox_in'
LANGUAGE c IMMUTABLE STRICT;
Now if I can just figure out how to get this egg off my face...
You'd be a lot better off to define all your
Gregory Maxwell [EMAIL PROTECTED] writes:
On 11/8/05, Tom Lane [EMAIL PROTECTED] wrote:
Does look a bit suspicious ... Robert, are you *sure* you've got the
right version of pgsphere linked in?
So it turned out that he didn't... Is this a sign that we need to
include a versioning symbol in
Thanks a lot man!!! You saved my life :P
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Martes, 08 de Noviembre de 2005 04:13 p.m.
To: Cristian Prieto
Cc: pgsql-general@postgresql.org; pgsql-hackers@postgresql.org
Subject: Re: [GENERAL]
Oh, and the duplication is not isolated but I only went through the one
case when checking the indexes.
ssdb=# select ctid, xmin, cmin, xmax, account_instance_id, keyword_id
from feature_keyword_supply_google where (account_instance_id,
keyword_id) in (select account_instance_id, keyword_id from
How about representing null array elements with a special-case cast-like
null? Something like {::null}
__
Marc
On Tue, 2005-11-08 at 23:30 -0400, [EMAIL PROTECTED]
wrote:
Date: Tue, 08 Nov 2005 19:21:34 -0500
From: Tom Lane [EMAIL PROTECTED]
To: pgsql-hackers@postgreSQL.org
Subject: Re:
On Wed, Nov 09, 2005 at 10:57:25AM -0500, Tom Lane wrote:
There are cases where it would work, and other cases where it wouldn't.
Given the pain involved in debugging when it's wrong, maybe we should
just endeavor to forbid loading of all wrong-version modules.
I'm not sure that there's any
Marc Munro [EMAIL PROTECTED] writes:
How about representing null array elements with a special-case cast-like
null? Something like {::null}
The problem with *any* proposal for let's-spell-NULL-like-this
is that this is inevitably a string that is valid as a text
data value. Making the string
On Wed, Nov 09, 2005 at 11:22:37AM -0500, Tom Lane wrote:
Marc Munro [EMAIL PROTECTED] writes:
How about representing null array elements with a special-case cast-like
null? Something like {::null}
The problem with *any* proposal for let's-spell-NULL-like-this
is that this is inevitably
On Wed, 09 Nov 2005 09:56:51 -0500
Andrew Dunstan [EMAIL PROTECTED] wrote:
Why use an absolute path? Why not just give the name of the .so and let
postgres find it in $libdir (i.e. sed -e 's,/usr/local/pgsql.*/lib/,,'
on your dump) ?
'cause I didn't know I could? I'll go and fix the
On Wed, 09 Nov 2005 10:42:00 -0500
Tom Lane [EMAIL PROTECTED] wrote:
If pg_sphere is supplying a setup procedure that gets this wrong,
yell at them.
I'll just go fix it, now that I know what the right way is ;-)
Thanks,
Rob
---(end of
Alvaro Herrera [EMAIL PROTECTED] writes:
There was a discussion during the 8.1 devel cycle about shortening the
HeapTupleHeader struct. It involved some games with the command Ids.
Maybe you'll want to look at that, as it could have an impact on what
you're trying to do here.
It would, in
We have spent a lot of time on this to be able to do Windows builds
during the beta cycle. Our DBA manager is going to start with a
fresh machine and attempt to do a full setup from our existing notes
and produce a how to document. When we have this, somebody
here will submit it to the community
Joe Conway wrote:
Last time I thought about this problem, that's what I concluded. I don't
think there is a reasonable and backward compatible solution.
I also think the best non-compatible solution is to require non-numeric
elements to be delimited (double quotes, configurable?), and use
As you can see, we have duplicates within the table (heap) of a primary
key value. The index itself only references one of these tuples.
Nearly all data inserted into this table is wrapped in a subtransaction,
and is created a single tuple per subtransaction. About 20% of entries
are duplicate,
Ron Mayer [EMAIL PROTECTED] writes:
If we're going non-computable, would something that's a superset
of the SQL Standard's array value constructor be useful;
I think you've confused ARRAY[] expressions with the I/O representation
for array values. There are many good reasons why those are not
Rod Taylor [EMAIL PROTECTED] writes:
As you can see, we have duplicates within the table (heap) of a primary
key value. The index itself only references one of these tuples.
Can you put together a test case to reproduce this? It doesn't have to
fail every time, as long as it fails once in
On Wed, 2005-11-09 at 14:20 -0500, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
As you can see, we have duplicates within the table (heap) of a primary
key value. The index itself only references one of these tuples.
Can you put together a test case to reproduce this? It doesn't
Joel Stevenson [EMAIL PROTECTED] writes:
(gdb) p *CurrentTransactionState
$3 = {transactionId = 1068154, subTransactionId = 1, name = 0x0,
savepointLevel = 0,
state = TRANS_ABORT, blockState = TBLOCK_ABORT, nestingLevel = 1,
curTransactionContext = 0x9b06a9c, curTransactionOwner =
Here I found an installation issue:
- I was installing pg 8.1 on a Windows 2000 box.
- I chose a different folder than default (D:\PGSERVER did
not exist yet)
- When installing, the setup complained about not being able
to write into the directory
- I check the directory permissions
On Sun, 2005-11-06 at 11:26 -0500, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On Thu, 2005-11-03 at 10:32 -0500, Tom Lane wrote:
I think we could make it go by cramming the sign and
the high-order dscale bit into the first NumericDigit --- the
digit itself can only be 0..
Simon Riggs [EMAIL PROTECTED] writes:
On Sun, 2005-11-06 at 11:26 -0500, Tom Lane wrote:
Really? After I woke up a bit more I realized there was only one bit
and change to spare, not two, so I don't see how it would work.
Not sure why you think that. Seems to fit
[ counts on fingers and
Are you talking about make install, initdb, or somethingi else?
In any event, is it really something you want to give Everyone
the right to directly modify?
-Kevin
Gevik babakhani [EMAIL PROTECTED]
Here I found an installation issue:
- I was installing pg 8.1 on a Windows 2000 box.
- I
He's talking about the installer, I think (and so should really be
asking on the installer site at
http://pgfoundry.org/projects/pginstaller , or at any rate not on -hackers.
cheers
andrew
Kevin Grittner wrote:
Are you talking about make install, initdb, or somethingi else?
In any
We found PostgreSQL a mature product, but in two things Firebird was
simply better than PostgreSQL: Two-Phase commit (ok, that is gone with
PG 8.1), but the second is a SNAPSHOT / REPEATABLE READ transaction
isolation. I can't live without that when it comes having a stable view
of data during
Tom Lane [EMAIL PROTECTED] wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
There was a discussion during the 8.1 devel cycle about shortening the
HeapTupleHeader struct.
It would, in fact, largely eliminate the point of this patch, since the
standard header size would go back to being a
On Wed, 2005-11-09 at 19:35 -0600, Tony Caduto wrote:
We found PostgreSQL a mature product, but in two things Firebird was
simply better than PostgreSQL: Two-Phase commit (ok, that is gone with
PG 8.1), but the second is a SNAPSHOT / REPEATABLE READ transaction
isolation. I can't live
Anyone know how I can turn off these emails to the pgsql committer's list?
User Chriskl wrote:
Update of /cvsroot/dbsamples/dbsamples
In directory pgfoundry.org:/tmp/cvs-serv14202
Log Message:
Intial import of port of MySQL world database.
Status:
Vendor Tag: chriskl
Release Tags:
In the CREATE FUNCTION docs I notice this:
RETURNS NULL ON NULL INPUT or STRICT indicates that the function always
returns null whenever any of its arguments are null. If this parameter
is specified, the function is not executed when there are null
arguments; instead a null result is assumed
On Wed, Nov 09, 2005 at 19:35:30 -0600,
Tony Caduto [EMAIL PROTECTED] wrote:
We found PostgreSQL a mature product, but in two things Firebird was
simply better than PostgreSQL: Two-Phase commit (ok, that is gone with
PG 8.1), but the second is a SNAPSHOT / REPEATABLE READ transaction
Bruno Wolff III [EMAIL PROTECTED] writes:
On Wed, Nov 09, 2005 at 19:35:30 -0600,
Tony Caduto [EMAIL PROTECTED] wrote:
We found PostgreSQL a mature product, but in two things Firebird was
simply better than PostgreSQL: Two-Phase commit (ok, that is gone with
PG 8.1), but the second is a
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
In the CREATE FUNCTION docs I notice this:
RETURNS NULL ON NULL INPUT or STRICT indicates that the function always
returns null whenever any of its arguments are null. If this parameter
is specified, the function is not executed when there
47 matches
Mail list logo
