diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/rules.out | 20 | ||||
| -rw-r--r-- | src/test/regress/sql/rules.sql | 6 |
2 files changed, 15 insertions, 11 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index 6bc0c221010..ed6a1439851 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -944,14 +944,14 @@ QUERY: CREATE RULE log_shoelace AS ON UPDATE TO shoelace_data DO INSERT INTO shoelace_log VALUES ( NEW.sl_name, NEW.sl_avail, - getpgusername(), + 'Al Bundy', 'epoch'::text ); QUERY: UPDATE shoelace_data SET sl_avail = 6 WHERE sl_name = 'sl7'; QUERY: SELECT * FROM shoelace_log; -sl_name |sl_avail|log_who|log_when -----------+--------+-------+-------- -sl7 | 6|postgres|epoch +sl_name |sl_avail|log_who |log_when +----------+--------+--------+-------- +sl7 | 6|Al Bundy|epoch (1 row) QUERY: CREATE RULE shoelace_ins AS ON INSERT TO shoelace @@ -1019,12 +1019,12 @@ sl6 | 20|brown | 0.9|m | 90 (8 rows) QUERY: SELECT * FROM shoelace_log; -sl_name |sl_avail|log_who|log_when -----------+--------+-------+-------- -sl7 | 6|postgres|epoch -sl3 | 10|postgres|epoch -sl6 | 20|postgres|epoch -sl8 | 21|postgres|epoch +sl_name |sl_avail|log_who |log_when +----------+--------+--------+-------- +sl7 | 6|Al Bundy|epoch +sl3 | 10|Al Bundy|epoch +sl6 | 20|Al Bundy|epoch +sl8 | 21|Al Bundy|epoch (4 rows) QUERY: CREATE VIEW shoelace_obsolete AS diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql index 319a2066522..12fe2236f30 100644 --- a/src/test/regress/sql/rules.sql +++ b/src/test/regress/sql/rules.sql @@ -594,12 +594,16 @@ SELECT * FROM shoe_ready WHERE total_avail >= 2; log_when datetime -- when ); +-- Want "log_who" to be CURRENT_USER, +-- but that is non-portable for the regression test +-- - thomas 1999-02-21 + CREATE RULE log_shoelace AS ON UPDATE TO shoelace_data WHERE NEW.sl_avail != OLD.sl_avail DO INSERT INTO shoelace_log VALUES ( NEW.sl_name, NEW.sl_avail, - getpgusername(), + 'Al Bundy', 'epoch'::text ); |