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
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
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
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 &
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
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
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
> > > 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,
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
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
201 - 210 of 210 matches
Mail list logo