wangbowen1024 commented on issue #7732:
URL: 
https://github.com/apache/dolphinscheduler/issues/7732#issuecomment-1007371228


   > @wangbowen1024 @tangchunbo Do you find in which version `is_directory` 
changed to int? I didn't find this change in postgresql ddl file. If no history 
ddl file contains this change, it's only need to change the type in 
dolphinscheduler_postgresql.sql.
   
   v2.0.X all, i change int to bool to slove it,just like my problem description
   
![image](https://user-images.githubusercontent.com/48642743/148544046-58b2f4d6-80ea-4210-8b29-fe1b1ea784fa.png)
   
   ```sql
   CREATE TABLE t_ds_resources (
     id serial NOT NULL  ,
     alias varchar(64) DEFAULT NULL ,
     file_name varchar(64) DEFAULT NULL ,
     description varchar(255) DEFAULT NULL ,
     user_id int DEFAULT NULL ,
     type int DEFAULT NULL ,
     size bigint DEFAULT NULL ,
     create_time timestamp DEFAULT NULL ,
     update_time timestamp DEFAULT NULL ,
     pid int,
     full_name varchar(64),
     is_directory int,
     PRIMARY KEY (id),
     CONSTRAINT t_ds_resources_un UNIQUE (full_name, type)
   ) ;
   ```
   Need  a PR for that? If need, I can
   


-- 
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]


Reply via email to