Removing publicly-writable schemas from search_path with ECPG
От | PG Doc comments form |
---|---|
Тема | Removing publicly-writable schemas from search_path with ECPG |
Дата | |
Msg-id | 175463009658.797.7673870651535719486@wrigleys.postgresql.org обсуждение исходный текст |
Список | pgsql-docs |
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ecpg-connect.html Description: Hello, This comment relates to the last paragraph of section 34.2.1 of the Postgres 16 documentation. I am learning to use ECPG and trying to follow best practices. After connecting to my database, I am trying to remove publicly-writable schemas from search_path using the command "EXEC SQL SELECT pg_catalog.set_config('search_path', '', false)". Unfortunately, that command seems to fail. The following function (from section 36.8.2. of the documentation) void print_sqlca() { fprintf(stderr, "==== sqlca ====\n"); fprintf(stderr, "sqlcode: %ld\n", sqlca.sqlcode); fprintf(stderr, "sqlerrm.sqlerrml: %d\n", sqlca.sqlerrm.sqlerrml); fprintf(stderr, "sqlerrm.sqlerrmc: %s\n", sqlca.sqlerrm.sqlerrmc); fprintf(stderr, "sqlerrd: %ld %ld %ld %ld %ld %ld\n", sqlca.sqlerrd[0],sqlca.sqlerrd[1],sqlca.sqlerrd[2], sqlca.sqlerrd[3],sqlca.sqlerrd[4],sqlca.sqlerrd[5]); fprintf(stderr, "sqlwarn: %d %d %d %d %d %d %d %d\n", sqlca.sqlwarn[0], sqlca.sqlwarn[1], sqlca.sqlwarn[2], sqlca.sqlwarn[3], sqlca.sqlwarn[4], sqlca.sqlwarn[5], sqlca.sqlwarn[6], sqlca.sqlwarn[7]); fprintf(stderr, "sqlstate: %5s\n", sqlca.sqlstate); fprintf(stderr, "===============\n"); } produces the following output: ==== sqlca ==== sqlcode: -202 sqlerrm.sqlerrml: 28 sqlerrm.sqlerrmc: too few arguments on line 25 sqlerrd: 0 0 1 0 0 0 sqlwarn: 0 0 0 0 0 0 0 0 sqlstate: 07002 =============== Line 25 of my .pgc file is where I call EXEC SQL SELECT pg_catalog.set_config. I would appreciate any guidance. Please let me know if this inquiry would be better suited for a different forum, such as stackexchange.
В списке pgsql-docs по дате отправления: