Re: [HACKERS] 486 Optimizations...

2000-11-14 Thread Larry Rosenman
* Alfred Perlstein <[EMAIL PROTECTED]> [001114 15:47]: > * Trond Eivind Glomsrød <[EMAIL PROTECTED]> [001114 13:45] wrote: > > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > > > Anyone care if I build a patch to kill the -m486 type options in the >

Re: [HACKERS] 486 Optimizations...

2000-11-14 Thread Larry Rosenman
* Trond Eivind Glomsr?d <[EMAIL PROTECTED]> [001114 15:43]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > Anyone care if I build a patch to kill the -m486 type options in the > > following files: > > > > $ grep -i -- 486 * > > bsdi: i?86)

[HACKERS] 486 Optimizations...

2000-11-14 Thread Larry Rosenman
Anyone care if I build a patch to kill the -m486 type options in the following files: $ grep -i -- 486 * bsdi: i?86) CFLAGS="$CFLAGS -m486";; freebsd:CFLAGS='-O2 -m486 -pipe' univel:CFLAGS='-v -O -K i486,host,inline,loop_unroll -Dsvr4' $ pwd /home/ler/pg-dev/pg

Re: [HACKERS] Syslog Facility Patch

2000-11-14 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001114 14:44]: > * Peter Eisentraut <[EMAIL PROTECTED]> [001114 14:39]: > > Larry Rosenman writes: > > > > > * Peter Eisentraut <[EMAIL PROTECTED]> [001114 13:18]: > > > > Larry Rosenman write

[HACKERS] Re: Commit finished?

2000-11-14 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001114 15:16]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > * Tom Lane <[EMAIL PROTECTED]> [001114 15:07]: > >> Is your copy of gram.y up to date? > > > *$Header: > > */home/projects/pgsql/c

[HACKERS] Re: Commit finished?

2000-11-14 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001114 15:16]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > * Tom Lane <[EMAIL PROTECTED]> [001114 15:07]: > >> Is your copy of gram.y up to date? > > > *$Header: > > */home/projects/pgsql/c

[HACKERS] Re: Commit finished?

2000-11-14 Thread Larry Rosenman
Oct, 1994 lispy *code conve rsion * $ > > regards, tom lane -- 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] Commit finished?

2000-11-14 Thread Larry Rosenman
dev/src/backend/parser' gmake[2]: *** [parser-recursive] Error 2 gmake[2]: Leaving directory `/home/ler/pg-dev/src/backend' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/home/ler/pg-dev/src' gmake: *** [all] Error 2 $ Tom, Is the template0/1 stuff all

Re: [HACKERS] Syslog Facility Patch

2000-11-14 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001114 14:39]: > Larry Rosenman writes: > > > * Peter Eisentraut <[EMAIL PROTECTED]> [001114 13:18]: > > > Larry Rosenman writes: > > > > > > > > I can't reproduce that. I set 's

Re: [HACKERS] Syslog Facility Patch

2000-11-14 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001114 13:18]: > Larry Rosenman writes: > > > > I can't reproduce that. I set 'syslog_facility = local97' and got the > > > right error message. > > try setting it in postgresql.conf > > That

Re: [HACKERS] Syslog Facility Patch

2000-11-14 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001114 12:45]: > Larry Rosenman writes: > > > In looking at this some more, it appears that *SOMETHING* is not > > allowing messages from set_config_option() in > > /src/backend/utils/misc/guc.c out WHEN WE ARE DEALING WITH sy

Re: [HACKERS] Syslog Facility Patch

2000-11-14 Thread Larry Rosenman
t;", NULL}, #ifdef ENABLE_SYSLOG ! {"syslog_facility", PGC_POSTMASTER, &Syslog_facility, "LOCAL0", check_facility}, ! {"syslog_progid", PGC_POSTMASTER, &Syslog_progid, "postgres", N

Re: [HACKERS] Syslog Facility Patch

2000-11-14 Thread Larry Rosenman
quot; the SIGHUP? Although, it probably doesn't matter. I'll do a patch. I was just following the syslog lead. -- 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] Syslog Facility Patch

