Re: Tables dissapearing - Mailing list pgsql-general

From Richard Huxton
Subject Re: Tables dissapearing
Date
Msg-id 46D3D6C0.4000606@archonet.com
Whole thread Raw
In response to Re: Tables dissapearing  (Kamil Srot <kamil.srot@nlogy.com>)
Responses Re: Tables dissapearing  (Kamil Srot <kamil.srot@nlogy.com>)
List pgsql-general
Kamil Srot wrote:
> In the version used on this particular server, there is no
> automatic/programing way of changing
> the schema. Upgrades are done manually and application itself doesn't
> need schema changes
> for routine operations...

In that case, you can settle the matter by making sure your application
connects as a user that doesn't own any of the tables. That way they
can't be dropped.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Tables dissapearing
Next
From: Richard Huxton
Date:
Subject: Re: delete vs insert vs update due to primary key dups -> which is better