Re: Can we directly upgrade postgresql from 13 to 15.4

Στις 8/11/24 20:16, ο/η Christophe Pettus έγραψε: On Nov 8, 2024, at 10:12, jayesh thakare wrote: Can we upgrade postresql from 13 to 15.4 directly? Can we upgrade postgresql from 13 to 16 directly? Yes. Ideally how many major version can we jump to from older version ? There's no practi

Re: Plans for partitioning of inheriting tables

On 10/24/24 21:58, David G. Johnston wrote: On Thursday, October 24, 2024, wrote: Up to version 17, partitioning of tables inheriting from other tables is not possible. psql:../code_files/data_storage/PostgreSQL/tables/TOPO_FILES.pg_sql:68: ERROR:  no se puede crear u

Re: Regression in Postgres 17?

Στις 22/10/24 18:54, ο/η Colin 't Hart έγραψε: Hi, This works in Postgres 15: pg15> create function json_test(out value text, out json jsonb) returns record language sql as $$   select null::text, null::jsonb; $$ ; CREATE FUNCTION pg15> select * from json_test(); ┌───┬──┐ │ value │ jso

Re: Backup

Στις 16/10/24 23:02, ο/η Ron Johnson έγραψε: On Wed, Oct 16, 2024 at 4:00 PM Achilleas Mantzios wrote: Στις 16/10/24 22:55, ο/η Ron Johnson έγραψε: On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman wrote: I am very new to Postgres and have always worked in the mssql

Re: Backup

Στις 16/10/24 22:55, ο/η Ron Johnson έγραψε: On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman wrote: I am very new to Postgres and have always worked in the mssql world. I'm looking for suggestions on DB backups. I currently have a DB used to store Historical information that has imag

Re: What are best practices wrt passwords?

Στις 16/10/24 19:47, ο/η Tom Lane έγραψε: Bruce Momjian writes: On Wed, Oct 16, 2024 at 06:16:57PM +0200, mb...@mbork.pl wrote: `ps auxe` shows all processes with their environments, no? I think that only shows for super-user. I believe it depends on your platform --- some BSDen are pretty

Re: Strange permission effect depending on DEFERRABILITY

Στις 10/9/24 20:22, ο/η Laurenz Albe έγραψε: On Tue, 2024-09-10 at 12:20 +0300, Achilleas Mantzios - cloud wrote: On 9/10/24 00:09, Laurenz Albe wrote: On Mon, 2024-09-09 at 16:14 +0300, Achilleas Mantzios - cloud wrote: The below runs on PostgreSQL 16.4 We are trying to implement a certain

Re: Strange permission effect depending on DEFERRABILITY

On 9/10/24 00:09, Laurenz Albe wrote: On Mon, 2024-09-09 at 16:14 +0300, Achilleas Mantzios - cloud wrote: The below runs on PostgreSQL 16.4 We are trying to implement a certain operation based on a security definer function : mariner_update_availability_date This is supposed to update a

Re: postgresql FDW vs dblink for DDL

Στις 9/9/24 18:40, ο/η Tom Lane έγραψε: Adrian Klaver writes: On 9/9/24 03:24, Achilleas Mantzios - cloud wrote: And the thing is that this creation via DDL is inside our design. Certain users create some backup tables of the public data in their own schema (via our app), then do some

Re: Strange permission effect depending on DEFERRABILITY

On 9/9/24 17:21, Tom Lane wrote: Achilleas Mantzios - cloud writes: As you noticed the last trigger is a CONSTRAINT DEFERRABLE trigger. This function mariner_update_availability_date is supposed to be run by a user : cbt_results_import strippedof any privileges to the rest of the system. Here

Re: ssh to DB server and su normal users very slow :

On 9/9/24 16:18, KK CHN wrote: update :  the      ssh -v root@db_Server_IP from my Windows cmd   pasted below for more details Why is your windows cmd important here, show ssh debugging from your DB host to the pgbackrest host. On Mon, Sep 9, 2024 at 4:50 PM KK CHN wrote: List,

Strange permission effect depending on DEFERRABILITY

