Re: Proposal: CREATE/ALTER DOMAIN ... STORAGE/COMPRESSION = ...

2022-08-21 Thread Nikita Malakhov
Hi! I agree, domains are supposed to define data types only and are not meant to impact how these types are stored. Storage and compression strategy differ for one given type from table to table and must be defined explicitly, except for default. Also, such implicit-like storage and compression def

Re: Proposal: CREATE/ALTER DOMAIN ... STORAGE/COMPRESSION = ...

2022-08-20 Thread Peter Eisentraut
On 17.08.22 11:43, Aleksander Alekseev wrote: Do you think it will be useful to specify STORAGE and/or COMPRESSION for domains? Domains are supposed to a logical construct that restricts the accepted values for a data type (it's in the name "domain"). Expanding that into a general "column de

Proposal: CREATE/ALTER DOMAIN ... STORAGE/COMPRESSION = ...

2022-08-17 Thread Aleksander Alekseev
Hi hackers, Do you think it will be useful to specify STORAGE and/or COMPRESSION for domains? As an example, this will allow creating an alias for TEXT with EXTERNAL storage strategy. In other words, to do the same we do with ALTER TABLE, but for types. This feature is arguably not something most