Re: Call for port reports

--On Saturday, October 25, 2003 22:29:04 +0200 Peter Eisentraut
<peter_e@gmx.net> wrote:

> Larry Rosenman writes:
>
>> *** ./expected/privileges.out    Thu Oct  9 20:49:31 2003
>> --- ./results/privileges.out    Sat Oct 25 12:04:45 2003
>> ***************
>> *** 247,253 ****
>>   (1 row)
>>
>>   CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE
>> sql; -- fail
>> - ERROR:  permission denied for language sql
>>   SET SESSION AUTHORIZATION regressuser3;
>>   SELECT testfunc1(5); -- fail
>>   ERROR:  permission denied for function testfunc1
>> --- 247,252 ----
>
> That sounds extremely strange.  Can you step through the privileges.sql
> file manually (psql single-step mode) and check what the contents of
> pg_language, pg_shadow, current_user, and session_user are before the
> misbehaving command?
>
> --
> Peter Eisentraut   peter_e@gmx.net

here ya go:
Script started on Sat Oct 25 16:34:24 2003
$ psql -s reg? ?? ?? ?-U p? ?ler regression
Welcome to psql 7.4beta5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms      \h for help with SQL commands      \? for help on internal slash commands
    \g or terminate with semicolon to execute query      \q to quit 

regression=# \i privileges.sql
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:5: ERROR:  user "regressuser1" already exists
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:6: ERROR:  user "regressuser2" already exists
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:7: ERROR:  user "regressuser3" already exists
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:8: ERROR:  user "regressuser4" already exists
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:9: ERROR:  user "regressuser4" already exists
***(Single step mode: verify
command)*******************************************
CREATE GROUP regressgroup1;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:11: ERROR:  group "regressgroup1" already exists
***(Single step mode: verify
command)*******************************************
CREATE GROUP regressgroup2 WITH USER regressuser1, regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:12: ERROR:  group "regressgroup2" already exists
***(Single step mode: verify
command)*******************************************
ALTER GROUP regressgroup1 ADD USER regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

ALTER GROUP
***(Single step mode: verify
command)*******************************************
ALTER GROUP regressgroup2 ADD USER regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

ALTER GROUP
***(Single step mode: verify
command)*******************************************
ALTER GROUP regressgroup2 DROP USER regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

ALTER GROUP
***(Single step mode: verify
command)*******************************************
ALTER GROUP regressgroup2 ADD USER regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

ALTER GROUP
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT session_user, current_user;
***(press return to proceed or enter x and return to
cancel)********************
session_user | current_user
--------------+--------------regressuser1 | regressuser1
(1 row)

***(Single step mode: verify
command)*******************************************
CREATE TABLE atest1 ( a int, b text );
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:26: ERROR:  relation "atest1" already exists
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************
a |  b
---+-----1 | two1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 VALUES (1, 'one');
***(press return to proceed or enter x and return to
cancel)********************

INSERT 2356104 1
***(Single step mode: verify
command)*******************************************
DELETE FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

DELETE 3
***(Single step mode: verify
command)*******************************************
UPDATE atest1 SET a = 1 WHERE b = 'blech';
***(press return to proceed or enter x and return to
cancel)********************

UPDATE 0
***(Single step mode: verify
command)*******************************************
LOCK atest1 IN ACCESS EXCLUSIVE MODE;
***(press return to proceed or enter x and return to
cancel)********************

LOCK TABLE
***(Single step mode: verify
command)*******************************************
REVOKE ALL ON atest1 FROM PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

REVOKE
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************
a | b
---+---
(0 rows)

***(Single step mode: verify
command)*******************************************
GRANT ALL ON atest1 TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atest1 TO regressuser3, regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************
a | b
---+---
(0 rows)

