search

BrightcoveOS / Diamond

1.18k stars 384 forks source link

Fixed regex of WalSegmentStats #879

Closed sw0x2A closed 7 years ago

sw0x2A commented 7 years ago

Regex pattern '^[0-9A-Z]{{24}}\$' is causing the following warning and result of query is always 0 on Postgresql 9.4-9.6.

HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of escape in a string literal at character 97

This change fixes the query. AFAICS this fix should not break with earlier versions of Postgresql but I could not test it.

r3cgm commented 7 years ago

Hi sw0x2A,

Sorry to hear about your regex issues. Note however this project has been discontinued and is now being maintained here: https://github.com/python-diamond

It may be your issue has already been resolved at the new location. Good luck!