From 60d6f49a47dbb7770509034d012db00fbb7e7823 Mon Sep 17 00:00:00 2001
From: Bruce Momjian Last updated: Sat Jan 29 23:25:05 EST 2005 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) There are several There are several
+ "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us)
log_*
server configuration variables
+ log_*
server configuration variables
that enable printing of process statistics which can be very useful
for debugging and performance measurements.text_pattern_ops
index for such cases that work only
- for LIKE
indexing.
+ text_pattern_ops
index for such cases that work only
+ for LIKE indexing.
To uniquely number columns in user tables, it is best to use - SERIAL> rather than OIDs because - SERIAL sequences are unique only within a single + SERIAL rather than OIDs because + SERIAL sequences are unique only within a single table. and are therefore less likely to overflow. SERIAL8 is available for storing eight-byte sequence values.
@@ -1149,8 +1150,7 @@ BYTEA bytea variable-length byte array (null-byte safe)Use CURRENT_TIMESTAMP:
-CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP );
-
+ CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP );