Aw: Re: Key encryption and relational integrity

believe you when you say "they say that ..." but I truly doubt that GDPR intended to make data processing fully impractical. (I work in the medical field) Karsten

Aw: Re: Key encryption and relational integrity

> I believe you when you say "they say that ..." but I truly doubt that > GDPR intended to make data processing fully impractical. > > (I work in the medical field) In Germany, that is, which usually takes things to the extreme, for better or worse. Karsten

Re: Key encryption and relational integrity

What Andrea Moreno's client seems to think is required by GDPR is clearly bogus -- it would render illegal any and all DICOM images existing today, because they contain programmatically easily processable personally identifying data right inside the clinical data. Karsten Hilbert -- GPG

Re: does postgresql backup require additional space on disk

ckups which should free up space in the old tablespace. Then take backups of and move the remaining databases, perhaps one by one. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

CREATE DATABASE ... TEMPLATE ... vs checksums

QL command select pg_verify_checksums(object); on the horizon, right ? So, for the time being, my only option would be to include a pg_dump step of the template before cloning it ? Thanks for insights shared, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

verify checksums / CREATE DATABASE

, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Requirement PA-DSS 1.1.4

ed disk. Move the tablespace when requirements ask for deletion. Wipe the storage medium after moving the tablespace. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

pg_dump include/exclude data, was: verify checksums / CREATE DATABASE

source or suitable server logs and compare queries between runs with/without said options ? Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: pg_dump include/exclude data, was: verify checksums / CREATE DATABASE

Dear Adrian, On Fri, Jun 07, 2019 at 08:02:32AM -0700, Adrian Klaver wrote: > On 6/6/19 6:50 AM, Karsten Hilbert wrote: > > The current canonical solution (?) for verifying checksums in > > an existing database is, to may understanding, to pg_dump it > > (

Re: pg_dump include/exclude data, was: verify checksums / CREATE DATABASE

Dear Tom, On Fri, Jun 07, 2019 at 11:41:36AM -0400, Tom Lane wrote: > On 6/6/19 6:50 AM, Karsten Hilbert wrote: > >> The current canonical solution (?) for verifying checksums in > >> an existing database is, to may understanding, to pg_dump it > >> (to /dev/nul

Aw: Re: pg_dump include/exclude data, was: verify checksums / CREATE DATABASE

database cloning would reveal the corruption before it got cloned. Does that make sense ? Karsten

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

fields as well > (if relevant). A specifig knob for "sensitive data" cannot be supplied by PostgreSQL because it cannot know beforehand what information will be considered sensitive under a given, future, usage scenario. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

rt of sitting tight-and-mum and not reflect much of *anything* beyond "error". And even that can be a side channel. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

question basically boils down to "Given a rogue/dumb app, and a DBA who neglected his job, is it PG's business (or even within its possibilities) to mop up ?" I'd be inclined to say No. I would agree it is not entirely trivial to accept that resolve, though. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

%c - session ID %l - in-session log line idx %e - SQLSTATE would probably suffice if sent to the client, given it is logged in the server log. (not that I suggest any such thing as I certainly lack the skills to provide a patch) Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Sequences part 2

tionable assumptions the app thinks it needs -- if at all logically possible Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Too short field

base side or can I just go on running the app as is. > > Nothing will break on the database size. We don't know. There may be functions in triggers or for direct use which rely on the assumption that it be 60 chars max. PostgreSQL itself won't care, that much holds. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Too short field

On Wed, Jul 03, 2019 at 02:10:55PM +0200, Karsten Hilbert wrote: > > Karl Martin Skoldebrand schrieb am 03.07.2019 um 13:30: > > > Now, we have a bug in another application that prevents an automatic > > > tool to enter certain users in the database. The organisational f

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

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

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

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

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: Fatal Error : Invalid Memory alloc request size 1236252631

/README.md might be of help 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: 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: 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

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

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

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

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 ?

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 ?

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

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

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

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

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 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: 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: 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: client waits for end of update operation and server proc is idle

Following which sending the data seems (intentionally?) aborted by the server, which the other side likely reports as loss-of-signal. Also, where does the "imcomplete message from client" originate from ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: client waits for end of update operation and server proc is idle

ot; > > > 2021-04-23 05:55:23.593 CEST [2317] DETAIL: Kann Zeichenkettenpuffer mit > > > 0 Bytes nicht um 1380986158 Bytes vergrößern. "cannot extend 0-byte string buffer by 1380986158 bytes" > > > 2021-04-23 05:55:23.593 CEST [2317] LOG: konnte Daten nicht an den > > > Client senden: Datenübergabe unterbrochen (broken pipe) Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Aw: Ideas for building a system that parses medical research publications/articles

highlighted", > "historical", type Those three categories won't help much. I'm sure though you had something specific in mind with them ? Karsten

Aw: Re: Database issues when adding GUI

> The problem source is postgres telling me it cannot connect to the database via TCP/IP > but I can do so directly using psql: via UNIX domain sockets. That makes a difference. See pg_hba.conf. Karsten

pg_dump/pg_restore vs default_transaction_read_only under PG 13.2

would seem the restore script lacks a SET default_transaction_read_only TO 'off'; in the setup section after re-connecting to the DB following the ALTER DATABASE section ? Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2

the dump does not contain the "on" setting (because, I assume, it does not dump configuration of the server, but content and properties of databases). Still, thanks for thinking along. Best, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2

ter what the source of that was. I think it's probably not > hard to construct scenarios where someone would really not be happy > about such behavior. Any chance pg_dump (and/or pg_restore) might gain an option --ignore-read-only ? That way, PostgreSQL need not decide for users. Thank

Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2

Am Sun, Jun 20, 2021 at 09:34:45PM +0200 schrieb Karsten Hilbert: > Any chance pg_dump (and/or pg_restore) might gain an option > --ignore-read-only ? That way, PostgreSQL need not decide > for users. Or, options --pre-dump-sql and -post-dump-sql ? Users could then run setup/teardow

Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2

ble-deferrable "${_PG_HOST_ARG}" "${_PG_PORT_ARG}" --username="${GM_DBO}" -f "${BACKUP_DATA_DIR}" "${GM_DATABASE}" 2> /dev/null And this is the restore: sudo -u postgres pg_restore --verbose --create --dbname=template1 --exit-on-error -p ${GM_PORT} ${BACKUP}.dir/ Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2

to skillfully emit alter database ... default_transaction_read_only to 'on' only after having emitted any data-loading statements or else gain a --do-not-alter-database-to-read-only effectively omitting said statement thereby allowing for a more elegant treatment of the issue. Best, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2

Am Fri, Jun 25, 2021 at 11:39:46AM +0200 schrieb Karsten Hilbert: > I would be happy to hope that pg_dump might ... > gain a --do-not-alter-database-to-read-only or even a --(pre|post)-dump-sql=(pre|post).sql allowing for (here) temporarily altering a role to default_transaction_read_only=

Re: PostgreSQL reference coffee mug

Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz: > The prototype is ready. Nice. Now the elephant needs to fade into the background. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Issue with a query while running on a remote host

Deep packet inspection naively scanning for potential fragments of bash scripts being transferred ? Karsten Am Fri, Aug 27, 2021 at 12:32:09PM +0530 schrieb Ninad Shah: > Date: Fri, 27 Aug 2021 12:32:09 +0530 > From: Ninad Shah > To: pgsql-general > Subject: Issue with a query whil

Aw: Re: Timestamp with vs without time zone.

> It seems like it would be so much more useful if the timestamp with > time zone type actually stored the time zone in the record. Which one ? Karsten

Aw: Re: Timestamp with vs without time zone.

ct candidate for a fully fleshed out, exemplary composite type ? (but, then, yes it would beg the question what the TZ field of the composite is to actually mean...) Karsten

Aw: Re: Re: Timestamp with vs without time zone.

zone information. What would that TZ mean, exactly, especially in relation to the timestamp itself ? Would the timestamp be stored as that TZ ? Karsten

Aw: Re: Re: Timestamp with vs without time zone.

> It's just that the phrase > "timestamp with time zone" would seem to indicate the time zone is > stored somewhere in there. Now, I can fully agree with _that_ :-) Karsten

Re: Timestamp with vs without time zone.

he machine (towards user consumption) it gets converted to whatever is desired. UTC = UTF8 Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: PostgreSQL - Ordering Table based of Foreign Key

ll referenced from table" drop table if exists ... cascade; Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: pg_dump save command in output

lines, as a comment > > -- original command was: psql -h some_host -p . > > > > > Are you dumping in plain or custom format? > > > > plain (SQL) Run the dump from a bash script which pre-catenates (Is that even a word ? it is now :) the command into the plain (SQL) ou

Re: PostgreSQL CHECK Constraint

Am Sun, Oct 03, 2021 at 07:16:32PM +0100 schrieb Shaozhong SHI: > That is interesting. Can errors be captured and saved as data with > scripting? Depends on what the script does. If the script runs (or is written in) Python the canonical PG driver (psycopg2/3) will give you such data. K

Re: PostgreSQL CHECK Constraint

GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B -- Karsten Sure, they are just a search engine's use away. > Are there any examples on the web these days? > That sounds brilliant. :Am Sun, Oct 03, 2021 at 07:44:41PM +0100 schrieb Shaozhong SHI

Aw: Re: Fault with initcap

Hi David, >Expected are as follows: >Notemachine >Sainsbury's bank. Now, step two: generalize that exemplary definition. Karsten

Aw: Re: Re: Fault with initcap

> Only the first letter of each word to be capitalised/uppercased. The next step is to not top-post. Then to keep the list involved if you wish further help. Then, if you are intent on using regular expressions, look at the PostgreSQL docs for regexp_replace. Karsten  

Re: Fault with initcap

t, hopefully, not quite there yet. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: check scripts after database code change

Am Thu, Nov 18, 2021 at 05:45:37PM +0300 schrieb Dennis: > Are there any scripts that we can check after the changes we made in the > database code? > In summary, are there any automatic post-development scripts before they > come to the beta stage? What do you want those script to d

Re: How to allow null as an option when using regexp_matches?

? something like this > select count(*) from regexp_matches('Great London', 'null|Great > London|Information Centre|Department for Transport', 'g'); You seem to want to apply coalesce() judiciously. Best, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: a very naive question about table names in Postgres

rack of tables" ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Proposed German Translation of Code of Conduct Policy

t, mit der Ausnahme, dass die > Person, die in die Beschwerde involviert ist, in ihrer > Funktion im Komitee oder dem Core-Team vom Verfahren > ausgeschlossen wird. What happens if all members of the committee are impeached at once ? > Die Komitee kann feststellen, dass ein Verstoß gegen

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

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

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

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

Aw: Operator % and its meaning and use

hat helped my understanding ! Best regards, 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: 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: To all who wish to unsubscribe

On Mon, Nov 20, 2017 at 1:11 PM, Tom Lane wrote: > Vick Khera writes: > > Did the list software change? All my messages from here are not being > properly auto-files by the filter I have set up. > > Yes - did you not see either of the "migration to pglister" messages? > There's a summary of the

Re: migrations (was Re: To all who wish to unsubscribe)

I would like to remind everyone that a) we are all friends, and b) we don't need to reply to everything. Now for some humour https://xkcd.com/386/ "someone is wrong on the internet" Tail of Banana talk, just before Get me off your ... very strong language https://youtu.be/eC9rmsI7dnw?t=1m32s (I

Re: Feature idea: Dynamic Data Making

VIEWs column GRANTs RLS Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

Re: a back up question

Nothing wrong with lots of tables and data. Don't impose any constraints on your problem you don't need to. Like what are you backing up to?$400 for a 1T ssd or $80 fo a 2T usb3 spinny disk. If you are backing up while the db is being updated, you need to make sure updates are queued until t

Re: a back up question

On Tue, Dec 5, 2017 at 4:15 PM, Alvaro Herrera wrote: > Carl Karsten wrote: > > Nothing wrong with lots of tables and data. > > > > Don't impose any constraints on your problem you don't need to. > > > > Like what are you backing up to?$400 for a

Re: a back up question

On Tue, Dec 05, 2017 at 09:52:28PM +, Martin Mueller wrote: > Are there rules for thumb for deciding when you can dump a > whole database and when you’d be better off dumping groups of > tables? It seems to me we'd have to define the objective of "dumping" first ?

Re: a back up question

big deal. In that case I would stick to pg_dump, perhaps with directory format and then tarred and compressed, until you notice actual problems (unbearable slowdown of the machine during backup, running out of disk space). My 2 cents, Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

Re: How to know if a database has changed

ity at the end of some day. > How can it be done? Implement INSERT/UPDATE/DELETE/TRUNCATE triggers on all tables and DDL triggers on CREATE, ALTER, DROP, SECURITY LABEL, COMMENT, GRANT or REVOKE. Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

Re: pg_dump and logging

On Mon, Dec 11, 2017 at 01:51:59PM -0300, marcelo wrote: > When pg_dump runs on a database, is it warranted that the log is fully > impacted, or at least, taken into account for the dumping? As per the second sentence in the Description section of the Fine Manual. Karsten -- GPG

Re: How to know if a database has changed

didn't change will 'copy' almost instantly. I think OP wants to minimize the time spent during shutdown, not during the next day. Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

Re: Adding an extra boolean column to "information_schema.columns" or "pg_attribute"

IEW or dynamic SQL but I am > looking something different. Can you explain why ? One thing that comes to mind is complex user types. Or columns of type table. Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

Re: Use of Port 5433 with Postgresql 9.6

On Mon, Jan 01, 2018 at 05:42:28PM +, Graeme wrote: > If the default port for v9.6 is 5433, It is not. > why does the utility pg_isready still > default to searching for 5432? Which is why. Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD

Re: Equivalent shell script of create user and schema in specific postgres db

and password pass as argument. Like in a configuration file it will be > mentioned and in xyz.sh file will be access as $1 , $2 > > > What should be the equivalent shell script? This rather sounds like a homework assignment. What have you tried so far ? Regards, Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

Re: == PostgreSQL Weekly News - January 28 2018 ==

abu Kommi, reviewed at > various > times by Andreas Karlsson, Vaishnavi Prabakaran, and Robert Haas; further > hacking by me. Discussion: > > https://postgr.es/m/CAJrrPGcUurV0eWTeXODwsOYFN=ekq36t1s0ynfyunzsmrfd...@mail.gmail.com > > https://git.postgresql.org/pg/commitdiff/b3f8401205afdaf63cb20dc316d44644c933d5a1 ... am I right in assuming my use case (dumping/restoring databases with default_transaction_read_only=True) should still work without removing that setting beforehand ? Thanks, Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

<    1   2   3   >