golang pq sql driver: pq: invalid input syntax for type uuid error type

Question

I'm trying to handle Postgres error. If user sends invalid uuid - Postgres returns an error with message: pq: invalid input syntax for type uuid:...

So, i want to check that error and if the error equals to the invalid input syntax error - i would like to show to the client 404 error, rather than returning server error.

But i can't find the defined error type for the returned error in Postgres library...

Can someone suggest me, where is the error returned?

Could you add more context? Are you using github.com/lib/pq? — Stéphane Jeandeaux
– Stéphane Jeandeaux, Commented Sep 23, 2021 at 19:46
A suggestion: you could validate the parameter before querying the database. — Stéphane Jeandeaux
– Stéphane Jeandeaux, Commented Sep 23, 2021 at 19:48

Mike Vosseller · Accepted Answer · 2021-10-24 12:29:41Z

2

In the query you can cast the uuid column to text. Here are two ways to do that:

SELECT * FROM user WHERE id::text = 'sometext'
SELECT * FROM user WHERE text(id) = 'sometext'

Also discussed here: https://stackoverflow.com/a/46494463/2316115

PostgreSQL Type Casts are documented here: https://www.postgresql.org/docs/current/sql-expressions.html#SQL-SYNTAX-TYPE-CASTS

edited Oct 24, 2021 at 12:29

answered Oct 24, 2021 at 10:41

Mike Vosseller

4,2175 gold badges29 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

golang pq sql driver: pq: invalid input syntax for type uuid error type

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related