PostgreSQL dbmigrate test error - column am.amcanorder does not exist

[chrisdpeters]

@neokoenig When I run the test suite on my local CF11 + PostgreSQL + Linux, I get this in the dbmigrate.migration.addindex package. Any ideas?

addindex 	Add Index creates an index 	174 	Error
Error Executing Database Query.
cfml.cfm line 185

    /app/wheels/global/cfml.cfm line 185
    /app/wheels/tests/dbmigrate/migration/addindex.cfc line 20
    /app/wheels/test/functions.cfm line 294
    /app/wheels/test/functions.cfm line 472
    /app/root.cfm line 1
    /app/wheels/global/internal.cfm line 540
    /app/wheels/public/tests.cfm line 11
    /app/wheels/public/wheels.cfm line 6
    /app/views/wheels/wheels.cfm line 6
    /app/wheels/global/cfml.cfm line 117
    /app/wheels/controller/rendering.cfm line 425
    /app/wheels/controller/rendering.cfm line 191
    /app/wheels/controller/rendering.cfm line 64
    /app/wheels/controller/processing.cfm line 136
    /app/wheels/controller/processing.cfm line 93
    /app/wheels/dispatch/functions.cfm line 154
    /app/wheels/index.cfm line 5
    /app/rewrite.cfm line 2
    /app/wheels/events/onrequest.cfm line 5



ERROR: column am.amcanorder does not exist
Position: 407

[chrisdpeters]

I also get a similar error in dbmigrate.migration.removeindex:

removeindex 	Remove Index removes an index 	1269 	Error
Error Executing Database Query.
cfml.cfm line 185

    /app/wheels/global/cfml.cfm line 185
    /app/wheels/tests/dbmigrate/migration/removeindex.cfc line 19
    /app/wheels/test/functions.cfm line 294
    /app/wheels/test/functions.cfm line 472
    /app/root.cfm line 1
    /app/wheels/global/internal.cfm line 540
    /app/wheels/public/tests.cfm line 11
    /app/wheels/public/wheels.cfm line 6
    /app/views/wheels/wheels.cfm line 6
    /app/wheels/global/cfml.cfm line 117
    /app/wheels/controller/rendering.cfm line 425
    /app/wheels/controller/rendering.cfm line 191
    /app/wheels/controller/rendering.cfm line 64
    /app/wheels/controller/processing.cfm line 136
    /app/wheels/controller/processing.cfm line 93
    /app/wheels/dispatch/functions.cfm line 154
    /app/wheels/index.cfm line 5
    /app/rewrite.cfm line 2
    /app/wheels/events/onrequest.cfm line 5



ERROR: column am.amcanorder does not exist
Position: 407

[perdjurner]

I had the same thing happen. I think it's a driver issue. I was using CF 10 and was hoping the drivers had been updated to fix it in more recent versions :(

[perdjurner]

http://stackoverflow.com/questions/38427585/postgresql-error-column-am-amcanorder-doesnt-exist

[chrisdpeters]

@perdjurner Looks like CF 11 drivers provided via the CommandBox install aren't upgraded to support PostgreSQL 9.6 yet. I switched to PostgreSQL 9.5, and everything works well.

Thanks for pointing that out through your sage wisdom. 🙌

[xiaoweixiaoyun]

hello，

Use eclipse to make ER diagram, driver version error report, how to modify to 9.5 driver version