File: 12-generated-column.sql

package info (click to toggle)
pgcopydb 0.17-1
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 30,636 kB
  • sloc: ansic: 217,474; sql: 1,654; sh: 812; makefile: 365; python: 94
file content (11 lines) | stat: -rw-r--r-- 280 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
 
--
-- See https://github.com/dimitri/pgcopydb/issues/496
--
-- Migration fails when table has generated columns
--

CREATE TABLE ref_admin_commune (
    id character varying NOT NULL,
    nom character varying(50),
    test text GENERATED ALWAYS AS (upper((nom)::text)) STORED
);