pgmq_create doesn't validate queue names

[v0idpwn]

Extension version: 0.10
Postgres version: 15.3 (I'm running your docker image)

Current behaviour

Some characters that aren't allowed cause error 22000:

>select * from pgmq_create('hello-world');
SQL Error [22000]

Very long names get truncated and cause issues:

>select * from pgmq_create('veryloooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooongstring'); 
SQL Error [42703]: column "deleted_at" does not exist

Expected behaviour

If the name is valid, queue is created normally. If it isn't, error early.

This should also probably be documented somewhere.

[ChuckHend]

Nice find! Table name length limitation is 63 characters in postgres, so we probably just add that check in the below and handle the error reporting back to user

pgmq/core/src/query.rs

Line 303 in aaaf47e

pub fn check_input(input: &str) -> Result<(), PgmqError> {

Thoughts?
 

[vrmiguel]

I feel like we already handle pgmq_create('hello-world') but need some way of providing a better error message to the user

[ChuckHend]

@vrmiguel - did #37 close this, or was there something we wanted to do before we marked this one done?