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

sent to a backend greatly aids in debugging queries (such as which query originated from which part of remote code [or even when]). Not that it didn't take me quite a few years to chance upon that idea ... Best regards, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

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

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 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 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: 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: 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: 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 &

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

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: 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: Reg: Size difference

04 > GB, while the same database on the standby side is 216 GB. Both are in sync > with zero delay. First thing that comes to my mind is different effect of autovacuum between both clusters. Best, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Transaction issue

behind the scenes which failed and thereby set the open transaction to abort state ... And, no, I can't reproduce :/ Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: DROP COLLATION vs pg_collation question

Am Tue, Jun 18, 2024 at 03:02:56PM +0200 schrieb Karsten Hilbert: > I see, and since any database can be used as a template for > more databases, which can be create with an encoding > different from the template, Proving myself wrong: root@hermes:~/tmp# sudo -u postgres psql -e -f /t

Re: DROP COLLATION vs pg_collation question

base can be used as a template for more databases, which can be create with an encoding different from the template, it doesn't really make too much sense to be able to remove even pg_collation entries. So, DROP COLLATION is somewhat of a smoking gun pointed at my foot :-) Thanks, Karsten -- G

Re: DROP COLLATION vs pg_collation question

Am Sun, Jun 16, 2024 at 06:53:31AM +0200 schrieb Laurenz Albe: > On Fri, 2024-06-14 at 22:08 +0200, Karsten Hilbert wrote: > > Are collations per-database or per-cluster objects ? > > Each database has its own "pg_collation" catalog table. > > So they are local

Re: DROP COLLATION vs pg_collation question

ing operating system (ICU update, libc update) -- one would have to live with outdated version information in pg_collations short of dump/sed/restore or some such ? I'm pretty sure I am overlooking something. Best, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: DROP COLLATION vs pg_collation question

|| _rec.collname || ''"''; EXCEPTION WHEN undefined_object THEN RAISE NOTICE ''collation does not seem to exist (perhaps for the DB encoding ?)''; END; END LOOP;

DROP COLLATION vs pg_collation question

tion sv_SE) ? Experimentation seems to hint that way but I was unable to confirm. Thanks Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

year of college folks ? However, let's refrain from discussing that _here_. Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

ar 13 2023, 12:18:29) [GCC 12.2.0] on linux Type "help", "copyright", "credits" or "license" for more information. >>> for idx in [0,1,2,3]: print(idx) ... 0 1 2 3 >>> Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: "reverse" (?) UPSERT -- how to ?

Am Sat, Feb 17, 2024 at 07:25:11PM +0100 schrieb Karsten Hilbert: > +1 except that I've got use for both parts of the UNION on > their own (they are both views themselves involving a bunch > of joins with yet other tables, 4 or 5 each or so ;-) Just for kicks, attached find

Re: "reverse" (?) UPSERT -- how to ?

ow with > > detail table columns NULLed > > > > A better way to do that is to just use a LEFT JOIN. +1 except that I've got use for both parts of the UNION on their own (they are both views themselves involving a bunch of joins with yet other tables, 4 or 5 each or so ;-) T

Re: "reverse" (?) UPSERT -- how to ?

entity? Rob, I'm sure there's something to be learned from that suggestion the significance of which I don't grasp yet. Would you mind expanding a bit ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: "reverse" (?) UPSERT -- how to ?

e.html :-) I knew I missed something. As Greg also pointed out that is what I need. Thanks ! Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

"reverse" (?) UPSERT -- how to ?

imens / schedules thereof involving a whole lot more columns, of course, which should not be relevant to the problem though) Thanks for taking the time to read, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Safest pgupgrade jump distance

ld be stressed that the binaries of the later version (16 in OPs case) should be used to run the upgrade, right ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: How should we design our tables and indexes

ata, because interleaving data may have been inserting while the user inspected the first batch of results. A "second page" is only defined in terms of "what the original query returned on the first run". Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Nested-Internal Functions

