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
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 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
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
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.
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
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
