Re: Corrupted sequences

I would back up things whenever my ISP says something like, "We're going
to ..."

Francisco Reyes wrote:
> On Fri, 14 Mar 2003, scott.marlowe wrote:
>
>
>>The first could be a problem.  Are you sure the sequence was being used to
>>update the table you were inserting it into?
>
>
> Yes. This site has been working for some time. I got a note from the ISP
> that they were moving databases. I think it has to do with that. Opened a
> ticket with them asking if that domain's DB was moved.
>
>
>>bulk load, so the sequence was set right?  or has it been updated properly
>>by "insert into table (field1,field2,id) values ('a','b',DEFAULT)"
>
>
>
> I am leaning towards the thought that they moved the database and did it
> wrong somehow. Did a 'select currval()' for every sequence and all, except
> the ones I have fixed, gave the error 'is not yet defined in this
> session'.
>
> All these sequences are from primary keys. I am thinking maybe the easiest
> way to fix it may be to drop and re-create the constraint. It's only 25
> tables and have only fixed 4 manually so I am just looking for a way to
> automate the rest.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>