We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
I am trying this interesting repo: I create a partition table ,and use measurement.
CREATE TABLE measurement( city_id int not null, logdate date not null, peaktemp int, unitsales int )partition by range(logdate); select enable_ts_table('measurement');
Then I try to drop it (both cascade and no cascade have been tested):
DROP TABLE measurement CASCADE;
Then I create the same partition table, try to use ts_table, it doesn't work:
NOTICE: relation "template_public_measurement" already exists, skipping ERROR: duplicate key value violates unique constraint "part_config_parent_table_pkey"
We have to delete it manually.
DELETE FROM part_config where part_config.parent_table ='public.measurement';
The text was updated successfully, but these errors were encountered:
No branches or pull requests
I am trying this interesting repo:
I create a partition table ,and use measurement.
Then I try to drop it (both cascade and no cascade have been tested):
Then I create the same partition table, try to use ts_table, it doesn't work:
We have to delete it manually.
The text was updated successfully, but these errors were encountered: