Re: [DOCS] Incorrect description of xmax and xip in functions docs
On Sat, 2008-09-06 at 21:31 -0400, Bruce Momjian wrote: > Applied, and attached. Thanks. > > And for txid_visible_in_snapshot() comment added: > > "Function should not be used with subtransaction xids. It is possible > > that this function will return a true result for a subtransaction xid > > that was actually still in progress at the time of the snapshot". > > I think the cleaner solution is to throw an appropriate error if a > subtransaction xid is used, rather than adding documentation. Or maybe check subtrans for it, as it really should be doing. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Incorrect description of xmax and xip in functions docs
Simon Riggs wrote: > > On Sat, 2008-09-06 at 21:31 -0400, Bruce Momjian wrote: > > Applied, and attached. > > Thanks. > > > > And for txid_visible_in_snapshot() comment added: > > > "Function should not be used with subtransaction xids. It is possible > > > that this function will return a true result for a subtransaction xid > > > that was actually still in progress at the time of the snapshot". > > > > I think the cleaner solution is to throw an appropriate error if a > > subtransaction xid is used, rather than adding documentation. > > Or maybe check subtrans for it, as it really should be doing. Yea, that's what I meant. You can't be sure everyone is going to read the documentation but they are sure to see the function results or error message. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Incorrect description of xmax and xip in functions docs
On Sun, 2008-09-07 at 08:31 -0400, Bruce Momjian wrote: > Simon Riggs wrote: > > > > On Sat, 2008-09-06 at 21:31 -0400, Bruce Momjian wrote: > > > Applied, and attached. > > > > Thanks. > > > > > > And for txid_visible_in_snapshot() comment added: > > > > "Function should not be used with subtransaction xids. It is possible > > > > that this function will return a true result for a subtransaction xid > > > > that was actually still in progress at the time of the snapshot". > > > > > > I think the cleaner solution is to throw an appropriate error if a > > > subtransaction xid is used, rather than adding documentation. > > > > Or maybe check subtrans for it, as it really should be doing. > > Yea, that's what I meant. You can't be sure everyone is going to read > the documentation but they are sure to see the function results or error > message. In fact, neither is possible. We cannot assume subtrans is available on the system on which the check is made, neither can we identify which xids are subtransactions and which are not. The only way is to document it. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
