rel.h 13.4 KB
Newer Older
1 2
/*-------------------------------------------------------------------------
 *
3
 * rel.h
4
 *	  POSTGRES relation descriptor (a/k/a relcache entry) definitions.
5 6
 *
 *
B
Bruce Momjian 已提交
7
 * Portions Copyright (c) 1996-2011, PostgreSQL Global Development Group
B
Add:  
Bruce Momjian 已提交
8
 * Portions Copyright (c) 1994, Regents of the University of California
9
 *
10
 * src/include/utils/rel.h
11 12 13
 *
 *-------------------------------------------------------------------------
 */
14
#ifndef REL_H
15 16
#define REL_H

17
#include "access/tupdesc.h"
B
Bruce Momjian 已提交
18 19
#include "catalog/pg_am.h"
#include "catalog/pg_class.h"
20
#include "catalog/pg_index.h"
21
#include "fmgr.h"
22
#include "nodes/bitmapset.h"
23
#include "rewrite/prs2lock.h"
24 25
#include "storage/block.h"
#include "storage/relfilenode.h"
26
#include "utils/relcache.h"
27

28

29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
/*
 * LockRelId and LockInfo really belong to lmgr.h, but it's more convenient
 * to declare them here so we can have a LockInfoData field in a Relation.
 */

typedef struct LockRelId
{
	Oid			relId;			/* a relation identifier */
	Oid			dbId;			/* a database identifier */
} LockRelId;

typedef struct LockInfoData
{
	LockRelId	lockRelId;
} LockInfoData;

typedef LockInfoData *LockInfo;

47 48 49 50
/*
 * Likewise, this struct really belongs to trigger.h, but for convenience
 * we put it here.
 */
51 52
typedef struct Trigger
{
53 54
	Oid			tgoid;			/* OID of trigger (pg_trigger row) */
	/* Remaining fields are copied from pg_trigger, see pg_trigger.h */
55 56 57
	char	   *tgname;
	Oid			tgfoid;
	int16		tgtype;
58
	char		tgenabled;
59
	bool		tgisinternal;
60
	Oid			tgconstrrelid;
61
	Oid			tgconstrindid;
62
	Oid			tgconstraint;
63 64
	bool		tgdeferrable;
	bool		tginitdeferred;
65
	int16		tgnargs;
66 67
	int16		tgnattr;
	int16	   *tgattr;
68
	char	  **tgargs;
69
	char	   *tgqual;
70
} Trigger;
71 72 73

typedef struct TriggerDesc
{
T
Tom Lane 已提交
74 75 76
	Trigger    *triggers;		/* array of Trigger structs */
	int			numtriggers;	/* number of array entries */

77
	/*
T
Tom Lane 已提交
78 79
	 * These flags indicate whether the array contains at least one of each
	 * type of trigger.  We use these to skip searching the array if not.
80
	 */
T
Tom Lane 已提交
81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98
	bool		trig_insert_before_row;
	bool		trig_insert_after_row;
	bool		trig_insert_instead_row;
	bool		trig_insert_before_statement;
	bool		trig_insert_after_statement;
	bool		trig_update_before_row;
	bool		trig_update_after_row;
	bool		trig_update_instead_row;
	bool		trig_update_before_statement;
	bool		trig_update_after_statement;
	bool		trig_delete_before_row;
	bool		trig_delete_after_row;
	bool		trig_delete_instead_row;
	bool		trig_delete_before_statement;
	bool		trig_delete_after_statement;
	/* there are no row-level truncate triggers */
	bool		trig_truncate_before_statement;
	bool		trig_truncate_after_statement;
99
} TriggerDesc;
100

101

102 103 104 105 106 107 108 109 110
/*
 * Cached lookup information for the index access method functions defined
 * by the pg_am row associated with an index relation.
 */
typedef struct RelationAmInfo
{
	FmgrInfo	aminsert;
	FmgrInfo	ambeginscan;
	FmgrInfo	amgettuple;
111
	FmgrInfo	amgetbitmap;
112 113 114 115 116
	FmgrInfo	amrescan;
	FmgrInfo	amendscan;
	FmgrInfo	ammarkpos;
	FmgrInfo	amrestrpos;
	FmgrInfo	ambuild;
R
Robert Haas 已提交
117
	FmgrInfo	ambuildempty;
118 119 120
	FmgrInfo	ambulkdelete;
	FmgrInfo	amvacuumcleanup;
	FmgrInfo	amcostestimate;
121
	FmgrInfo	amoptions;
122 123 124
} RelationAmInfo;


125 126 127
/*
 * Here are the contents of a relation cache entry.
 */
128

