hi, boss.
i was use “dump” to backup, i got this message:
Error: pq: syntax error at or near ","
SELECT id, id, image_id, left, top, size, remark, state, status, changed, created FROM zdlot.broker_promote@“primary” AS OF SYSTEM TIME ‘1504703792008007720.0000000000’ ORDER BY id LIMIT 10000
^
Failed running “dump”
table:
| broker_promote | CREATE TABLE broker_promote (
|
| | id INT NOT NULL DEFAULT unique_rowid(),
|
| | image_id INT NOT NULL,
|
| | left FLOAT NOT NULL DEFAULT 0.0:::FLOAT,
|
| | top FLOAT NOT NULL DEFAULT 0.0:::FLOAT,
|
| | size FLOAT NOT NULL DEFAULT 0.0:::FLOAT,
|
| | remark STRING(500) NULL,
|
| | state STRING(50) NOT NULL DEFAULT ‘standby’:::STRING,
|
| | status STRING(50) NULL,
|
| | changed TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
|
| | created TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
|
| | CONSTRAINT “primary” PRIMARY KEY (id ASC),
|
| | INDEX broker_promote_image_id_state_status_idx (image_id ASC, state ASC, status ASC),
|
| | FAMILY “primary” (id, image_id, left, top, size, remark, state, status, changed, created)
|
| | )