Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
Tom Lane wrote: > "Larry Rosenman" 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 &g

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
Tom Lane wrote: > "Larry Rosenman" 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&#

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
systems (since I think 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 M

Re: [HACKERS] Exposing DEFAULT_PGSOCKET_DIR via a libpq function?

2006-03-28 Thread Larry Rosenman
Tom Lane wrote: > "Larry Rosenman" 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.

Re: [HACKERS] Unresolved Win32 bug reports

2006-04-20 Thread Larry Rosenman
g up just fine on my XPSP2, PG 8.1.2 HTT box. :( 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 PROTECTED] Web: www.pervasive.com ---(e

Re: [HACKERS] Unresolved Win32 bug reports

2006-04-20 Thread 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? >> >>

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
t autovacuum messages, but this doesn't say what gets logged at what level for autovacuum. I'd like to see a more concrete definition of what we want Autovacuum to output and at what levels. LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA T

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
Tom Lane wrote: > "Larry Rosenman" <[EMAIL PROTECTED]> writes: >> I'd like to see a more concrete definition of what we >> want Autovacuum to output and at what levels. > > I would argue that what people typically want is > > (0) noth

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
ng on it. LER > --- > >>> >> >> This sounds like a winner to me. Anyone else want to grab it? I'm >> in the position to try and do this, but don't want to step on anyone >> else's toes. >> >> LER -- Larry Rosenman

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
wever, it might be cleaner if we allowed a "level 3" that made all > of autovac's vacuums be VERBOSE. > I was thinking along those exact lines. (A 3rd level). LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
7;m happy if we just emit that at DEBUG1 and let people > select it with log_min_messages. > > regards, tom lane I was going to make that same comment, as this seems to be more implementation detail, which should be at DEBUGn. LER -- Larry Rosenman D

Re: [HACKERS] Logging pg_autovacuum

2006-04-27 Thread Larry Rosenman
Simon Riggs wrote: > On Thu, 2006-04-27 at 14:53 -0400, Tom Lane wrote: >> "Larry Rosenman" <[EMAIL PROTECTED]> writes: >>> I'd like to see a more concrete definition of what we >>> want Autovacuum to output and at what levels. >> >> aut

Re: [HACKERS] Logging pg_autovacuum

2006-04-28 Thread Larry Rosenman
Larry Rosenman wrote: > Simon Riggs wrote: >> On Thu, 2006-04-27 at 14:53 -0400, Tom Lane wrote: >>> "Larry Rosenman" <[EMAIL PROTECTED]> writes: >>>> I'd like to see a more concrete definition of what we >>>> want Autovac

Re: [HACKERS] Logging pg_autovacuum

2006-04-28 Thread Larry Rosenman
Robert Treat wrote: > On Friday 28 April 2006 12:09, Larry Rosenman wrote: >> Larry Rosenman wrote: >>> Simon Riggs wrote: >>>> On Thu, 2006-04-27 at 14:53 -0400, Tom Lane wrote: >>>>> "Larry Rosenman" <[EMAIL PROTECTED]> writes:

Re: [HACKERS] Logging pg_autovacuum

2006-04-28 Thread Larry Rosenman
or me (as a relative noobie) to do. -- 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 PROTECTED] Web: www.pervasive.com ---(end of broadcast)--

Re: [HACKERS] Logging pg_autovacuum

2006-04-28 Thread Larry Rosenman
Martijn van Oosterhout wrote: > On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote: >>> Martijn van Oosterhout writes: >>>> You know, rather than adding new columns to pg_class, why not >>>> extend the stats collector to collect this information. &

Re: [HACKERS] Logging pg_autovacuum

2006-05-01 Thread Larry Rosenman
ag to set that says this (vacuum|analyze) was done by the autovacuum daemon? I agree that the existing stats calls are good, but I'm still reading code to see whether I can determine at the time they are cut that this was autovacuum that did it. Thanks for the nice introductory project :)

Re: [HACKERS] Logging pg_autovacuum

2006-05-01 Thread Larry Rosenman
Jim C. Nasby wrote: > On Mon, May 01, 2006 at 12:28:21PM -0500, Larry Rosenman wrote: >> Since both vacuum and autovacuum will be cutting stats records, do we >> want to just have the autovacuum >> stats record have the fact that it was autovacuum that did the >> vacuum?

Re: [HACKERS] Logging pg_autovacuum

2006-05-01 Thread Larry Rosenman
Larry Rosenman wrote: > Jim C. Nasby wrote: >> On Mon, May 01, 2006 at 12:28:21PM -0500, Larry Rosenman wrote: >>> Since both vacuum and autovacuum will be cutting stats records, do >>> we want to just have the autovacuum >>> stats record have the fact

Re: [HACKERS] Logging pg_autovacuum

2006-05-02 Thread Larry Rosenman
Simon Riggs wrote: > On Fri, 2006-04-28 at 22:38 +0200, Martijn van Oosterhout wrote: >> On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote: >>>> Martijn van Oosterhout writes: >>>>> You know, rather than adding new columns to pg_class, why not

[HACKERS] patch review, please: Autovacuum/Vacuum times via stats.

2006-05-02 Thread Larry Rosenman
review, it includes docs as well. Thanks! 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 PROTECTED] Web: www.pervasive.com ---(end of

Re: [HACKERS] patch review, please: Autovacuum/Vacuum times via stats.

2006-05-02 Thread Larry Rosenman
Larry Rosenman wrote: > Greetings, > I've got a patch to be reviewed for having the stats system keep > track of the last > time a table was vacuumed or analyzed either by the user or via > AutoVacuum. > > The patch is at: > http://www.lerctr.org/~ler/pg-dev/vacuu

Re: [HACKERS] sblock state on FreeBSD 6.1

2006-05-03 Thread Larry Rosenman
aybe that's not the proper way not to block on FBSD. Though Larry was > telling me that there's recently been changes made in the socket code, > so maybe this problem was fixed recently. I didn't see a direct hit looking at the routines we talked about yesterday, but

[HACKERS] autovacuum logging, part deux.

2006-05-04 Thread Larry Rosenman
or it. Thanks, Larry Rosenman -- 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 PROTECTED] Web: www.pervasive.com ---(end of broa

Re: [HACKERS] autovacuum logging, part deux.

2006-05-04 Thread Larry Rosenman
ble? I.E. capture all the verbose info somewhere? Or, do people just want to increase the logging? I still don't see a consensus on what needs to come out. Do we still need the autovacuum_verbosity type change? LER -- Larry Rosenman Database Support Engineer PERVA

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
x27;ve proposed libpq functions to expose compile-time constants, I've been shot down. How is this different? -- 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 Emai

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
Bruce Momjian wrote: > Larry Rosenman wrote: >> Tom Lane wrote: >>> Bruce Momjian writes: >>>> I thought about this. Attached is a patch you can use to >>>> popen("pg_config") and then look for the thread flag to configure. >>>>

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
Bruce Momjian wrote: > Larry Rosenman wrote: >> Bruce Momjian wrote: >>> Larry Rosenman wrote: >>>> Tom Lane wrote: >>>>> Bruce Momjian writes: >>>>>> I thought about this. Attached is a patch you can use to >>>>>&

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
Bruce Momjian wrote: > Larry Rosenman wrote: >> Bruce Momjian wrote: >>> Larry Rosenman wrote: >>>> Bruce Momjian wrote: >>>>> Larry Rosenman wrote: >>>>>> Tom Lane wrote: >>>>>>> Bruce Momjian writes: >>

Re: [HACKERS] [GENERAL] Querying libpq compile time options

2006-05-17 Thread Larry Rosenman
Tom Lane wrote: > "Larry Rosenman" <[EMAIL PROTECTED]> writes: >>> Uh, it is an _admin_ function, not an application programmer >>> function. > >> but libpq is the only thing that knows where it is, and I had >> proposed a way for psql to use t

Re: [HACKERS]

2006-05-19 Thread Larry Rosenman
your table/index/relation. see the storage section of the documentation. -- 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 PROTECTED] Web: www.pervasive.com

Re: [HACKERS] Gborg and pgfoundry

2006-05-25 Thread Larry Rosenman
e of how each is set up, is resident in a very small minority of the folks that help run things. I have Pervasive's blessing to spend paid time working on "community" projects, and this could be one of them, but every time I try to get more information about how things on BOTH gborg

Re: [HACKERS] Gborg and pgfoundry

2006-05-25 Thread Larry Rosenman
I *thought* was already written, just needed alot >> of testing? > > I remember reading something abou this as well but the big question > is: > > Where is the scripting? > it's in an admin project on pgfoundry, and VERY lacking in details. It assumes a

Re: [HACKERS] Going for "all green" buildfarm results

2006-06-02 Thread Larry Rosenman
y (I'm the owner), would they have a prayer Of being applied? LER > > regards, tom lane > > ---(end of > broadcast)--- > TIP 2: Don't 'kill -9' the postmaster -- Larry Rosenman http://w

Re: [HACKERS] Going for 'all green' buildfarm results

2006-06-02 Thread Larry Rosenman
Tom Lane wrote: > "Andrew Dunstan" <[EMAIL PROTECTED]> writes: >> Larry Rosenman said: >>> If I generate fixes for firefly (I'm the owner), would they have a >>> prayer Of being applied? > >> Sure, although I wouldn't bother with 7.3

Re: [HACKERS] Going for 'all green' buildfarm results

2006-06-02 Thread Larry Rosenman
Larry Rosenman wrote: > Tom Lane wrote: >> "Andrew Dunstan" <[EMAIL PROTECTED]> writes: >>> Larry Rosenman said: >>>> If I generate fixes for firefly (I'm the owner), would they have a >>>> prayer Of being applied? >>

Re: [HACKERS] Going for 'all green' buildfarm results

2006-06-02 Thread Larry Rosenman
Larry Rosenman wrote: > Larry Rosenman wrote: >> Tom Lane wrote: >>> "Andrew Dunstan" <[EMAIL PROTECTED]> writes: >>>> Larry Rosenman said: >>>>> If I generate fixes for firefly (I'm the owner), would they have a >>>>&

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-08 Thread Larry Rosenman
BLE #59: Thu Jun 1 09:40:47 CDT 2006 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/THEBIGHONKER amd64 $ sysctl hw hw.machine: amd64 hw.model: Intel(R) Xeon(TM) CPU 3.00GHz hw.ncpu: 4 hw.byteorder: 1234 hw.physmem: 4286132224 hw.usermem: 4003151872 hw.pagesize: 4096 hw.floatingpoint: 1 hw.machine_ar

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-09 Thread Larry Rosenman
terday (39ms without explain analyze, 280+ with explain analyze) on FreeBSD/amd64, Dual Xeon's in HTT mode help? What can I do to further the investigation? It has 8.1.4 on it. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-M

Re: [HACKERS] Test request for Stats collector performance improvement

2006-06-15 Thread Larry Rosenman
SD. This was done on a dual-xeon in 64-bit mode. HTT *IS* enabled. 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 --

[HACKERS] Followup on the UnixWare Optimizer bug.

2005-08-24 Thread Larry Rosenman
o interval_justify_hours() which allocates another Interval "result" and that "result" is what gets 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 t

Re: [HACKERS] timestamp.c

2005-08-28 Thread Larry Rosenman
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.o

Re: [HACKERS] [COMMITTERS] pgsql: Update timezone data files to release 2005m of the zic database.

2005-09-08 Thread Larry Rosenman
gt; The horology test failed on both 8.x branches for Snake (win32) last > night. It appears one of the timezones 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

[HACKERS] Alpha: HEAD: Failure

2005-10-18 Thread Larry Rosenman
help 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

[HACKERS] 2nd try @NetBSD/2.0 Alpha

2005-10-18 Thread Larry Rosenman
) $ -- 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

Re: [HACKERS] Alpha: HEAD: Failure

2005-10-18 Thread Larry Rosenman
Tom Lane wrote: > "Larry Rosenman" 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 l

Re: [HACKERS] 2nd try @NetBSD/2.0 Alpha

2005-10-18 Thread Larry Rosenman
Tom Lane wrote: > Martijn van Oosterhout 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_mu

Re: [HACKERS] 2nd try @NetBSD/2.0 Alpha

2005-10-18 Thread Larry Rosenman
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: If it is that, does it work if you compile postgres with -lpthread. Sure, we

Re: [HACKERS] 2nd try @NetBSD/2.0 Alpha

2005-10-18 Thread Larry Rosenman
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: If it is that, do

Re: [HACKERS] 2nd try @NetBSD/2.0 Alpha

2005-10-18 Thread Larry Rosenman
On Oct 18, 2005, at 9:39 PM, Tom Lane wrote: Larry Rosenman 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 progre

Re: [HACKERS] 2nd try @NetBSD/2.0 Alpha

2005-10-18 Thread Larry Rosenman
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

Re: [HACKERS] 2nd try @NetBSD/2.0 Alpha

2005-10-19 Thread Larry Rosenman
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, actual

Re: [HACKERS] server closed connection on a select query

2005-11-15 Thread Larry Rosenman
rtijn van Oosterhout >> http://svana.org/kleptog/ >>> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent >>> is a tool for doing 5% of the work and then sitting around waiting >>> for someone else to do the other 95% so you can sue them

Re: [HACKERS] server closed connection on a select query

2005-11-22 Thread Larry Rosenman
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 : Bruce Momjian wrote: The SCO compiler is so buggy (and for so many years) I see no reason

Re: [HACKERS] server closed connection on a select query

2005-11-22 Thread Larry Rosenman
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 t

Re: [HACKERS] broken 'SHOW TABLE'-like query works in 8, not 8.1.1

2005-12-29 Thread Larry Rosenman
. For clarification, I'm 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 Ro

Re: [HACKERS] Why don't we allow DNS names in pg_hba.conf?

2006-01-03 Thread Larry Rosenman
P changes when the PPPoE moves, 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 30

Re: [HACKERS] Why don't we allow DNS names in pg_hba.conf?

2006-01-03 Thread Larry Rosenman
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

[HACKERS] ISO 8601 Intervals

2006-01-07 Thread Larry Rosenman
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: if

Re: [HACKERS] ISO 8601 Intervals

2006-01-09 Thread Larry Rosenman
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 sta

[HACKERS] FW: Intermittent Stats Failiures: firefly: HEAD

2006-01-11 Thread Larry Rosenman
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 wel

Re: [HACKERS] [BUGS] Bug in create operator and/or initdb

2005-01-31 Thread Larry Rosenman
ues about conversions 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

[HACKERS] 8.0.1: Runs on UnixWare 7.1.4mp2

2005-02-03 Thread Larry Rosenman
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:

[HACKERS] Failed assertion on cluster

2005-02-06 Thread Larry Rosenman
TER INDEX public.vu_lhs_index OWNER TO ler; When I issue 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: 19

Re: [HACKERS] Failed assertion on cluster

2005-02-06 Thread Larry Rosenman
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 times

Re: [HACKERS] Failed assertion on cluster

2005-02-06 Thread Larry Rosenman
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 te

Re: [HACKERS] Re: Add support for

2000-10-19 Thread Larry Rosenman
on of the previous >definition > > > > I have never heard of before and am rather dubious that it > > Yes, I never heard of xti.h either. > > -- > Bruce Momjian| http://candle.pha.pa.us > [EMAIL PROTECTED] | (6

[HACKERS] UnixWare 7.1.1b FS

2000-10-20 Thread Larry Rosenman
? Attached is the configure output, gmake output for analysis by y'all... The configure invocation was: CXXFLAGS=-O ./configure --with-perl --with-CC=cc --with-CXX=CC --with-includes=/usr/local/include --with-libs=/usr/local/lib >ler.conf.out 2>&1 & -- Larry Rosenman

Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-21 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001021 03:42]: > Larry Rosenman writes: > > > Question: Why do we (for UnixWare) force i486 optimization? > > No particularly good reason, I suppose. We could remove it and leave it > up to the installer to choose the optimiza

Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-21 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001021 07:34]: > I will, in the next couple of days... Well, I pulled todays (2000/10/21) snapshot. I didn't get very far... 1) when I included -with-openssl, it didn't add /usr/local/ssl/lib to the -L options, so couldn't find lib

[HACKERS] quickie patch to UnixWare Template

2000-10-21 Thread Larry Rosenman
x27; DLSUFFIX=.so --- 1,8 AROPT=crs ! CFLAGS='-O -K host,inline,loop_unroll,alloca -Dsvr4' SHARED_LIB='-K PIC' SRCH_INC='/opt/include' SRCH_LIB='/opt/lib' DLSUFFIX=.so + CC=cc + CXX=CC -- Larry Rosenman http://www.le

[HACKERS] Style question

2000-10-21 Thread Larry Rosenman
have to remember to patch their sources? Larry -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

[HACKERS] UnixWare

2000-10-21 Thread Larry Rosenman
BTW, if someone wants shell/telnet/ssh access to this box, please let me know. I'm more than willing. It's a P-III 500 w/128MB ram and 18GB disk, so I can support stuff. Larry -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Intern

Re: [HACKERS] quickie patch to UnixWare Template

2000-10-21 Thread Larry Rosenman
; SHARED_LIB='-K PIC' > > SRCH_INC='/opt/include' > > SRCH_LIB='/opt/lib' > > DLSUFFIX=.so > > --- 1,8 > > AROPT=crs > > ! CFLAGS='-O -K host,inline,loop_unroll,alloca -Dsvr4' > > SHARED_LIB='-K

Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-21 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001021 11:45]: > Larry Rosenman writes: > > > 1) when I included -with-openssl, it didn't add /usr/local/ssl/lib to > > the -L options, so couldn't find libssl.a > > Confirmed. It's being put into a different

Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-21 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001021 12:02]: > I wrote: > > > Larry Rosenman writes: > > > > > 1) when I included -with-openssl, it didn't add /usr/local/ssl/lib to > > > the -L options, so couldn't find libssl.a > > > >

Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-21 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001021 12:04]: > * Peter Eisentraut <[EMAIL PROTECTED]> [001021 11:45]: > > > 2) I forced CC=cc and CXX=CC in src/templates/unixware and removed the > > > -K i486 option, and we still pass GCC options. This is *NOT* go

