Jacky Leng wrote: > If I run the database under non-archiving mode, and execute the following > command: > alter table t set tablespace tblspc1; > Isn't it possible that the "new t" cann't be recovered?
No. At the end of copy_relation_data we call smgrimmedsync, which fsyncs the new relation file. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
