ParseDateTime in src/backend/utils/adt/datetime.c

2018-05-03 Thread Vladimir Svedov
Hi guys, https://stackoverflow.com/questions/50153122/how-come-this-postgres-query-is-working Above guys are surprised by "ignore other punctuation but use as delimiter" part. Do you think this should be mentioned in docs? E.g.

Re: Racing DEADLOCK on PostgreSQL 9.3

2018-04-26 Thread Vladimir Svedov
try "Сombination of blocked and blocking activity" from https://wiki.postgresql.org/wiki/Lock_Monitoring - it should show you the originator. pg_stat_activity.waiting only show affected On 25 April 2018 at 19:56, Jerry Sievers wrote: > Nick Dro

Re: array_ndims never returns zero

2017-12-29 Thread Vladimir Svedov
t...@sss.pgh.pa.us>: > >> Vladimir Svedov <vode...@gmail.com> writes: >> > Reading >> > https://stackoverflow.com/questions/48022753/why-does-array- >> ndimsarray-produce-null#48022980 >> > confused me much - why array_ndims never returns zero indeed?.. >

Re: proposal: alternative psql commands quit and exit

2017-12-08 Thread Vladimir Svedov
I wonder if *exit;* to terminate loop be confused with exit psql in case of bad syntax. then instead of reporting error in plpgsql it would just silently exit?.. 2017-12-08 15:19 GMT+00:00 Tom Lane : > "David G. Johnston" writes: > > I'll agree