Dear List The below runs on PostgreSQL 16.4 We are trying to implement a certain operation based on a security definer function : mariner_update_availability_date This is supposed to update a table : mariner , which has several other triggers : mariner_build_natural_id_tg BEFORE INSERT OR

Re: postgresql FDW vs dblink for DDL

On 9/8/24 23:46, Adrian Klaver wrote: On 9/8/24 13:04, Achilleas Mantzios wrote: Hi for remote DDL execution (such as CREATE TABLE) is dblink my only option? You will need to define in what context you are considering options. For instance you can do remote DDL operations by passing a

postgresql FDW vs dblink for DDL

Hi for remote DDL execution (such as CREATE TABLE) is dblink my only option? thanks

Re: PostgreSQL Active-Active Clustering

nt rows on the same data page. -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)

Re: Can a long running procedure detect when smart shutdown is pending?

Στις 6/7/24 09:22, ο/η Pavel Stehule έγραψε: so 6. 7. 2024 v 8:19 odesílatel Pavel Stehule napsal: so 6. 7. 2024 v 8:06 odesílatel Achilleas Mantzios napsal: Στις 6/7/24 08:39, ο/η Pavel Stehule έγραψε: so 6. 7. 2024 v 1:36 odesílatel Dennis White

Re: Can a long running procedure detect when smart shutdown is pending?

own try to cancel any query. The plpgsql routine should be canceled without problems. fast mode will have this effect. smart mode not, from my testing. The running queries do not get interrupted in smart shutdown. Thanks On Fri, Jul 5, 2024 at 4:57 PM Achilleas Mantzios wrote:

Re: Can a long running procedure detect when smart shutdown is pending?

il against the log and then implement some logic using NOTIFY , ideally you want your procedure to be interrupted rather than do polling. Thanks, Dennis -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)

Re: Description field for tables and views

not sure how to populate it. am using PostgreSQL 13.xx in Debian. In addition to the COMMENT advised by PostgreSQL friends above, you might put your schema into some version control system, such as git, so you can have all the info : why something was added/changed, by whom, what for, etc.

Re: Autovacuum, dead tuples and bloat

with my verification? Thanks in advance & Best regards, Manuel -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)

Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34.

hi On 6/20/24 10:23, Dmitry O Litvintsev wrote: Hello, I am in the process of migrating DB to Alma9 host. The databse is rather large - few TBs. I have run pg_basebackup on Alma9 host and established replication from production to it. The idea is to quickly switch from master to this new host

Re: Is a VACUUM or ANALYZE necessary after logical replication?

ce part would be nice to be handled in a more elegant manner, e.g. by an option in pg_dump to dump only sequences, for "nearly zero" downtime upgrades, this step should happen rapidly at the switchover. Regards, Koen De Groote -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)

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

Στις 7/3/24 21:29, ο/η Adrian Klaver έγραψε: On 3/7/24 10:13, Achilleas Mantzios wrote: Στις 7/3/24 18:44, ο/η Robert Treat έγραψε: I am not talking for fun. I am talking about the future programmers of this world. Teaching Python or C to them upon arrival to the classes seems so wrong in

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

Στις 7/3/24 18:44, ο/η Robert Treat έγραψε: On Thu, Mar 7, 2024 at 11:26 AM Pavel Stehule wrote: čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus napsal: On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud wrote: So, I ask, have there been any efforts to bring PL/PGSQL to the terminal

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

Στις 7/3/24 18:25, ο/η Pavel Stehule έγραψε: čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus napsal: > On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud wrote: > So, I ask, have there been any efforts to bring PL/PGSQL to the terminal? Strictly speaki

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

Στις 7/3/24 17:13, ο/η Karsten Hilbert έγραψε: Am Thu, Mar 07, 2024 at 04:56:18PM +0200 schrieb Achilleas Mantzios - cloud: Python IMHO is too advanced, too rich, Python _is_ powerful but it needn't be difficult. weird indentation rules A matter of taste IMO. no simple for loop R

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

Hello I notice both my kids struggling with either C or Python as first programming languages. I believe both are unsuitable for use as introductory languages to college juniors. Python IMHO is too advanced, too rich, weird indentation rules, no simple for loop etc. C, ok, punishing little

