On Mon, Sep 26, 2022 at 11:18:34AM -0700, Bryn Llewellyn wrote:
>
> My demo seems to show that when a program connects as "client", it can
> perform exactly and only the database operations that the database design
> specified.
>
> Am I missing something? In other words, can anybody show me a vulne
Am 26.09.22 um 14:05 schrieb Andreas Fröde:
Hello,
I am looking for a way to find out when a table was last used for
reading. (Without writing every statement in the logfile or putting a
trigger on it). Is there such a thing?
no really what you are looking for, i know, but we have
pg_st
Hi Laurenz,
No, there is no way to do that short of logging all statements.
Thank you for the quick if unfortunate reply.
I expect that removing permissions on a table and checking whether
your application hits an error is not an option...
I will try to suggest this. :-)
Have a nice day.
On Mon, 2022-09-26 at 14:05 +0200, Andreas Fröde wrote:
> I am looking for a way to find out when a table was last used for
> reading. (Without writing every statement in the logfile or putting a
> trigger on it). Is there such a thing?
No, there is no way to do that short of logging all stateme
> On 14-Sep-2022, t...@sss.pgh.pa.us wrote:
>
> …. Therefore, if you don't trust another session that is running as your
> userID, you have already lost. That session can drop your tables, or corrupt
> the data in those tables to an arbitrary extent, and the SQL permissions
> system will not sq
Hello,
I am looking for a way to find out when a table was last used for
reading. (Without writing every statement in the logfile or putting a
trigger on it). Is there such a thing?
CIAO
andreas
On Mon, 2022-09-26 at 06:57 +0200, Kim Johan Andersson wrote:
> But if there is no opportunity to make a dynamic expression suitable for
> the index, then I guess it won't be possible to make a really useful
> support function for range types.
I think it could still be useful if it only deals wi
