Re: Tables dissapearing - Mailing list pgsql-general

From Jeff Amiel
Subject Re: Tables dissapearing
Date
Msg-id 46D43169.9080100@istreamimaging.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
My entire shop has set up a betting pool on the outcome of this...so I
hope you post results regardless of the outcome, Kamil.

(in all seriousness, we hope you find/fix the problem before things get
really ugly)

Kamil Srot wrote:
> Richard Huxton wrote:
>> 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.
>>
> Yes, I'll do it in the future, but now, I want to know what is the
> problem and solve it rather than doing some workarounds (even if they
> are good also from the principle indeed).
>
> Regards,


pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)
Next
From: "Kynn Jones"
Date:
Subject: Re: One database vs. hundreds?