Is is possible to tell PostgreSQL to ignore transactions committed
after some point? In particular I want to get it to rollback a
faulty recovery.
On a related note, how can I get the most recent transaction id from
the WAL segment that I want to rollback to?
TIA,
John Barham
between May 28 and yesterday morning?
John Barham
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
test=# explain select s from tt where id = currval('tt_id_key');
QUERY PLAN
--
Seq Scan on tt (cost=0.00..1734.42 rows=1 width=32)
Filter: (id = currval('tt_id_key'::text))
(2 rows)
should be:
test=# explain
test=# create table tt (id serial unique, s varchar);
[populate tt w/ 10 rows]
test=# insert into tt (s) values ('foo');
test=# select currval('tt_id_seq');
currval
-
12
(1 row)
test=# explain select s from tt where id = 12;
QUERY PLAN