[hibernate-issues] [JIRA] (HHH-13954) PostgreSQL - partitioned table: Schema-validation: missing table (when table exists)

[HZ Jiang (JIRA)]

HZ Jiang ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ab129593ce81c2a7cd31cc0 ) *commented* on HHH-13954 ( https://hibernate.atlassian.net/browse/HHH-13954?atlOrigin=eyJpIjoiZTMxZjExODNjMTUwNDc5OWJmZDVhNDNmNTk4MTMyOWQiLCJwIjoiaiJ9 )

Re: PostgreSQL - partitioned table: Schema-validation: missing table (when table exists) ( https://hibernate.atlassian.net/browse/HHH-13954?atlOrigin=eyJpIjoiZTMxZjExODNjMTUwNDc5OWJmZDVhNDNmNTk4MTMyOWQiLCJwIjoiaiJ9 )

You can refer to https://github.com/hibernate/hibernate-orm/pull/3350 Should solve your problem

You can temporarily use a custom dialect：

public class CustomPostgresqlDialect extends PostgreSQL10Dialect {

	/**
	 * An SQL Dialect for PostgreSQL 10 and later. Adds support for Partition table.
	 * 
	 * @param tableTypesList
	 */
	@Override
	public void augmentRecognizedTableTypes(List<String> tableTypesList) {
		super.augmentRecognizedTableTypes(tableTypesList);
		tableTypesList.add("PARTITIONED TABLE");
	}

}

( https://hibernate.atlassian.net/browse/HHH-13954#add-comment?atlOrigin=eyJpIjoiZTMxZjExODNjMTUwNDc5OWJmZDVhNDNmNTk4MTMyOWQiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13954#add-comment?atlOrigin=eyJpIjoiZTMxZjExODNjMTUwNDc5OWJmZDVhNDNmNTk4MTMyOWQiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100124- sha1:93e2dd3 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200417/eff11f35/attachment.html