Re: [HACKERS] Style question

2000-10-21 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001021 11:54]: > Larry Rosenman writes: > > > We currently have a patch in the doc/FAQ_SCO file for the "accept > > doesn't send AF_UNIX to the caller" problem on SCO UnixWare 7.1.[01]. > > Is there any proble

Re: [HACKERS] Style question

2000-10-21 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001021 13:25]: > Larry Rosenman writes: > > > I was just thinking of checking uname -v and if it is 7.1.0 or 7.1.1 > > set a define that pq_comm.c sees and includes the fix. There isn't a > > good #define yet.. :

Re: [HACKERS] Last builtin OID?

2000-10-21 Thread Larry Rosenman
_ \ > Fax: (+61) 0500 83 82 82 | ___ | > Http://www.rhyme.com.au |/ \| > |---- > PGP key available upon request, | / > and from pgp5.ai.mit.edu:11371 |/ -- Larry

[HACKERS] AnonCVS access?

2000-10-22 Thread Larry Rosenman
Ok, I can't find it on the web site How do I check out the current tree? (I want to play with Peter_E's changes...) LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED] US Mail: 1905 Steamboat Spr

Re: [HACKERS] AnonCVS access?

2000-10-22 Thread Larry Rosenman
I couldn't find a link ANYWHERE on the site to this file. There are hints about it's existence, but it ain't linked obviously anywhere... Thanks! LER * Tom Lane <[EMAIL PROTECTED]> [001022 18:44]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > How do I che

