6.5.0-M3 - passkeys jdbc user-credentials-schema.sql blob columns not compatible with postgresql

[zyro23]

Describe the bug
org/springframework/security/user-credentials-schema.sql contains blob columns.

that is not supported on postgresql:

org.postgresql.util.PSQLException: ERROR: type "blob" does not exist

To Reproduce
try to run the ddl-/schema-sql against a postgresql database manually.

Expected behavior
a postgresql-compatible schema should be provided.

Sample

[2025-03-27 10:21:47] Connected
demo.public> create table user_credentials
                (
                    credential_id                varchar(1000) not null,
                    user_entity_user_id          varchar(1000) not null,
                    public_key                   blob          not null,
                    signature_count              bigint,
                    uv_initialized               boolean,
                    backup_eligible              boolean       not null,
                    authenticator_transports     varchar(1000),
                    public_key_credential_type   varchar(100),
                    backup_state                 boolean       not null,
                    attestation_object           blob,
                    attestation_client_data_json blob,
                    created                      timestamp,
                    last_used                    timestamp,
                    label                        varchar(1000) not null,
                    primary key (credential_id)
                )
[2025-03-27 10:21:47] [42704] ERROR: type "blob" does not exist
[2025-03-27 10:21:47] Position: 180

Misc
changing the blob columns to bytea seems to work for postgresql.

[ngocnhan-tran1996]

Spring Security use H2 for default dabase. If you have another database, you should have your own script.

Reference
https://docs.spring.io/spring-security/reference/servlet/authentication/passwords/jdbc.html

[franticticktick]

Hey @zyro23, good catch :) This tikect will be solved via #16839