|
26 | 26 | # |
27 | 27 | # |
28 | 28 | # IDENTIFICATION |
29 | | -# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.54 1998/08/24 01:38:06 momjian Exp $ |
| 29 | +# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.55 1998/09/09 18:16:36 momjian Exp $ |
30 | 30 | # |
31 | 31 | #------------------------------------------------------------------------- |
32 | 32 |
|
@@ -425,41 +425,41 @@ echo "UPDATE pg_type SET typname = 'pg_user' WHERE typname = 'xpg_user';" |\ |
425 | 425 | postgres$PGSQL_OPT template1> /dev/null |
426 | 426 | mv$PGDATA/base/template1/xpg_user$PGDATA/base/template1/pg_user |
427 | 427 |
|
428 | | -echo"CREATE RULE _RETpg_user AS ON SELECT TO pg_user DO INSTEAD\ |
| 428 | +echo"CREATE RULE\"_RETpg_user\" AS ON SELECT TO pg_user DO INSTEAD\ |
429 | 429 | SELECT usename, usesysid, usecreatedb, usetrace,\ |
430 | 430 | usesuper, usecatupd, '********'::text as passwd,\ |
431 | 431 | valuntil FROM pg_shadow;"| \ |
432 | 432 | postgres$PGSQL_OPT template1> /dev/null |
433 | 433 | echo"REVOKE ALL on pg_shadow FROM public"| \ |
434 | 434 | postgres$PGSQL_OPT template1> /dev/null |
435 | 435 |
|
436 | | -echo"Creating viewpg_rule" |
437 | | -echo"CREATE TABLExpg_rule (\ |
| 436 | +echo"Creating viewpg_rules" |
| 437 | +echo"CREATE TABLExpg_rules (\ |
438 | 438 | rulenamename,\ |
439 | 439 | definitiontext);"| postgres$PGSQL_OPT template1> /dev/null |
440 | | -#move it intopg_rule |
441 | | -echo"UPDATE pg_class SET relname = 'pg_rule' WHERE relname = 'xpg_rule';"|\ |
| 440 | +#move it intopg_rules |
| 441 | +echo"UPDATE pg_class SET relname = 'pg_rules' WHERE relname = 'xpg_rules';"|\ |
442 | 442 | postgres$PGSQL_OPT template1> /dev/null |
443 | | -echo"UPDATE pg_type SET typname = 'pg_rule' WHERE typname = 'xpg_rule';"|\ |
| 443 | +echo"UPDATE pg_type SET typname = 'pg_rules' WHERE typname = 'xpg_rules';"|\ |
444 | 444 | postgres$PGSQL_OPT template1> /dev/null |
445 | | -mv$PGDATA/base/template1/xpg_rule$PGDATA/base/template1/pg_rule |
| 445 | +mv$PGDATA/base/template1/xpg_rules$PGDATA/base/template1/pg_rules |
446 | 446 |
|
447 | | -echo"CREATE RULE_RETpg_rule AS ON SELECT TOpg_rule DO INSTEAD\ |
| 447 | +echo"CREATE RULE\"_RETpg_rules\" AS ON SELECT TOpg_rules DO INSTEAD\ |
448 | 448 | SELECT rulename, pg_get_ruledef(rulename) AS definition\ |
449 | 449 | FROM pg_rewrite;"| postgres$PGSQL_OPT template1> /dev/null |
450 | 450 |
|
451 | | -echo"Creating viewpg_view" |
452 | | -echo"CREATE TABLExpg_view (\ |
| 451 | +echo"Creating viewpg_views" |
| 452 | +echo"CREATE TABLExpg_views (\ |
453 | 453 | viewnamename,\ |
454 | 454 | definitiontext);"| postgres$PGSQL_OPT template1> /dev/null |
455 | | -#move it intopg_view |
456 | | -echo"UPDATE pg_class SET relname = 'pg_view' WHERE relname = 'xpg_view';"|\ |
| 455 | +#move it intopg_views |
| 456 | +echo"UPDATE pg_class SET relname = 'pg_views' WHERE relname = 'xpg_views';"|\ |
457 | 457 | postgres$PGSQL_OPT template1> /dev/null |
458 | | -echo"UPDATE pg_type SET typname = 'pg_view' WHERE typname = 'xpg_view';"|\ |
| 458 | +echo"UPDATE pg_type SET typname = 'pg_views' WHERE typname = 'xpg_views';"|\ |
459 | 459 | postgres$PGSQL_OPT template1> /dev/null |
460 | | -mv$PGDATA/base/template1/xpg_view$PGDATA/base/template1/pg_view |
| 460 | +mv$PGDATA/base/template1/xpg_views$PGDATA/base/template1/pg_views |
461 | 461 |
|
462 | | -echo"CREATE RULE_RETpg_view AS ON SELECT TOpg_view DO INSTEAD\ |
| 462 | +echo"CREATE RULE\"_RETpg_views\" AS ON SELECT TOpg_views DO INSTEAD\ |
463 | 463 | SELECT relname AS viewname,\ |
464 | 464 | pg_get_viewdef(relname) AS definition\ |
465 | 465 | FROM pg_class WHERE relhasrules AND\ |
|