Hello.

Currently the module does not work correctly with PostgreSQL. This is because it is not possible to include in the ORDER BY clause, columns that do not appear in the select. This occurs in nodeorder_select_nodes() with weight_in_tid.

I am attaching a patch that fixes this.

Thank you very much.

Leandro

CommentFileSizeAuthor
#3 nodeorder_6.x-1.x-dev_postgresql_v2.patch1.54 KBeltrufa
nodeorder_6.x-1.x-dev_postgresql.patch771 byteseltrufa

Comments

eltrufa’s picture

eltrufa commented
Title: PostgreSQL aupport » PostgreSQL support
marcp’s picture

marcp commented

@lportela - you make a great point. If you are able to create a patch off DRUPAL-6--1 it would make our job easier to get this in. See http://drupal.org/patch/create for instructions on how to create the patch.

Thanks for bringing this issue to our attention.

eltrufa’s picture

eltrufa commented
StatusFileSize
new nodeorder_6.x-1.x-dev_postgresql_v2.patch1.54 KB

According to the request, I send the new version of the patch.

Thanks.

tuffnatty’s picture

tuffnatty commented
Status: Active » Needs review

vote +1 for this patch

pvanderspek’s picture

pvanderspek commented
Status: Needs review » Reviewed & tested by the community

I've added the patch to the current dev-version in the 6.x branch. Thanks for the work.

pvanderspek’s picture

pvanderspek commented
Version: 6.x-1.x-dev » 6.x-1.1
Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.