***(Single step mode: verify
command)*******************************************
CREATE TABLE atest2 (col1 varchar(10), col2 boolean);
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:40: ERROR:  relation "atest2" already exists
***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atest2 TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT UPDATE ON atest2 TO regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT INSERT ON atest2 TO regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT session_user, current_user;
***(press return to proceed or enter x and return to
cancel)********************
session_user | current_user
--------------+--------------regressuser2 | regressuser2
(1 row)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************
a | b
---+---
(0 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************
col1 | col2
------+------bar  | t
(1 row)

***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 VALUES (2, 'two');
***(press return to proceed or enter x and return to
cancel)********************

INSERT 2356105 1
***(Single step mode: verify
command)*******************************************
INSERT INTO atest2 VALUES ('foo', true);
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:54: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 SELECT 1, b FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

INSERT 2356106 1
***(Single step mode: verify
command)*******************************************
UPDATE atest1 SET a = 1 WHERE a = 2;
***(press return to proceed or enter x and return to
cancel)********************

UPDATE 1
***(Single step mode: verify
command)*******************************************
UPDATE atest2 SET col2 = NOT col2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:57: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1 FOR UPDATE;
***(press return to proceed or enter x and return to
cancel)********************
a |  b
---+-----1 | two1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2 FOR UPDATE;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:59: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
DELETE FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:60: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
LOCK atest2 IN ACCESS EXCLUSIVE MODE;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:61: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
COPY atest2 FROM stdin;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:62: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
GRANT ALL ON atest1 TO PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:63: ERROR:  permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1 WHERE ( b IN ( SELECT col1 FROM atest2 ) );
***(press return to proceed or enter x and return to
cancel)********************
a | b
---+---
(0 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2 WHERE ( col1 IN ( SELECT b FROM atest1 ) );
***(press return to proceed or enter x and return to
cancel)********************
col1 | col2
------+------
(0 rows)

***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT session_user, current_user;
***(press return to proceed or enter x and return to
cancel)********************
session_user | current_user
--------------+--------------regressuser3 | regressuser3
(1 row)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************
a |  b
---+-----1 | two1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:74: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 VALUES (2, 'two');
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:75: ERROR:  permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
INSERT INTO atest2 VALUES ('foo', true);
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:76: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 SELECT 1, b FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:77: ERROR:  permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
UPDATE atest1 SET a = 1 WHERE a = 2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:78: ERROR:  permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
UPDATE atest2 SET col2 = NULL;
***(press return to proceed or enter x and return to
cancel)********************

UPDATE 1
***(Single step mode: verify
command)*******************************************
UPDATE atest2 SET col2 = NOT col2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:80: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
UPDATE atest2 SET col2 = true WHERE atest1.a = 5;
***(press return to proceed or enter x and return to
cancel)********************

UPDATE 0
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1 FOR UPDATE;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:82: ERROR:  permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2 FOR UPDATE;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:83: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
DELETE FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:84: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
LOCK atest2 IN ACCESS EXCLUSIVE MODE;
***(press return to proceed or enter x and return to
cancel)********************

LOCK TABLE
***(Single step mode: verify
command)*******************************************
COPY atest2 FROM stdin;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:86: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1 WHERE ( b IN ( SELECT col1 FROM atest2 ) );
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:89: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2 WHERE ( col1 IN ( SELECT b FROM atest1 ) );
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:90: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
COPY atest2 FROM stdin;
***(press return to proceed or enter x and return to
cancel)********************

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************
a |  b
---+-----1 | two1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
CREATE TABLE atest3 (one int, two int, three int);
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:102: ERROR:  relation "atest3" already exists
***(Single step mode: verify
command)*******************************************
GRANT DELETE ON atest3 TO GROUP regressgroup2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:107: ERROR:  permission denied for relation atest3
***(Single step mode: verify
command)*******************************************
DELETE FROM atest3;
***(press return to proceed or enter x and return to
cancel)********************

DELETE 0
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
CREATE VIEW atestv1 AS SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:115: ERROR:  relation "atestv1" already exists
***(Single step mode: verify
command)*******************************************
/* The next *should* fail, but it's not implemented that way yet. */
CREATE VIEW atestv2 AS SELECT * FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:117: ERROR:  relation "atestv2" already exists
***(Single step mode: verify
command)*******************************************
CREATE VIEW atestv3 AS SELECT * FROM atest3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:118: ERROR:  relation "atestv3" already exists
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv1;
***(press return to proceed or enter x and return to
cancel)********************
a |  b
---+-----1 | two1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:121: ERROR:  permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atestv1, atestv3 TO regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atestv2 TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv1;
***(press return to proceed or enter x and return to
cancel)********************
a |  b
---+-----1 | two1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:128: ERROR:  permission denied for relation atestv2
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv3;
***(press return to proceed or enter x and return to
cancel)********************
one | two | three
-----+-----+-------
(0 rows)

***(Single step mode: verify
command)*******************************************
CREATE VIEW atestv4 AS SELECT * FROM atestv3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:131: ERROR:  relation "atestv4" already exists
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv4;
***(press return to proceed or enter x and return to
cancel)********************
one | two | three
-----+-----+-------
(0 rows)

***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atestv4 TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:139: ERROR:  permission denied for relation atestv3
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv4;
***(press return to proceed or enter x and return to
cancel)********************
one | two | three
-----+-----+-------
(0 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************
col1 | col2
------+------bar  |bar  | t
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:143: ERROR:  permission denied for relation atest2
You are now connected to database "regression".
***(Single step mode: verify
command)*******************************************
REVOKE ALL PRIVILEGES ON LANGUAGE sql FROM PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

REVOKE
***(Single step mode: verify
command)*******************************************
GRANT USAGE ON LANGUAGE sql TO regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT USAGE ON LANGUAGE c TO PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:153: ERROR:  language "c" is not trusted
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
GRANT USAGE ON LANGUAGE sql TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:156: ERROR:  permission denied for language sql
***(Single step mode: verify
command)*******************************************
CREATE FUNCTION testfunc1(int) RETURNS int AS 'select 2 * $1;' LANGUAGE sql;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:157: ERROR:  function "testfunc1" already exists with
same argument types
***(Single step mode: verify
command)*******************************************
CREATE FUNCTION testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:158: ERROR:  function "testfunc2" already exists with
same argument types
***(Single step mode: verify
command)*******************************************
REVOKE ALL ON FUNCTION testfunc1(int), testfunc2(int) FROM PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

REVOKE
***(Single step mode: verify
command)*******************************************
GRANT EXECUTE ON FUNCTION testfunc1(int), testfunc2(int) TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT USAGE ON FUNCTION testfunc1(int) TO regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:162: ERROR:  invalid privilege type USAGE for function
***(Single step mode: verify
command)*******************************************
GRANT ALL PRIVILEGES ON FUNCTION testfunc1(int) TO regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT ALL PRIVILEGES ON FUNCTION testfunc_nosuch(int) TO regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:164: ERROR:  function testfunc_nosuch(integer) does not
exist
***(Single step mode: verify
command)*******************************************
CREATE FUNCTION testfunc4(boolean) RETURNS text AS 'select col1 from atest2 where col2 = $1;' LANGUAGE sql SECURITY
DEFINER;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:168: ERROR:  function "testfunc4" already exists with
same argument types
***(Single step mode: verify
command)*******************************************
GRANT EXECUTE ON FUNCTION testfunc4(boolean) TO regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT testfunc1(5), testfunc2(5);
***(press return to proceed or enter x and return to
cancel)********************
testfunc1 | testfunc2
-----------+-----------       10 |        15
(1 row)

***(Single step mode: verify
command)*******************************************
CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE sql;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:173: ERROR:  function "testfunc3" already exists with
same argument types
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser3;
***(press return to proceed or enter x and return to
cancel)********************
x
***(Single step mode: verify
command)*******************************************
SELECT testfunc1(5);
***(press return to proceed or enter x and return to
cancel)********************
regression=> select? ?? ?? ?? ?? ?? ????\?~d? ?? ?d? ?c regression ler
You are now connected to database "regression" as user "ler".
regression=# select * from pg_language;
***(Single step mode: verify
command)*******************************************
select * from pg_language;
***(press return to proceed or enter x and return to
cancel)********************
lanname  | lanispl | lanpltrusted | lanplcallfoid | lanvalidator |
lanacl
----------+---------+--------------+---------------+--------------+--------
--------------------------internal | f       | f            |             0 |         2246 |c        | f       | f
     |             0 |         2247 |plpgsql  | t       | t            |       2218642 |            0 |sql      | f
 | t            |             0 |         2248 |  
{=U/postgres,regressuser1=U/ler}
(4 rows)

regression=# select * from pg_shadow;
***(Single step mode: verify
command)*******************************************
select * from pg_shadow;
***(press return to proceed or enter x and return to
cancel)********************
  usename    | usesysid | usecreatedb | usesuper | usecatupd |
passwd                | valuntil | useconfig
--------------+----------+-------------+----------+-----------+------------
-------------------------+----------+-----------horde        |      407 | t           | f        | f         |
md5789761213b76339cb1da715d0c51d888 |          |ler          |      101 | t           | t        | t         |
md5dc936a84fbec3cdca4209c15f1ce424d |          |mrm          |      401 | t           | f        | f         |
md59a6f9a2291c2b99dfa7794167f6f90e5 |          |cph          |      151 | t           | f        | f         |
md56f213a50183cb0b5b503391c96061751 |          |nobody       |      403 | f           | f        | f         |
md5eaa50fc990ef9147accb04fd39c69263 |          |ed           |      402 | t           | f        | f         |
md56d10f55bec241097be543d50441902a4 |          |webmail      |      404 | t           | f        | f         |
md5939853e11c511400d5709c547287a8a9 |          |tipnet       |      405 | t           | f        | f         |
md5ceba6024d54ca3d68647dae1cd58222a |          |nagios       |      408 | f           | f        | f         |
md5d36bbc9979deee7cca850e582b9a8e18 |          |webcal       |      409 | f           | f        | f         |
md5e736e686ce964baaa81ec18583f06921 |          |bric         |      413 | f           | f        | f         |
md55a71606fd33d3e92229ce73ad6c3f408 |          |ohp          |      410 | t           | f        | f         |
md59276c229c3c21fdc944a7532db499a01 |          |root         |      411 | t           | t        | t         |
md5a54504778e2f7c06d13e420bca278b16 |          |rt_user      |      412 | f           | f        | f         |
md5e5ffbd5626278386cfa50d801ce24517 |          |regressuser1 |      414 | f           | f        | f         |
|          |postgres     |        1 | t           | t        | t         |
md51a4c61baf99fb9be1b8763c70f4304e7 |          |regressuser2 |      415 | f           | f        | f         |
|          |regressuser3 |      416 | f           | f        | f         |
|          |regressuser4 |      417 | f           | f        | f         |
|          |
(19 rows)

regression=# select *? ?current_user session_user;???????????????[1@,
***(Single step mode: verify
command)*******************************************
select current_user, session_user;
***(press return to proceed or enter x and return to
cancel)********************
current_user | session_user
--------------+--------------ler          | ler
(1 row)

regression=# \q
$

script done on Sat Oct 25 16:36:56 2003




--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749