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

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

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

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

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

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

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