2000-11-13 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001113 17:43]: > Larry Rosenman writes: > > > Ok, You guys are probably tired of me, BUT, here is another one, that > > adds the facility to set the program name used in syslog. > > (this includes the other ones). >

Re: [HACKERS] Syslog Facility Patch

2000-11-13 Thread Larry Rosenman
backend to get the right error out. I'm not familiar enough with the backend startup to debug these wierdnesses(sp?). 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

[HACKERS] Re: [COMMITTERS] pgsql/src/backend/libpq (pqcomm.c)

2000-11-13 Thread Larry Rosenman
/pgsql/src/backend/libpq > > Modified Files: > pqcomm.c > > - Log Message - > > Fix for no hterror(). -- 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] Syslog Facility Patch

2000-11-13 Thread Larry Rosenman
* Bruce Momjian <[EMAIL PROTECTED]> [001113 15:36]: > Applied. > Thanks. FWIW, I had to pull the CVS copy of guc.c (my cvs update got two copies of my updates to the table). Comments on my postgresql.conf issues from the rest of the -hackers corp? Thanks! -- La

[HACKERS] FW: Returned mail: see transcript for details

2000-11-13 Thread Larry Rosenman
, November 13, 2000 @ 16:31:47 > Author: momjian > > Update of /home/projects/pgsql/cvsroot/pgsql/src/backend/libpq > from hub.org:/home/projects/pgsql/tmp/cvs-serv56413/pgsql/src/backend/libpq > > Modified Files: > pqcomm.c > > - Log Mes

Re: [HACKERS] Re: UUNET socket-file-location patch

2000-11-13 Thread Larry Rosenman
*** [postmaster.o] Error 1 > > Please revert this patch, so I can get some work done? > > regards, tom lane -- 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] Syslog Facility Patch

2000-11-13 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001112 19:20]: > Ok, You guys are probably tired of me, BUT, here is another one, that > adds the facility to set the program name used in syslog. > (this includes the other ones). > > One gotcha, the parser doesn't like spe

Re: [HACKERS] Syslog Facility Patch

2000-11-12 Thread Larry Rosenman
t;LOCAL3") == 0) return true; + if (strcasecmp(facility,"LOCAL4") == 0) return true; + if (strcasecmp(facility,"LOCAL5") == 0) return true; + if (strcasecmp(facility,"LOCAL6") == 0) return true; + if (strcasecmp(facility,"LOCAL7") == 0) return true; + return false; + } + #endif -- 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] Syslog Facility Patch

2000-11-12 Thread Larry Rosenman
asecmp(facility,"LOCAL2") == 0) return true; + if (strcasecmp(facility,"LOCAL3") == 0) return true; + if (strcasecmp(facility,"LOCAL4") == 0) return true; + if (strcasecmp(facility,"LOCAL5") == 0) return true; + if (strcasecmp(facility,&

Re: [HACKERS] Syslog Facility Patch

2000-11-12 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001112 15:41]: > * Larry Rosenman <[EMAIL PROTECTED]> [001112 14:02]: > > OK, I don't like it (it just says "syntax error"), but here is an > > improved version. I also switched to strcasecmp... > In looking at t

Re: [HACKERS] Syslog Facility Patch

2000-11-12 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001112 14:02]: > OK, I don't like it (it just says "syntax error"), but here is an > improved version. I also switched to strcasecmp... In looking at this some more, it appears that *SOMETHING* is not allowing messages from

Re: [HACKERS] Syslog Facility Patch

2000-11-12 Thread Larry Rosenman
lity,"LOCAL6") == 0) return true; + if (strcasecmp(facility,"LOCAL7") == 0) return true; + fprintf(stderr,"invalid syslog_facility %s\n",facility); + elog(FATAL,"invalid syslog_facility %s",facility); + return false; + } + #endif * Peter

[HACKERS] Syslog Facility Patch

2000-11-12 Thread Larry Rosenman
03,308 --- 304,312 {"unix_socket_group", PGC_POSTMASTER, &Unix_socket_group, "", NULL}, + #ifdef ENABLE_SYSLOG + {"syslog_facility", PGC_SIGHUP, &Syslog_facility, "LOCAL0", NULL}, + + #endif

[HACKERS] SYSLOG/LOG_LOCAL0

