{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/19337","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/19337/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/19337/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/19337/events","html_url":"https://github.com/cockroachdb/cockroach/issues/19337","id":266421554,"number":19337,"title":"Compatibility with Doctrine/Symfony","user":{"login":"knz","id":642886,"avatar_url":"https://avatars3.githubusercontent.com/u/642886?v=4","gravatar_id":"","url":"https://api.github.com/users/knz","html_url":"https://github.com/knz","followers_url":"https://api.github.com/users/knz/followers","following_url":"https://api.github.com/users/knz/following{/other_user}","gists_url":"https://api.github.com/users/knz/gists{/gist_id}","starred_url":"https://api.github.com/users/knz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/knz/subscriptions","organizations_url":"https://api.github.com/users/knz/orgs","repos_url":"https://api.github.com/users/knz/repos","events_url":"https://api.github.com/users/knz/events{/privacy}","received_events_url":"https://api.github.com/users/knz/received_events","type":"User","site_admin":false},"labels":[{"id":464498682,"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/pg-compat","name":"pg-compat","color":"22aa88","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/3","html_url":"https://github.com/cockroachdb/cockroach/milestone/3","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/3/labels","id":1298443,"number":3,"title":"Later","description":"","creator":{"login":"BramGruneir","id":1614265,"avatar_url":"https://avatars1.githubusercontent.com/u/1614265?v=4","gravatar_id":"","url":"https://api.github.com/users/BramGruneir","html_url":"https://github.com/BramGruneir","followers_url":"https://api.github.com/users/BramGruneir/followers","following_url":"https://api.github.com/users/BramGruneir/following{/other_user}","gists_url":"https://api.github.com/users/BramGruneir/gists{/gist_id}","starred_url":"https://api.github.com/users/BramGruneir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BramGruneir/subscriptions","organizations_url":"https://api.github.com/users/BramGruneir/orgs","repos_url":"https://api.github.com/users/BramGruneir/repos","events_url":"https://api.github.com/users/BramGruneir/events{/privacy}","received_events_url":"https://api.github.com/users/BramGruneir/received_events","type":"User","site_admin":false},"open_issues":556,"closed_issues":162,"state":"open","created_at":"2015-09-09T21:24:17Z","updated_at":"2018-02-08T20:54:41Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2017-10-18T09:25:03Z","updated_at":"2018-02-09T07:16:08Z","closed_at":null,"author_association":"OWNER","body":"So I have been iterating for a while with the folk at https://github.com/radutopala/cockroach-app/issues/3#issuecomment-337453864 who are checking compatibility between CockroachDB and [Symfony](http://symfony.com/) (PHP web framework) with [Doctrine](http://www.doctrine-project.org/) (PHP ORM).\r\n\r\nThe latest news is a full pg-side trace of how this software stack talks to a pg server:\r\n\r\n```\r\n2017-10-18 03:55:18 UTC [9282-1] postgres@postgres LOG:  execute <unnamed>: SET NAMES 'UTF8'\r\n2017-10-18 03:55:18 UTC [9282-2] postgres@postgres LOG:  statement: CREATE DATABASE \"symfony\"\r\n2017-10-18 03:55:24 UTC [9287-1] postgres@symfony LOG:  execute <unnamed>: SET NAMES 'UTF8'\r\n2017-10-18 03:55:24 UTC [9287-2] postgres@symfony LOG:  execute <unnamed>: SELECT schema_name AS nspname\r\n\t                FROM   information_schema.schemata\r\n\t                WHERE  schema_name NOT LIKE 'pg_%'\r\n\t                AND    schema_name != 'information_schema'\r\n2017-10-18 03:55:24 UTC [9287-3] postgres@symfony LOG:  execute <unnamed>: SELECT sequence_name AS relname,\r\n\t                       sequence_schema AS schemaname\r\n\t                FROM   information_schema.sequences\r\n\t                WHERE  sequence_schema NOT LIKE 'pg_%'\r\n\t                AND    sequence_schema != 'information_schema'\r\n2017-10-18 03:55:24 UTC [9287-4] postgres@symfony LOG:  execute <unnamed>: SELECT quote_ident(table_name) AS table_name,\r\n\t                       table_schema AS schema_name\r\n\t                FROM   information_schema.tables\r\n\t                WHERE  table_schema NOT LIKE 'pg_%'\r\n\t                AND    table_schema != 'information_schema'\r\n\t                AND    table_name != 'geometry_columns'\r\n\t                AND    table_name != 'spatial_ref_sys'\r\n\t                AND    table_type != 'VIEW'\r\n2017-10-18 03:55:24 UTC [9287-5] postgres@symfony LOG:  execute <unnamed>: SHOW search_path\r\n2017-10-18 03:55:24 UTC [9287-6] postgres@symfony LOG:  execute <unnamed>: SHOW search_path\r\n2017-10-18 03:55:24 UTC [9287-7] postgres@symfony LOG:  execute <unnamed>: SELECT schema_name AS nspname\r\n\t                FROM   information_schema.schemata\r\n\t                WHERE  schema_name NOT LIKE 'pg_%'\r\n\t                AND    schema_name != 'information_schema'\r\n2017-10-18 03:55:24 UTC [9287-8] postgres@symfony LOG:  execute <unnamed>: SELECT sequence_name AS relname,\r\n\t                       sequence_schema AS schemaname\r\n\t                FROM   information_schema.sequences\r\n\t                WHERE  sequence_schema NOT LIKE 'pg_%'\r\n\t                AND    sequence_schema != 'information_schema'\r\n2017-10-18 03:55:24 UTC [9287-9] postgres@symfony LOG:  execute <unnamed>: SELECT quote_ident(table_name) AS table_name,\r\n\t                       table_schema AS schema_name\r\n\t                FROM   information_schema.tables\r\n\t                WHERE  table_schema NOT LIKE 'pg_%'\r\n\t                AND    table_schema != 'information_schema'\r\n\t                AND    table_name != 'geometry_columns'\r\n\t                AND    table_name != 'spatial_ref_sys'\r\n\t                AND    table_type != 'VIEW'\r\n2017-10-18 03:55:24 UTC [9287-10] postgres@symfony LOG:  execute <unnamed>: SHOW search_path\r\n2017-10-18 03:55:24 UTC [9287-11] postgres@symfony LOG:  execute <unnamed>: SHOW search_path\r\n2017-10-18 03:55:24 UTC [9287-12] postgres@symfony LOG:  execute <unnamed>: CREATE SEQUENCE automailer_id_seq INCREMENT BY 1 MINVALUE 1 START 1\r\n2017-10-18 03:55:24 UTC [9287-13] postgres@symfony LOG:  execute <unnamed>: CREATE TABLE automailer (id INT NOT NULL, from_email VARCHAR(255) NOT NULL, from_name VARCHAR(255) NOT NULL, to_email VARCHAR(255) NOT NULL, subject TEXT NOT NULL, body TEXT NOT NULL, alt_body TEXT NOT NULL, swift_message TEXT NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, sent_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, started_sending_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, is_html BOOLEAN NOT NULL, is_sending BOOLEAN DEFAULT NULL, is_sent BOOLEAN DEFAULT NULL, is_failed BOOLEAN DEFAULT NULL, PRIMARY KEY(id))\r\n2017-10-18 03:55:24 UTC [9287-14] postgres@symfony LOG:  execute <unnamed>: CREATE INDEX find_next ON automailer (is_sent, is_failed, is_sending, created_at)\r\n2017-10-18 03:55:24 UTC [9287-15] postgres@symfony LOG:  execute <unnamed>: CREATE INDEX recover_sending ON automailer (is_sending, started_sending_at)\r\n```\r\n\r\nof interest:\r\n\r\n1) it wants `quote_ident()` - #15006 cc @jordanlewis @justinj \r\n2) it wants sequences - #5811 #19196 with various options, cc @vilterp \r\n"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/364354731","html_url":"https://github.com/cockroachdb/cockroach/issues/19337#issuecomment-364354731","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/19337","id":364354731,"user":{"login":"lemonCMS","id":4980003,"avatar_url":"https://avatars3.githubusercontent.com/u/4980003?v=4","gravatar_id":"","url":"https://api.github.com/users/lemonCMS","html_url":"https://github.com/lemonCMS","followers_url":"https://api.github.com/users/lemonCMS/followers","following_url":"https://api.github.com/users/lemonCMS/following{/other_user}","gists_url":"https://api.github.com/users/lemonCMS/gists{/gist_id}","starred_url":"https://api.github.com/users/lemonCMS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lemonCMS/subscriptions","organizations_url":"https://api.github.com/users/lemonCMS/orgs","repos_url":"https://api.github.com/users/lemonCMS/repos","events_url":"https://api.github.com/users/lemonCMS/events{/privacy}","received_events_url":"https://api.github.com/users/lemonCMS/received_events","type":"User","site_admin":false},"created_at":"2018-02-09T07:16:08Z","updated_at":"2018-02-09T07:16:08Z","author_association":"NONE","body":"Hello,\r\n\r\nI also noticed when trying to change a column, doctrine wants the function ````string_to_array````\r\n````sql\r\n  An exception occurred while executing 'SELECT                                                                                                                                                                                                                                  \r\n                      a.attnum,                                                                                                                                                                                                                                                  \r\n                      quote_ident(a.attname) AS field,                                                                                                                                                                                                                           \r\n                      t.typname AS type,                                                                                                                                                                                                                                         \r\n                      format_type(a.atttypid, a.atttypmod) AS complete_type, (SELECT tc.collcollate FROM pg_catalog.pg_collation tc WHERE tc.oid = a.attcollation) AS collation,                                                                                                 \r\n                      (SELECT t1.typname FROM pg_catalog.pg_type t1 WHERE t1.oid = t.typbasetype) AS domain_type,                                                                                                                                                                \r\n                      (SELECT format_type(t2.typbasetype, t2.typtypmod) FROM                                                                                                                                                                                                     \r\n                        pg_catalog.pg_type t2 WHERE t2.typtype = 'd' AND t2.oid = a.atttypid) AS domain_complete_type,                                                                                                                                                           \r\n                      a.attnotnull AS isnotnull,                                                                                                                                                                                                                                 \r\n                      (SELECT 't'                                                                                                                                                                                                                                                \r\n                       FROM pg_index                                                                                                                                                                                                                                             \r\n                       WHERE c.oid = pg_index.indrelid                                                                                                                                                                                                                           \r\n                          AND pg_index.indkey[0] = a.attnum                                                                                                                                                                                                                      \r\n                          AND pg_index.indisprimary = 't'                                                                                                                                                                                                                        \r\n                      ) AS pri,                                                                                                                                                                                                                                                  \r\n                      (SELECT pg_get_expr(adbin, adrelid)                                                                                                                                                                                                                        \r\n                       FROM pg_attrdef                                                                                                                                                                                                                                           \r\n                       WHERE c.oid = pg_attrdef.adrelid                                                                                                                                                                                                                          \r\n                          AND pg_attrdef.adnum=a.attnum                                                                                                                                                                                                                          \r\n                      ) AS default,                                                                                                                                                                                                                                              \r\n                      (SELECT pg_description.description                                                                                                                                                                                                                         \r\n                          FROM pg_description WHERE pg_description.objoid = c.oid AND a.attnum = pg_description.objsubid                                                                                                                                                         \r\n                      ) AS comment                                                                                                                                                                                                                                               \r\n                      FROM pg_attribute a, pg_class c, pg_type t, pg_namespace n                                                                                                                                                                                                 \r\n                      WHERE n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND c.relname = 'pages' AND n.nspname = ANY(string_to_array((select replace(replace(setting,'\"$user\"',user),' ','') from pg_catalog.pg_settings where name = 'search_path'),','))  \r\n                          AND a.attnum > 0                                                                                                                                                                                                                                       \r\n                          AND a.attrelid = c.oid                                                                                                                                                                                                                                 \r\n                          AND a.atttypid = t.oid                                                                                                                                                                                                                                 \r\n                          AND n.oid = c.relnamespace                                                                                                                                                                                                                             \r\n                      ORDER BY a.attnum':                                                                                                                                                                                                                                        \r\n                                                                                                                                                                                                                                                                                 \r\n  SQLSTATE[42883]: Undefined function: 7 ERROR:  unknown function: string_to_array()   \r\n````"}}
{"actor":{"display_login":"lemonCMS"}}