RetroSearch Browse

Showing content from https://github.com/orgrim/pg_back/commit/e4aca9dcd8c51aed52bff587f9b483c824c363c0 below:

File tree Expand file treeCollapse file tree 1 file changed

-8

lines changed

Filter options

Expand file treeCollapse file tree 1 file changed

-8

lines changed Original file line number Diff line number Diff line change


 @@ -13,15 +13,16 @@ GRANT CONNECT ON DATABASE b2 TO u2;

13 13


 \c b1

14 14 15 15


 SET ROLE u1;

16

-
 CREATE TABLE t1 AS SELECT generate_series(0, 9) i;

17

-
 CREATE TABLE t2 AS SELECT generate_series(10, 19) j;

18

-
 CREATE TABLE t3 AS SELECT generate_series(0, 9) i;

19

-
 CREATE TABLE t4 AS SELECT generate_series(10, 19) j;

16

+
 CREATE TABLE IF NOT EXISTS t1 AS SELECT generate_series(0, 9) i;

17

+
 CREATE TABLE IF NOT EXISTS t2 AS SELECT generate_series(10, 19) j;

18

+
 CREATE TABLE IF NOT EXISTS t3 AS SELECT generate_series(0, 9) i;

19

+
 CREATE TABLE IF NOT EXISTS t4 AS SELECT generate_series(10, 19) j;

20 20 21 21


 \c b2

22 22 23

+
 GRANT CREATE,USAGE ON SCHEMA public TO u2;

23 24


 SET ROLE u2;

24

-
 CREATE TABLE t1 AS SELECT generate_series(0, 9) i;

25

-
 CREATE TABLE t2 AS SELECT generate_series(10, 19) j;

26

-
 CREATE TABLE t3 AS SELECT generate_series(0, 9) i;

27

-
 CREATE TABLE t4 AS SELECT generate_series(10, 19) j;

25

+
 CREATE TABLE IF NOT EXISTS t1 AS SELECT generate_series(0, 9) i;

26

+
 CREATE TABLE IF NOT EXISTS t2 AS SELECT generate_series(10, 19) j;

27

+
 CREATE TABLE IF NOT EXISTS t3 AS SELECT generate_series(0, 9) i;

28

+
 CREATE TABLE IF NOT EXISTS t4 AS SELECT generate_series(10, 19) j;

You can’t perform that action at this time.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4