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. https://www.postgresql.org/docs/current/static/functions-formatting.htm

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 writes: > > > Hi, > > I have a stock table. > > >

Re: array_ndims never returns zero

2017-12-29 Thread Vladimir Svedov
Maybe if you decide not to touch the code, I should report to documentation mail group, asking to add this special exception to docs?.. Thank you On 29 December 2017 at 19:50, Pavel Stehule wrote: > > > 2017-12-29 17:52 GMT+01:00 Tom Lane : > >> Vladimir Svedov writes: >&

array_ndims never returns zero

2017-12-29 Thread Vladimir Svedov
Hi, Reading https://stackoverflow.com/questions/48022753/why-does-array-ndimsarray-produce-null#48022980 confused me much - why array_ndims never returns zero indeed?.. select char_length('') returns zero and according to https://www.postgresql.org/docs/current/static/functions-string.html it shows

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 that exiting the program is a special case that mer