What changed?

System Catalogs · PostgreSQL 8.0 → 8.1

Historical documentation for a PostgreSQL version that is no longer supported.

7 added · 0 removed · 15 changed · 0 coverage changes. These are changes between the pinned reference snapshots.

--- 8.0
+++ 8.1
@@ -1,5 +1,6 @@
 aggfnoid  regproc
 aggtransfn  regproc
 aggfinalfn  regproc
+aggsortop  oid
 aggtranstype  oid
 agginitval  text

changedpg_am

--- 8.0
+++ 8.1
@@ -1,15 +1,16 @@
 amname  name
-amowner  int4
 amstrategies  int2
 amsupport  int2
 amorderstrategy  int2
 amcanunique  bool
 amcanmulticol  bool
+amoptionalkey  bool
 amindexnulls  bool
 amconcurrent  bool
-amgettuple  regproc
 aminsert  regproc
 ambeginscan  regproc
+amgettuple  regproc
+amgetmulti  regproc
 amrescan  regproc
 amendscan  regproc
 ammarkpos  regproc

addedpg_auth_members

--- 8.0
+++ 8.1
@@ -0,0 +1,4 @@
+roleid  oid
+member  oid
+grantor  oid
+admin_option  bool

addedpg_authid

--- 8.0
+++ 8.1
@@ -0,0 +1,11 @@
+rolname  name
+rolsuper  bool
+rolinherit  bool
+rolcreaterole  bool
+rolcreatedb  bool
+rolcatupdate  bool
+rolcanlogin  bool
+rolconnlimit  int4
+rolpassword  text
+rolvaliduntil  timestamptz
+rolconfig  text[]

addedpg_autovacuum

--- 8.0
+++ 8.1
@@ -0,0 +1,8 @@
+vacrelid  oid
+enabled  bool
+vac_base_thresh  integer
+vac_scale_factor  float4
+anl_base_thresh  integer
+anl_scale_factor  float4
+vac_cost_delay  integer
+vac_cost_limit  integer

changedpg_class

--- 8.0
+++ 8.1
@@ -1,7 +1,7 @@
 relname  name
 relnamespace  oid
 reltype  oid
-relowner  int4
+relowner  oid
 relam  oid
 relfilenode  oid
 reltablespace  oid

changedpg_conversion

--- 8.0
+++ 8.1
@@ -1,6 +1,6 @@
 conname  name
 connamespace  oid
-conowner  int4
+conowner  oid
 conforencoding  int4
 contoencoding  int4
 conproc  regproc

changedpg_database

--- 8.0
+++ 8.1
@@ -1,8 +1,9 @@
 datname  name
-datdba  int4
+datdba  oid
 encoding  int4
 datistemplate  bool
 datallowconn  bool
+datconnlimit  int4
 datlastsysoid  oid
 datvacuumxid  xid
 datfrozenxid  xid

changedpg_group

--- 8.0
+++ 8.1
@@ -1,3 +1,3 @@
 groname  name
-grosysid  int4
-grolist  int4[]
+grosysid  oid
+grolist  oid[]

changedpg_index

--- 8.0
+++ 8.1
@@ -1,10 +1,10 @@
 indexrelid  oid
 indrelid  oid
-indkey  int2vector
-indclass  oidvector
 indnatts  int2
 indisunique  bool
 indisprimary  bool
 indisclustered  bool
+indkey  int2vector
+indclass  oidvector
 indexprs  text
 indpred  text

changedpg_locks

--- 8.0
+++ 8.1
@@ -1,5 +1,12 @@
+locktype  text
+database  oid
 relation  oid
-database  oid
+page  integer
+tuple  smallint
+transactionid  xid
+classid  oid
+objid  oid
+objsubid  smallint
 transaction  xid
 pid  integer
 mode  text

changedpg_namespace

--- 8.0
+++ 8.1
@@ -1,3 +1,3 @@
 nspname  name
-nspowner  int4
+nspowner  oid
 nspacl  aclitem[]

changedpg_opclass

--- 8.0
+++ 8.1
@@ -1,7 +1,7 @@
 opcamid  oid
 opcname  name
 opcnamespace  oid
-opcowner  int4
+opcowner  oid
 opcintype  oid
 opcdefault  bool
 opckeytype  oid

changedpg_operator

--- 8.0
+++ 8.1
@@ -1,6 +1,6 @@
 oprname  name
 oprnamespace  oid
-oprowner  int4
+oprowner  oid
 oprkind  char
 oprcanhash  bool
 oprleft  oid

addedpg_pltemplate

--- 8.0
+++ 8.1
@@ -0,0 +1,6 @@
+tmplname  name
+tmpltrusted  boolean
+tmplhandler  text
+tmplvalidator  text
+tmpllibrary  text
+tmplacl  aclitem[]

addedpg_prepared_xacts

--- 8.0
+++ 8.1
@@ -0,0 +1,5 @@
+transaction  xid
+gid  text
+prepared  timestamp with time zone
+owner  name
+database  name

changedpg_proc

--- 8.0
+++ 8.1
@@ -1,6 +1,6 @@
 proname  name
 pronamespace  oid
-proowner  int4
+proowner  oid
 prolang  oid
 proisagg  bool
 prosecdef  bool
@@ -10,6 +10,8 @@
 pronargs  int2
 prorettype  oid
 proargtypes  oidvector
+proallargtypes  oid[]
+proargmodes  char[]
 proargnames  text[]
 prosrc  text
 probin  bytea

addedpg_roles

--- 8.0
+++ 8.1
@@ -0,0 +1,12 @@
+rolname  name
+rolsuper  bool
+rolinherit  bool
+rolcreaterole  bool
+rolcreatedb  bool
+rolcatupdate  bool
+rolcanlogin  bool
+rolconnlimit  int4
+rolpassword  text
+rolvaliduntil  timestamptz
+rolconfig  text[]
+oid  oid

changedpg_shadow

--- 8.0
+++ 8.1
@@ -1,5 +1,5 @@
 usename  name
-usesysid  int4
+usesysid  oid
 usecreatedb  bool
 usesuper  bool
 usecatupd  bool

addedpg_shdepend

--- 8.0
+++ 8.1
@@ -0,0 +1,6 @@
+dbid  oid
+classid  oid
+objid  oid
+refclassid  oid
+refobjid  oid
+deptype  char

changedpg_tablespace

--- 8.0
+++ 8.1
@@ -1,4 +1,4 @@
 spcname  name
-spcowner  int4
+spcowner  oid
 spclocation  text
 spcacl  aclitem[]

changedpg_type

--- 8.0
+++ 8.1
@@ -1,6 +1,6 @@
 typname  name
 typnamespace  oid
-typowner  int4
+typowner  oid
 typlen  int2
 typbyval  bool
 typtype  char