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 the
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> On Wed, Nov 09, 2005 at 19:35:30 -0600,
> Tony Caduto <[EMAIL PROTECTED]> wrote:
>> > 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
On Wed, Nov 09, 2005 at 19:35:30 -0600,
Tony Caduto <[EMAIL PROTECTED]> wrote:
> 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 vie
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 a
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: start
On Wed, 2005-11-09 at 19:35 -0600, Tony Caduto wrote:
> 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 one tra
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
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 one transaction, or did that change with 8.1? Is there
now a SNAPHOST
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 ev
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 2
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 fing
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
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
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
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 d
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 a
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 n
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, so
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 NU
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 communit
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,
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 broadcast)-
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, 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
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 st
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
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
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
f
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 s
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] [HA
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
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
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, ar
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 co
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 MSYS-x.x.x.e
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),
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
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
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 buil
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 th
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 attrib
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 expec
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 t
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 st
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 only
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 memb
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 chang
47 matches
Mail list logo