Simple question - is it possible to have a select query providing the values for a list partitioned table? ie:
CREATE TABLE testpart (fileid int,tagname text,tagvalue text[]) PARTITION BY LIST (tagname); CREATE TABLE testpart_tag PARTITION OF testpart FOR VALUES IN (SELECT tag FROM tagmap);
CREATE TABLE testpart_def PARTITION OF testpart DEFAULT;