> I am currently using PostgreSQL 15 and I am trying to create a nested > function with the following structure: ...   > However, I get an error What *is* the error ? Karsten

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

Am Sat, Jan 13, 2024 at 05:53:14PM -0500 schrieb Ron Johnson: > *No,* that's a technology problem. What is the purpose of storing them > back in the database using psql? Or even the end goal to be achieved by that ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Time zone offset in to_char()

d-coded > functions based on an IN parameter help any ? Without testing the idea - could it even generate the hardcoded function as needed, based on the parameter, and then run it ? Karsten

Aw: Time zone offset in to_char()

ons need to be created in the caching database before we can > use them, while we have several environments where they would apply (DEV, > pre-PROD, PROD). Would a function that dispatches its calls to a suitable array of hard-coded functions based on an IN parameter help any ? Karsten

Aw: Role for just read the data + avoid CREATE / ALTER / DROP

set default_transaction_read_only can help   Karsten     Gesendet: Freitag, 25. August 2023 um 14:38 Uhr Von: "Durumdara" An: "Postgres General" Betreff: Role for just read the data + avoid CREATE / ALTER / DROP Dear Members!   Normally we use the "db owner"

Aw: Re: Fatal Error : Invalid Memory alloc request size 1236252631

/README.md might be of help Karsten

Re: question on auto_explain

ng pointed out: that auto_explain *doesn't* suffer from plain EXPLAIN write-query "side effects" because it instruments normally-run queries and just outputs to the log extra information (the plans). Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Re: question on auto_explain

uided by psql discarding (?) query results (the rows) while displaying EXPLAIN output only. The auto_explain docs might perhaps still benefit from a more explicit hint towards write query side effects. Karsten

Aw: Re: question on auto_explain

> On Thu, Aug 3, 2023 at 9:29 AM Karsten Hilbert > mailto:karsten.hilb...@gmx.net]> wrote: >> >>   >>https://www.postgresql.org/docs/current/auto-explain.html[https://www.postgresql.org/docs/current/auto-explain.html] >> >> don't explicitel

question on auto_explain

n INSERT/UPDATE/DELETE if auto_explain.log_analyze is TRUE ? If not how so ? (I guess it would have to run a dance of "BEGIN; EXPLAIN ANALYZE ...; ROLLBACK;" just before any query is being run.) Thanks, Karsten

Aw: When will trusted PL/Python be supported?

have any relevant email discussion? AFAIR the consensus was that Python cannot really be (made to be) trusted in the PG sense which is why plpython/trusted was *removed*. Karsten

Re: Reproducing incorrect order with order by in a subquery

sible* to find a dataset (of any size) which *reliably* demonstrates the ordering mismatch. To my understanding -- since the outer query *can* (per happenstance) return rows in the order of the subquery's ORDER BY it is not possible to reliably demonstrate that it won't, is it ? Karste

Re: Reproducing incorrect order with order by in a subquery

unless* one forces a different order on the outer query. Which in turn would defeat the purpose as then the outer query *does* have an explicit ordering... IMO you need to either rewrite the query or look to MySQL for more detailed help. Probably the former, regardless of the latter. Best, Kars

Re: Guidance on INSERT RETURNING order

Am Fri, Apr 14, 2023 at 10:44:19PM +0100 schrieb John Howroyd: > The problem is that SQLAlchemy is an ORM [...] ... > [...] as the majority of the python world will use this ORM for > their database needs. I wouldn't be so sure on this count ... Karsten -- GPG 40BE 5B0E C98E 1

Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres

l) PK with respect to a given time line only, right? > > spoofing ? > > ¿ Of what ? The time stamp. But then I assume that is obtained on the logging system. All I really wanted to hint at is that "incoming call timestamp" may work pretty well in given settings but does not _always_ make for a "unique enough" key. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres

the last incoming call timestamp for a > phone number will be exactly that. timezones ? DST ? spoofing ? ... Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?

here to be read. And it tends to be the longer the more details it is expected to cover, isn't it ? Searching for generic terms on typical search engines can be quite a task, agreed. Karsten

Aw: Re: REINDEX vs VACUUM

the stuff from the living room to the bedroom and then jettison > the living room. > > Isn't that how you normally vacuum your living room? Well, yeah, I wouldn't expect the table to be *copied*. After all, there's not that much use for more than one per living room. Karsten

Re: dropped default locale

Am Wed, Dec 21, 2022 at 03:46:48PM +0100 schrieb Karsten Hilbert: > I wasn't so sure whether inserting appropriate > rows would be equivalent to create collation... For that matter, is DELETE FROM pg_collation ... equivalent to DROP COLLATION ? Thanks, Karsten -- GPG 40BE 5B0E C98

Re: dropped default locale

#x27;c', TRUE, -1, 'POSIX', 'POSIX'); Many thanks ! I wasn't so sure whether inserting appropriate rows would be equivalent to create collation... (pg_collation might have been a view projecting inner workings of the server engine). Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

dropped default locale

Dear all, I managed to drop the "special" collations default, C, and POSIX with OIDs 100, 950, 951. Is there a way to recreate them (short of restoring a backup) ? Naive attempts with create collation do not seem to work out. Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA

Re: plpgsql_check_function issue after upgrade

to help you ? Such as not to top post. Best regards, Karsten > On Mon, 5 Dec, 2022, 1:36 pm Pavel Stehule, wrote: > > > > > > > po 5. 12. 2022 v 8:42 odesílatel shashidhar Reddy < > > shashidharreddy...@gmail.com> napsal: > > > >> Pavel,

Re: Q: error on updating collation version information

W.euctw" will be ignored by the server for all practical purposes. Does this mean it is impossible to "correct" its version information ? And if so, that is expected to be non-harmful and is not expected to trigger nag messages ? Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Stored procedure code no longer stored in v14 and v15, changed behaviour

”, precisely for that reason. I see. That makes sense. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Q: error on updating collation version information

p (the "reindex / revalidate constraint / refresh collation version" dance). There also was a libc upgrade which also affected locales. Most of them were fixable by that dance but some popped up (such as br_FR@euro) to not be "correctable" showing the "does not exist for encoding" error. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Q: error on updating collation version information

Am Sun, Dec 04, 2022 at 01:22:02PM +0100 schrieb Karsten Hilbert: > following an ICU upgrade, collations in a stock Debian PG 15.1 > cluster now have divergent version information in pg_collations. Correction: this is following a libc upgrade 2.35 -> 2.36 Karsten -- GPG 40BE 5B0E

Re: Q: error on updating collation version information

Am Sun, Dec 04, 2022 at 01:22:02PM +0100 schrieb Karsten Hilbert: > gnumed_v22=> ALTER COLLATION pg_catalog."br_FR@euro" REFRESH VERSION; > ERROR: collation "pg_catalog.br_FR@euro" for encoding "UTF8" does not > exist The OS (libc) does see

Q: error on updating collation version information

n my database(s). What is the canonical advice on the way forward here ? Is the _suggested_ solution to delete the collation or am I missing to see the "proper" approach to fixing it ? Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Re: Stored procedure code no longer stored in v14 and v15, changed behaviour

he output of pg_get_functiondef, applied > to the stored diff?). I wonder whether that would tie the sanity check to a particular PG version. I mean, pg_get_functiondef output being a server runtime artifact it might well change between server versions, no ? Best, Karsten

Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...

realize... That's a > great idea. > Honestly not sure how to even run it? > > Thanks for the support, it's encouraging... especially when I know there's > an 80% chance that > this may fail to get accepted for any number of reasons. I don't think that estimate n

Re: Q: fixing collation version mismatches

all this has been discussed in detail, I'd be glad for a pointer into the archive. Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Q: fixing collation version mismatches

