Bug #77047 [Opn->Csd]: pg_convert has a broken regex for the 'TIME WITHOUT TIMEZONE' data type

Edit report at https://bugs.php.net/bug.php?id=77047&edit=1 ID: 77047 Updated by: ab@php.net Reported by: andy at gajetzki dot com Summary: pg_convert has a broken regex for the 'TIME WITHOUT TIMEZONE' data type -Status: Open +Status: Closed Type: Bug Package: PostgreSQL related Operating System: Linux PHP Version: 7.1.23 Block user comment: N Private report: N New Comment: Automatic comment on behalf of andy@gajetzki.com Revision: http://git.php.net/?p=php-src.git;a=commit;h=369c991d5cbb0e606ec1106697925d6d958cc4bf Log: FIX #77047: fixes regex for "time" data type Previous Comments: ------------------------------------------------------------------------ [2018-10-22 14:48:28] andy at gajetzki dot com Description: ------------ While using pg_insert, it was discovered that any values other than empty strings and null cannot be inserted into fields having the 'time without timezone' data type. Expected result: ---------------- Data should be inserted without error Actual result: -------------- pg_insert(): Cannot compile regex in xxx.php on line yy PHP Notice: pg_insert(): Expects NULL or string for PostgreSQL time field (occurrence_time) in xxx.php on line yy ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=77047&edit=1