oauth2-authorization-schema.sql produces org.postgresql.util.PSQLException: ERROR: type "blob" does not exist

[pratikpanchal4472]

Describe the bug
Getting below error when using registredClientRepository with Postgres 15.x version
org.postgresql.util.PSQLException: ERROR: type "blob" does not exist
seems like blob datatype is not supported in postgres anymore: oauth2-authorization-schema.sql

To Reproduce
Use postgres v15.2 and below configuration

spring:
sql:
init:
schema-locations:
- 'classpath:org/springframework/security/oauth2/server/authorization/client/oauth2-registered-client-schema.sql'
- 'classpath:org/springframework/security/oauth2/server/authorization/oauth2-authorization-consent-schema.sql'
- 'classpath:org/springframework/security/oauth2/server/authorization/oauth2-authorization-schema.sql'

Expected behavior
It should create the tables for all provided schema locations

[m-thirumal]

For PostgreSQL, update ALL columns defined with blob to text, as PostgreSQL does not support the blob data type.

OR

Use oauth2-authorization-schema.sql which is modified for this PostgreSQL repository

[jgrandja]

Closing this as duplicate of gh-480

@pratikpanchal4472 Please see

spring-authorization-server/oauth2-authorization-server/src/main/resources/org/springframework/security/oauth2/server/authorization/oauth2-authorization-schema.sql

Line 2 in 9c1ec34

IMPORTANT: