This message was deleted.
# pythons
sparse-intern-71089
06/04/2021, 1:50 PMThis message was deleted.
e
enough-garden-22763
06/04/2021, 1:55 PMRedshift does not speak the Postgres dialect precisely, there’re differences especially around things like roles. I.e. they both support CREATE USER but only Postgres supports CREATE ROLE
s
sticky-bear-14421
06/04/2021, 1:57 PMAnd as the Pulumi PostgreSQL provider only has a Role Resource it won't be able to create a Role within a Redshift derivate of PostgreSQL
sticky-bear-14421
06/04/2021, 1:57 PMI see
sticky-bear-14421
06/04/2021, 1:58 PMDo you have plans for adding the User aswell?
sticky-bear-14421
06/04/2021, 1:58 PMAm not too familiar with PostgreSQL, but User was the old concept, Roles are the new way to go?
sticky-bear-14421
06/04/2021, 2:08 PMWhat about adding a Script resource to the provider for raw SQL scripts to execute, this could help in cases of feature incompatibilities like mine
e
enough-garden-22763
06/04/2021, 2:10 PMI’m not too familiar with this part of the codebase yet, but it sounds like if things like this are missing https://github.com/pulumi/pulumi-postgresql/issues adding requests to issue tracker can be very helpful
👍 1
s
sticky-bear-14421
06/04/2021, 2:11 PMAwesome, will add a feature request. Thanks for your help
👍 1