Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id JAA11660 for postgres-redist; Fri, 2 Sep 1994 09:53:17 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199409021653.JAA11660@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from obelix.icce.rug.nl (root@obelix.icce.rug.nl [129.125.14.129]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id JAA11641 for ; Fri, 2 Sep 1994 09:53:15 -0700 Received: from basil.icce.rug.nl (uubasil@localhost) by obelix.icce.rug.nl (8.6.9/8.6.9) with UUCP id SAA02595 for postgres@postgres.berkeley.edu; Fri, 2 Sep 1994 18:18:12 +0200 Received: by basil.icce.rug.nl (NX5.67e/R&A-1.5(basil#5)) id AA00301; Fri, 2 Sep 94 17:44:01 +0200 Date: Fri, 2 Sep 94 17:44:01 +0200 From: tom@basil.icce.rug.nl (Tom R.Hageman) Message-Id: <9409021544.AA00301@basil.icce.rug.nl> Received: by NeXT.Mailer (1.100) Received: by NeXT Mailer (1.100) To: POSTGRES mailing list Subject: ACL patch (was: 4.2 regression test) Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Fri, 02 Sep 94 09:53:17 -0700 Resent-XMts: smtp aoki@CS.Berkeley.EDU (Paul M. Aoki) writes: > tom@basil.icce.rug.nl (Tom R.Hageman) writes: > > replace pg_class (relacl="{}") > > where pg_class.relname !~ "pg_*"::text > > As far as I understand it, this revokes all access privileges for all > > user-created classes. > > actually, the effect should be the same as setting it to NULL. look > at src/backend/tcop/aclchk.c .. Here is a patch that seems to solve my acl problem: (turns out to be due to an out-of-bounds array reference -- empty arrays don't have dimensions. Oh well...) =================================================================== RCS file: /usr/local/sources/CVS/postgres/src/backend/tmp/acl.h,v retrieving revision 1.1.1.3 diff -c -2 -r1.1.1.3 acl.h *** 1.1.1.3 1994/08/04 11:46:33 --- acl.h 1994/09/01 19:10:06 *************** *** 76,81 **** * always have a lower-bound of 0, this is the same as the number of * elements in the array. ! */ ! #define ARR_DIM0(a) (((unsigned *) (((char *) a) + sizeof(ArrayType)))[0]) /* --- 76,82 ---- * always have a lower-bound of 0, this is the same as the number of * elements in the array. ! * XXX [TRH 1-Sep-94] handle empty arrays correctly. */ ! #define ARR_DIM0(a) ((a)->ndim > 0 ? ((unsigned *) (((char *) a) + sizeof(ArrayType)))[0] : 0) /* -- __/__/__/__/ Tom Hageman [NeXTMail accepted] __/ __/_/ __/__/__/ "...to baldly go where no one has gone before." __/ _/_/ -- star trek TNG ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ==============================================================================