Re: postgresql custom variable in pg_settings table

On 1/9/24 09:38, Yi Sun wrote: Hello, We custom set variable Added patroni.nodes_count = 2 in postgresql.conf postgres=# show patroni.nodes_count;  patroni.nodes_count -  2 (1 row) postgres=# select current_setting('patroni.nodes_count');  current_setting

Re: Removing oids with pg_repack

Στις 27/11/23 16:51, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 12:38:54 PM EST, Achilleas Mantzios wrote: Στις 22/11/23 15:14, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios <mailto:a.mantz...@cloud.gatewaynet.com> wrote: Στις

Re: Removing oids with pg_repack

Στις 22/11/23 15:14, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios wrote: Στις 21/11/23 20:41, ο/η CG έγραψε: I have a very large PostgreSQL 9.5 database that still has very large tables with oids. I'm trying to get rid of the oids with as l

Re: Removing oids with pg_repack

or a 2TB table conversion) : https://www.percona.com/blog/performing-etl-using-inheritance-in-postgresql/ CG -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: pgBackRest on old installation

file, but if you give password on the command line or env variable then you give this info to all users in the system. On Mon, Nov 20, 2023 at 4:16 PM Achilleas Mantzios - cloud wrote: On 11/20/23 12:31, KK CHN wrote: list, I am trying pgBackRest on an RHEL 7.6 and old EDB

Re: pgBackRest on old installation

On 11/20/23 12:31, KK CHN wrote: list, I am trying pgBackRest on an RHEL 7.6 and old EDB 10 database cluster( a legacy application.) I have installed pgbackrest through  package install on RHEL7.6 But unable to get the basic stanza-creation working It throws an error. * /etc/pgbackrest.con

Re: Getting most records possibly from an Inner/Left Join

the community can understand and refrain from giving external links for downloading files. Many people won't click on your URL or hit the download button. ... -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

as well, I have to say. PostgreSQL was presented as catching up MySQL in terms of usage/growth. In some future similar events I'd love to prepare a better and more current presentation for the local Greek community! Στις 23/10/23 14:45, ο/η Achilleas Mantzios - cloud έγραψε: Hello All i

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 19:58, ο/η Achilleas Mantzios έγραψε: Στις 23/10/23 19:54, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios wrote: I find PostgreSQL inheritance a great feature. The caveats are the same since a long time, nothing changed in that regard, but as you say, the

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 20:06, ο/η Laurenz Albe έγραψε: On Mon, 2023-10-23 at 19:49 +0300, Achilleas Mantzios wrote: Tom Lane wrote:  But there are valid use-cases where you actually do want more columns in the child tables than the parent. also data departmentalization, consolidation, multi-tenancy

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 19:54, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios wrote: I find PostgreSQL inheritance a great feature. The caveats are the same since a long time, nothing changed in that regard, but as you say, the implementation/limitations exist in native table partitioning

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 17:07, ο/η Christophe Pettus έγραψε: On Oct 23, 2023, at 04:45, Achilleas Mantzios - cloud wrote: I believe this text is false on too many accounts. So, what's the consensus about Inheritance in PostgreSQL, I am going to give a talk on it in November and I wouldn'

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 17:01, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios - cloud wrote: I believe this text is false on too many accounts. So, what's the consensus about Inheritance in PostgreSQL, I am going to give a talk on it in November and I wouldn't like to adverti

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 17:35, ο/η Tom Lane έγραψε: Achilleas Mantzios - cloud writes: someone added this section about inheritance : Don't use table inheritance That's one person's opinion. (Well, they're not alone in it, but it's just an opinion not a considered communi

PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Hello All in the wiki above and specifically in this commit : https://wiki.postgresql.org/index.php?title=Don%27t_Do_This&type=revision&diff=33210&oldid=33082 someone added this section about inheritance : " Don't use table inheritance Don't use table inheritance

Re: Presentation tools used ?

Thank you All people!

Re: Presentation tools used ?

