FilesExpand file tree

main

/

0018_unsupported_reg_types.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

43 lines (42 loc) · 1.45 KB

main

/

0018_unsupported_reg_types.sql

Copy path

Top

File metadata and controls

• Code
• Blame

43 lines (42 loc) · 1.45 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

create view lint."0018_unsupported_reg_types" AS

select

'unsupported_reg_types' as name,

'Unsupported reg types' as title,

'WARN' as level,

'EXTERNAL' as facing,

array['SECURITY'] as categories,

'Identifies columns using unsupported reg* types outside pg_catalog schema, which prevents database upgrades using pg_upgrade.' as description,

format(

'Table \`%s.%s\` has a column \`%s\` with unsupported reg* type \`%s\`.',

n.nspname,

c.relname,

a.attname,

t.typname

) as detail,

'https://supabase.com/docs/guides/database/database-linter?lint=unsupported_reg_types' as remediation,

jsonb_build_object(

'schema', n.nspname,

'name', c.relname,

'column', a.attname,

'type', 'table'

) as metadata,

format(

'unsupported_reg_types_%s_%s_%s',

n.nspname,

c.relname,

a.attname

) AS cache_key

from

pg_catalog.pg_attribute a

join pg_catalog.pg_class c

on a.attrelid = c.oid

join pg_catalog.pg_namespace n

on c.relnamespace = n.oid

join pg_catalog.pg_type t

on a.atttypid = t.oid

join pg_catalog.pg_namespace tn

on t.typnamespace = tn.oid

where

tn.nspname = 'pg_catalog'

and t.typname in ('regcollation', 'regconfig', 'regdictionary', 'regnamespace', 'regoper', 'regoperator', 'regproc', 'regprocedure')

and n.nspname not in ('pg_catalog', 'information_schema', 'pgsodium');