<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
<div class="moz-cite-prefix">On 12/17/20 10:13 PM, Sven Hartge
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:4c5c2627-6e4c-4a5e-060a-fe618365e912@svenhartge.de">All
the scripts are in src/cats/
<br>
<br>
<br>
</blockquote>
<p>Well... There is definitely a difference:</p>
<p>For example:</p>
<p><font face="monospace"><b>CREATE TABLE public.object (</b><b><br>
</b><b> objectid bigint NOT NULL,</b></font><br>
<br>
This "<font face="monospace"><b>objectid</b></font>" is type <font
face="monospace"><b>bigtint</b></font> in this table if database
is created from scratch, and <font face="monospace"><b>integer</b></font>
in database migrated from 9.6.7 to 11.0.<br>
<br>
</p>
<p>Further down the line we can see one index is present only in
migrated version in table "job" and not present in clean install:<br>
<font face="monospace"><b> "job_jobtdate_idx" btree (jobtdate)</b></font><b><br>
</b></p>
<p><br>
</p>
<p>Third difference:<br>
In table job, column priorjob has default set as: <font
face="monospace">'</font><b><font face="monospace">'::text</font>
</b>only in clean install.<br>
</p>
<p><br>
So ... I believe this is something it should be fixed in upstream.<br>
<br>
Opinions?<br>
<br>
<br>
Best regards,<br>
<br>
--<br>
Mario.<br>
</p>
</body>
</html>