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;
thanks
Mike