BUG #15555: Syntax errors when using the COMMENT command in plpgsqland a "comment" variable
От | PG Bug reporting form |
---|---|
Тема | BUG #15555: Syntax errors when using the COMMENT command in plpgsqland a "comment" variable |
Дата | |
Msg-id | 15555-149bbd70ddc7b4b6@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15555: Syntax errors when using the COMMENT command in plpgsql and a "comment" variable
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15555 Logged by: Feike Steenbergen Email address: feikesteenbergen@gmail.com PostgreSQL version: 11.1 Operating system: CentOS Linux release 7.5.1804 (Core) Description: Recently, I ran into an issue when trying to put comments on objects in plpgsql DO block, for example the following: DO $$ DECLARE "comment" text := 'This is a comment'; BEGIN COMMENT ON TABLE abc IS 'This is another comment'; END; $$; Generates the following error message: ERROR: 42601: syntax error at or near "ON" LINE 5: COMMENT ON TABLE abc IS 'This is another comment'; Renaming the variable from "comment" to something else makes the problem go away, as well as wrapping the COMMENT command in an EXECUTE call; It happens both when double quoting the identifier, or when omitting the double quotes. For now I'll just avoid using comment as a variable name altogether, but I was surprised by this behaviour. Kind regards, Feike
В списке pgsql-bugs по дате отправления: