Support psycopg 3

[bufke]

psycopg 3 is supported in Django 4.2. However it's interface has breaking changes.

File "/usr/local/lib/python3.10/site-packages/bitfield/types.py", line 261, in <module>
  Database.extensions.register_adapter(Bit, lambda x: Database.extensions.AsIs(int(x)))
AttributeError: module 'psycopg' has no attribute 'extensions'

extensions no longer exists. It's replacement is documented here.

I might be able to contribute a fix for this, however I'd have to learn about psycopg.

[bufke]

In some limited testing, it appears that removing these lines from types.py fixes the problem.

    Database.extensions.register_adapter(Bit, lambda x: Database.extensions.AsIs(int(x)))
    Database.extensions.register_adapter(BitHandler, lambda x: Database.extensions.AsIs(int(x)))

No adaption is required at all perhaps. I played around with django admin and was able to check and uncheck the bitfield options.

Are there instructions on how to run tests locally?

[kjumybit]

Hi team,

I'm running my Django apps using pscopg3. With reference to Django 4.2 release notes

Support for psycopg2 is likely to be deprecated and removed at some point in the future.

supporting pscopg3 is very helpful and required for migration existing apps.