https://communities.sas.com/t5/SAS-Programming/Cannot-create-the-temporary-relation-in-non-temporary-schema/m-p/745695#M233801 <P>This error message is a Postgres message.</P> <P>You cannot do what you are trying to do. Look at the explanations for this error message in the Postgres documentation.</P> Fri, 04 Jun 2021 06:19:10 GMT ChrisNZ 2021-06-04T06:19:10Z https://communities.sas.com/t5/SAS-Programming/Cannot-create-the-temporary-relation-in-non-temporary-schema/m-p/745516#M233699 <P>Hi</P><P>I am trying to use SCD 2 Type transformation in my DI job ,but when running the job ,i am getting below error message.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Shubham5497_0-1622734617832.png" style="width: 713px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/59995i4357D993B2F743D4/image-dimensions/713x166?v=v2" width="713" height="166" role="button" title="Shubham5497_0-1622734617832.png" alt="Shubham5497_0-1622734617832.png" /></span></P><P>&nbsp;</P><P>My Target table is <STRONG>postgres table :</STRONG></P><P>&nbsp;</P><P>I am not able to figure out ,why that error is coming.</P><P>Can you please help me to resolve this issue?</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks</P><P><STRONG>&nbsp;</STRONG></P><P>&nbsp;</P> Thu, 03 Jun 2021 15:45:01 GMT https://communities.sas.com/t5/SAS-Programming/Cannot-create-the-temporary-relation-in-non-temporary-schema/m-p/745516#M233699 Shubham5497 2021-06-03T15:45:01Z https://communities.sas.com/t5/SAS-Programming/Cannot-create-the-temporary-relation-in-non-temporary-schema/m-p/745695#M233801 <P>This error message is a Postgres message.</P> <P>You cannot do what you are trying to do. Look at the explanations for this error message in the Postgres documentation.</P> Fri, 04 Jun 2021 06:19:10 GMT https://communities.sas.com/t5/SAS-Programming/Cannot-create-the-temporary-relation-in-non-temporary-schema/m-p/745695#M233801 ChrisNZ 2021-06-04T06:19:10Z