Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-21 Thread Peter Eisentraut
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 optimization level. CXXFLAGS=-O ./configure --with-perl --with-CC=cc --with-CXX=CC

Re: [HACKERS] Now 376175 lines of code

2000-10-21 Thread Gunnar R|nning
Bruce Momjian [EMAIL PROTECTED] writes: I just counted lines, not line content. Not sure which is more meaningful. Our comments are as important as the code, sometimes, though they do not add functionality to the application. I am not inclined to inflate numbers, but I am not sure the 59%

[HACKERS] Problem do backup/restore for empty database

2000-10-21 Thread Denis Perchine
Hello, I tried to do backup/restore of empty database. And get the following error: Connecting to database for restore Connecting to test4 as postgres Creating OPERATOR = Archiver(db): Could not execute query. Code = 7. Explanation from backend: 'ERROR: OperatorDef: operator "=" already

Re: [HACKERS] Problem do backup/restore for empty database

2000-10-21 Thread Denis Perchine
I tried to do backup/restore of empty database. And get the following error: Archiver(db): Could not execute query. Code = 7. Explanation from backend: 'ERROR: OperatorDef: operator "=" already defined '. Another funny thing is that dump of empty database occupies 657614 bytes. It is

Re: [HACKERS] Problem do backup/restore for empty database

2000-10-21 Thread Denis Perchine
BTW, also, if it is possible it is a good idea to remove the following warning if there are no BLOBs in the archive: Archiver: WARNING - skipping BLOB restoration -- Sincerely Yours, Denis Perchine -- E-Mail: [EMAIL PROTECTED] HomePage:

Re: [HACKERS] Problem do backup/restore for empty database

2000-10-21 Thread Philip Warner
At 22:33 21/10/00 +1000, Philip Warner wrote: OK. I just built with absolute latest CVS again, and pg_dump has started dumping the entire schema, including system tables, functions etc. Looks like the way it decides something is user-defined is now broken. Same is true for non-empty databases.

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-21 Thread Horst Herb
http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz(11k) First of all, thankd for tis contribution. I had impemented a similar thing for my own purposes. A problem I still have is using the digest for "checksumming" rows in my tables - which is a 'MUST' for medico-legal reasons in my

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 optimization level. CXXFLAGS=-O

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-21 Thread Marko Kreen
On Sat, Oct 21, 2000 at 11:27:54PM +1000, Horst Herb wrote: http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz(11k) First of all, thankd for tis contribution. I had impemented a similar thing for my own purposes. A problem I still have is using the digest for "checksumming" rows in

Re: [HACKERS] Last builtin OID?

2000-10-21 Thread Peter Eisentraut
Philip Warner writes: pg_dump uses the OID of template1 as the last builtin OID, but this now seems broken in CVS (it returns 1). Should this work? If not, what is the recommended way to find the last built-in OID? If you define the last builtin oid as the highest oid in existence after

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 libssl.a 2) I forced CC=cc

[HACKERS] quickie patch to UnixWare Template

2000-10-21 Thread Larry Rosenman
Per my ongoing discussion with PeterE, here is the patch I applied to src/template/unixware: cvs diff: Diffing . Index: unixware === RCS file: /cvsroot/pgsql-snap/src/template/unixware,v retrieving revision 1.1.1.1 diff -c -r1.1.1.1

Re: [HACKERS] quickie patch to UnixWare Template

2000-10-21 Thread Bruce Momjian
Applied. Thanks. Per my ongoing discussion with PeterE, here is the patch I applied to src/template/unixware: cvs diff: Diffing . Index: unixware === RCS file: /cvsroot/pgsql-snap/src/template/unixware,v retrieving

