You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In the object explorer we select a table and by right click on that table we choose Scripts > CREATE Script. In the detailed view we see the query to create the table and all its details. I.e. also the comments on the columns and the table. But I missing the comments for the defined policies.
To Reproduce
Steps to reproduce the behavior:
Open Query Tool
Copy this SQLs and execute it
CREATE TABLE IF NOT EXISTS public.table_comments_policies
(
id bigint NOT NULL
)
CREATE POLICY plcy_table_comments_policies
ON public.table_comments_policies
AS PERMISSIVE
FOR ALL
TO authenticated
USING (true)
WITH CHECK (true);
COMMENT ON POLICY "plcy_table_comments_policies" ON "public"."table_comments_policies" IS 'All: auths';
Refresh tables
Right click on table table_comments_policies
Choose Scripts > CREATE Script
Expected behavior
The expected behavior is that SQLs from the create scripts command contains the COMMENT ON POLICY command, but it is not included.
-- Table: public.table_comments_policies
-- DROP TABLE IF EXISTS public.table_comments_policies;
CREATE TABLE IF NOT EXISTS public.table_comments_policies
(
id bigint NOT NULL
)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.table_comments_policies
OWNER to postgres;
GRANT ALL ON TABLE public.table_comments_policies TO anon;
GRANT ALL ON TABLE public.table_comments_policies TO authenticated;
GRANT ALL ON TABLE public.table_comments_policies TO postgres;
GRANT ALL ON TABLE public.table_comments_policies TO service_role;
-- POLICY: plcy_table_comments_policies
-- DROP POLICY IF EXISTS plcy_table_comments_policies ON public.table_comments_policies;
CREATE POLICY plcy_table_comments_policies
ON public.table_comments_policies
AS PERMISSIVE
FOR ALL
TO authenticated
USING (true)
WITH CHECK (true);
Describe the bug
In the object explorer we select a table and by right click on that table we choose Scripts > CREATE Script. In the detailed view we see the query to create the table and all its details. I.e. also the comments on the columns and the table. But I missing the comments for the defined policies.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
The expected behavior is that SQLs from the create scripts command contains the
COMMENT ON POLICY
command, but it is not included.Error message
No error message.
Screenshots
No screenshots attached.
Desktop:
Additional context
The text was updated successfully, but these errors were encountered: