Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?

2002-11-01 Thread Larry Rosenman
On Fri, 2002-11-01 at 10:43, Tom Lane wrote: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Is the following supposed to work? > > No. 7.3 psql uses schema syntax in its internal queries, so it will > fail to detect superuser status on pre-7.3 backends. Most backsla

Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?

2002-11-01 Thread Larry Rosenman
rt multiple versions was a suggestion Tom made a while > back, but nobody took up the challenge. Hmm. Ok. How about a cross-version/upgrade note somewhere? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mai

Re: [HACKERS] 7.3B3 psql talking to a 7.2.3 server?

2002-11-01 Thread Larry Rosenman
On Fri, 2002-11-01 at 21:54, Bruce Momjian wrote: > Rod Taylor wrote: > > On Fri, 2002-11-01 at 14:18, Larry Rosenman wrote: > > > On Fri, 2002-11-01 at 12:25, Rod Taylor wrote: > > > > > I know this, the question is, Should this happen? If not

Re: [HACKERS] v7.3Beta4 Tag'd and Packaged ...

2002-11-04 Thread Larry Rosenman
(heh) way to upgrade(change?) a checked out tree to be off the branch? -- 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 ---

Re: [HACKERS] PostgreSQL supported platform report and a patch.

2002-11-06 Thread Larry Rosenman
he additional library search paths to the rpath linker option.See Makefile.unixware for an example of how to do this. After applying these patches, PostgreSQL successfully compiled on OpenUnix 8 and it passed all the regression tests. -- Larry Rosenman, Sr. Network Engineer, Internet

Re: [HACKERS] PostgreSQL supported platform report and a patch.

2002-11-07 Thread Larry Rosenman
--On Thursday, November 07, 2002 01:17:55 -0500 "Billy G. Allie" <[EMAIL PROTECTED]> wrote: Larry Rosenman wrote: We already have success messages from Olivier Prenant for 7.3B4 on 8.0.0, and me for 7.1.3. I don't believe your changes are necessary. Was that us

Re: [HACKERS] PostgreSQL supported platform report and a patch.

2002-11-07 Thread Larry Rosenman
--On Thursday, November 07, 2002 02:42:47 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: Larry Rosenman <[EMAIL PROTECTED]> writes: I don't believe your changes are necessary. The static-inline change was obsoleted by a recent fix, per discussion. But the rpath changes seem po

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
ith-includes ans --with-libs on configure command. Not a problem here. (the change that is). Reagrds On Wed, 6 Nov 2002, Larry Rosenman wrote: Date: Wed, 06 Nov 2002 23:27:31 -0600 From: Larry Rosenman <[EMAIL PROTECTED]> To: Billy G. Allie <[EMAIL PROTECTED]>, [EMAIL PRO

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
--On Thursday, November 07, 2002 14:23:43 +0100 Olivier PRENANT <[EMAIL PROTECTED]> wrote: On Thu, 7 Nov 2002, Larry Rosenman wrote: Date: Thu, 07 Nov 2002 06:41:02 -0600 From: Larry Rosenman <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: Billy G. Allie <[EMAIL PROTECTED]>

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
--On Thursday, November 07, 2002 15:44:37 +0100 Olivier PRENANT <[EMAIL PROTECTED]> wrote: On Thu, 7 Nov 2002, Larry Rosenman wrote: Date: Thu, 07 Nov 2002 08:41:58 -0600 From: Larry Rosenman <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: Billy G. Allie <[EMAIL PROTECTED]>

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
It looks like you do **NOT** have B4 or B5 LER --On Thursday, November 07, 2002 17:00:21 +0100 Olivier PRENANT <[EMAIL PROTECTED]> wrote: On Thu, 7 Nov 2002, Tom Lane wrote: Date: Thu, 07 Nov 2002 10:21:25 -0500 From: Tom Lane <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: La

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
I've just relaunched my mirroring procedure and it did'nt pick another b4 or b5! What happens?? Regards, On Thu, 7 Nov 2002, Tom Lane wrote: Date: Thu, 07 Nov 2002 11:26:42 -0500 From: Tom Lane <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: Larry Rosenman <[EMAIL PROTECTED]>,

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
I don't mind having CFLAGS=-Xb though, done it for php already... By everyone says this should go off so.. Regards On Thu, 7 Nov 2002, Larry Rosenman wrote: Date: Thu, 07 Nov 2002 10:37:36 -0600 From: Larry Rosenman <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], Tom Lane <[EMAIL PRO

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
. LER --On Thursday, November 07, 2002 17:40:24 +0100 Olivier PRENANT <[EMAIL PROTECTED]> wrote: What's FS, it(s the 7.1.1b compiler yes. I don't mind having CFLAGS=-Xb though, done it for php already... By everyone says this should go off so.. Regards On Thu, 7 Nov 2002, Larr

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
--On Thursday, November 07, 2002 18:02:51 +0100 Olivier PRENANT <[EMAIL PROTECTED]> wrote: Haha!!! It passes (b4) on 800 and not on uw 711.. Larry, should I install 800 SDK on 711? Yes. On Thu, 7 Nov 2002, Larry Rosenman wrote: Date: Thu, 07 Nov 2002 10:45:13 -0600 From:

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
witch is NOT a secret dance. It's needed for LOTS of open source stuff. See the discussion from the Caldera folks last week. Tom's fix fixed the defaults for 7.1.2+ -- Peter Eisentraut [EMAIL PROTECTED] -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
For compilers earlier than the one released with OpenUNIX 8.0.0(UnixWare 7.1.2), Including the 7.1.1b Feature Supplement, you may need to specify -Xb in CFLAGS or the CC environment variable. --On Thursday, November 07, 2002 16:34:12 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: Larry Ro

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
ff for that file? ----- -- Larry Rosenman wrote: For compilers earlier than the one released with OpenUNIX 8.0.0(UnixWare 7.1.2), Including the 7.1.1b Feature Supplement, you may need to specify -Xb in CFLAGS or the CC environment variable. --On Thursday, November 07, 200

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-07 Thread Larry Rosenman
LIBRARY_PATH to '/usr/local/lib' (or add it to + LD_LIBRARY_PATH, if LD_LIBRARY_PATH already exists) before running config- + ure or the test for readline will fail. ----- -- Larry Rosenman wrote: With or withou Billie&

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-08 Thread Larry Rosenman
Here is diff. Please let me know if you need better wording. --On Thursday, November 07, 2002 16:50:26 -0600 Larry Rosenman <[EMAIL PROTECTED]> wrote: OK, I'll try and do up a diff to B5's tonite (probably late, my Daughter's elementary school honors choir has a perf

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-08 Thread Larry Rosenman
Do y'all want a new diff, or can you deal with it when you do the patch? LER --On Friday, November 08, 2002 09:45:44 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: Larry Rosenman <[EMAIL PROTECTED]> writes: +For compilers earlier than the one released with OpenUNIX 8.0.

[HACKERS] pg_atoi: zero length string

2002-11-24 Thread Larry Rosenman
terminate with semicolon to execute query \q to quit ler=# create table z_test(t int); CREATE TABLE ler=# insert into z_test(t) values(''); ERROR: pg_atoi: zero-length string ler=# \q $ This drive phpgroupware nuts... (their code needs help, but). LER -- Larry Rosenman

Re: [HACKERS] pg_atoi: zero length string

2002-11-24 Thread Larry Rosenman
needs help, but). It is in the release notes. I'm not sure why the behaviour was changed (other than it really is bad behaviour). Chris -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steambo

Re: [HACKERS] [GENERAL] 7.3 -> pg_atoi: zero-length string

2002-12-03 Thread Larry Rosenman
quare, Pennsylvania 19073 ---(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: 1905

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Larry Rosenman
ME calls. If you need more details, Ask. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-

Re: [HACKERS] Problems with 7.3.1

2002-12-27 Thread Larry Rosenman
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive

Re: [GENERAL] [HACKERS] v7.3.1 Bundled and Released ...

2003-01-04 Thread Larry Rosenman
version based on the TAG to checkout something (without pulling the whole tarball). LER Its not like tag'ng is hard to do ... ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send &qu

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-05 Thread Larry Rosenman
ZSB8oXoO3ycza4g6h5Hg= =19gB -END PGP SIGNATURE- ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archi

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-05 Thread Larry Rosenman
wrote: On Sun, 5 Jan 2003, Larry Rosenman wrote: --On Sunday, January 05, 2003 12:52:11 -0400 "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > Any volunteers to act as a tertiary? :) Sure, I have 2 NS's on my network with good upstream connectivity (UUNET, SPRINT,

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-05 Thread Larry Rosenman
--On Sunday, January 05, 2003 12:59:42 -0400 "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: On Sun, 5 Jan 2003, Larry Rosenman wrote: --On Sunday, January 05, 2003 12:52:11 -0400 "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > Any volunteers to act

Re: [HACKERS] IPv6 patch

2003-01-07 Thread Larry Rosenman
o at least 7.1.3). regards, tom lane ---(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 M

Re: [HACKERS] IPv6 patch

2003-01-07 Thread Larry Rosenman
--On Tuesday, January 07, 2003 12:07:05 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: Larry Rosenman <[EMAIL PROTECTED]> writes: Please make sure that you can handle the situation of a IPv6 API, but no IPv6 stack. (E.G. UnixWare up to at least 7.1.3). Certainly. But tha

Re: [HACKERS] IPv6 patch

2003-01-07 Thread Larry Rosenman
e machine has IPv6 addresses, or it doesn't. It is not our job to notify the DBA what the addresses on his machine are. In the UnixWare case, you can't even find out if there is an IPv6 address, and the API returns a wierd error, IIRC. regards, tom lane -- Larry Rosenman

Re: [HACKERS] IPv6 patch

2003-01-07 Thread Larry Rosenman
--On Tuesday, January 07, 2003 12:24:41 -0500 Bruce Momjian <[EMAIL PROTECTED]> wrote: Larry Rosenman wrote: --On Tuesday, January 07, 2003 12:20:31 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: >> We already do. The

Re: [GENERAL] [HACKERS] I feel the need for speed. What am I doing

2003-01-07 Thread Larry Rosenman
eren't updated. -- 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 5: Have

Re: [HACKERS] Request for qualified column names

2003-01-27 Thread Larry Rosenman
+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Larry Rosenman

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-01-30 Thread Larry Rosenman
her datapoint. LER regards, tom lane ---(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

Re: [HACKERS] Changing the default configuration (was Re:

2003-02-12 Thread Larry Rosenman
PROTECTED]:/usr/obj/usr/src/sys/LERLAPTOP i386 lerlaptop# Chris ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812

Re: [HACKERS] way to pass NEW into function

2001-07-10 Thread Larry Rosenman
What I did in a similar trigger was set a variable (of type RECORD) to NEW and then use that. (I actually used the appropriate fields, but record should... work) LER >> Original Message << On 7/10/01, 4:22:34 PM, Mike Cianflone <[EMAIL PROTECTED]> wrote rega

Re: [HACKERS] iconv?

2001-07-15 Thread Larry Rosenman
.646DE.e 88591.cpz unicode.sjis.so 852.88592.p 88591.646DE.p 88591.dk_pc unicode.utf.so 857.88599.b 88591.646DK.b 88591.roman8.dvt220.88591.b 857.88599.d 88591.646DK.d 88591.vt220.b vt220.88591.d 857.88599.e 88591.646DK.e 88591.vt220

Re: [HACKERS] 2 gig file size limit

2001-07-06 Thread Larry Rosenman
;t have to worry about it. LER > -- > Naomi Walker > Chief Information Officer > Eldorado Computing, Inc. > 602-604-3100 ext 242 > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] iconv?

2001-07-15 Thread Larry Rosenman
* Tatsuo Ishii <[EMAIL PROTECTED]> [010715 20:02]: > > Here is UnixWare: > [snip] > > Hum. I'm not sure what each file represents, but it looks like no > Asian language is supported except Japanese on UnixWare. May need to load something from the CD LER &

Re: OID wraparound (was Re: [HACKERS] pg_depend)

2001-07-18 Thread Larry Rosenman
Also, without OID's, how do you fix EXACT duplicate records that happen by accident? LER >> Original Message << On 7/18/01, 3:46:30 PM, Rod Taylor <[EMAIL PROTECTED]> wrote regarding Re: OID wraparound (was Re: [HACKERS] pg_depend) : > If OIDs are dropped a

Re: [HACKERS] NetBSD 1.5.1(HP300)

2001-07-16 Thread Larry Rosenman
Reported to NetBSD as pr BIN/13486 LER >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 7/16/01, 3:40:31 PM, Peter Eisentraut <[EMAIL PROTECTED]> wrote regarding Re: [H

[HACKERS] NetBSD 1.5.1(HP300)

2001-07-16 Thread Larry Rosenman
in testing CVS tip(sort of), I found that you need -lcurses with -ledit on NetBSD 1.5.1. _tputs in undefined otherwise. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive

Re: [HACKERS] Idea: recycle WAL segments, don't delete/recreate 'em

2001-07-18 Thread Larry Rosenman
Err PG_DUMP nightly on a 38,000,000+row table that takes forever to dump/unload, and gets updated every 5 minutes with 256KChar worth of updates? Give me a FAST pg_dump, and I'll think about it, until then, no LER (PS: this is also a reason for making a pg_upgrade work IN PLACE on a

Re: OID wraparound (was Re: [HACKERS] pg_depend)

2001-07-18 Thread Larry Rosenman
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 Me

Re: [HACKERS] NetBSD 1.5.1(HP300)

2001-07-16 Thread Larry Rosenman
t sure WHY configure doesn't add -lcurses, but it needs to. I can give you a shell account on this box (WARNING: it's slow, it's a 25 Mhz 68040) if you want. LER >>>>>>>>>>>>>>>>>> Original Message <<<<<<<

[HACKERS] (forw) Caldera OpenUNIX 8

2001-07-27 Thread Larry Rosenman
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 PROTECT

[HACKERS] config.guess on OpenUnix 8...

2001-07-27 Thread Larry Rosenman
I believe Caldera has submitted changes to the autoconf people to update config/config.guess to support OpenUNIX 8. Our current stuff BREAKS unless you use the SCOMPAT magic to look like a UnixWare 7.1.1 box. Who needs to pick up an update? Larry -- Larry Rosenman

[HACKERS] OU8...

2001-07-27 Thread Larry Rosenman
Skip the patch for configure.in in that last one, use this in it's place (I missed one sysv5uw). -- 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

[HACKERS] Re: Autoconf 2.50 is out (was Re: [PATCHES] Re: OpenUnix 8 Patch)

2001-07-30 Thread Larry Rosenman
ful. 150 Opening ASCII mode data connection for file list. -rw-r--r-- 1 ftp ftp 38214 Jul 30 14:00 config.guess -rw-r--r-- 1 ftp ftp 27872 Jul 30 14:00 config.sub 226-Transfer complete. 226 Quotas off ftp> Larry > > regards, tom lane

[HACKERS] Re: Autoconf 2.50 is out (was Re: [PATCHES] Re: OpenUnix 8 Patch)

2001-08-05 Thread Larry Rosenman
he patch I submitted was from the FTP site. Can you at least commit those? > > -- > Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]

[HACKERS] Makefile.PL for Pg.so

2001-08-12 Thread Larry Rosenman
PER::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

Re: [HACKERS] OID unsigned long long

2001-08-13 Thread Larry Rosenman
> The wire protocol... LER > > -- > 5-4-3-2-1 Thunderbirds are GO! > > http://www.mohawksoft.com > > ---(end of broadcast)------- > TIP 4: Don't 'kill -9' the postmaster > -- Larry Ro

[HACKERS] Re: [PATCHES] Makefile.PL for Pg.so

2001-08-14 Thread Larry Rosenman
* 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? >

[HACKERS] /bin/ld -G vs /usr/ccs/bin/cc -G

2001-08-24 Thread Larry Rosenman
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? Larry -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 97

[HACKERS] Re: /bin/ld -G vs /usr/ccs/bin/cc -G

2001-08-25 Thread Larry Rosenman
* 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. >

[HACKERS] Re: [PATCHES] Makefile.PL for Pg.so

2001-08-25 Thread Larry Rosenman
* 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

[HACKERS] Re: [PATCHES] Makefile.PL for Pg.so

2001-08-25 Thread Larry Rosenman
* 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

Re: [HACKERS] Re: [PATCHES] Makefile.PL for Pg.so

2001-08-26 Thread Larry Rosenman
-debug \ --with-tcl --with-tclconfig=/usr/local/lib \ --with-tkconfig=/usr/local/lib --enable-locale --with-python The above is my configure input. > > regards, tom lane -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-98

Re: [HACKERS] Re: [PATCHES] Makefile.PL for Pg.so

2001-08-26 Thread Larry Rosenman
ses. I ass/u/me that you tested it on lerami? 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

[HACKERS] pg_dump failure, can't get data out...

2001-08-26 Thread Larry Rosenman
]: [504] DEBUG: query: SELECT proname from pg_proc where pg_proc.oid = '-'::oid Aug 26 19:10:07 lerami pg-prod[3861]: [505] ERROR: oidin: error in "-": can't parse "-" Aug 26 19:10:07 lerami pg-prod[3861]: [506] DEBUG: AbortCurrentTransaction Aug 26 19:10:07 le

[HACKERS] Re: pg_dump failure, can't get data out...

2001-08-26 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [010826 19:25]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > I had upgraded yesterday and *THOUGHT* all was fine. > > Forgot to pg_dump, so I restored my $PGLIB and bin directory, now get > > the following when I try to pg_dump:

[HACKERS] Re: pg_dump failure, can't get data out...

2001-08-26 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [010826 19:39]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > pg_dump: query to get function name of oid - failed: ERROR: oidin: > > error in "-": can't parse "-" > > Actually, I'm seeing it here

Re: [HACKERS] pg_dump failure, can't get data out...

2001-08-26 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [010826 20:23]: > Larry Rosenman writes: > > > pg_dump: query to get function name of oid - failed: ERROR: oidin: > > error in "-": can't parse "-" > > It's trying to dump a functional index b

Re: [HACKERS] NetBSD 1.5.1(HP300)

2001-08-28 Thread Larry Rosenman
* 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?

Re: [HACKERS] Bytea/Base64 encoders for libpq - interested?

2001-09-04 Thread Larry Rosenman
scaping, though. > Better ideas anyone? Cooked vs raw? LER > > regards, tom lane > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere"

Re: [HACKERS] Beta Monday?

2001-09-06 Thread Larry Rosenman
-- > TIP 3: if posting/reading through 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

Re: [HACKERS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c win1251. ...

2001-09-06 Thread Larry Rosenman
8_to_alt.map utf8_to_koi8r.map > utf8_to_win1251.map > win1251_to_utf8.map > > Log message: > Add missing files. > > > ---(end of broadcast)--

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Larry Rosenman
ll, Pennsylvania 19026 > > > > > > ---(end of broadcast)--- > > > TIP 3: if posting/reading through Usenet, please send an appropriate > > > subscribe-nomail command to [EMAIL PROTECTED] so that your > > >

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Larry Rosenman
* Karel Zak <[EMAIL PROTECTED]> [010907 09:00]: > On Fri, Sep 07, 2001 at 07:31:50AM -0500, Larry Rosenman wrote: > > * Bruce Momjian <[EMAIL PROTECTED]> [010906 23:45]: > > > > > > > > > Oh, I see. Can you send an detailed email to hackers to Ta

Re: [HACKERS] Makefile.PL for Pg.so

2001-09-07 Thread Larry Rosenman
+ sub MY::dynamic_lib { > > + package MY; > > + my $inherited= shift->SUPER::dynamic_lib(@_); > > + if (! -d $ENV{POSTGRES_LIB} ) { > > +my $cwd = `pwd`; > > + chop $cwd; > > + $ENV{POSTGRES_LIB} = "$cwd/../libpq"; > >

Re: [PATCHES] [HACKERS] CURRENT CVS: MULTIBYTE: CANT CONNECT....

2001-09-08 Thread Larry Rosenman
gt; from the database. To fix this Larry's patch or you stat in the > previous mail are sufficient. I will commit the fix. I use password authentication, and that seems to be what tripped it. The applied patch works for me. Thanks, Gentlemen. LER > > > Forget it! A default cl

[HACKERS] CURRENT CVS: MULTIBYTE: CANT CONNECT....

2001-09-07 Thread Larry Rosenman
ith zero length at 0/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 Ste

Re: [HACKERS] CURRENT CVS: MULTIBYTE: CANT CONNECT....

2001-09-07 Thread Larry Rosenman
* 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

Re: [HACKERS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Larry Rosenman
enable-multibyte --enable-cassert \ > > --with-includes=/usr/local/include --with-libs=/usr/local/lib \ > > --enable-debug \ > > --with-tcl --with-tclconfig=/usr/local/lib \ > > --with-tkconfig=/usr/local/lib --enable-locale --with-python > >

Re: [HACKERS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Larry Rosenman
udes=/usr/local/include --with-libs=/usr/local/lib \ --enable-debug \ --with-tcl --with-tclconfig=/usr/local/lib \ --with-tkconfig=/usr/local/lib --enable-locale --with-python > > > ---(end of broadcast)--- > TIP 4:

[HACKERS] anoncvs and CVS link off developers.postgresql.org

2001-10-06 Thread Larry Rosenman
-- 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 'ki

Re: [HACKERS] anoncvs and CVS link off developers.postgresql.org

2001-10-06 Thread Larry Rosenman
* 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.po

Re: [HACKERS] [SQL] [ADMIN] Syslog

2002-03-14 Thread Larry Rosenman
4C34 3E1D 0C1C > > "Let your light so shine before men, that they may see > your good works, and glorify your Father which is in > heaven." Matthew 5:16 > > > ---(end of broadcast)--- > TI

Re: [HACKERS] Debugging symbols by default

2002-04-05 Thread Larry Rosenman
pped binaries around > elsewhere for debugging -- the possibilities are endless ;-) ) > > 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 C

Re: [HACKERS] Summary: what to do about INET/CIDR

2000-10-27 Thread Larry Rosenman
it simple/efficient. I don't think we need this ASAP for 7.1. Let's get the basic stuff working from a "least surprise" standpoint, and see what the user base comes up with. I really think your proposal from earlier tonite is the way to go, at least from my perspective.

Re: [HACKERS] Summary: what to do about INET/CIDR

2000-10-27 Thread Larry Rosenman
* Alex Pilosov <[EMAIL PROTECTED]> [001027 21:36]: > On Fri, 27 Oct 2000, Larry Rosenman wrote: > > > Not necessarily, especially for novices. Some people may want to > > store the netmask with the IP of a host (think ifconfig being > > AUTOGEN'd). >

Re: [HACKERS] Summary: what to do about INET/CIDR

2000-10-27 Thread Larry Rosenman
y but are pretty much > useless in reality. Yes, it is nice to be able to store a netmask with > every IP address, it is useless in reality. (Yes, please, someone tell me > if you are using inet with netmasks and you actually like it). > See above. > > I'

Re: [HACKERS] Summary: what to do about INET/CIDR

2000-10-27 Thread Larry Rosenman
need both, from the statements we get each time this has been brought up), such that you can freely move between the 4-octet and short-octet (for lack of a better term) version of a CIDR network spec. Thanks for any consideration, and if this could make 7.1, I'd be most appreciative... La

Re: [HACKERS] Gram.y patches for better parenthesis handling.

2000-10-28 Thread Larry Rosenman
SubLink *n = makeNode(SubLink); > > n->lefthand = $2; > > @@ -4154,7 +4223,7 @@ > > n->subselect = $7; > > $$ =

Re: [HACKERS] more multibyte/After TGL...

2000-10-28 Thread Larry Rosenman
to src/backend/utils/mb/common.c's > > object file for the psql build. Not sure how to get there... > > > > Larry > > * Larry Rosenman <[EMAIL PROTECTED]> [001027 07:26]: > > > Todays Sources still die: > > > > > > cc -c -I/usr/local/includ

Re: [HACKERS] more multibyte/After TGL...

2000-10-28 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001028 20:25]: > I have that version. I am, however, compiling with a NON-GCC > compiler. > Ok, just re-cvs'd, and still have the problem. Configure: CC=cc CXX=CC ./configure --prefix=/home/ler/pg-test --enable-syslog --with-CXX

Re: [HACKERS] more multibyte/After TGL...

2000-10-28 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001028 22:15]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Ok, just re-cvs'd, and still have the problem. > > I can't reproduce the problem either... > > pg_encoding_to_char is in common.c from backend/utils/mb

Re: [HACKERS] more multibyte/After TGL...

2000-10-28 Thread Larry Rosenman
ymbol in file pg_encoding_to_char command.o UX:ld: ERROR: Symbol referencing errors. No output written to psql $ unset LD_LIBRARY_PATH $ cc -O -K inline -o psql *.o -L ../../../src/interfaces/libpq -lpq -L /usr/l> $ * Larry Rosenman <[EMAIL PROTECTED]&

Re: [HACKERS] more multibyte/After TGL...

2000-10-28 Thread Larry Rosenman
LD_LIBRARY_PATH needs to go while building * Tom Lane <[EMAIL PROTECTED]> [001028 22:22]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > I did a gmake distclean before the reconfigure. There are multiple > > libpq's on the system. Would LD_LIBRARY_PATH

Re: [HACKERS] more multibyte/After TGL...

2000-10-28 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001028 22:28]: > LD_LIBRARY_PATH needs to go while building > It *IS* in the manpage at the very end. Now, how do we deal with this little bugaboo? LER > > * Tom Lane <[EMAIL PROTECTED]> [001028 22:22]: > > Larry Rosen

[HACKERS] initdb.sh fix...

2000-10-28 Thread Larry Rosenman
ION" ] then PGPATH=$self_path elif [ -x "$bindir/postgres" ]; then ! if [ x"`$bindir/postgres --version 2>/dev/null`" = x"postgres (PostgreSQL) $VERSION" ] then PGPATH=$bindir else -- 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

Re: [HACKERS] more multibyte/After TGL...

2000-10-29 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001029 05:48]: > Larry Rosenman writes: > > > YUP, it's LD_LIBRARY_PATH. > > That's odd. On my system (and on all others that I've heard of that have > it) this only affects the runtime linker, not the "ld&q

[HACKERS] regression failure/UnixWare7.1.1/current sources/multibyte.

2000-10-29 Thread Larry Rosenman
./expected/union.outThu Oct 5 14:11:39 2000 --- ./results/union.out Sun Oct 29 09:05:46 2000 *** *** 259,298 -- SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl; q2 ! -- ! 123 ! 4567890123456789 ! (2 rows) SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl; q2 ! -- ! 123 ! 4567890123456789 ! 4567890123456789 ! (3 rows) SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl; q2 ! --- ! -4567890123456789 456 ! (2 rows) SELECT q2 FROM int8_tbl EXCEPT ALL SELECT q1 FROM int8_tbl; q2 ! --- ! -4567890123456789 456 ! (2 rows) SELECT q2 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q1 FROM int8_tbl; q2 ! --- ! -4567890123456789 456 ! 4567890123456789 ! (3 rows) -- -- Mixed types --- 259,289 -- SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl; q2 ! ! (0 rows) SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl; q2 ! ! (0 rows) SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl; q2 ! - 456 ! (1 row) SELECT q2 FROM int8_tbl EXCEPT ALL SELECT q1 FROM int8_tbl; q2 ! - 456 ! (1 row) SELECT q2 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q1 FROM int8_tbl; q2 ! - 456 ! (1 row) -- -- Mixed types == *** ./expected/random.out Thu Jan 6 00:40:54 2000 --- ./results/random.outSun Oct 29 09:05:50 2000 *** *** 31,35 WHERE random NOT BETWEEN 80 AND 120; random ! (0 rows) --- 31,36 WHERE random NOT BETWEEN 80 AND 120; random ! 121 ! (1 row) == -- 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] CC not getting -O passed?

