[freeipdb-users] NULL syntax / new version of postgres

[Martin Richard]

Ah, got it.. found it in Postgres 7.2's HISTORY file:

---8<---
Migration to version 7.2
      * In this release, comparisons using = NULL will always return false (or
        NULL, more precisely). Previous releases automatically transformed
        this syntax to IS NULL. The old behavior can be re-enabled using a
        "postgresql.conf" parameter.
---8<---

So for now I'll change the config file to use the old behaviour, until code 
revisions support the new syntax.. in my distro the option is 
#transform_null_equals = false, the last line of the postgresql.conf file.. 
Just tested it - uncommented and switched to = true, and ipfreedb can 
finally report to me free blocks :)

I'm also guessing my comments about the sequence tables is working only 
with 7.2.. (sequence names themselves looks the same, but the pg_* tables 
seems to have changed..)

Martin Richard
Spécialiste Technique / Technical Specialist
Internet Solutions, COGNICASE