129 130
typedef struct RelationData
{
131 132
	RelFileNode rd_node;		/* relation physical identifier */
	/* use "struct" here to avoid needing to include smgr.h: */
B
Bruce Momjian 已提交
133
	struct SMgrRelationData *rd_smgr;	/* cached file handle, or NULL */
134
	int			rd_refcnt;		/* reference count */
135
	BackendId	rd_backend;		/* owning backend id, if temporary relation */
136 137
	bool		rd_isnailed;	/* rel is nailed in cache */
	bool		rd_isvalid;		/* relcache entry is valid */
B
Bruce Momjian 已提交
138 139
	char		rd_indexvalid;	/* state of rd_indexlist: 0 = not valid, 1 =
								 * valid, 2 = temporarily forced */
B
Bruce Momjian 已提交
140

141
	/*
142
	 * rd_createSubid is the ID of the highest subtransaction the rel has
B
Bruce Momjian 已提交
143 144 145
	 * survived into; or zero if the rel was not created in the current top
	 * transaction.  This should be relied on only for optimization purposes;
	 * it is possible for new-ness to be "forgotten" (eg, after CLUSTER).
B
Bruce Momjian 已提交
146 147 148
	 * Likewise, rd_newRelfilenodeSubid is the ID of the highest
	 * subtransaction the relfilenode change has survived into, or zero if not
	 * changed in the current transaction (or we have forgotten changing it).
149
	 */
150 151 152 153
	SubTransactionId rd_createSubid;	/* rel was created in current xact */
	SubTransactionId rd_newRelfilenodeSubid;	/* new relfilenode assigned in
												 * current xact */

154
	Form_pg_class rd_rel;		/* RELATION tuple */
155
	TupleDesc	rd_att;			/* tuple descriptor */
156
	Oid			rd_id;			/* relation's object id */
157
	List	   *rd_indexlist;	/* list of OIDs of indexes on relation */
158
	Bitmapset  *rd_indexattr;	/* identifies columns used in indexes */
159
	Oid			rd_oidindex;	/* OID of unique index on OID, if any */
160
	LockInfoData rd_lockInfo;	/* lock mgr's info for locking relation */
161
	RuleLock   *rd_rules;		/* rewrite rules */
162
	MemoryContext rd_rulescxt;	/* private memory cxt for rd_rules, if any */
163
	TriggerDesc *trigdesc;		/* Trigger info, or NULL if rel has none */
164

165 166
	/*
	 * rd_options is set whenever rd_rel is loaded into the relcache entry.
B
Bruce Momjian 已提交
167 168
	 * Note that you can NOT look into rd_rel for this data.  NULL means "use
	 * defaults".
169 170 171
	 */
	bytea	   *rd_options;		/* parsed pg_class.reloptions */

172 173
	/* These are non-NULL only for an index relation: */
	Form_pg_index rd_index;		/* pg_index tuple describing this index */
174
	/* use "struct" here to avoid needing to include htup.h: */
B
Bruce Momjian 已提交
175
	struct HeapTupleData *rd_indextuple;		/* all of pg_index tuple */
176 177
	Form_pg_am	rd_am;			/* pg_am tuple for index's AM */

178 179 180
	/*
	 * index access support info (used only for an index relation)
	 *
181
	 * Note: only default support procs for each opclass are cached, namely
182 183 184
	 * those with lefttype and righttype equal to the opclass's opcintype. The
	 * arrays are indexed by support function number, which is a sufficient
	 * identifier given that restriction.
185 186 187 188
	 *
	 * Note: rd_amcache is available for index AMs to cache private data about
	 * an index.  This must be just a cache since it may get reset at any time
	 * (in particular, it will get reset by a relcache inval message for the
B
Bruce Momjian 已提交
189
	 * index).	If used, it must point to a single memory chunk palloc'd in
190 191
	 * rd_indexcxt.  A relcache reset will include freeing that chunk and
	 * setting rd_amcache = NULL.
192
	 */
193
	MemoryContext rd_indexcxt;	/* private memory cxt for this stuff */
194
	RelationAmInfo *rd_aminfo;	/* lookup info for funcs found in pg_am */
195 196
	Oid		   *rd_opfamily;	/* OIDs of op families for each index col */
	Oid		   *rd_opcintype;	/* OIDs of opclass declared input data types */
197
	RegProcedure *rd_support;	/* OIDs of support procedures */
B
Bruce Momjian 已提交
198
	FmgrInfo   *rd_supportinfo; /* lookup info for support procedures */
199
	int16	   *rd_indoption;	/* per-column AM-specific flags */
200 201
	List	   *rd_indexprs;	/* index expression trees, if any */
	List	   *rd_indpred;		/* index predicate tree, if any */
202 203 204
	Oid		   *rd_exclops;		/* OIDs of exclusion operators, if any */
	Oid		   *rd_exclprocs;	/* OIDs of exclusion ops' procs, if any */
	uint16	   *rd_exclstrats;	/* exclusion ops' strategy numbers, if any */
205
	void	   *rd_amcache;		/* available for use by index AM */
206
	Oid		   *rd_indcollation;	/* OIDs of index collations */
207

208 209 210 211 212 213 214 215 216 217
	/*
	 * Hack for CLUSTER, rewriting ALTER TABLE, etc: when writing a new
	 * version of a table, we need to make any toast pointers inserted into it
	 * have the existing toast table's OID, not the OID of the transient toast
	 * table.  If rd_toastoid isn't InvalidOid, it is the OID to place in
	 * toast pointers inserted into this rel.  (Note it's set on the new
	 * version of the main heap, not the toast table itself.)
	 */
	Oid			rd_toastoid;	/* Real TOAST table's OID, or InvalidOid */

218
	/* use "struct" here to avoid needing to include pgstat.h: */
B
Bruce Momjian 已提交
219
	struct PgStat_TableStatus *pgstat_info;		/* statistics collection area */
220
} RelationData;
221

