Re: question on audit columns

| created_timestamp | updated_by_user | updated_timestamp | data -++-+---+-- vincent | 2024-09-05 19:17:53.446109 | postgres| 2024-09-05 19:24:01.19186 | def (1 row) -- Bien à vous, Vincent Veyron https://mari

Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres

works in SQLite, all you have to do is read those, and try to port; if it fails, read them again. Also search the archives of the pgsql-general list, many answers in there -- Bien à vous, Vincent Veyron https://compta.libremen.com Logiciel libre de compta

Re: running \copy through perl dbi ?

permissions so that the server may write the file, so I wonder what approach is cleaner? -- Bien à vous, Vincent Veyron https://marica.fr Logiciel de gestion des contentieux juridiques, des contrats et des sinistres d'assurance

Re: running \copy through perl dbi ?

permissions so that the server may write the file, so I wonder what approach is the most elegant? -- Bien à vous, Vincent Veyron https://marica.fr Logiciel de gestion des contentieux juridiques, des contrats et des sinistres d'assurance -- vv.lists

Re: running \copy through perl dbi ?

ame ) ; system( @args ) == 0 or die "Bad copy: $?" ; -- Bien à vous, Vincent Veyron https://marica.fr Logiciel de gestion des contentieux juridiques, des contrats et des sinistres d'assurance

Re: When Update balloons memory

On Tue, 14 Dec 2021 11:18:07 -0500 Tom Lane wrote: > > This leak is new in v14, possibly that's why Vincent didn't reproduce it. Indeed, I'm on v11 -- Bien à vous, Vincent Veyron https://marica.fr Gestion des contentieux juridi

Re: When Update balloons memory

icate on my Intel(R) Core(TM) i5 CPU M 520 @ 2.40GHz with 2Go of RAM time psql -c 'update part_main set txid = txid + 1' vv UPDATE 3100 real24m39.594s user0m0.121s sys 0m0.036s -- Bien à vous, Vincent Veyron https://marica.fr Ges

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

On Wed, 8 Dec 2021 17:07:27 + Shaozhong SHI wrote: > > Any good example? > Plenty of them in the fine documentation : https://www.postgresql.org/search/?q=coalesce -- Bien à vous, Vincent Veyron https://compta.libremen.com Logiciel

Re: Who altered the database?

ly the changes and have the web server log the info in its own logs? Apache has this directive : https://httpd.apache.org/docs/2.4/mod/mod_log_config.html#logformat -- Bien à vous, Vincent Veyron https://marica.fr/ Logiciel de suivi des contentieux ju

Re: How to implement expiration in PostgreSQL?

it also makes it easier to send reminders before the expiration date -- Bien à vous, Vincent Veyron https://marica.fr Logiciel de gestion des contentieux juridiques, des contrats et des sinistres d'assurance

Re: unexpected character used as group separator by to_char

M999G990D00'),E'\u202F', ' '), 'FM999G990D00'); to_number --- 1234.56 -- Bien à vous, Vincent Veyron https://compta.libremen.com Logiciel libre de comptabilité générale en partie double

Re: unexpected character used as group separator by to_char

On Tue, 09 Mar 2021 16:22:07 -0500 Tom Lane wrote: > The point here is that 'G' and related format codes act as specified by > your LC_MONETARY locale. If you don't like the results, you need to use > a different locale. This is a numeric(10,2) type field though. I tried casting it to money typ

Re: unexpected character used as group separator by to_char

to_char/to_number to manipulate numbers is much more appealing than writing my own parser in my front end. But this weird space is getting in my way. -- Bien à vous, Vincent Veyron https://marica.fr/ Logiciel de gestion des sinistres assurances, des dossiers contentieux et des contrats pour le service juridique

unexpected character used as group separator by to_char

tem | date | | not null | CURRENT_DATE libelle | text | | | debit | numeric(10,2) | | not null | 0 credit | numeric(10,2) | | not null | 0 lettrage| text | | | id_facture | integer | | not null | 0 -- Bien à vous, Vincent Veyron https://marica.fr/ Logiciel de gestion des sinistres assurances, des dossiers contentieux et des contrats pour le service juridique

Re: Same condition in the CTE and in the subsequent JOIN using it

OINwords_social s USING(uid) > WHERE s.social = in_social > AND s.sid = in_sid -- Bien à vous, Vincent Veyron https://compta.libremen.com Logiciel libre de comptabilité générale en partie double

Re: Windows XP to Win 10 migration issue

t would start postgresql with my rescued data folder. You might have better luck finding an old XP machine similar to your deceased one, installing postgresql on it, and using that to start your cluster. -- Bien à vous, Vincent Veyron https://marica.fr/ Logici