Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

unable to create valid postgres tables with sql changesets

Description

the following code doesn't work for numerous parsing errors in complete valid postgres syntax

--liquibase formatted sql --changeset 0004-g1-schema-order:ccushing create schema if not exists "order"; --changeset 0004-order_status:ccushing create table if not exists "order".order_status ( id uuid primary key not null default uuid_generate_v4(), key text unique not null, -- enum created_at TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, created_by text DEFAULT ("current_user"())::text NOT NULL, modified_at TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, modified_by text DEFAULT ("current_user"())::text NOT NULL, );

Environment

OS X, and Linux (irrelevant)

Activity

Show:

Caleb Cushing February 17, 2020 at 9:13 PM

I'm dumb, nevermind

Invalid

Details

Reporter

Components

Affects versions

Priority

Created February 17, 2020 at 8:05 PM
Updated February 17, 2020 at 9:13 PM
Resolved February 17, 2020 at 9:13 PM