View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006997 | SymmetricDS | Improvement | public | 2025-07-16 17:47 | 2025-07-16 17:49 |
| Reporter | mdrouard | Assigned To | |||
| Priority | low | ||||
| Status | feedback | Resolution | open | ||
| Product Version | 3.14.0 | ||||
| Summary | 0006997: Add support for Postgres ENUM type | ||||
| Description | If you try to use an enum you get the following message: "enum" is of type enum but expression is of type character varying. There is currently support for enum types in MySQL. Issues 0004003 and 0002849 relate to the integration of the MySql enum type. This will likely just need an update to DdlReader and DdlBuilder for Postgres. This is not exactly like MySql however, enums are not inline in Postgres and require 2 create statements as shown in the example below. CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy'); CREATE TABLE person ( name text, current_mood mood ); This may be closer to SQL Server's user defined types. | ||||
| Additional Information | https://sourceforge.net/p/symmetricds/discussion/739236/thread/39f1abf470/?limit=25#2db0 | ||||
| Tags | dialect: postgresql | ||||