{"action":"created","issue":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/4909","repository_url":"https://api.github.com/repos/greenplum-db/gpdb","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/4909/labels{/name}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/4909/comments","events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/4909/events","html_url":"https://github.com/greenplum-db/gpdb/issues/4909","id":318606413,"number":4909,"title":"Extra objects of `pg_dump -s -t`","user":{"login":"adam8157","id":153160,"avatar_url":"https://avatars0.githubusercontent.com/u/153160?v=4","gravatar_id":"","url":"https://api.github.com/users/adam8157","html_url":"https://github.com/adam8157","followers_url":"https://api.github.com/users/adam8157/followers","following_url":"https://api.github.com/users/adam8157/following{/other_user}","gists_url":"https://api.github.com/users/adam8157/gists{/gist_id}","starred_url":"https://api.github.com/users/adam8157/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adam8157/subscriptions","organizations_url":"https://api.github.com/users/adam8157/orgs","repos_url":"https://api.github.com/users/adam8157/repos","events_url":"https://api.github.com/users/adam8157/events{/privacy}","received_events_url":"https://api.github.com/users/adam8157/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2018-04-28T06:43:06Z","updated_at":"2018-05-10T16:56:35Z","closed_at":null,"author_association":"MEMBER","body":"```\r\ntestdb=# CREATE FUNCTION myread() RETURNS integer\r\nas '$libdir/gpextprotocol.so', 'demoprot_import'\r\nLANGUAGE C STABLE;\r\nCREATE FUNCTION\r\ntestdb=# CREATE FUNCTION mywrite() RETURNS integer\r\nas '$libdir/gpextprotocol.so', 'demoprot_export'\r\nLANGUAGE C STABLE;\r\nCREATE FUNCTION\r\ntestdb=# CREATE TRUSTED PROTOCOL myprot ( readfunc = 'myread', writefunc = 'mywrite');\r\nCREATE PROTOCOL\r\n```\r\n\r\n```\r\n$ pg_dump -s -x -O --no-gp-syntax  -t schema2.foo2 testdb\r\n--\r\n-- Greenplum Database database dump\r\n--\r\n\r\nSET statement_timeout = 0;\r\nSET client_encoding = 'UTF8';\r\nSET standard_conforming_strings = on;\r\nSET check_function_bodies = false;\r\nSET client_min_messages = warning;\r\n\r\nSET search_path = schema2, pg_catalog;\r\n\r\nSET default_tablespace = '';\r\n\r\nSET default_with_oids = false;\r\n\r\n--\r\n-- Name: foo2; Type: TABLE; Schema: schema2; Owner: -; Tablespace:\r\n--\r\n\r\nCREATE TABLE foo2 (\r\n    i integer\r\n);\r\n\r\n\r\n--\r\n-- Name: myprot; Type: PROTOCOL; Schema: -; Owner: -\r\n--\r\n\r\n-- Set the search_path required to look up the functions\r\nSET search_path = public;\r\n\r\nCREATE TRUSTED PROTOCOL myprot ( readfunc = 'myread', writefunc = 'mywrite');\r\n\r\n\r\n--\r\n-- Greenplum Database database dump complete\r\n--\r\n```\r\n\r\nWhy the protocol is dumped also? How could I get the dump of table's schema only?"},"comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments/388115317","html_url":"https://github.com/greenplum-db/gpdb/issues/4909#issuecomment-388115317","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/4909","id":388115317,"user":{"login":"chrishajas","id":1610524,"avatar_url":"https://avatars3.githubusercontent.com/u/1610524?v=4","gravatar_id":"","url":"https://api.github.com/users/chrishajas","html_url":"https://github.com/chrishajas","followers_url":"https://api.github.com/users/chrishajas/followers","following_url":"https://api.github.com/users/chrishajas/following{/other_user}","gists_url":"https://api.github.com/users/chrishajas/gists{/gist_id}","starred_url":"https://api.github.com/users/chrishajas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrishajas/subscriptions","organizations_url":"https://api.github.com/users/chrishajas/orgs","repos_url":"https://api.github.com/users/chrishajas/repos","events_url":"https://api.github.com/users/chrishajas/events{/privacy}","received_events_url":"https://api.github.com/users/chrishajas/received_events","type":"User","site_admin":false},"created_at":"2018-05-10T16:56:35Z","updated_at":"2018-05-10T16:56:35Z","author_association":"MEMBER","body":"@adam8157 Are there other issues you've seen beside protocols? pg_dump does make an effort to not dump objects such as procedural languages and other metadata during a table-only dump. "}}
{"actor":{"display_login":"chrishajas"}}