BUG #19352: SQL Error messages do not include schema name along with table or data object name.
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #19352: SQL Error messages do not include schema name along with table or data object name. |
| Дата | |
| Msg-id | 19352-51c017bf5177cadd@postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #19352: SQL Error messages do not include schema name along with table or data object name.
|
| Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 19352 Logged by: David Keeshin Email address: keeshd@keeshinds.com PostgreSQL version: 16.11 Operating system: Linux Description: Here's an actual error that I received: "Error moving summary data: Error in up_move_from_stage for control_id c5bcfbd9-1f20-42c1-bb0c-be626b3c15eb: insert or update on table "followup_data_flow_by_topic" violates foreign key constraint "followup_data_flow_by_topic_by_topic_id_fkey2" 23503 CONTEXT: PL/pgSQL function interview.up_move_from_stage(uuid,boolean) line 166 at RAISE" It's confusing. I have a "stage" schema and a "interview" schema in the database. There is a "followup_data_flow_by_topic' table in the stage "schema" and one in the "interview" schema. I did just noticed that the end of the message does include the schema name for the stored procedure - which by the was created as a stored procedure, not a function. Ideally this error message would be clearer if the schema name was included with the data table or object name. i.e. "Error moving summary data: Error in interview.up_move_from_stage for control_id c5bcfbd9-1f20-42c1-bb0c-be626b3c15eb: insert or update on table "interview.followup_data_flow_by_topic" violates foreign key constraint "interview.followup_data_flow_by_topic_by_topic_id_fkey2" 23503 CONTEXT: PL/pgSQL function interview.up_move_from_stage(uuid,boolean) line 166 at RAISE"
В списке pgsql-bugs по дате отправления: