File: crossuser.out

package info (click to toggle)
pgextwlist 1.19-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 216 kB
  • sloc: ansic: 849; sql: 62; makefile: 40; sh: 6
file content (11 lines) | stat: -rw-r--r-- 448 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
 
GRANT USAGE, CREATE ON SCHEMA public TO public;
CREATE ROLE evil_user;
SET ROLE mere_mortal;
CREATE TABLE mere_table (t citext);
SET ROLE evil_user;
DROP EXTENSION citext;
ERROR:  cannot drop extension citext because other objects depend on it
DETAIL:  table mere_table column t depends on type citext
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
DROP EXTENSION citext CASCADE;
NOTICE:  drop cascades to table mere_table column t