Обсуждение: Problems with deleting data.

Поиск
Список
Период
Сортировка

Problems with deleting data.

От
"Frederic S"
Дата:
Hi, I'm using pgsql 7.3.
I'm playing around with a project databse and I regularily drop the whole
database and then reload data in it.
The problem is, when i reload the data, the old data is reloaded, not the
new one.

I've tried dropping the database instead of deleting all the rows and i
still have the same data in my tables.

Thanx for the help


Fred

Re: Problems with deleting data.

От
Doug McNaught
Дата:
"Frederic S" <fredboard@sympatico.ca> writes:

> Hi, I'm using pgsql 7.3.
> I'm playing around with a project databse and I regularily drop the whole
> database and then reload data in it.
> The problem is, when i reload the data, the old data is reloaded, not the
> new one.

Sounds like you're restoring from an old dump, then.  Are you doing a
fresh backup before dropping the data?  Are you sure that backup is
going where you think it is?

-Doug