Didn't know about that one, at least from the reading of the docs...
Thanks,
You answered the question. I knew OID's weren't unique, but they are
likely to be able to distinguish between 2 rows in the same table.
Maybe ctid needs to be documented better?
LER
Original Message
On
I got a mailbox full for Peter, so here is information.
Larry ROsenman
- Forwarded message from Larry Rosenman [EMAIL PROTECTED] -
From: Larry Rosenman [EMAIL PROTECTED]
Subject: Caldera OpenUNIX 8
Date: Fri, 27 Jul 2001 11:58:01 -0500
Message-ID: [EMAIL PROTECTED]
User-Agent: Mutt
-r--r-- 1 ftp ftp 27872 Jul 30 14:00 config.sub
226-Transfer complete.
226 Quotas off
ftp
Larry
regards, tom lane
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail
::dynamic_lib(@_);
+ if (! -d $ENV{POSTGRES_LIB} ) {
+my $cwd = `pwd`;
+ chop $cwd;
+ $ENV{POSTGRES_LIB} = $cwd/../libpq;
+ }
+ $inherited=~ s@OTHERLDFLAGS =@OTHERLDFLAGS =-R$ENV{POSTGRES_LIB}@;
+ $inherited;
+ }
--
Larry Rosenman http
!
http://www.mohawksoft.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail
* Peter Eisentraut [EMAIL PROTECTED] [010814 16:58]:
Larry Rosenman writes:
I made the following patch, and it works for MY platform.
Peter,
Can we do something similar for the distribution to set the
RUNPATH for Pg.so?
This is an interesting idea. I'd rather rip out
* Peter Eisentraut [EMAIL PROTECTED] [010824 19:33]:
Larry Rosenman writes:
I noticed while testing the preceeding patch for resultmap, that we
use /bin/ld -G to build the .so's. THIS DOESN'T WORK on UnixWare and
OpenUNIX 8.
Where can I change this to use cc -G?
src/makefiles
* Peter Eisentraut [EMAIL PROTECTED] [010825 18:14]:
Larry Rosenman writes:
Can we do something similar for the distribution to set the
RUNPATH for Pg.so?
AFAICT, Pg.so does get the runpath set correctly. Are you saying it
doesn't work on your system or do you want to get rid
* Peter Eisentraut [EMAIL PROTECTED] [010825 18:14]:
Larry Rosenman writes:
Can we do something similar for the distribution to set the
RUNPATH for Pg.so?
AFAICT, Pg.so does get the runpath set correctly. Are you saying it
doesn't work on your system or do you want to get rid
.
regards, tom lane
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
---(end of broadcast
* Peter Eisentraut [EMAIL PROTECTED] [010828 09:59]:
Larry Rosenman writes:
in testing CVS tip(sort of), I found that you need -lcurses with
-ledit on NetBSD 1.5.1.
_tputs in undefined otherwise.
Fixed in current.
of NetBSD?
LER
--
Peter Eisentraut [EMAIL PROTECTED] http
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812
Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat
win1251_to_utf8.map
Log message:
Add missing files.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
--
Larry Rosenman http
{POSTGRES_LIB} = $cwd/../libpq;
+ }
+ $inherited=~ s@OTHERLDFLAGS =@OTHERLDFLAGS =-R$ENV{POSTGRES_LIB}@;
+ $inherited;
+ }
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail
of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED
/2922448
DEBUG: redo is not required
DEBUG: database system is ready
THIS IS UNACCEPTABLE.
How do I get out of it?
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive
* Larry Rosenman [EMAIL PROTECTED] [010907 21:06]:
I finally got all the way through a compile set:
CC=cc CXX=CC ./configure --prefix=/usr/local/pgsql --enable-syslog \
--with-CXX --with-perl --enable-multibyte --enable-cassert \
--with-includes=/usr/local/include --with-libs
\
--with-tkconfig=/usr/local/lib --enable-locale --with-python
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail
=/usr/local/lib \
--with-tkconfig=/usr/local/lib --enable-locale --with-python
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
---(end of broadcast)---
TIP 4: Don't 'kill -9
* Larry Rosenman [EMAIL PROTECTED] [011006 14:28]:
If I try:
cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login
I get a time out
This is fixed, and I needed to add a /projects before the /cvsroot.
If I go to the cvs repository checkout link on
developer.postgresql.org
I get the following
, and glorify your Father which is in
heaven. Matthew 5:16
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
--
Larry Rosenman http
;-) )
Comments?
With the Caldera (nee SCO) compiler -O and -g are mutually exclusive.
If you include both, you'll get -g.
I'd recommend against this for production use with the Caldera cc and CC
compilers.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812
locking. (We
already have two voting for such a variable.)
If there is no one except Tom, we can continue.
I'm with Tom. Playing with *ALL* locks is just asking for TROUBLE.
(I don't know if I count).
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812
: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX
. )
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
---(end of broadcast)---
TIP 7: don't forget to increase
this at the start of ServerLoop():
gettimeofday(earlier, tz);
and that value isn't changed, AFAICT. However, I'm not sure why an
uptime is all that useful?
Bragging rights? :)
If we ever do SNMP stuff, it will be useful for those packets as well.
LER
--
Larry Rosenman
a REL8_0_STABLE run running now (should work, unless something is
REALLY broken).
Did the build system change between 8.0 and HEAD?
Thanks!
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive
Larry Rosenman wrote:
Trying to set up my 7.1.4 box as a buildfarm member, and can't get
through A build. The latest failure (after removing --with-perl) is:
$ tail -20 ../../../lastrun-logs/make-contrib.log
cc -O -Kinline -g -K PIC -I. -I../../src/include
-I/usr/local/include -c -o
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
Did the build system change between 8.0 and HEAD?
I don't think so --- certainly there are no changes in
template/unixware or makefiles/Makefile.unixware, which is where
you'd expect to find any platform-specific stuff. The ar command
Getting my UnixWare box to be part of the buildfarm. Could one of the
knowledgeable hackers look at the failure for 'firefly' on REL7_4_STABLE and
tell me if it's ok?
Thanks.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail
My UnixWare 7.1.4 box started flunking with it's latest run..
See the firefly entry on the buildfarm.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US
Since tom seems to be fixing the back branches, I added 7.3 and 7.2 to
firefly's set of branches it tries. Unfortunately
neither one went green :(.
Also, 7.4 seems to now need some contrib check hacking. (It got further,
but not green yet).
Just FYI.
LER
--
Larry Rosenman
Looks like it's time for an update to the config.guess/config.sub scripts.
SCO (don't yell, I'm just the messenger), released OpenServer 6, and needs
updated versions to compile.
Do I need to generate a patch, or can we just get them updated in HEAD?
LER
--
Larry Rosenman
On Jul 19 2005, Peter Eisentraut wrote:
Larry Rosenman wrote:
Do I need to generate a patch, or can we just get them updated in
HEAD?
They were updated two weeks ago and there weren't any SCO-related
changes since then. If you have patches, please submit them to
[EMAIL PROTECTED] first
On Jul 19 2005, Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
Looks like it's time for an update to the config.guess/config.sub
scripts.
Didn't we just do that?
2005-07-01 14:17 petere
* configure, configure.in, config/config.guess, config/config.sub,
config
doesn't include pthreads.
regards, tom lane
---(end of
broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I don't have SMP, but I do have a 4.11 box.
Libc_r is what you want for threads.
LER
--
Larry
that the box is down at the moment. As soon as I can get someone
back in Dallas (I'm in Charlotte)
To get it back up I will. One question: was the python install on octopus
from ports?
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail
==
Regards
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611
---(end
(They'll want a small test case :( )
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611
---(end of broadcast
On Jul 25 2005, ohp@pyrenet.fr wrote:
On Mon, 25 Jul 2005, Larry Rosenman wrote:
Date: 25 Jul 2005 12:47:01 -0500
From: Larry Rosenman ler@lerctr.org
To: ohp@pyrenet.fr
Cc: pgsql-hackers list pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] regression failure on latest CVS
On Jul 25
Jim C. Nasby wrote:
On Sun, Jul 24, 2005 at 07:38:46PM -0400, Larry Rosenman wrote:
Andrew Dunstan wrote:
Larry,
please try building and testing (especially PL installcheck) on that
box using as close as possible to the same config setup as octopus:
http://www.pgbuildfarm.org/cgi-bin
ohp@pyrenet.fr wrote:
On Mon, 25 Jul 2005, Larry Rosenman wrote:
Date: 25 Jul 2005 12:47:01 -0500
From: Larry Rosenman ler@lerctr.org
To: ohp@pyrenet.fr
Cc: pgsql-hackers list pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] regression failure on latest CVS
On Jul 25 2005, ohp
Andrew Dunstan wrote:
Larry Rosenman wrote:
ohp@pyrenet.fr wrote:
On Mon, 25 Jul 2005, Larry Rosenman wrote:
Date: 25 Jul 2005 12:47:01 -0500
From: Larry Rosenman ler@lerctr.org
To: ohp@pyrenet.fr
Cc: pgsql-hackers list pgsql-hackers@postgresql.org
Subject: Re: [HACKERS
Larry Rosenman wrote:
ohp@pyrenet.fr wrote:
On Mon, 25 Jul 2005, Larry Rosenman wrote:
Date: 25 Jul 2005 12:47:01 -0500
From: Larry Rosenman ler@lerctr.org
To: ohp@pyrenet.fr
Cc: pgsql-hackers list pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] regression failure on latest CVS
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
For those following along at home:
Removing --enable-cassert and --enable-debug from the options causes
Firefly to fail.
FWIW, I just checked that CVS tip works OK for me without these
options, with either integer or float timestamps
they need, as far as I know, as well as
access to my box.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611
---(end of broadcast
%2015:29:33
So the question now is: how do we fix the issue with threaded python?
how do we get libc_r into the mix on FreeBSD 4.11?
I think that will answer it (IIRC, libc_r has the pthread_* functions in
it).
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1
$0.02.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US
---(end of broadcast)---
TIP 6: explain analyze is your friend
(they don't
yet, but...).
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US
---(end of broadcast)---
TIP 5: don't forget
, in the past, found other ways to fix the code as well, so
let's give them a few days.
I do know they are working it (I'm getting questions back and forth about
getting their systems up to snuf to compile it :) )
LER
cheers
andrew
--
Larry Rosenman http://www.lerctr.org/~ler
Phone
fixed.
Let's not pre-judge.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611
---(end of broadcast)---
TIP 2
**NOT** seeing this on my box, but.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US
---(end of broadcast)---
TIP 4: Have
Jim C. Nasby wrote:
My buildfarm machine
(http://pgbuildfarm.org/cgi-bin/show_history.pl?nm=octopusbr=HEAD)
is SMP, so if anything we need UP testing.
My UP 4.11-STABLE box is back accessable again.
If someone wants, I can set up another buildfarm member...
LER
--
Larry Rosenman
Andrew Dunstan wrote:
Looks like Unixware is broken too,
cheers
andrew
I think Tom's fix to use IPPROTO_TCP will fix firefly.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar
Larry Rosenman wrote:
I think Tom's fix to use IPPROTO_TCP will fix firefly.
LER
And based on the last run, it did.
Thanks, Tom!
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive
passed
back to caller on interval_div(). The 1st Interval allocated appears to be
left around...
--
I will get a pre-release copy of the compiler to test, but it will take a
while, since they have to revalidate it.
Comments?
--
Larry Rosenman http://www.lerctr.org
Yeah, I think it's a timing thing on when the fix was committed and when
Beta1 was pulled.
It will be in the next beta/release based on the commit I saw.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US
has changed - does the test
need to be updated for the new DST rules you mention, or is this
something else?
Regards, Dave.
Looks like it's RED across the board. It appears to be the DST change for
the US.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1
fix it?
Thanks!
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US
---(end of broadcast)---
TIP 5: don't forget
)
$
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US
---(end of broadcast)---
TIP 4: Have you searched our list archives
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
I just tried(!) to run the buildfarm script on a Alpha DS10L/NetBSD
2.0 box. It died in make check.
Given that the failure was in infinite_recurse, I'm guessing the
problem is that the stack limit is less than our default expectation
Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
On Tue, Oct 18, 2005 at 04:04:42PM -0500, Larry Rosenman wrote:
Upped the stack to 8Mb. Now it dies in Plcheck.
Wierd, it's dying in malloc() because the C library called kill()
from __libc_mutex_unlock().
I wonder
On Oct 18, 2005, at 5:11 PM, Martijn van Oosterhout wrote:
On Tue, Oct 18, 2005 at 05:03:35PM -0500, Larry Rosenman wrote:
Doesn't appear to have a separate libc, HOWEVER, -lpthread may be
screwing
us:
snip
If it is that, does it work if you compile postgres with -lpthread.
Sure, we
On Oct 18, 2005, at 8:49 PM, Larry Rosenman wrote:
On Oct 18, 2005, at 5:11 PM, Martijn van Oosterhout wrote:
On Tue, Oct 18, 2005 at 05:03:35PM -0500, Larry Rosenman wrote:
Doesn't appear to have a separate libc, HOWEVER, -lpthread may be
screwing
us:
snip
If it is that, does
On Oct 18, 2005, at 9:39 PM, Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
I added a LIBS += -lpthread to the end of src/makefiles/
Makefile.netbsd and got a LOOP
on the make check :(
Er ... define LOOP?
postgres master process sitting with 98%+ cpu for 1hour and NO
progress
On Oct 18, 2005, at 10:03 PM, Michael Fuhr wrote:
On Tue, Oct 18, 2005 at 08:59:23PM -0600, Michael Fuhr wrote:
On Tue, Oct 18, 2005 at 09:41:21PM -0500, Larry Rosenman wrote:
I could not find a truss/strace binary on the box :(
In BSD land try ktrace.
...or attach with a debugger
Martijn van Oosterhout wrote:
On Tue, Oct 18, 2005 at 10:07:26PM -0500, Larry Rosenman wrote:
...or attach with a debugger like gdb.
d'oh. I go stupid occasionally :)
If someone wants me to, I can try that.
Yes, actually. See, its dying in the seg test already with:
-- Open
can sue them.
-- End of PGP section, PGP failed!
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US
---(end of broadcast
Sorry for the top post. If you can get a UDK license, that will work
better.
LER
On Nov 22, 2005, at 12:02 PM, Guillaume Lelarge wrote:
Sorry for answering this late.
2005/11/16, Larry Rosenman ler@lerctr.org:
Bruce Momjian wrote:
The SCO compiler is so buggy (and for so many years) I
On Nov 22, 2005, at 7:04 PM, Alvaro Herrera wrote:
Larry Rosenman wrote:
Sorry for the top post. If you can get a UDK license, that will work
better.
Oh, so one gets a buggy compiler by default and has to pay for a
better
one? Cool! I'm drooling already, I want one of those SCO things
between the two types ...
Please do **NOT** break the external representations. We had enough fights
about that 2-3 releases ago, and I personally don't want to revisit them.
Yes, we do flakey things with inet on the masking stuff.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
I just finally got around to playing with PG 8.0.1.
Regression passes just fine on UnixWare 7.1.4mp2.
We can *NOT* enable thread safety for lack of a 2 arg version
of sigwait().
I've asked when it's coming :)
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414
the cluster vu_lhs_index on virtusers, I get the
above assertion.
8.0.1 on UnixWare 7.1.4
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
On Sun, 6 Feb 2005, Larry Rosenman wrote:
I get the following:
$ TRAP: FailedAssertion(!(!(tup-t_data-t_infomask 0x0010)), File:
heapam.c, Line: 1133)
when I try to cluster this table:
CREATE TABLE virtusers (
lhs text,
rhs text,
insert_date timestamp(0) with time zone DEFAULT now
On Sun, 6 Feb 2005, Larry Rosenman wrote:
1) alter table virtusers (and all the others in that db) set without oids;
2) changed postgresql.conf's default_with_oids to false.
Based on my read, this case is what's causing the grief.
To get me out of it:
pg_dump exim exim.db
psql template1
alter
the 4.11-FreeBSD guy refered to above, and with a
very simple table, it comes right back with NO results, but I may not have
what it's looking for in the table definition.
I **DO** get the explain failure, which seems, to me, to be a bug. :(
LER
--
Larry Rosenman, Database Support Engineer, E
, and I have
a DynDns.org
Hostname that changes to support that, as well as a CNAME out of my
domain to
Point to it.
Just more things to think about.
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel
Bruno Wolff III wrote:
On Tue, Jan 03, 2006 at 12:08:46 -0600,
Larry Rosenman [EMAIL PROTECTED] wrote:
The issue is folks that DON'T set reverse DNS, I.E. have generic
rDNS set on their IP's.
I've seen (in my ISP days, and on my mailserver) LOTS of folks that
can't/won't update
, but got a bounce :(
Thanks,
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US
---(end of broadcast)---
TIP 1
Michael Glaesemann wrote:
On Jan 8, 2006, at 12:12 , Larry Rosenman wrote:
I was thinking of handling the TODO for ISO8601 Interval output.
Just to be clear, you're talking about the ISO8601 duration syntax
(PnYnMnDTnHnMnS), correct? (The SQL standard made the unfortunate
choice
Reposting, since it seems to not have made it :(
Larry Rosenman wrote:
Ever since the stats collector changes, I've seen intermittent
failures
on 'firefly' in the buildfarm. This is my machine.
There is one posted now, and the history has them as well.
Could someone look and tell me
(SCO UDK) / 4.2
For more information, see
http://www.pgbuildfarm.org/cgi-bin/show_history.pl?nm=fireflybr=HEAD
This is a Stats failure. I thought the latest change Tom put in would fix
it.
I guess not.
How can I help?
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Greetings,
I've got a fast FreeBSD/amd64 server available to run Buildfarm on.
However, I see we already have a couple of others running it.
My questions are:
1) do we need another one?
2) if yes, what options need coverage?
Thanks,
LER
--
Larry Rosenman
Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
I've got a fast FreeBSD/amd64 server available to run Buildfarm
on.
However, I see we already have a couple of others running it.
My questions are:
1) do we need another one?
2) if yes, what options need
of that.
Please do **NOT** change the I/O formats.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
---(end of broadcast
in 1975.
Started posting on UseNet in 1988.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US
---(end of broadcast
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
the new
diffs (optionally compressed) from the ,v files that are needed to
bring the clients' repository mirror up to date.
As a complete out of nowhere suggestion, you might also look
at csup in FreeBSD's CVS (or the project page), which is a cvsup clone
in C.
LER
--
Larry Rosenman
distro changes it, and you then
overwrite parts of it,
it would be useful for diagnostics.
Comments?
LER
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: [EMAIL
Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
1) expose DEFAULT_PGSOCKET_DIR via a libpq call
2) add this information to the psql --version output (or some other
switch, I'm agnostic).
pg_config would seem to be the appropriate place, not libpq nor psql.
The issue is when you
Darcy Buskermolen wrote:
On Tuesday 28 March 2006 14:07, Larry Rosenman wrote:
Greetings,
After helping a user on irc, I was wondering if there would be
any objection to my making a patch that would:
1) expose DEFAULT_PGSOCKET_DIR via a libpq call
2) add this information to the psql
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
Tom Lane wrote:
pg_config would seem to be the appropriate place, not libpq nor
psql.
The issue is what psql (and any libpq using program) is going to use
to find the UNIX socket.
No, the issue is where the server put the socket
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
The other issue is borked installs where the server and libpq
disagree. What I'm looking for is to expose what libpq has for it's
default as well as what the server is using. There is currently no
way to determine what libpq has
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
That's making the assumption that you know which libpq. I was hoping
to have a psql commandline Switch to dump the info, but with your
objection(s), I'll just crawl back under my rock.
It's not that I don't feel your pain ... but if you
that
the windows code
doesn't enable HAVE_UNIX_SOCKETS, and therefore even if the library returns
a string, it's
useless.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX
Tom Lane wrote:
Larry Rosenman ler@lerctr.org writes:
What's the harm of a (pseudo code):
const char *PQgetunixsocketdir(void)
{
return(DEFAULT_PGSOCKET_DIR)
}
In libpq, and a psql command line switch to call it.
By the time you get done adding the infrastructure
the following batch file with arguments of 40 40 1000 is
almost guaranteed to trigger the problem, though...
@echo off
dropdb bench
createdb bench
pgbench -i -s %1 bench
pgbench -t %3 -c %2 -n bench
It seems to hang up just fine on my XPSP2, PG 8.1.2 HTT box.
:(
LER
--
Larry Rosenman
Larry Rosenman wrote:
Jim C. Nasby wrote:
On Thu, Apr 20, 2006 at 08:06:30PM +0200, Magnus Hagander wrote:
It reuqires a multi-CPU box, right? I don't hav eone with pgwin32 on
ATM. Do you know if it's enough with hyperthreading?
Hrm... not sure. Let me see if I can find a box with HT here
201 - 300 of 712 matches
Mail list logo