Am Sun, Nov 13, 2022 at 12:46:53PM -0800 schrieb Christophe Pettus: > > On Nov 13, 2022, at 12:45, Karsten Hilbert wrote: > > REINDEX DATABASE db_in_question; > > ALTER DATABASE db_in_question REFRESH COLLATION VERSION; > > ALTER COLLATION every_collation_f

Q: fixing collation version mismatches

COLLATION every_collation_from_pg_collation REFRESH VERSION; Note that I am currently _not_ concerned with minimizing work by running this on objects only that really need a reindex/refresh. Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Re: Q: documentation improvement re collation version mismatch

sion and the currently reported one unless you REALLY know what you're > doing." Given that it does not seem straightforward to mechanically detect objects in need of a collation-associated rebuild I would think that such a warning would change matters for the better, documentation-wise. Karsten

Aw: Re: Q: documentation improvement re collation version mismatch

ntation is rather assertive (even if may true to the letter) and may warrant some more cautionary wording ? Added, perhaps, some variation of this: > For now, the only safe way to go is either reindex everything, or everything > except some safe cases (non-partial indexes on plain-non-collatable datatypes > only). Best, Karsten

Q: documentation improvement re collation version mismatch

"Note: you may need to refresh the default collation even if the query above does not show any objects directly affected by a collation version change" ? Thanks for considering. Best, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Information to CVE-2022-42889

t for short-term feedback. It might be prudent for Barmenia, a large insurance company, to consider purchasing commercial support rather than requesting short-term feedback from volunteers. Other than that there's also excellent documentation and freely inspectable source code. Best regards, Karsten

Aw: Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

rying to *embed* PostgreSQL ? But that would not go with the account of multi-tenancy that's been presented. Karsten

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

uccessful login) should not change (mary is still mary). despite the additional code path. It seems to be a way of bisecting in order to verify/falsify assumptions in his mental model. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

> > bob || {} > mary || {} > postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} Just a hint: you may want to use "mary_os" and "mary_db&

Aw: Re: How to store "blobs" efficiently for small and large sizes, with random access

m of a table integrated with PGs access/security infrastructure that would be really helpful for some scenarios. A view-on-top-of-file_fdw kind of thing ? LO seems to nearly be there by now, or am I misunderstanding ? Karsten

Aw: Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE

there's no such table. And, indeed, there isn't. Perhaps there's a table s."silly name". It is accidental if unfortunate that the is quoted with ""'s in the \d output... Karsten  

Aw: Re: I slipped up so that no existing role allows connection. Is rescue possible?

Yes, one will forget most of what's written there. However, a coarse structure of a new mental model will form. Karsten

Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?

Am Wed, Sep 14, 2022 at 10:10:30AM +0200 schrieb Karsten Hilbert: > Am Tue, Sep 13, 2022 at 05:10:58PM -0400 schrieb Tom Lane: > > > (I recall that somewhere we have some code that warns about no-op > > grants. I wonder if issuing a warning for no-op revokes would be > >

Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?

than a no-op grant. Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Re: toast useless

l?   Essential to proper operation of the database code as of now.   Best, Karsten

Aw: Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario

ht. After all, how would I know which of the eight to skip while I don't know the intended rules for the current_role? = You'd certainly start out with all eight but then whittle down to what still exhibits the problem and post that. = Karsten  

Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence

Am Wed, Jul 20, 2022 at 09:15:29AM + schrieb Sebastien Flaesch: > Thomas, we already have a similar solution. > The idea is to use the native PostgreSQL SERIAL type. Which does not guarantuee gaplessness. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: lifetime of the old CTID

uot;pk AS ctid" (untested, however) Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: lifetime of the old CTID

not having changed might be another solution for detecting concurrent transacations if one is bent on using system columns for that. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: lifetime of the old CTID

rimary key, not to *add* one. You said that there *is* a primary key. So, more thought/explanation would need to go into why that cannot be used. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: How to set password in psql -h -d -U command line?

> I tried various ways to set password in psql command line, but got no luck. Have you tried all the methods that you showed in your mail or did you try others as well ? Best regards, Karsten

Re: PG14: "is of" vs pg_typeof

cting the above "is of" use ? > > Actually it can be done as: > > select pg_typeof('test'::text) in ('text'::regtype, 'varchar'::regtype); Found that, but thanks anyway. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: PG14: "is of" vs pg_typeof

Am Sat, Apr 23, 2022 at 10:14:03PM +0200 schrieb Karsten Hilbert: > I can't find anything in the changelog saying that "is of" > was removed. For what it's worth, nothing in the docs ever > said it existed either (though it did, as per real life). Oh, wait,

PG14: "is of" vs pg_typeof

so far: it requires laboriously constructing an array on the right hand side for the above use case, along the lines of: select pg_typeof('a'::text) = any(ARRAY[pg_typeof(''::text), pg_typeof(''::name)]); Is there anything obvious I am missing for easily resurrecting the above "is of" use ? Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Transaction and SQL errors

Am Mon, Apr 04, 2022 at 11:33:14AM + schrieb Sebastien Flaesch: > Is there any plan to have an equivalent of psql's > > set ON_ERROR_ROLLBACK on > > in the DB engine? That is already what happens. SQL fails, transaction rolls back. Karsten -- GPG 40BE 5B0E C98E 1713

Aw: Re: How long does iteration over 4-5 million rows usually take?

> How long does iteration over 4-5 million rows usually take? > > 4-5 million times as long as it takes to do one iteration ( if you’re doing > it correctly) I may not take quite that long because setup/teardown times might not be needed for each iteration. Best, Karsten

Aw: Additional accessors via the Extension API ?

a TextFile type I’d like to implement syntax like: > > (‘/home/me/a.txt’::TextFile).firstline > (‘/home/me/a.txt’::TextFile).lastline > (‘/home/me/a.txt’::TextFile).countlines() > (‘/home/me/a.txt’::TextFile).size() > (‘/home/me/a.txt’::TextFile).datemodified() Off on a tangent but would file_fdw help in any way ? Karsten

Re: Is there a way to automatically scan a table and determine the format of data

Am Wed, Feb 16, 2022 at 01:27:56AM + schrieb Shaozhong SHI: > Is there a way to automatically scan a table and report the format of data > for each column? pg_class But you may want to rethink the approach given that you use Python. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BE

Aw: Operator % and its meaning and use

hat helped my understanding ! Best regards, Karsten

Re: Proposed German Translation of Code of Conduct Policy

ument "Suggestions for execution of the Policy" containing such advice as you gave above. Other than that one might leave things as they are. > Thank you for your suggestions. These have been incorporated in the text Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Can we go beyond the standard to make Postgres radically better?

erence between going _beyond_ a standard and being _well outside_ said standard. Which do you propose ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Counting the number of repeated phrases in a column

Am Tue, Feb 01, 2022 at 11:29:50PM + schrieb Shaozhong SHI: > How about knock unique words into discrete joint up strings? Then check > whether there is any repeated words? Does it work when you try ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Counting the number of repeated phrases in a column

Am Wed, Jan 26, 2022 at 08:35:06PM + schrieb Shaozhong SHI: > Whatever. Can we try to build a regex for 'The City of London London > Great London UK ' ? Would you be so kind as do be more specific about that "we" ? Best, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Re: Counting the number of repeated phrases in a column

e ? So far, we (I?) can't tell because you have yet to (computably) define "phrase". Which may or may not solve the previous dilemma. (Top-posting is not liked on this list, to my knowledge.) Best, Karsten

Aw: Counting the number of repeated phrases in a column

>   > 'The City of London, London' also has no occurrences of any repeated phrase. >   > Anyone has got such a function to check out the number of occurrence of any > repeated phrases? For that to become answerable you may want to define what to do when facing ambiguity. Best, Karsten

  1   2   3   >