p, whatever way that is. :) True, I haven't been able
to recover that repository. Fortunately, the setback was minor, since I did
have a recent enough backup. Once again, the absolute rule is "always make
a backup".
--
Ciprian Popovici
---(end of broadcast)-
Oh, and FWIW, when I try a pg_dump on the database "recovered" with
pg_resetxlog, I get this:
pg_dump: missing pg_database entry for database "db"
--
Ciprian Popovici
---(end of broadcast)---
TIP 1: subscribe and unsubscribe c
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Ciprian Popovici <[EMAIL PROTECTED]> writes:
> > That is, a 8.0 which started on a 7.4.2 repository. After noticing,
> > I switched back to 7.4.2, but now it gives this error and won't start:
>
> I think you are omittin
eptable, use -f to force reset.
-
Then I use -f and it resets, but to no use.
I also tried recompiling 7.4.2 (I install it from source anyway) but
no use.
I did a backup of the repository before I attempted the reset.
Is there any other way I can try to recover the d
On Sun, 19 Dec 2004 13:51:39 + Ragnar Hafstaà <[EMAIL PROTECTED]> wrote:
> On Sun, 2004-12-19 at 15:02 +0200, Ciprian Popovici wrote:
> > On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III <[EMAIL PROTECTED]>
wrote:
> > > On Fri, Dec 17, 2004 at 11:10:12 -,
thin the individual groups. You have the unique
key for the entire table, but you need something like a serial restricted
to just a group of rows.
--
Ciprian Popovici
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Ignore my previous question. The special variable OLD is defined
for DELETE fired triggers as well.
--
Ciprian Popovici
---(end of broadcast)---
TIP 8: explain analyze is your friend
ecial vars don't seem to have something useful. The arguments to the
trigger could help, but can they be made dynamical? Is there any way
of identifying the affected rows?
--
Ciprian Popovici
---(end of broadcast)---
TIP 2: you can get off all lis
ve I
> misunderstood what you're trying to do?
No, you understood right. Yes, I will have to go with triggers instead.
Thanks for the input.
--
Ciprian Popovici
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
ted in the common table? I expect
that would break the whole referential integrity thingy, but that would be
useful right about now. Really, I don't want the entire referential
integrity thing, I just want the automatic delete/update half.
--
Ciprian Popovici
---(e
10 matches
Mail list logo
