@rajatpaliwal86 - Nope... Why not just fix the constraint violations? :wink: (View Post)

I can understand the confusion about the "you" directive :smile: I will bring this up to the doc team. Thanks for the feedback! And you are correct, the larger the data set the longer it wi… (View Post)

Any user that has the PSEUDOSUPERUSER role active can call the DISABLE_DUPLICATE_KEY_ERROR() function. But be careful, the PSEUDOSUPERUSER role gives a lot of power to the user! See: https://www.vert… (View Post)

dbadmin=> SELECT store_no, '3' || '_' || LEFT(regexp_replace(store_no, '[^0-9]', ''), 5) FROM store; store_no | ?column?---------------+---------- S19872563… (View Post)

Use the data type SUPER LONG VARBINARY! Example: dbadmin=> CREATE TABLE why_do_this(a_very_big_column LONG VARBINARY);CREATE TABLEdbadmin=> \d why_do_this; List of Fields by Tables Schema | Tab… (View Post)