Re: pg_dumpall SET default_transaction_read_only = off (was Re: == PostgreSQL Weekly News - January 28 2018 ==)

e. The old cluster still exists, but is not running. Failing scripts will abort the upgrade. The scripts are called as the user who owns the database. which will allow solving the problem with something like the attached sript. Karsten -- GPG key ID E4071346

Re: glibc updarte 2.31 to 2.38

ese changes ONLY seem to > affect Postgres. Or is it more that it also affects text editors and the > like, but we just tend to ignore that? Text editors for example do not persist ordering based on locale. I'm sure there's software ignoring the issue, too. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: PostgreSQL Log Info

Am Fri, Nov 22, 2024 at 01:02:27PM +0530 schrieb Jethish Jethish: > If an select query is fired I need the query returned values needs to be > logged in my PostgreSQL log file. What do you expect your log file to be in size after, say, a day of activity ? Karsten -- GPG 40BE 5B0E C98

Re: Lookup tables

worse because it ceases being transactional and users might > select something different than what they see on the screen. I never thought of that, thanks. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Lookup tables

same restaurant or not ? what if two restaurants have the same name at the same time ?). Primary keys are tools at the technical level. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Lookup tables

s selected but YELLOW. Yep, that's what I meant and which I never thought of before. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

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

from the table. If so, is there a reason I don't yet see why this is so ? What would be the proper way to achieve the above short of using another view dedicated to the restricted column (in real life, the views are way more involved, as usual ...). Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

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

very strong case that it would > violate the SQL standard. That's what I wanted to know. Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

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

s, for that matter. Updating a column to its DEFAULT value may also be closer to what you envision a "column-delete" to do. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Help with PhD Dissertation

a Tor or some such. Best regards, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

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

Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union

two (or number of unions) index-backward-scans and than only has to reorder at maximum two rows before limiting to the first of it? this should be significantly faster. thanks a lot and greetz, Karsten

Re: Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union

: under wich circumstance does the query-planner use or prefer the 'merge append' over 'append'? Thanks in advance! Am 08.05.25 um 11:57 schrieb Karsten P: Hi, i've already googled so far but didn't find anything regarding my problem.. I hope i'm here

<    1   2   3