PostgreSQL Training,
Consulting & Support
General Bits
By A. Elein Mustain

***idate*** Issue:

Archives | General Tidbits | Google General Bits | Docs: 8.0, 7.4 | Castellano | PortuguÍs | Subscriptions | Notifications

General Bits is a column loosely based on the PostgreSQL mailing list pgsql-general.
To find out more about the pgsql-general list and PostgreSQL, see
Issue # 103   28-Mar-2005
1 System Catalog Utility Functions
2 Primary Key Functions and Views
3 View for Column Information
Issue # 102   21-Mar-2005
1 Unix Hacker Tries to Install Windows Version
2 Prevent Update of Keys
3 Understanding Open Source Projects
Issue # 101   12-Mar-2005
1 Special Trigger Issue
2 Sequences and Triggers
3 Referential Integrity Update Trigger?
4 Turn off triggers for bulk load
5 Rules or Triggers
6 Returning What? From Triggers
7 plpgsql Trigger Basics
8 Concurrency and Transactions
9 Trigger to implement Exclusive OR
10 Implementation of Constraints
11 Tracking the row count
12 Effects of multiple triggers
13 Showing Triggers
14 Use Triggers, not Rules for History Logging
15 Timestamping Rows
16 Handling Trees in SQL
17 Using plpython to generically log or copy tables
18 Rules vs. Triggers: Inserts with Sequences
19 Trigger recursion danger
Issue # 100   07-Mar-2005
1 Template databases
2 Creating an operator
3 DBI-Link: Joining other data sources to PostgreSQL

Comments and Corrections are welcome. Suggestions and contributions of items are also welcome. Send them in!.
Copyright A. Elein Mustain 2003, 2004,2005

Search General Bits & Search WWW