Postgres errors: where can I find a guide to these byte messages?

Question

I tried inserting a record into a Postgres database, and got a "key already exists" error message, in Go:

S:"ERROR" M:"duplicate key value violates unique constraint \"unique_name\"" n:"unique_name" 
F:"nbtinsert.c" L:"398" C:"23505" D:"Key (name)=(kevinburke) already exists." 
s:"public" t:"players" R:"_bt_check_unique"

It's clear that each of these fields has a meaning for Postgres. I've tried searching for documentation but I can't find anything online; where can I find out what each of the fields means?

(For reference, the string I am looking at is generated by the "pq" Go driver wrapper: https://github.com/bmizerany/pq/blob/master/error.go#L32)

There is a list of error messages at postgresql.org/docs/current/static/errcodes-appendix.html which might help, and they will also be in the code if you feel like searching for them. — bma
– bma, Commented Nov 28, 2013 at 18:00

Kevin Burke · Accepted Answer · 2013-11-28 18:12:57Z

1

The list of identification tokens and their meanings can be found here:

Error and Notice Message Fields - Postgres

answered Nov 28, 2013 at 18:12

Kevin Burke

65.8k84 gold badges203 silver badges328 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joe Love · Accepted Answer · 2013-11-29 05:36:05Z

1

Is it possible that you're trying to auto-generate the primary key and your sequences have an incorrect value? If this makes no sense, could you post the query actually sent to the DB?

answered Nov 29, 2013 at 5:36

Joe Love

6,1262 gold badges24 silver badges33 bronze badges

Collectives™ on Stack Overflow

Postgres errors: where can I find a guide to these byte messages?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related