Στις 22/10/23 10:06, ο/η Matthias Apitz έγραψε: El día domingo, octubre 22, 2023 a las 08:50:10a. m. +0300, Achilleas Mantzios escribió: Hello All I am going to give a talk about PostgerSQL, so I'd like to ask you people what do you use for your presentations, also I have no idea ho

Presentation tools used ?

s and libreoffice Impress.  What tools would you suggest ? What's your setup ? Thank you! Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: pg_basebackup / recovery

Στις 13/4/23 01:31, ο/η Michael Paquier έγραψε: On Wed, Apr 12, 2023 at 01:45:56PM +0300, Achilleas Mantzios - cloud wrote: On 4/12/23 12:32, Fabrice Chapuis wrote: During recovery process of a self contained backup, how postgres know to stop reading wal when consistency is reached? Because

Re: pg_basebackup / recovery

On 4/12/23 12:32, Fabrice Chapuis wrote: During recovery process of a self contained backup, how postgres know to stop reading wal when consistency is reached? Because it knows the full packup info. It will observe the STOP WAL LOCATION: 3BC7/4B000130 (file 00023BC7004B) inside

Re: Guidance on INSERT RETURNING order

lect i.id from i order by id; +1 for this version! Sorry for the long email, Thanks Federico -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: doc sql-grant.html Synopsis error?

EMA twice ? -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: PostgreSQL vs MariaDB

On 3/28/23 06:44, Thomas Guyot wrote: On 2023-03-24 07:07, Inzamam Shafiq wrote: Hi Team, Hope you are doing well. Can someone please list pros and cons of MariaDB vs PostgreSQL that actually needs serious consideration while choosing the right database for large OLTP DBs (Terabytes)?

Re: PostgreSQL vs MariaDB

some commercial DBs lack. Thanks. Regards, /Inzamam Shafiq/ /Sr. DBA/ -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

On 19/7/22 20:32, Adrian Klaver wrote: On 7/19/22 10:26 AM, Achilleas Mantzios wrote: Thank you Adrian! Actually thank: https://sqlformat.darold.net/ Στις 19/7/22 18:36, ο/η Adrian Klaver έγραψε: On 7/19/22 03:38, Achilleas Mantzios wrote: I reformatted queries to see thing better

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

On 19/7/22 20:31, David G. Johnston wrote: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: Thanks David Στις 19/7/22 17:19, ο/η David G. Johnston έγραψε: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: ERROR:  cannot convert infinity to numeric

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Thank you Adrian! Στις 19/7/22 18:36, ο/η Adrian Klaver έγραψε: On 7/19/22 03:38, Achilleas Mantzios wrote: I reformatted queries to see thing better. -- still has problem testing the range select it.id ,cept.value::numeric as val, numrange(ceptl.min_alarm::numeric,ceptl.max_alarm

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Στις 19/7/22 17:23, ο/η Tom Lane έγραψε: "David G. Johnston" writes: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: ERROR: cannot convert infinity to numeric The column cept.value contains an infinity. I see nothing unusual in any of these queries given that fact. If

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Thanks David Στις 19/7/22 17:19, ο/η David G. Johnston έγραψε: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: ERROR:  cannot convert infinity to numeric -- has no problem testing against infinity select it.id <http://it.id> ,cept.value::numeric as val, nu

pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

s it, cept_report cept , dynacom.vessels vsl, machdefs md, cept_reportli mits ceptl where it.id=cept.id AND md.defid=ceptl.defid AND it.defid=md.defid AND it.vslwhid=vsl.id AND vsl.vs lstatus='Active' and md.application = 'Critical Equipment Performance Test' AND cept.systemdate>= (now()-'1 ye ar'::interval)  ORDER BY 1) select * from bar where NOT range @> val; -- good data here -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: What do you guys use for issue tracking, CI/CD and team management? any nice open source options?

On 16/4/22 6:39 π.μ., Michael Paquier wrote: On Thu, Apr 14, 2022 at 06:19:44PM +0300, Achilleas Mantzios wrote: What issue/bug tracking is PostgreSQL itself using? What continuous build system (CI/CD) is PostgreSQL itself using? Any tool that you ppl or the PostgreSQL infrastructure use that

What do you guys use for issue tracking, CI/CD and team management? any nice open source options?

/push, manages issues/projects/people ? I know I am asking a lot, any help welcome, thanks! -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: Refresh ONE publication out of the Two Publications the Subscription has

Στις 4/1/22 5:47 μ.μ., ο/η Avi Weinberg έγραψε: Is it possible to specify the publication name to be refreshed in case I do not want to refresh all publications of the subscription? Something like: alter subscription subscription_name refresh publication publication_name Here is the method:

Re: Visibility of data from table inherits function

Στις 2/1/22 2:23 μ.μ., ο/η ourdiaspora έγραψε: Recipients, A table was created: CREATE TABLE exampletable ( name varchar(200) ); Table 'exampletable' _already_ contains data, e.g. 'Jane Bloggs' A new table was created with inheritance of 'exampletable': Please could someone explain why the

Re: Postgresql + containerization possible use case

Thank you Rainer, I'll have to play a little bit myself, and read some serious docs about it, in order to fully comprehend your thoughts. I'll revisit your positions I hope. On 13/12/21 5:11 μ.μ., Rainer Duffner wrote: Am 13.12.2021 um 12:41 schrieb Achilleas Mantzios

Re: Postgresql + containerization possible use case

On 13/12/21 5:55 μ.μ., Adrian Klaver wrote: On 12/13/21 03:41, Achilleas Mantzios wrote: Hi Rainer, On 13/12/21 11:50 π.μ., Rainer Duffner wrote: So Docker is NOT free? Please share your thoughts? I am a complete noob. Take a look here: https://www.docker.com/pricing Thank you Adrian

Re: Postgresql + containerization possible use case

ion of pgsql on the ships. So apps are much more frequently upgraded than the system of pgsql. I will check out rolling upgrades with kubernetes. (are we talking BDR here?) On Mon, Dec 13, 2021, 11:03 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: Hi Berto,

Re: Postgresql + containerization possible use case

Hi Berto, On 13/12/21 3:03 μ.μ., Bèrto ëd Sèra wrote: On Mon, 13 Dec 2021 at 12:41, Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: Hmm, I don't know about that. The hardware is given (existing) and limited. You are like the 2nd person who warned about com

Re: Postgresql + containerization possible use case

Hi Rainer, On 13/12/21 11:50 π.μ., Rainer Duffner wrote: Am 10.12.2021 um 13:01 schrieb Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>>: On 10/12/21 1:24 μ.μ., o1bigtenor wrote: On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com&g

Re: Postgresql + containerization possible use case

ubles because of unreliable system setup in the past, that I'd hate to repeat the same (or similar) mistakes again. -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: Postgresql + containerization possible use case