2000-10-29 Thread Larry Rosenman
o.3.1 pgconnection.o pgdatabase.o pgtransdb.o pgcursordb.o pglobject.o -L/usr/local/lib -L../../../src/interfaces/libpq -lpq -Wl,-R/home/ler/pg-test/lib Why? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED] US Mail: 1905 Stea

Re: [HACKERS] more multibyte/After TGL...

2000-10-29 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001029 10:47]: > Larry Rosenman writes: > > > So, at least for the UDK FS, we probably need to walk the > > LD_LIBRARY_PATH and cleanse it of any libraries that contain OUR libs. > > How do you know what your libs are? The

Re: [HACKERS] regression failure/UnixWare7.1.1/current sources

2000-10-29 Thread Larry Rosenman
Same sources, configured as: CC=cc CXX=CC ./configure --prefix=/home/ler/pg-test --enable-syslog \ --with-CXX --with-perl --with-includes=/usr/local/include \ --with-libs=/usr/local/lib only fails the following: *** ./expected/timestamp.outFri Sep 22 10:33:31 2000 --- ./res

Re: [HACKERS] regression failure/UnixWare7.1.1/current sources

2000-10-29 Thread Larry Rosenman
Would the timezone change last night be causing this? Larry * Larry Rosenman <[EMAIL PROTECTED]> [001029 12:55]: > Same sources, configured as: > > CC=cc CXX=CC ./configure --prefix=/home/ler/pg-test --enable-syslog \ > --with-CXX --with-perl --with-includes=

<    1   2   3   4   5   6   7   8   9   >