Update of /usr/cvs/Public/pygresql/docs
In directory druid.net:/tmp/cvs-serv255/docs
Modified Files:
pg.txt
Log Message:
Add more details about how the insert method works before PG version 8.2.
To see the diffs for this commit:
http://www.druid.net/pygresql/viewcvs.cgi/cvs/pygresql/docs/pg.txt.diff?r1=1.23&r2=1.24
Index: pg.txt
===================================================================
RCS file: /usr/cvs/Public/pygresql/docs/pg.txt,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -p -u -r1.23 -r1.24
--- pg.txt 5 Dec 2008 15:00:18 -0000 1.23
+++ pg.txt 5 Dec 2008 16:23:19 -0000 1.24
@@ -906,11 +906,17 @@ Description:
The dictionary is then, if possible, reloaded with the values actually
inserted in order to pick up values modified by rules, triggers, etc.
- Due to the way that this function works you will find inserts taking
- longer and longer as your table gets bigger. To overcome this problem
- simply add an index onto the OID of any table that you think may get
- large over time. You may also consider using the inserttable() method
- described in section 3.
+ Due to the way that this function works in PostgreSQL versions below
+ 8.2, you may find inserts taking longer and longer as your table gets
+ bigger. If this happens and it is a table with OID but no primary key
+ you can overcome this problem by simply adding an index onto the OID of
+ any table that you think may get large over time. You may also consider
+ using the inserttable() method described in section 3.
+
+ Note: With PostgreSQL versions before 8.2 the table being inserted to
+ must have a primary key or an OID to use this method properly. If not
+ then the dictionary will not be filled in as described. Also, if this
+ method is called within a transaction, the transaction will abort.
Note: The method currently doesn't support insert into views
although PostgreSQL does.
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
