Graphql-engine: Default value does not accept HTTP URL (Postgres error)

[Tchoupinax]

Hello,

I tried to add a default value in Hasura as an URL but Postgres threw an error:

I guess that the URL should be between quote in this query because Postgres does not like the charactere :. :)

I do not have the knowledge of your project to know where to edit this and if it is the good way to fix that.

Thank you for your awesome work ! :)

[rikinsk]

@Tchoupinax I attempted to do this for a column of type text and it seems to work. Can you confirm the type of the imageUrl column in your schema

[Tchoupinax]

@rikinsk Hello, my column is typed as character varying.
What is it the problem with that ? I can change but i would like to understand. ^^

Is varchar a bad practice to store URL or other string ?

[rikinsk]

@Tchoupinax No no. I was just querying to help debug the issue. This is definitely a bug.

[Tchoupinax]

Great. Tell me if you need other information. ;)

[rikinsk]

Till this is fixed, a workaround would be to surround the default values with single-quotes. eg. '<value>'

[Tchoupinax]

Yeah, to continue my work i performed manually the query with quote as you suggested and now it works.
For details, Hasura shows this: