PostgreSQL 9 - Errors when populating sample data when scheme minimal is set to false

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2
• Fix Version/s: 6.1.30 EE GA3, --Sprint 11/12, 6.2.0 CE M2
• Component/s: Environments, Environments > Databases
• Labels:
  • QA-R
• Environment: Tomcat 7 + PostgreSQL 9. Portal 6.1.x GIT ID 52a37db4f36c1e018d87cbf2313d33c5c5ef196a.; Tomcat 7 + PostgreSQL 9. Portal 6.2.x GIT ID: f701cbcca68a6b144964128899927ed2ed8a6075.
• Branch Version/s:
  6.1.x
• Backported to Branch:
  Committed
• Databases:
  PostgreSQL 9.0
• Git Pull Request: https://github.com/hhuijser/liferay-portal/pull/773

When you start up Liferay (set schema.run.minimal=false in the portal-ext.properties) using PostgreSQL 9, you get type cast errors in the console.

18:07:49,378 INFO  [pool-2-thread-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
18:07:51,684 WARN  [pool-2-thread-1][BaseDB:428] ERROR: column "visible" is of type boolean but expression is of type integer
  Hint: You will need to rewrite or cast the expression.
  Position: 381: insert into AssetEntry (entryId, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, classUuid, classTypeId, visible, startDate, endDate, publishDate, expirationDate, mimeType, title, description, summary, url, layoutUuid, height, width, priority, viewCount) VALUES (93, 88, 1, 2, 'Joe Blogs', current_timestamp, current_timestamp, 13, 2, '', 0, 0, NULL, NULL, NULL, NULL, '', 'Joe Bloggs', '', '', '', 0, 0, 0, 0, 0);

18:07:51,706 WARN  [pool-2-thread-1][BaseDB:428] ERROR: column "visible" is of type boolean but expression is of type integer
  Hint: You will need to rewrite or cast the expression.
  Position: 382: insert into AssetEntry (entryId, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, classUuid, classTypeId, visible, startDate, endDate, publishDate, expirationDate, mimeType, title, description, summary, url, layoutUuid, height, width, priority, viewCount) VALUES (99, 96, 1, 2, 'Joe Blogs', current_timestamp, current_timestamp, 13, 94, '', 0, 0, NULL, NULL, NULL, NULL, '', 'Test LAX 1', '', '', '', 0, 0, 0, 0, 0);

18:07:51,727 WARN  [pool-2-thread-1][BaseDB:428] ERROR: column "visible" is of type boolean but expression is of type integer
  Hint: You will need to rewrite or cast the expression.
  Position: 385: insert into AssetEntry (entryId, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, classUuid, classTypeId, visible, startDate, endDate, publishDate, expirationDate, mimeType, title, description, summary, url, layoutUuid, height, width, priority, viewCount) VALUES (105, 102, 1, 2, 'Joe Blogs', current_timestamp, current_timestamp, 13, 100, '', 0, 0, NULL, NULL, NULL, NULL, '', 'Test LAX 2', '', '', '', 0, 0, 0, 0, 0);

18:07:51,747 WARN  [pool-2-thread-1][BaseDB:428] ERROR: column "visible" is of type boolean but expression is of type integer
  Hint: You will need to rewrite or cast the expression.
  Position: 385: insert into AssetEntry (entryId, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, classUuid, classTypeId, visible, startDate, endDate, publishDate, expirationDate, mimeType, title, description, summary, url, layoutUuid, height, width, priority, viewCount) VALUES (111, 108, 1, 2, 'Joe Blogs', current_timestamp, current_timestamp, 13, 106, '', 0, 0, NULL, NULL, NULL, NULL, '', 'Test LAX 3', '', '', '', 0, 0, 0, 0, 0);