[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) Internet: [EMAIL

Re: [HACKERS] quickie patch to UnixWare Template

2000-10-21 Thread Larry Rosenman
That may be premature, it still doesn't build, but it's probably the right answer when we fix the rest of it. LER * Bruce Momjian [EMAIL PROTECTED] [001021 10:42]: Applied. Thanks. Per my ongoing discussion with PeterE, here is the patch I applied to src/template/unixware: cvs

Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-21 Thread Peter Eisentraut
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 variable. I'll see about fixing this. 2) I forced CC=cc and CXX=CC in src/templates/unixware and removed the

Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-21 Thread Peter Eisentraut
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 Confirmed. It's being put into a different variable. I'll see about fixing this. No, this is fine. It's in the LIBS variable, where it

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 variable. I'll see about fixing this. Cool.

Re: [HACKERS] UnixWare 7.1.1b FS

2000-10-21 Thread Bruce Momjian
DOne. * 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 variable. I'll see about fixing this.

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 Confirmed. It's being put into a different variable. I'll see about fixing

[HACKERS] failed runcheck

2000-10-21 Thread Patrick Welche
First a core dump which can be relieved by: Index: catalog.c === RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/catalog/catalog.c,v retrieving revision 1.34 diff -c -u -r1.34 catalog.c --- catalog.c 2000/10/16 14:52:02

Re: [HACKERS] Style question

2000-10-21 Thread Peter Eisentraut
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.. :-( We could use the result of checking host system type... i586-sco-sysv5uw7.1.1 But which one is the good

Re: [HACKERS] failed runcheck

2000-10-21 Thread Bruce Momjian
Applied First a core dump which can be relieved by: Index: catalog.c === RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/catalog/catalog.c,v retrieving revision 1.34 diff -c -u -r1.34 catalog.c --- catalog.c

Re: [HACKERS] Unable to access CVS server

2000-10-21 Thread Tom Lane
Hannu Krosing [EMAIL PROTECTED] writes: Kevin O'Gorman wrote: I've been unable to follow the directions in the Programmer's Guide for getting to the anonymous CVS server. I ran into the same problem a while ago. Both username and password in docs are WRONG IIRC, the username/password are

Re: [HACKERS] Last builtin OID?

2000-10-21 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Philip Warner writes: pg_dump uses the OID of template1 as the last builtin OID, but this now seems broken in CVS (it returns 1). Should this work? If not, what is the recommended way to find the last built-in OID? If you define the last builtin

Re: [HACKERS] Last builtin OID?

2000-10-21 Thread Philip Warner
At 21:40 21/10/00 -0400, Tom Lane wrote: We could implement this by initializing the OID counter at 16384 as now, and then rewriting it to 32768 at the end of initdb. ... BTW, this raises a point I'd never thought hard about: if the dbadmin adds some site-local objects to template1, then makes

Re: [HACKERS] Last builtin OID?

2000-10-21 Thread Tom Lane
Philip Warner [EMAIL PROTECTED] writes: ... I would prefer the 'CREATE DATABASE' code to set a value in a table somewhere to the last OID used when the DB was created. This would deal with the 'extended template1' scenario (which, incidentally, I am already a victim of). Could a new

Re: [HACKERS] failed runcheck

2000-10-21 Thread Tom Lane
Patrick Welche [EMAIL PROTECTED] writes: [ core dump due to ] #0 IsSystemRelationName (relname=0x0) at catalog.c:176 #1 0x807ed9a in IsSharedSystemRelationName (relname=0x0) at catalog.c:197 #2 0x80e9272 in RelationInitLockInfo (relation=0x82af018) at lmgr.c:119 #3 0x81202ef in formrdesc

Re: [HACKERS] failed runcheck

2000-10-21 Thread Bruce Momjian
Patrick Welche [EMAIL PROTECTED] writes: [ core dump due to ] #0 IsSystemRelationName (relname=0x0) at catalog.c:176 #1 0x807ed9a in IsSharedSystemRelationName (relname=0x0) at catalog.c:197 #2 0x80e9272 in RelationInitLockInfo (relation=0x82af018) at lmgr.c:119 #3 0x81202ef in