PostgreSQL error code
PostgreSQL error 42939
42939 is the SQLSTATE PostgreSQL reports for reserved name, in class 42, Syntax Error or Access Rule Violation.
| SQLSTATE | 42939 |
|---|---|
| Condition name | reserved_name |
| Class | 42 — Syntax Error or Access Rule Violation |
Reproduce it, then fix it
Names starting with pg_ are reserved for PostgreSQL’s own roles, such as pg_read_all_data. Run the broken query to see the error, then switch to the fixed one. Edit either freely; every run is rolled back.
CREATE ROLE pg_reporter;
CREATE ROLE reporter;