hummmmmmm! 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 israel these days??
jt
-----Original Message-----
From: Herouth Maoz [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 03, 1999 11:00 AM
To: JT Kirkpatrick; '[EMAIL PROTECTED]'
Subject: Re: [ADMIN] rollback
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 used at the present, but i need it back.
If you didn't have an ongoing transaction, the chances of ROLLBACK helping
are not very good...
Anyway, if you wanted to know what to do to make the physical file work, I
think the following should work correctly: Create the table with all the
same definitions as it had before, no indices though. Then (probably with
postmaster down) remove the newly created file corresponding to that table,
and put the saved file instead.I think this should work. You should
probably vacuum afterwards or something.
Disclaimer: I'm not a postgres developer, so I'm not the most reliable
expert on this issue.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
************
