avamingli commented on PR #1163: URL: https://github.com/apache/cloudberry/pull/1163#issuecomment-2978787843
> > What's the behavior if we drop the aocs table to zero column? > > Is it possible to convert other type of table with zero column to aocs table? > > @gfphoenix78 can you provide sql ? create a table with one column, then drop the column. Same concern, create a table with zero column is valid in Postgres/GPDB. > > > What's the behavior if we drop the aocs table to zero column? > > > Is it possible to convert other type of table with zero column to aocs table? > > > > > > @gfphoenix78 can you provide sql ? > > create a table with one column, then drop the column. > > Same concern, create a table with zero column is valid in Postgres/GPDB. Designed to be valid. https://www.postgresql.org/docs/14/sql-createtable.html > Zero-Column Tables PostgreSQL allows a table of no columns to be created (for example, CREATE TABLE foo();). This is an extension from the SQL standard, which does not allow zero-column tables. Zero-column tables are not in themselves very useful, but disallowing them creates odd special cases for ALTER TABLE DROP COLUMN, so it seems cleaner to ignore this spec restriction. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
