well, in all my wisdom and quick typing, i dropped a main table rather than
the one i meant to drop. this just happened. can i recover it with some
quick statement i have an actual backup on tape from last night --
not a pgdump but a physical backup of the files in the database direc
i just sent an email saying i dropped a table and didn't mean to.
i haven't done anything else. will rollback work? i hate to try without
asking because this thing is in production use right now. luckily the
table isn't one that is used at the present, but i need it back.
thanks for any hel
well, rollback didn't restore that table i just dropped. . .
At 17:31 +0200 on 03/11/1999, JT Kirkpatrick wrote:
> i just sent an email saying i dropped a table and didn't mean to.
>
> i haven't done anything else. will rollback work? i hate to try without
> asking because this thing is in production use right now. luckily the
> table isn't one that is
hummm! that should work! it does have a primary key associated with
it. i bet i could create the primary key index as well, and copy that file
into the directory too! i don't think i can create the primary key after
the file has been created?
thanks very much!
what's weather like in i
At 19:20 +0200 on 03/11/1999, JT Kirkpatrick wrote:
> hummm! that should work! it does have a primary key associated with
> it. i bet i could create the primary key index as well, and copy that file
> into the directory too! i don't think i can create the primary key after
> the file has
