Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitc703b1e

Browse files
committed
Further fixes for the buildfarm for pg_audit
The database built by the buildfarm is specific to the extension, use\connect - instead.
1 parentdfb7624 commitc703b1e

File tree

2 files changed

+26
-26
lines changed

2 files changed

+26
-26
lines changed

‎contrib/pg_audit/expected/pg_audit.out

Lines changed: 13 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -17,7 +17,7 @@ create extension pg_audit;
1717
CREATE USER super SUPERUSER;
1818
ALTER ROLE super SET pg_audit.log = 'Role';
1919
ALTER ROLE super SET pg_audit.log_level = 'notice';
20-
\connectcontrib_regression super;
20+
\connect- super;
2121
--
2222
-- Create auditor role
2323
CREATE ROLE auditor;
@@ -32,7 +32,7 @@ ALTER ROLE user1 SET pg_audit.log_level = 'notice';
3232
NOTICE: AUDIT: SESSION,4,1,ROLE,ALTER ROLE,,,ALTER ROLE user1 SET pg_audit.log_level = 'notice';,<not logged>
3333
--
3434
-- Create, select, drop (select will not be audited)
35-
\connectcontrib_regression user1
35+
\connect- user1
3636
CREATE TABLE public.test (id INT);
3737
NOTICE: AUDIT: SESSION,1,1,DDL,CREATE TABLE,TABLE,public.test,CREATE TABLE public.test (id INT);,<not logged>
3838
SELECT * FROM test;
@@ -44,7 +44,7 @@ DROP TABLE test;
4444
NOTICE: AUDIT: SESSION,2,1,DDL,DROP TABLE,TABLE,public.test,DROP TABLE test;,<not logged>
4545
--
4646
-- Create second test user
47-
\connectcontrib_regression super
47+
\connect- super
4848
CREATE USER user2;
4949
NOTICE: AUDIT: SESSION,1,1,ROLE,CREATE ROLE,,,CREATE USER user2;,<not logged>
5050
ALTER ROLE user2 SET pg_audit.log = 'Read, writE';
@@ -57,7 +57,7 @@ ALTER ROLE user2 SET pg_audit.role = auditor;
5757
NOTICE: AUDIT: SESSION,5,1,ROLE,ALTER ROLE,,,ALTER ROLE user2 SET pg_audit.role = auditor;,<not logged>
5858
ALTER ROLE user2 SET pg_audit.log_statement_once = ON;
5959
NOTICE: AUDIT: SESSION,6,1,ROLE,ALTER ROLE,,,ALTER ROLE user2 SET pg_audit.log_statement_once = ON;,<not logged>
60-
\connectcontrib_regression user2
60+
\connect- user2
6161
CREATE TABLE test2 (id INT);
6262
GRANT SELECT ON TABLE public.test2 TO auditor;
6363
--
@@ -203,10 +203,10 @@ UPDATE test3
203203
WARNING: AUDIT: OBJECT,6,1,WRITE,INSERT,TABLE,public.test2,<previously logged>,<previously logged>
204204
--
205205
-- Change permissions of user 2 so that only object logging will be done
206-
\connectcontrib_regression super
206+
\connect- super
207207
alter role user2 set pg_audit.log = 'NONE';
208208
NOTICE: AUDIT: SESSION,1,1,ROLE,ALTER ROLE,,,alter role user2 set pg_audit.log = 'NONE';,<not logged>
209-
\connectcontrib_regression user2
209+
\connect- user2
210210
--
211211
-- Create test4 and add permissions
212212
CREATE TABLE test4
@@ -278,10 +278,10 @@ DROP TABLE test3;
278278
DROP TABLE test4;
279279
--
280280
-- Change permissions of user 1 so that session logging will be done
281-
\connectcontrib_regression super
281+
\connect- super
282282
alter role user1 set pg_audit.log = 'DDL, READ';
283283
NOTICE: AUDIT: SESSION,1,1,ROLE,ALTER ROLE,,,"alter role user1 set pg_audit.log = 'DDL, READ';",<not logged>
284-
\connectcontrib_regression user1
284+
\connect- user1
285285
--
286286
-- Create table is session logged
287287
CREATE TABLE public.account
@@ -314,12 +314,12 @@ INSERT INTO account (id, name, password, description)
314314
VALUES (1, 'user1', 'HASH1', 'blah, blah');
315315
--
316316
-- Change permissions of user 1 so that only object logging will be done
317-
\connectcontrib_regression super
317+
\connect- super
318318
alter role user1 set pg_audit.log = 'none';
319319
NOTICE: AUDIT: SESSION,1,1,ROLE,ALTER ROLE,,,alter role user1 set pg_audit.log = 'none';,<not logged>
320320
alter role user1 set pg_audit.role = 'auditor';
321321
NOTICE: AUDIT: SESSION,2,1,ROLE,ALTER ROLE,,,alter role user1 set pg_audit.role = 'auditor';,<not logged>
322-
\connectcontrib_regression user1
322+
\connect- user1
323323
--
324324
-- ROLE class not set, so auditor grants not logged
325325
GRANT SELECT (password),
@@ -361,12 +361,12 @@ NOTICE: AUDIT: OBJECT,2,1,WRITE,UPDATE,TABLE,public.account,"UPDATE account
361361
SET password = 'HASH2';",<not logged>
362362
--
363363
-- Change permissions of user 1 so that session relation logging will be done
364-
\connectcontrib_regression super
364+
\connect- super
365365
alter role user1 set pg_audit.log_relation = on;
366366
NOTICE: AUDIT: SESSION,1,1,ROLE,ALTER ROLE,,,alter role user1 set pg_audit.log_relation = on;,<not logged>
367367
alter role user1 set pg_audit.log = 'read, WRITE';
368368
NOTICE: AUDIT: SESSION,2,1,ROLE,ALTER ROLE,,,"alter role user1 set pg_audit.log = 'read, WRITE';",<not logged>
369-
\connectcontrib_regression user1
369+
\connect- user1
370370
--
371371
-- Not logged
372372
create table ACCOUNT_ROLE_MAP
@@ -460,7 +460,7 @@ NOTICE: AUDIT: SESSION,5,1,WRITE,UPDATE,TABLE,public.account,"UPDATE account
460460
SET password = 'HASH2';",<not logged>
461461
--
462462
-- Change back to superuser to do exhaustive tests
463-
\connectcontrib_regression super
463+
\connect- super
464464
SET pg_audit.log = 'ALL';
465465
NOTICE: AUDIT: SESSION,1,1,MISC,SET,,,SET pg_audit.log = 'ALL';,<not logged>
466466
SET pg_audit.log_level = 'notice';

‎contrib/pg_audit/sql/pg_audit.sql

Lines changed: 13 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,7 @@ create extension pg_audit;
1919
CREATEUSERsuper SUPERUSER;
2020
ALTER ROLE superSETpg_audit.log='Role';
2121
ALTER ROLE superSETpg_audit.log_level='notice';
22-
\connectcontrib_regression super;
22+
\connect- super;
2323

2424
--
2525
-- Create auditor role
@@ -33,14 +33,14 @@ ALTER ROLE user1 SET pg_audit.log_level = 'notice';
3333

3434
--
3535
-- Create, select, drop (select will not be audited)
36-
\connectcontrib_regression user1
36+
\connect- user1
3737
CREATETABLEpublic.test (idINT);
3838
SELECT*FROM test;
3939
DROPTABLE test;
4040

4141
--
4242
-- Create second test user
43-
\connectcontrib_regression super
43+
\connect- super
4444

4545
CREATEUSERuser2;
4646
ALTER ROLE user2SETpg_audit.log='Read, writE';
@@ -49,7 +49,7 @@ ALTER ROLE user2 SET pg_audit.log_level = 'warning';
4949
ALTER ROLE user2SETpg_audit.role= auditor;
5050
ALTER ROLE user2SETpg_audit.log_statement_once=ON;
5151

52-
\connectcontrib_regression user2
52+
\connect- user2
5353
CREATETABLEtest2 (idINT);
5454
GRANTSELECTON TABLEpublic.test2 TO auditor;
5555

@@ -148,10 +148,10 @@ UPDATE test3
148148

149149
--
150150
-- Change permissions of user 2 so that only object logging will be done
151-
\connectcontrib_regression super
151+
\connect- super
152152
alter role user2setpg_audit.log='NONE';
153153

154-
\connectcontrib_regression user2
154+
\connect- user2
155155

156156
--
157157
-- Create test4 and add permissions
@@ -221,9 +221,9 @@ DROP TABLE test4;
221221

222222
--
223223
-- Change permissions of user 1 so that session logging will be done
224-
\connectcontrib_regression super
224+
\connect- super
225225
alter role user1setpg_audit.log='DDL, READ';
226-
\connectcontrib_regression user1
226+
\connect- user1
227227

228228
--
229229
-- Create table is session logged
@@ -247,10 +247,10 @@ INSERT INTO account (id, name, password, description)
247247

248248
--
249249
-- Change permissions of user 1 so that only object logging will be done
250-
\connectcontrib_regression super
250+
\connect- super
251251
alter role user1setpg_audit.log='none';
252252
alter role user1setpg_audit.role='auditor';
253-
\connectcontrib_regression user1
253+
\connect- user1
254254

255255
--
256256
-- ROLE class not set, so auditor grants not logged
@@ -284,10 +284,10 @@ UPDATE account
284284

285285
--
286286
-- Change permissions of user 1 so that session relation logging will be done
287-
\connectcontrib_regression super
287+
\connect- super
288288
alter role user1setpg_audit.log_relation=on;
289289
alter role user1setpg_audit.log='read, WRITE';
290-
\connectcontrib_regression user1
290+
\connect- user1
291291

292292
--
293293
-- Not logged
@@ -344,7 +344,7 @@ UPDATE account
344344

345345
--
346346
-- Change back to superuser to do exhaustive tests
347-
\connectcontrib_regression super
347+
\connect- super
348348
SETpg_audit.log='ALL';
349349
SETpg_audit.log_level='notice';
350350
SETpg_audit.log_relation=ON;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp