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,
J
ata
that was written 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=# 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
---
> 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=# explai