222 223 224 225 226 227 228 229
/*
 * StdRdOptions
 *		Standard contents of rd_options for heaps and generic indexes.
 *
 * RelationGetFillFactor() and RelationGetTargetPageFreeSpace() can only
 * be applied to relations that use this format or a superset for
 * private options data.
 */
230 231 232
 /* autovacuum-related reloptions. */
typedef struct AutoVacOpts
{
233 234 235 236 237 238 239 240 241 242
	bool		enabled;
	int			vacuum_threshold;
	int			analyze_threshold;
	int			vacuum_cost_delay;
	int			vacuum_cost_limit;
	int			freeze_min_age;
	int			freeze_max_age;
	int			freeze_table_age;
	float8		vacuum_scale_factor;
	float8		analyze_scale_factor;
243 244
} AutoVacOpts;

245 246
typedef struct StdRdOptions
{
247
	int32		vl_len_;		/* varlena header (do not touch directly!) */
B
Bruce Momjian 已提交
248
	int			fillfactor;		/* page fill factor in percent (0..100) */
249
	AutoVacOpts autovacuum;		/* autovacuum-related options */
250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276
} StdRdOptions;

#define HEAP_MIN_FILLFACTOR			10
#define HEAP_DEFAULT_FILLFACTOR		100

/*
 * RelationGetFillFactor
 *		Returns the relation's fillfactor.  Note multiple eval of argument!
 */
#define RelationGetFillFactor(relation, defaultff) \
	((relation)->rd_options ? \
	 ((StdRdOptions *) (relation)->rd_options)->fillfactor : (defaultff))

/*
 * RelationGetTargetPageUsage
 *		Returns the relation's desired space usage per page in bytes.
 */
#define RelationGetTargetPageUsage(relation, defaultff) \
	(BLCKSZ * RelationGetFillFactor(relation, defaultff) / 100)

/*
 * RelationGetTargetPageFreeSpace
 *		Returns the relation's desired freespace per page in bytes.
 */
#define RelationGetTargetPageFreeSpace(relation, defaultff) \
	(BLCKSZ * (100 - RelationGetFillFactor(relation, defaultff)) / 100)

277
/*
B
Bruce Momjian 已提交
278
 * RelationIsValid
279
 *		True iff relation descriptor is valid.
280
 */
281
#define RelationIsValid(relation) PointerIsValid(relation)
282

283 284
#define InvalidRelation ((Relation) NULL)

285
/*
B
Bruce Momjian 已提交
286
 * RelationHasReferenceCountZero
287
 *		True iff relation reference count is zero.
288 289
 *
 * Note:
290
 *		Assumes relation descriptor is valid.
291 292
 */
#define RelationHasReferenceCountZero(relation) \
293
		((bool)((relation)->rd_refcnt == 0))
294 295

/*
B
Bruce Momjian 已提交
296
 * RelationGetForm
297
 *		Returns pg_class tuple for a relation.
298 299
 *
 * Note:
300
 *		Assumes relation descriptor is valid.
301
 */
302
#define RelationGetForm(relation) ((relation)->rd_rel)
303

304
/*
B
Bruce Momjian 已提交
305
 * RelationGetRelid
N
Neil Conway 已提交
306
 *		Returns the OID of the relation
307
 */
308
#define RelationGetRelid(relation) ((relation)->rd_id)
309 310

/*
311
 * RelationGetNumberOfAttributes
N
Neil Conway 已提交
312
 *		Returns the number of attributes in a relation.
313 314 315 316
 */
