Changeset 393 for trunk/docs


Ignore:
Timestamp:
Dec 5, 2008, 11:23:19 AM (11 years ago)
Author:
darcy
Message:

Add more details about how the insert method works before PG version 8.2.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/docs/pg.txt

    r391 r393  
    907907  inserted in order to pick up values modified by rules, triggers, etc.
    908908
    909   Due to the way that this function works you will find inserts taking
    910   longer and longer as your table gets bigger. To overcome this problem
    911   simply add an index onto the OID of any table that you think may get
    912   large over time. You may also consider using the inserttable() method
    913   described in section 3.
     909  Due to the way that this function works in PostgreSQL versions below
     910  8.2, you may find inserts taking longer and longer as your table gets
     911  bigger.  If this happens and it is a table with OID but no primary key
     912  you can overcome this problem by simply adding an index onto the OID of
     913  any table that you think may get large over time. You may also consider
     914  using the inserttable() method described in section 3. 
     915
     916  Note: With PostgreSQL versions before 8.2 the table being inserted to
     917  must have a primary key or an OID to use this method properly.  If not
     918  then the dictionary will not be filled in as described.  Also, if this
     919  method is called within a transaction, the transaction will abort.
    914920
    915921  Note: The method currently doesn't support insert into views
Note: See TracChangeset for help on using the changeset viewer.