problem with postgresql views (psycopg2)

[fulviociriaco]

I attempted to use django with postgresql views by means of model class, the view rows
however do not change when the db is externally updated untill reentering python, e.g.

>>> mv=MyView.object
>>> mv.all()
[<Myview: MyView object>]
.....
insert row into table
.....
>>> mv.all()
[<Myview: MyView object>]     #1 row
^d
manage.py shell
>>> from ... import MyView
>>> MyView.objects.all()
[<Myview: MyView object>,<Myview: MyView object>]  #2 rows

That's all.
Fulvio

[Alex Gaynor]

I've reformatted the description of this ticket, in the future you can use the "Preview" button to ensure that your message is formatted the way you intended.

[Russell Keith-Magee]

This sounds like a case of user-error, related to the default isolation mode of your server. Unless you can point at something specific that Django is doing wrong, I'm going to close this.