Bruce Momjian <[EMAIL PROTECTED]> writes:
> I run it every night and it fails 25% of the time.
When did you start seeing the problem?
I just wasted an hour running eighty-some iterations of "make check"
on two different machines/OSes/architectures. Zero failures. I also
eyeballed recent changes
On Fri, 25 Jul 2003 19:57:04 -0400
Tom Lane <[EMAIL PROTECTED]> said something like:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am seeing the following parallel regression test failures. Any
> > idea on the cause?
>
> I don't see it here, on either of two different architectures. Maybe
>
On Fri, 25 Jul 2003 19:57:04 -0400
Tom Lane <[EMAIL PROTECTED]> said something like:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am seeing the following parallel regression test failures. Any
> > idea on the cause?
>
> I don't see it here, on either of two different architectures. Maybe
>
On Fri, 25 Jul 2003 19:57:04 -0400
Tom Lane <[EMAIL PROTECTED]> said something like:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am seeing the following parallel regression test failures. Any
> > idea on the cause?
>
> I don't see it here, on either of two different architectures. Maybe
>
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am seeing the following parallel regression test failures. Any idea
> > on the cause?
>
> I don't see it here, on either of two different architectures. Maybe
> you need a make distclean and rebuild?
I do (I run tools/pgtest), an
Nigel J. Andrews wrote:
On Thu, 24 Jul 2003, Francisco Figueiredo Jr. wrote:
Nigel J. Andrews wrote:
On Tue, 22 Jul 2003, Francisco Figueiredo Jr. wrote:
How's this for an alternative if you really don't want any rows returned:
create function fincF ( ) returns setof integer as '
begin
d
Tom Lane wrote:
"Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes:
I just wanted void functions behave like others when called as select *
from voidfunction So I dont have to do select voidfunction. :)
It's not only void functions that fail --- I believe the code will
reject any pseudo-ty
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I am seeing the following parallel regression test failures. Any idea
> on the cause?
I don't see it here, on either of two different architectures. Maybe
you need a make distclean and rebuild?
regards, tom lane
--
--On Friday, July 25, 2003 18:20:10 -0400 Greg Stark <[EMAIL PROTECTED]>
wrote:
Peter Eisentraut <[EMAIL PROTECTED]> writes:
Bruce Momjian writes:
> I still think it is confusing to create a libpq_r on platforms that
> have no _r libraries. I am on BSD/OS and I can find only _r library
> on
On 7/25/2003 8:10 AM, Tom Lane wrote:
>Thomas Swan <[EMAIL PROTECTED]> writes:
>
>
>>Hypothetically, if I knew the relations that contained the tuples I was
>>locking, I could conceivably visit them in, let's say, alphabetical
>>order or oid order or any predictable order, and then select the
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Bruce Momjian writes:
>
> > I still think it is confusing to create a libpq_r on platforms that have
> > no _r libraries. I am on BSD/OS and I can find only _r library on my
> > entire system,
>
> The criterion is not whether the platform has _r li
I am seeing the following parallel regression test failures. Any idea
on the cause?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.
On Fri, 25 Jul 2003, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > 'K, fixed the TAG to point to the right revision and am rebuilding the
> > packages right now ...
>
> Repackaged tarball looks good from here. Don't forget to adjust the
> symlink at the top level of the FTP
[ Moved to hackers.]
(The discussion is whether we should support dates of the format
yy-mm-dd. We already support -mm-dd, but we have code that would
see 97-01-01 and detect the first part was a year.)
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I have never seen YY/MM/
The semantics of this conceptually is not too
bad. The implementation could be tricky.
For any given DML or sub-DML (select, eg) the scope
should be for that DML. The DML is the "parent"
of the function. The DML is the statement
context and the function is the function
context.
statement --> fu
Folks,
(Sorry for the cross-posting, but these lists don't have 100% overlap)
If you are planning on attending Linux World Expo San Francisco starting
August 4 please e-mail me in the next 3 days. San Francisco PostgreSQL
User's Group is planning on having a meeting around that time; we would
Peter Eisentraut wrote:
> Bruce Momjian writes:
> 1. need to link in special libc_r (FreeBSD)
> 2. need to use magic flags for compiler and/or linker (FreeBSD, UnixWare)
> 3. need to compile with special preprocessor symbols (UnixWare, AIX)
> 4. need to use different compiler altogether (AIX)
>
>
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
Specifically I'd like to reset a variable within my PL/R interpreter
each time a new SQL statement begins.
Define "new SQL statement". In particular, what of a PL function
executing multiple SQL statements inside an outer SQL statement that
i
I am confused because according to Greg Stark the entire APi had changed
wsith 2.5.31.
---
Peter Eisentraut wrote:
> FYI, after the latest ecpg change, you can now use flex 2.5.31 with
> PostgreSQL.
>
> --
> Peter Eisentra
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> 'K, fixed the TAG to point to the right revision and am rebuilding the
> packages right now ...
Repackaged tarball looks good from here. Don't forget to adjust the
symlink at the top level of the FTP site ...
regards, tom la
On 24 Jul 2003 at 9:42, William Yu wrote:
> As far as I can tell, the performance impact seems to be minimal.
> There's a periodic storm of replication updates in cases where there's
> mass updates sync last resync. But if you have mostly reads and few
> writes, you shouldn't see this situation
Thomas Swan <[EMAIL PROTECTED]> writes:
> Hypothetically, if I knew the relations that contained the tuples I was
> locking, I could conceivably visit them in, let's say, alphabetical
> order or oid order or any predictable order, and then select the rows
> for update (using oid order or primary
On Thu, Jul 24, 2003 at 05:52:07PM -0400, Bruce Momjian wrote:
> Well, our behavior has always been to abort any open transctions on
> client exit. In fact, it is so obvious, we don't even document it.
>
> There are some SQL databases that commit on client exit, but that sounds
> just wrong to u
--On Friday, July 25, 2003 11:51:50 +0200 Peter Eisentraut
<[EMAIL PROTECTED]> wrote:
Larry Rosenman writes:
The -D_REENTRANT causes NO pain, and makes it possible to have ONE
library for UnixWare.
Didn't you just say that -D_REENTRANT changes the definition of errno on
your system? Surely it
Larry Rosenman writes:
> The -D_REENTRANT causes NO pain, and makes it possible to have ONE library
> for UnixWare.
Didn't you just say that -D_REENTRANT changes the definition of errno on
your system? Surely it would not be a good idea to link a libpq that uses
variant 1 with a program that use
--On Friday, July 25, 2003 11:23:05 +0200 Peter Eisentraut
<[EMAIL PROTECTED]> wrote:
Bruce Momjian writes:
I still think it is confusing to create a libpq_r on platforms that have
no _r libraries. I am on BSD/OS and I can find only _r library on my
entire system,
The criterion is not whether
Bruce Momjian writes:
> I still think it is confusing to create a libpq_r on platforms that have
> no _r libraries. I am on BSD/OS and I can find only _r library on my
> entire system,
The criterion is not whether the platform has _r libraries, it's whether
special actions are required in order
Tom Lane wrote:
Thomas Swan <[EMAIL PROTECTED]> writes:
When a SELECT FOR UPDATE query is executed, are the row level locks on a
table acquired in any specific order
Nope, just whatever order the chosen plan happens to visit the tuples
in.
I had remembered several readings on orde
FYI, after the latest ecpg change, you can now use flex 2.5.31 with
PostgreSQL.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
29 matches
Mail list logo