2000-11-12 Thread Larry Rosenman
Any reason to NOT make the facility used (Currently hardcoded to LOG_LOCAL0) settable at runtime? (or at least compile)? Larry -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive

[HACKERS] UW711/UDK FS

2000-11-11 Thread Larry Rosenman
FINALLY, the SCO UDK Feature Supplement is released. I know a couple of other people were waiting for it, so I figured I'd tell people it's out. Peter, The released version is now on lerami. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 97

[HACKERS] NEW Inet/Cidr

2000-11-10 Thread Larry Rosenman
Just a BIG *THANK YOU* to tom for making the inet/cidr stuff work as one would expect. 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] Horology failure on UW711/cc...

2000-11-10 Thread Larry Rosenman
== -- 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] Summary: what to do about INET/CIDR

2000-11-09 Thread Larry Rosenman
OPHICAL* objection to text() in this case? It's a TEXT output? LER > > regards, tom lane -- 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] Transaction ID wraparound: problem and proposed solution

2000-11-05 Thread Larry Rosenman
gt; > what operations do we need to be defined ? > > will >, <, ==, !=, >=, <== and ++ be enough ? > > - > Hannu -- 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] Transaction ID wraparound: problem and proposed solution

2000-11-05 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001105 12:07]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > >> Uh, we don't want to depend on gcc, do we? > > > Doesn't C99 *REQUIRE* long long? > > What difference does that make? It'll be a very long tim

Re: [HACKERS] Transaction ID wraparound: problem and proposed solution

2000-11-05 Thread Larry Rosenman
CO UDK Compiler has had it for a long time. I know it's early in C99's life, but... > > But we could make the XID a struct of two 4-byte integers, at the obvious > increase in storage size. What is the difference between a native long long and a struct of 2 long's? -- Larry

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

2000-11-05 Thread Larry Rosenman
s, as well as netmasks, etc. PostgreSQL is the perfect DB for the backend BECAUSE of the inet/cidr types. Yes, I could write convoluted PHP code to print out the stuff, but why should I when the DB has all the information in a nice compact form, and a SELECT statement could handle it? I do unders

Re: [HACKERS] regression failure...

2000-11-04 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001104 18:40]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Looks like someone changed an error message, but didn't upgrade the > > expected file... > > Yup. I just undid the error message change, because the new text d

[HACKERS] regression failure...

2000-11-04 Thread Larry Rosenman
RROR: columns in foreign key table of constraint not found. CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE(ptest2)); NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ERROR: UNIQUE constraint matching given keys fo

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

2000-11-03 Thread Larry Rosenman
But I don't see any value in that for > >netmasks.) > > > > 8. Because we still consider inet and cidr to be binary-equivalent types, > >all of these functions can be applied to either inet or cidr columns. > > > > Comments? > > > > regards, tom lane > > > > -- 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] Summary: what to do about INET/CIDR

2000-11-03 Thread Larry Rosenman
Works for me. 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

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

2000-11-03 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001028 02:23]: > 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 tonit

Re: [HACKERS] Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (Makefile README pg_dumpaccounts.sh)

2000-11-02 Thread Larry Rosenman
Most things you find > in contrib directories don't even work and you're worried about a testing > phase? Most folks don't even look in contrib directories unless they're > specifically looking for something. > > Vince. > -- >

[HACKERS] Re: CC not getting -O passed?

2000-10-30 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001030 10:53]: > Larry Rosenman writes: > > > BUT, we default C to -O, why not C++? > > Basically because we haven't done it yet. I'm not sure whether we're > going beta anytime soon, if not it'll probab

Re: [HACKERS] another try

2000-10-29 Thread Larry Rosenman
IRC Nick: Scrappy > Systems Administrator @ hub.org > primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org -- 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] regression failure/UnixWare7.1.1/current sources

2000-10-29 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001029 14:32]: > Larry Rosenman writes: > > > Would the timezone change last night be causing this? > > The "timestamp" failure, yes. The "geometry", no. Geometry simply needs > a new expected file, but

[HACKERS] Re: CC not getting -O passed?

