Re: [HACKERS] Point in Time Recovery

2004-07-09 Thread spock
On Thu, 8 Jul 2004, Simon Riggs wrote: > We don't need to mention timelines in the docs, nor do we need to alter > pg_controldata to display it...just a comment in the code to explain why > we add a large number to the LogId after each recovery completes. I'd disagree on that. Knowing what exactl

[HACKERS] Update pg_tables, pg_index views to show tablespace name?

2004-07-09 Thread spock
Hi, while playing around with the tablespace stuff I noticed that on can't see the tablespace a table is in when querying the pg_tables view. I think the tablespace a table is in is a valuable information and should be shown there. This also applies to any ohter related view (like pg_indexes etc.

Re: [HACKERS] Point in Time Recovery

2004-07-09 Thread spock
On Tue, 6 Jul 2004, Zeugswetter Andreas SB SD wrote: > > Should we use a different datatype than time_t for the commit timestamp, > > one that offers more fine grained differentiation between checkpoints? > > Imho seconds is really sufficient. If you know a more precise position > you will probabl