Re: PLPGSQL - extra column existence in trigger

2022-05-09 Thread Durumdara
Dear David! That was a very good idea! I have integrated it! :-) Priorly I had another idea: I made a DDL to extend the table with "add column if not exists" elements. But what you suggested is better. Thank you! Best wishes dd David G. Johnston ezt írta (időpont: 2022. máj. 7., Szo, 16:41):

Re: pg_dump: VACUUM and REINDEXING

2022-05-09 Thread Tom Lane
Laurenz Albe writes: > But from PostgreSQL v13 on, autovacuum is also triggered by INSERTs. > So I'd say that there is nothing to do after restoring a pg_dump, except > to wait until autovacuum is done. You might want to do manual VACUUM ANALYZE (no need for FULL) if you don't want to wait around

Need to install Postgres Version 14 in Linux server with Client and migration steps.

2022-05-09 Thread Rajamoorthy-CW, Thirumurugan 8361
Hi Team, I need to install Postgres Version 14 in Linux server with Client and migration steps. Can you please provide me the installation steps document ? Regards Thirumurugan Rajamoorthy - Biometrics Support

Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.

2022-05-09 Thread Sandeep Kumar Jakkaraju
Please email it help desk On Mon, 9 May 2022, 9:28 pm Rajamoorthy-CW, Thirumurugan 8361, < thirumurugan.rajamoorthy...@otsuka-us.com> wrote: > Hi Team, > > > > I need to install Postgres Version 14 in Linux server with Client and > migration steps. Can you please provide me the installation steps

Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.

2022-05-09 Thread Alan Hodgson
On Mon, 2022-05-09 at 06:46 +, Rajamoorthy-CW, Thirumurugan 8361 wrote: > Hi Team, >   > I need to install Postgres Version 14 in Linux server with Client > and migration steps. Can you please provide me the installation > steps document ? > PostgreSQL is kind of a do-it-yourself thing like a

Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.

2022-05-09 Thread Sandeep Kumar Jakkaraju
Sure, here it is. ith...@bimetrics.in On Mon, 9 May 2022, 9:39 pm Rajamoorthy-CW, Thirumurugan 8361, < thirumurugan.rajamoorthy...@otsuka-us.com> wrote: > What is the helpdesk email address ? please let me know. > > > > > > > > > > > > > > Regards > > Thirumurugan Rajamoorthy – Biometrics Support

Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.

2022-05-09 Thread Adrian Klaver
On 5/8/22 23:46, Rajamoorthy-CW, Thirumurugan 8361 wrote: Hi Team, I need to install Postgres Version 14 in Linux server with Client and migration steps. Can you please provide me the installation steps document ? You have not said what Linux distro, but here is link to installing software:

Set timeout just on a query?

2022-05-09 Thread Shaozhong SHI
Can timeout be set just on a query? Can we do the following? Begin do a query set timeout Exception report a record End; Regards, David

Re: Set timeout just on a query?

2022-05-09 Thread Bharath Rupireddy
On Tue, May 10, 2022 at 6:29 AM Shaozhong SHI wrote: > > > Can timeout be set just on a query? > > Can we do the following? > > Begin > > do a query > set timeout > Exception > report a record > > End; Won't the statement_timeout [1] help here? [1] https://www.postgresql.org/docs/devel/runtime-c

Question on cast string to date

2022-05-09 Thread 正华吕
Hi, I test the following SQL in pg15dev (seems same behavior as the previous version). select '2020701'::date; date 0202-07-01 (1 row) At the first glance, the result seems quite strange. Go through the code, postgres use date_in to do the cast, and firs

Re: Question on cast string to date

2022-05-09 Thread Pavel Stehule
út 10. 5. 2022 v 6:28 odesílatel 正华吕 napsal: > Hi, > > I test the following SQL in pg15dev (seems same behavior as the > previous version). > > select '2020701'::date; > date > > 0202-07-01 >(1 row) > >At the first glance, the result seems quite strange. >

Re: Question on cast string to date

2022-05-09 Thread Ian Lawrence Barwick
2022年5月10日(火) 13:28 正华吕 : > > Hi, > > I test the following SQL in pg15dev (seems same behavior as the previous > version). > > select '2020701'::date; > date > > 0202-07-01 >(1 row) > >At the first glance, the result seems quite strange. > >Go through th

Re: Question on cast string to date

2022-05-09 Thread Tom Lane
=?UTF-8?B?5q2j5Y2O5ZCV?= writes: > I test the following SQL in pg15dev (seems same behavior as the > previous version). > select '2020701'::date; > date > > 0202-07-01 >(1 row) >At the first glance, the result seems quite strange. [ shrug... ] You left out

Re: Question on cast string to date

2022-05-09 Thread David G. Johnston
On Monday, May 9, 2022, Tom Lane wrote: > =?UTF-8?B?5q2j5Y2O5ZCV?= writes: > > I test the following SQL in pg15dev (seems same behavior as the > > previous version). > > select '2020701'::date; > > date > > > > 0202-07-01 > >(1 row) > >At the first glance,

Re: Question on cast string to date

2022-05-09 Thread 正华吕
Thanks all. David G. Johnston 于2022年5月10日周二 13:41写道： > On Monday, May 9, 2022, Tom Lane wrote: > >> =?UTF-8?B?5q2j5Y2O5ZCV?= writes: >> > I test the following SQL in pg15dev (seems same behavior as the >> > previous version). >> > select '2020701'::date; >> > date >> >-

Re: Question on cast string to date

2022-05-09 Thread Tom Lane
"David G. Johnston" writes: > On Monday, May 9, 2022, Tom Lane wrote: >> If you want to pursue this question, you could start by bisecting >> to find just which commit changed it and why. > Manual history inspection of datetime.c > https://github.com/postgres/postgres/commit/7778ddc7a2d5b006edbf