[HACKERS] GCC: Works fine for me...

2000-10-22 Thread Larry Rosenman
Shared libpq works for me. I bet you were getting tripped up by some ENV vars I set globally... LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 PGP

[HACKERS] Re: Linking

2000-10-22 Thread Larry Rosenman
Ed > > > -- > > contaminated fish and microchips > huge supertankers on Arabian trips > oily propaganda from the leaders' lips > all about the future > there's people over here, people over there > everybody's looking for a li

[HACKERS] testing my connection to list.

2000-10-23 Thread Larry Rosenman
I posted some regression failures twice, and never saw them on the list or in the newsgroup. This is a test. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044

Re: [HACKERS] testing my connection to list.

2000-10-23 Thread Larry Rosenman
Ok, so why didn't my regression outputs post? Marc? LER * Larry Rosenman <[EMAIL PROTECTED]> [001023 04:32]: > > I posted some regression failures twice, and never saw them on the > list or in the newsgroup. This is a test. > -- > Larry Rosenman

[HACKERS] regress issues: UW7.1.1/PG7.1dev/GCC

2000-10-23 Thread Larry Rosenman
Here is some regression stuff. CVS as of about an hour or so ago (right after Tom answered my note...) === Notes... = postmaster must already be running for the regression tests to succeed. The time zone is set to PST8PDT for these test