Hi Michael, Adrian On 10/12/21 11:28 μ.μ., Adrian Klaver wrote: On 12/10/21 12:06, Michael Lewis wrote: On Fri, Dec 10, 2021, 2:24 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:     Hi     we are running some 140 remote servers (in the 7 seas via satellite     conne

Re: Postgresql + containerization possible use case

Hi Adrian On 10/12/21 6:01 μ.μ., Adrian Klaver wrote: On 12/10/21 01:24, Achilleas Mantzios wrote: Hi The idea for future upgrades is to containerize certain aspects of the software. The questions are (I am not skilled in docker, only minimal contact with lxd) : - is this a valid use

Re: Postgresql + containerization possible use case

all of what you paid for it. I have pile of software installed on my main use system - - - I'm looking for good stuff that works and far too much stuff in the programming world is hype and not function!!) Thanks, this is more than true. Regards -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: Postgresql + containerization possible use case

On 10/12/21 1:24 μ.μ., o1bigtenor wrote: On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: Hi we are running some 140 remote servers (in the 7 seas via satellite connections), and in each one of them we run: - jboss - post

Re: What is the best way to redefine a trigger? (lock issue)

On 10/12/21 12:56 μ.μ., Marc Mamin wrote: > >-Original Message- >From: Achilleas Mantzios >Sent: Freitag, 10. Dezember 2021 11:36 >To: pgsql-general@lists.postgresql.org >Subject: Re: What is the best way to redefine a trigger? (lock issue)

Re: What is the best way to redefine a trigger? (lock issue)

UPDATE "BlockedItemAO" SET >>"blockedItem" = blockedItemLevel, >>"modificationDate" = now() >>WHERE "SeenPosRef" = NEW."id"; >>ELSE &g

Re: What is the best way to redefine a trigger? (lock issue)

t;id"; ELSE DELETE FROM "BlockedItemAO" WHERE "SeenPosRef" = NEW."id"; END IF; RETURN NEW; END; $BODY$ LANGUAGE plpgsql COST 100; DROP TRIGGER IF EXISTS block_item_cancel ON "SeenPosDO"; CREATE TRIGGER block_item_cancel AFTER UPDATE OF "quantityCanceled" ON "SeenPosDO" FOR EACH ROW WHEN ( NEW."providerRef" <> 1 AND ( NEW."quantityCanceled" IS DISTINCT FROM OLD."quantityCanceled" ) ) EXECUTE PROCEDURE block_item_cancel(); -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Postgresql + containerization possible use case

exactly the business as far data transfers and emails are concerned. It would be hard to uniformly manage data transfers and emails in/out in a plain TCP/IP setup (rsync, ftp, etc, sendmail/exim4/postfix or other MTA). -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: Require details that how to find user creation date in postgresql Database

any damage caused by any virus transmitted by this email. Thank you for your cooperation. -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: case insensitive collation of Greek's sigma

gree with you all of them should be deducted to a single letter s. Firefox's find recognizes all three (Σ,σ,ς) as the same letter. Thanks, - jj -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: function difference not found

On 25/11/21 6:12 μ.μ., Shaozhong SHI wrote: Function difference not found. Should an extension created for finding it? fuzzystrmatch Regards, David -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: get last timestamp of table ddl

a smarter way to achieve this in PostgreSQL than simply relying on logs and commit timestamps? You mean like trying to correlate pg_class.xmin with some timestamp via track_commit_timestamp or other means? Luca -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

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

Στις 5/6/21 10:12 μ.μ., ο/η Adrian Klaver έγραψε: On 6/5/21 10:39 AM, Achilleas Mantzios wrote: Στις 5/6/21 8:03 μ.μ., ο/η Adrian Klaver έγραψε: On 6/5/21 9:56 AM, Achilleas Mantzios wrote: Στις 5/6/21 6:34 μ.μ., ο/η Adrian Klaver έγραψε: On 6/5/21 2:49 AM, Achilleas Mantzios wrote

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

Στις 5/6/21 8:03 μ.μ., ο/η Adrian Klaver έγραψε: On 6/5/21 9:56 AM, Achilleas Mantzios wrote: Στις 5/6/21 6:34 μ.μ., ο/η Adrian Klaver έγραψε: On 6/5/21 2:49 AM, Achilleas Mantzios wrote: Hello I am imagining a system that can parse papers from various sources (web/files/etc) and in

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

) with postgresql. On Sat, 5 Jun 2021 at 5:14 PM Laura Smith <mailto:n5d9xq3ti233xiyif...@protonmail.ch>> wrote: Sent with ProtonMail Secure Email. ‐‐‐ Original Message ‐‐‐ On Saturday, 5 June 2021 12:14, Achilleas Mantzios mailto:ach...@matrix.gatewaynet.co

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

Στις 5/6/21 6:34 μ.μ., ο/η Adrian Klaver έγραψε: On 6/5/21 2:49 AM, Achilleas Mantzios wrote: Hello I am imagining a system that can parse papers from various sources (web/files/etc) and in various formats (text, pdf, etc) and can store metadata for this paper ,some kind of global ID if

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

Στις 5/6/21 1:52 μ.μ., ο/η Laura Smith έγραψε: ‐‐‐ Original Message ‐‐‐ On Saturday, 5 June 2021 10:49, Achilleas Mantzios wrote: Hello I am imagining a system that can parse papers from various sources (web/files/etc) and in various formats (text, pdf, etc) and can store metadata

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

