RE: [HACKERS] Transaction logging

Your getting me excited about 6.5.  Is there a projected release date for
6.5?  Is there any information on transaction logging?  Is there anything I
can do to help?  I am curious about these items because they will make my
life much easier in the upcoming months as I migrate my application to
Postgres.  Working around these could be very difficulty or near impossible.
-----Original Message-----From:	Bruce Momjian [SMTP:maillist@candle.pha.pa.us]Sent:	Tuesday, February 23, 1999 8:02 PMTo:	Michael DavisCc:	pgsql-general@postgreSQL.org; pgsql-hackers@postgreSQL.orgSubject:	Re: [GENERAL] Transaction logging
> What would it take to have transaction logging added to Postgres.
I am a> c/c++ programmer and will consider contributing to the Postgres
development> effort.  I really like everything I see and read about Postgres.
As a> result, I am strongly considering Postgres as the database engine
for my> Membership database application.  My customer is willing to invest
in a> commercial database, but most of the commercial databases I have
briefly> looked at fall a little short in one way or another.  I have
several> concerns/needs that I am willing to implement and/or support:> > 	- Outer join support in views
In the works.  Perhaps for 6.5, probably not.
> > 	- Transaction logging> > 	- Some form of mirroring, shadowing, or replication> > 	- The current locking mechanism is of some concern.  I need
to make> sure that one user can read a record and then a second can read
and update> that same record.
MVCC locking in 6.5.  Will do what you need.> > 	- If the first user attempts to update that record, what
happens?
Hard to explain.  Will wait or update a copy while read's use an
oldercopy fo the row.

--   Bruce Momjian                        |  http://www.op.net/~candle  maillist@candle.pha.pa.us            |  (610) 853-3000  +  If your life is a hard drive,     |  830 Blythe Avenue  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
19026