Pavan Deolasee wrote: > > Xids are unstable and will come back to bite you after 2G transactions. > > > > Why not just use the "isindvalid" flag ? > > > > > Who would set the flag to true ? Unless of course we are waiting in > CREATE INDEX. But that seems to be less acceptable to me.
Agreed, and we have the problem of crash recovery if we do that. The xid seems to handle that automatically. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate