On 10/26/05 8:42 AM, "Venki" <Venki@xxxxxxxxxx> wrote:
>
> Hi
> thanks for the replies. The situation is as follows. We get backups from the
> production server and update the local database in the local server but each
> time when we restore the database backup the sequence values are not getting
> updated properly. So what i thought was to write a function which will check
> the last value of the row in the table and compare it with the lastvalue of
> the sequnce and if it is not proper then update the lastvalue of the sequence
> to a proper value.
>
> I Hope that i have explained the situation properly. If you have any other
> suggestion it will be greatly helpful as we are new to postgres and might be
> doing something wrong when restoring the database.
I may be wrong, but I thought that sequences were also dumped and restored
with database dumps, unless you are dumping and restoring only data. Is
that the case?
Sean
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
