Skip to content

Postgres service stops while running pivotmytable

Created by: shankarnayagam

Hi,

I have been using this script for quite a while without any issue. But suddenly this script stopped working and whenever I run this select * from pivotmytable query my postgreSQL database service stops and I am not able create the pivot table. My original table almost has 1 million records, could this be the reason for this issue? Kindly confirm.