2000-10-29 Thread Larry Rosenman
* Peter Eisentraut <[EMAIL PROTECTED]> [001029 14:58]: > Larry Rosenman writes: > > > CC doesn't see the -O flag. > > Why? > > Because C++ is not C. You can specify the flags manually with > CXXFLAGS=... BUT, we default C to -O, why not C++? &

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=

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] 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

[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

[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

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] 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-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

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
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
* 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
* 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
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
They still die today. I did some looking, but I'm not sure how to fix it. Apparently we need to have access 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]: > Today

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; > > $$ =

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

2000-10-27 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001027 20:45]: > Sigh ... I was really hoping not to get drawn into fixing these issues > for 7.1, but ... [SNIP] Works WELL for me. THANK YOU, Tom. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voi

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] 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
* 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
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
* Tom Lane <[EMAIL PROTECTED]> [001027 17:41]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Fine, but host() rejects CIDR types right now > > What's your point? network() doesn't behave the way you want right now, > either. Fine, network() can ret

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

2000-10-27 Thread Larry Rosenman
;),netmask('207.158.72.0/24') I get 207.158.72.0 207.158.72.255 255.255.255.0 as output. Aside from that, I'm not picky. Larry > > regards, tom lane -- 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] Summary: what to do about INET/CIDR

2000-10-27 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001027 17:29]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > I.E. for select network('207.158.72.0/24') > > I get > > 207.158.72.0 > > To my mind that should be done with host(), not network(). If you strip &

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

2000-10-27 Thread Larry Rosenman
I can't type today - Forwarded message from Larry Rosenman <[EMAIL PROTECTED]> ----- From: Larry Rosenman <[EMAIL PROTECTED]> Subject: Re: [HACKERS] Summary: what to do about INET/CIDR Date: Fri, 27 Oct 2000 15:09:36 -0500 Message-ID: <[EMAIL PROTECTED]> User-Agent

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

2000-10-27 Thread Larry Rosenman
aybe the answer for you is to use INET, rather > than to try to persuade us that you understand CIDR notation better than > Vixie does... What I need is a way to convince PG to print all 4 octets from a CIDR type. I *WANT* the safety of the CIDR type for blocks of addresses, but need to be ab

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

2000-10-27 Thread Larry Rosenman
* Alex Pilosov <[EMAIL PROTECTED]> [001027 14:43]: > On Fri, 27 Oct 2000, Larry Rosenman wrote: > > ler=# select * from ler_test; > > net | host > > ---+-- > > 207.158.72/24 | 207.158.72.11/24 > > (1 row) >

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

2000-10-27 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001027 09:49]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Also a way to get network (.0) and broadcast (all ones) for a cidr > > block out of our stuff. > > network() and broadcast() have been there all along ... OK, what I

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

2000-10-27 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001027 11:08]: > * Tom Lane <[EMAIL PROTECTED]> [001027 09:49]: > > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > Also a way to get network (.0) and broadcast (all ones) for a cidr > > > block out of our stuff.

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

2000-10-27 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001027 09:51]: > * Tom Lane <[EMAIL PROTECTED]> [001027 09:49]: > > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > Also a way to get network (.0) and broadcast (all ones) for a cidr > > > block out of our stuff.

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

2000-10-27 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001027 09:49]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Also a way to get network (.0) and broadcast (all ones) for a cidr > > block out of our stuff. > > network() and broadcast() have been there all along ... but d

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

2000-10-27 Thread Larry Rosenman
* Tatsuo Ishii <[EMAIL PROTECTED]> [001027 02:49]: > > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > Saw Tom's commits, now it breaks here: > > > cc -c -I/usr/local/include -I../../../src/include -DFRONTEND -I. >-DSYSCONFDIR='"/home/ler/pg-tes

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

2000-10-27 Thread Larry Rosenman
greed to it. Last chance to complain... I'd like to see a way to get all 4 octets of a CIDR printed out... Also a way to get network (.0) and broadcast (all ones) for a cidr block out of our stuff. Larry > > regards, tom lane -- Larry Rosenman

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

[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: ***

[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] 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

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

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] 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

[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

[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] 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

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] 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] 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] 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
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] 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

[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] 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

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] 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] 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

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] 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

<    3   4   5   6   7   8   9   >