What changed?

System Catalogs · PostgreSQL 7.4 → 8.0

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

1 added · 0 removed · 10 changed · 0 coverage changes. These are changes between the pinned reference snapshots.

--- 7.4
+++ 8.0
@@ -1,4 +1,5 @@
 amopclaid  oid
+amopsubtype  oid
 amopstrategy  int2
 amopreqcheck  bool
 amopopr  oid

changedpg_amproc

--- 7.4
+++ 8.0
@@ -1,3 +1,4 @@
 amopclaid  oid
+amprocsubtype  oid
 amprocnum  int2
 amproc  regproc

changedpg_attribute

--- 7.4
+++ 8.0
@@ -9,7 +9,6 @@
 atttypmod  int4
 attbyval  bool
 attstorage  char
-attisset  bool
 attalign  char
 attnotnull  bool
 atthasdef  bool

changedpg_class

--- 7.4
+++ 8.0
@@ -4,6 +4,7 @@
 relowner  int4
 relam  oid
 relfilenode  oid
+reltablespace  oid
 relpages  int4
 reltuples  float4
 reltoastrelid  oid

changedpg_database

--- 7.4
+++ 8.0
@@ -6,6 +6,6 @@
 datlastsysoid  oid
 datvacuumxid  xid
 datfrozenxid  xid
-datpath  text
+dattablespace  oid
 datconfig  text[]
 datacl  aclitem[]

changedpg_indexes

--- 7.4
+++ 8.0
@@ -1,4 +1,5 @@
 schemaname  name
 tablename  name
 indexname  name
+tablespace  name
 indexdef  text

changedpg_proc

--- 7.4
+++ 8.0
@@ -10,6 +10,7 @@
 pronargs  int2
 prorettype  oid
 proargtypes  oidvector
+proargnames  text[]
 prosrc  text
 probin  bytea
 proacl  aclitem[]

changedpg_settings

--- 7.4
+++ 8.0
@@ -1,5 +1,8 @@
 name  text
 setting  text
+category  text
+short_desc  text
+extra_desc  text
 context  text
 vartype  text
 source  text

changedpg_tables

--- 7.4
+++ 8.0
@@ -1,6 +1,7 @@
 schemaname  name
 tablename  name
 tableowner  name
+tablespace  name
 hasindexes  boolean
 hasrules  boolean
 hastriggers  boolean

addedpg_tablespace

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

changedpg_type

--- 7.4
+++ 8.0
@@ -12,6 +12,7 @@
 typoutput  regproc
 typreceive  regproc
 typsend  regproc
+typanalyze  regproc
 typalign  char
 typstorage  char
 typnotnull  bool