Menu

#120 Incompatibility with Postgresql 8.1 +

open
nobody
None
5
2006-06-19
2006-06-19
Anonymous
No

Postgresql 8.1 does not use OID by default [1] but the
Webmin Postgresql module uses it in some SQL requests
(ex: viewing table content).

select oid,* from "foo" limit 25 offset 0 failed :
ERROR: column "oid" does not exist

[1] see "default_with_oids is now false by default"
http://www.postgresql.org/docs/8.1/static/release-8-1.html

Discussion

  • Jamie Cameron

    Jamie Cameron - 2006-06-19

    Logged In: YES
    user_id=129364

    This is a known problem in Webmin, which is still being
    worked on. Its a pity OIDs are not supported any more, as
    they are a great way to uniquely identify rows!

     
  • Jamie Cameron

    Jamie Cameron - 2006-06-19
    • labels: 323103 -->
    • milestone: 114355 -->
    • assigned_to: jcameron --> nobody