Re: [HACKERS] testing my connection to list.

2000-10-23 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001023 09:15]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Ok, so why didn't my regression outputs post? > > Marc? > > How big were they? I think the default configuration for majordomo > is that posts over 50K or s

[HACKERS] UDK....

2000-10-23 Thread Larry Rosenman
One thing my testing gave SCO was the fact that cc needs to know about the -R option to ld. It will change before release to know that -R takes an argument. Just keep that in mind -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet

Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-23 Thread Larry Rosenman
OK, removing the second --with-CXX got us past configure, and gmake ran a long while, but MAXBUFSIZE didn't get defined such that fe-connect.c died: gmake -C doc all gmake[1]: Entering directory `/home/ler/pg-dev/pgsql-snap/doc' gmake[1]: Nothing to be done for `all'. gmake[1]: Leaving directory

[HACKERS] libpq needs -lsocket on UnixWare

2000-10-23 Thread Larry Rosenman
Is there any way to get libpq built with -lsocket on the unixware (and probably other SVR4's) to get the network stuff required ? (other SVR4's prolly need -lsocket -lnsl) Larry -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Intern

[HACKERS] looks like we forgot something...

2000-10-24 Thread Larry Rosenman
ory `/home/ler/pg-dev/pgsql/src/pl/plperl' gmake[3]: *** [all] Error 2 gmake[3]: Leaving directory `/home/ler/pg-dev/pgsql/src/pl/plperl' gmake[2]: *** [all] Error 2 gmake[2]: Leaving directory `/home/ler/pg-dev/pgsql/src/pl' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `

[HACKERS] --with-perl=/path/to/prefered/perl?

2000-10-25 Thread Larry Rosenman
Would it be possible to add a path spec to the --with-perl configure option so that if we have 2 or more PERL versions on the system we can pick which one to use? Larry -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED

Re: [HACKERS] looks like we forgot something...

2000-10-25 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001024 17:12]: Ok, looks like my failure was a system issue. None of the PERL libperl.so.*'s had a symlink as libperl.so. I fixed this. and we build and pass regression. BUT, we still probably need the option to pick a specific PERL so the u

Re: [HACKERS] --with-perl=/path/to/prefered/perl?

2000-10-25 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001025 13:20]: > > Oh, so it wouldn't be a search path but a specific executable name > (with or without full path info). OK, that makes sense to me. > I've had different perls installed with different executable names > myself. Bingo. Larry

Re: [HACKERS] --with-perl=/path/to/prefered/perl?

2000-10-25 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001025 11:10]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Would it be possible to add a path spec to the --with-perl configure > > option so that if we have 2 or more PERL versions on the system we can > > pick which one to us

[HACKERS] Re: libpq needs -lsocket on UnixWare

2000-10-25 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001025 11:21]: > Larry Rosenman writes: > > > Is there any way to get libpq built with -lsocket on the unixware (and > > probably other SVR4's) to get the network stuff required ? > > Try now. OpenSSL should be workin

[HACKERS] --enable-multibyte dies (UnixWare 7.1.1)/Current Sources

2000-10-26 Thread Larry Rosenman
tcop/SUBSYS.o UX:ld: ERROR: Symbol referencing errors. No output written to postgres gmake[2]: *** [postgres] Error 1 gmake[2]: Leaving directory `/home/ler/pg-dev/pgsql/src/backend' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/home/ler/pg-dev/pgsql/src' gmak

[HACKERS] more multibyte/After TGL...

2000-10-26 Thread Larry Rosenman
onnect.o] Error 1 gmake[3]: Leaving directory `/home/ler/pg-dev/pgsql/src/interfaces/libpq' gmake[2]: *** [all] Error 2 gmake[2]: Leaving directory `/home/ler/pg-dev/pgsql/src/interfaces' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/home/ler/pg-dev/pgsql/src' gmake: ***

Re: [HACKERS] Idea: cross-check versions during initdb

2000-10-26 Thread Larry Rosenman
y). initdb could look for this to ensure that PGLIB is pointing > to a compatible library directory. Alternatively, add version info as > a comment in the first line of global.bki. > > I don't have time to pursue this right now, but maybe someone else would > like to pick up on i

<    3   4   5   6   7   8   9   >