Hello I am imagining a system that can parse papers from various sources (web/files/etc) and in various formats (text, pdf, etc) and can store metadata for this paper ,some kind of global ID if applicable, authors, areas of research, whether the paper is "new", "highlighted", "historical", ty

Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?

On 2/10/20 2:08 π.μ., tutilu...@tutanota.com wrote: On Thu, Sep 24, 2020 at 10:40 PM mailto:tutilu...@tutanota.com>> wrote: Well not partial as in incremental. Instead dump only some portion of the schema with or without its associated data. It's funny tha

Re: Doubt in pgbouncer

transaction mode (some PR's were rejected because of that). You might find this interesting : https://github.com/awslabs/pgbouncer-rr-patch regards, fabio pardi -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Creating many tables gets logical replication stuck

created the very same problem during the latest attempts for reproduction but I did not focus on this scenario. The walsender process can get stuck. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: pgbouncer bug?

On 21/8/20 7:56 μ.μ., greigwise wrote: Not sure if this is the right place to post this, but if not someone please point me in the right direction. My issue is with pgbouncer 1.14. This does not seem to happen on 1.13. If I do a service pgbouncer restart, then anytime I try to connect to my

Re: Creating many tables gets logical replication stuck

-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Multitenent architecture

/multitenancy-options-postgresql Thank you so much all. Regards, Vasu -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Oracle vs. PostgreSQL - a comment

On 5/6/20 5:19 μ.μ., Thomas Kellerer wrote: Achilleas Mantzios schrieb am 05.06.2020 um 14:05: Plus PG does not directly support cross database queries using 3 part name, something sqlserver excels at. Maybe because SQL server does not have real databases but schemas instead ? This sucks

Re: Oracle vs. PostgreSQL - a comment

versions they solved this problem by the failover group concept which failovers all inter-related databases at one go. BTW Mysql treats databases and schemas as same (that's what it was few years ago) -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Oracle vs. PostgreSQL - a comment

part name, something sqlserver excels at. Maybe because SQL server does not have real databases but schemas instead ? This sucks security wise. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: serie of serie

On 18/4/20 10:18 π.μ., Olivier Leprêtre wrote: Hi, I would like to generate a serie of serie and didn’t find how.  With generate_series. I can generate a serie 1 1 1 2 2 2 3 3 3 But how can I repeat this serie several times ? 1 1 1 2 2 2 3 3 3 1 with foo as (select flo

Re: easy way to acquire height / width from images (PNG, JPEG) stored as bytea?

tackoverflow.com/questions/33602308/how-to-check-png-file-if-its-a-decompression-bomb Regards,  Imre Thank you  a lot Imre. Great info. Achilleas Mantzios <mailto:ach...@matrix.gatewaynet.com>> ezt írta (időpont: 2020. ápr. 17., P, 16:39): On 17/4/20 4:09 μ.μ., Adam Brussel

Re: easy way to acquire height / width from images (PNG, JPEG) stored as bytea?

On 17/4/20 5:47 μ.μ., Steve Atkins wrote: If running an extension crashed your server you should look at how / why, especially if it corrupted your filesystem. That shouldn't happen on a correctly configured system, so the underlying issue might cause you other problems. Crashing postgresql,

Re: easy way to acquire height / width from images (PNG, JPEG) stored as bytea?

On 17/4/20 4:09 μ.μ., Adam Brusselback wrote: Why not extract and store that metadata with the image rather than trying to extract it to filter on at query time? That way you can index your height and width columns to speed up that filtering if necessary. Yes I thought of that, but those are

easy way to acquire height / width from images (PNG, JPEG) stored as bytea?

Hello Dear List, we have a table holding email attachments as bytea, and we would like to filter out images of small dimensions, which are not of any value to our logic. I took a look at pg_image extension, tested it, and it proved problematic, it killed my 200+ days uptime FreeBSD box :( .

Re: strange locks on PG 11 with Golang programs

reSQL but in golang libraries? Thank you for any suggestions Josef Machytka Berlin -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

  1   2   3   >