因为您使用的是内存中的数据库，所以Hibernate在执行以下命令时找不到任何表：

hibernate.hbm2ddl.auto=create-drop

这是因为语句的顺序是：

• 删除约束（fk）
• 放下table
• 创建表
• 创建约束（fk）

Query:{[alter table tableIdentifier drop constraint FK_202gbutq8qbxk0chvcpjsv6vn][]} 
ERROR [main]: o.h.t.h.SchemaExport - HHH000389: Unsuccessful: alter table tableIdentifier drop constraint FK_202gbutq8qbxk0chvcpjsv6vn
ERROR [main]: o.h.t.h.SchemaExport - user lacks privilege or object not found: PUBLIC.TABLEIDENTIFIER
Query:{[drop table sequenceIdentifier if exists][]} 
Query:{[drop table tableIdentifier if exists][]} 
Query:{[create table sequenceIdentifier (id bigint not null, primary key (id))][]} 
Query:{[create table tableIdentifier (id bigint not null, sequenceIdentifier_id bigint, primary key (id))][]} 
Query:{[alter table tableIdentifier add constraint FK_202gbutq8qbxk0chvcpjsv6vn foreign key (sequenceIdentifier_id) references sequenceIdentifier][]} 
Query:{[create sequence hibernate_sequence start with 1 increment by 1][]}

您可以通过将www.example.com更改为更新来解决此问题hibernate.hbm2ddl.auto：

hibernate.hbm2ddl.auto=update

尝试create-only：

spring.jpa.properties.hibernate.hbm2ddl.auto=create-only

它被添加到Hibernate至少从5.2开始（也许甚至更早），我没有找到任何适当的文档，但它提到用户指南：23.15.自动模式生成
如果您在日志中看到：

WARN  SessionFactoryOptionsBuilder:394 - Unrecognized hbm2ddl_auto value : create-only.  Supported values include 'create', 'create-drop', 'update', 'none' and 'validate'.  Ignoring

这可能是一个错误的警报和in fact it works

您可以创建自定义Dialect并阻止执行drop constraints语句，如下所示：

public class CustomH2Dialect extends H2Dialect {

    @Override
    public boolean dropConstraints() {
        return false;
    }
}

并在您的属性中引用以下内容：

spring.jpa.database-platform=my.package.CustomH2Dialect

谢谢，这对我来说很有用。

## Spring DATASOURCE (DataSourceAutoConfiguration & DataSourceProperties)
spring.datasource.url=jdbc:postgresql://localhost:5432/postgres
spring.datasource.username=postgres
spring.datasource.password=postgres
# The SQL dialect makes Hibernate generate better SQL for the chosen database
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQL9Dialect
# Hibernate ddl auto (create, create-drop, validate, update)
spring.jpa.hibernate.ddl-auto=create
logging.level.org.hibernate.SQL= DEBUG
hibernate.hbm2ddl.auto=update

spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true
# Enable response compression
server.compression.enabled=true
# The comma-separated list of mime types that should be compressed
server.compression.mime-types=text/html,text/xml,text/plain,text/css,text/javascript,application/javascript,application/json
# Compress the response only if the response size is at least 1KB
server.compression.min-response-size=1024
server.http2.enabled=true
# Maximum time the response should be cached (in seconds)
spring.resources.cache.cachecontrol.max-age=120
# The cache must re-validate stale resources with the server. Any expired resources must not be used without re-validating.
spring.resources.cache.cachecontrol.must-revalidate=true
#https://www.callicoder.com/configuring-spring-boot-application/
server.port=8080