#define RelationGetNumberOfAttributes(relation) ((relation)->rd_rel->relnatts)

/*
B
Bruce Momjian 已提交
317
 * RelationGetDescr
318
 *		Returns tuple descriptor for a relation.
319
 */
320
#define RelationGetDescr(relation) ((relation)->rd_att)
321

322 323
/*
 * RelationGetRelationName
N
Neil Conway 已提交
324
 *		Returns the rel's name.
325
 *
326
 * Note that the name is only unique within the containing namespace.
327 328
 */
#define RelationGetRelationName(relation) \
329
	(NameStr((relation)->rd_rel->relname))
330

331 332
/*
 * RelationGetNamespace
N
Neil Conway 已提交
333
 *		Returns the rel's namespace OID.
334 335 336 337
 */
#define RelationGetNamespace(relation) \
	((relation)->rd_rel->relnamespace)

338 339 340 341 342 343 344 345 346 347
/*
 * RelationIsMapped
 *		True if the relation uses the relfilenode map.
 *
 * NB: this is only meaningful for relkinds that have storage, else it
 * will misleadingly say "true".
 */
#define RelationIsMapped(relation) \
	((relation)->rd_rel->relfilenode == InvalidOid)

348 349 350 351 352 353 354
/*
 * RelationOpenSmgr
 *		Open the relation at the smgr level, if not already done.
 */
#define RelationOpenSmgr(relation) \
	do { \
		if ((relation)->rd_smgr == NULL) \
355
			smgrsetowner(&((relation)->rd_smgr), smgropen((relation)->rd_node, (relation)->rd_backend)); \
356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372
	} while (0)

/*
 * RelationCloseSmgr
 *		Close the relation at the smgr level, if not already done.
 *
 * Note: smgrclose should unhook from owner pointer, hence the Assert.
 */
#define RelationCloseSmgr(relation) \
	do { \
		if ((relation)->rd_smgr != NULL) \
		{ \
			smgrclose((relation)->rd_smgr); \
			Assert((relation)->rd_smgr == NULL); \
		} \
	} while (0)

373 374 375 376
/*
 * RelationGetTargetBlock
 *		Fetch relation's current insertion target block.
 *
B
Bruce Momjian 已提交
377
 * Returns InvalidBlockNumber if there is no current target block.	Note
378 379 380 381 382 383 384 385 386 387 388 389 390 391 392
 * that the target block status is discarded on any smgr-level invalidation.
 */
#define RelationGetTargetBlock(relation) \
	( (relation)->rd_smgr != NULL ? (relation)->rd_smgr->smgr_targblock : InvalidBlockNumber )

/*
 * RelationSetTargetBlock
 *		Set relation's current insertion target block.
 */
#define RelationSetTargetBlock(relation, targblock) \
	do { \
		RelationOpenSmgr(relation); \
		(relation)->rd_smgr->smgr_targblock = (targblock); \
	} while (0)

393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413
/*
 * RelationNeedsWAL
 *		True if relation needs WAL.
 */
#define RelationNeedsWAL(relation) \
	((relation)->rd_rel->relpersistence == RELPERSISTENCE_PERMANENT)

/*
 * RelationUsesLocalBuffers
 *		True if relation's pages are stored in local buffers.
 */
#define RelationUsesLocalBuffers(relation) \
	((relation)->rd_rel->relpersistence == RELPERSISTENCE_TEMP)

/*
 * RelationUsesTempNamespace
 *		True if relation's catalog entries live in a private namespace.
 */
#define RelationUsesTempNamespace(relation) \
	((relation)->rd_rel->relpersistence == RELPERSISTENCE_TEMP)

414 415 416 417 418 419 420 421
/*
 * RELATION_IS_LOCAL
 *		If a rel is either temp or newly created in the current transaction,
 *		it can be assumed to be visible only to the current backend.
 *
 * Beware of multiple eval of argument
 */
#define RELATION_IS_LOCAL(relation) \
422
	((relation)->rd_backend == MyBackendId || \
423
	 (relation)->rd_createSubid != InvalidSubTransactionId)
424

425 426 427 428 429 430 431
/*
 * RELATION_IS_OTHER_TEMP
 *		Test for a temporary relation that belongs to some other session.
 *
 * Beware of multiple eval of argument
 */
#define RELATION_IS_OTHER_TEMP(relation) \
432 433
	((relation)->rd_rel->relpersistence == RELPERSISTENCE_TEMP \
	&& (relation)->rd_backend != MyBackendId)
434

435 436 437 438
/* routines in utils/cache/relcache.c */
extern void RelationIncrementReferenceCount(Relation rel);
extern void RelationDecrementReferenceCount(Relation rel);

439
#endif   /* REL_H */