Re: glibc 2.35-2.39 upgrade requirements

You will want to ingest https://www.joeconway.com/presentations/glibc-PostgresConfSEA-2024.pdf Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Q on SELECT column list pushdown from view to table

Dear all, given this schema and role: create table t_partially_private ( public_col text, private_col text ); insert into t_partially_private (public_col, private_col) values ('public value', 'private value'); create view v_partia

Re: Q on SELECT column list pushdown from view to table

Am Wed, Mar 26, 2025 at 06:24:14PM +0100 schrieb Karsten Hilbert: > > Works fine if you don't mess with the view's security_invoker > > status. > > I know but doing so was kind of the point. > > The views are created by a "database owner" role having &g

Re: Q on SELECT column list pushdown from view to table

Am Tue, Mar 25, 2025 at 06:55:34PM -0400 schrieb Tom Lane: > Karsten Hilbert writes: > > I expected this: > > > set role "restricted-role"; > > -- this works: > > select public_col from t_partially_private; > > -- this fails: with &

Re: Q on SELECT column list pushdown from view to table

Am Wed, Mar 26, 2025 at 04:36:55PM -0400 schrieb Tom Lane: > It is intentional that this happens even if the reference to > private_col is subsequently optimized away. To do otherwise > would make implementation artifacts in the optimizer far too > visible, and there's also a very strong case tha

Re: Help with PhD Dissertation

Am Tue, Apr 15, 2025 at 11:26:35AM -0400 schrieb Osmel Brito-Bigott: > I'm not collecting emails in the survey Don't get me wrong, I am not questioning your good faith or intent. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Feature Proposal: Column-Level DELETE Operation in SQL

Am Mon, Apr 21, 2025 at 10:23:30PM +0530 schrieb Abhishek Hatgine: >*deleting* a value is conceptually different from *updating* it to NULL. In what way ? In other words, you'll have to much better define what you mean be "deleting a value". DROP COLUMN already exists, for that matter. Upd

Re: Help with PhD Dissertation

> > > The survey [...] is completely anonymous. > > > > Nope. > > > > Can you elaborate on this, please, for my sake and others? I was, certainly somewhat tersely, trying to point out that using Google Forms nearly precludes anonymity unless one accesses them via Tor or some such. Best regards,

Re: Help with PhD Dissertation

Am Mon, Apr 14, 2025 at 09:27:30PM -0400 schrieb Osmel Brito-Bigott: > forms.gle > > The survey [...] is completely anonymous. Nope. Karsten Hilbert -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Feature request: Settings to disable comments and multiple statements in a connection

Am Wed, Jun 04, 2025 at 10:41:15PM + schrieb Glen K: > In my experience developing backends for APIs, I have > never come across a case where comments were needed or > desired within SQL statements generated for API requests, Being able to garnish with comments the SQL being sent to a backend

<    1   2   3