Django 分页对象与 Postgresql QuerySets 存在问题

发布于 2024-10-15 03:33:48 字数 909 浏览 2 评论 0原文

我有一些 django 代码在 SQLite 数据库或 MySQL 数据库上运行良好,但它在 Postgres 上遇到问题,这让我抓狂,因为以前没有人遇到过这个问题。我认为这也可能与寻呼机评估查询集的方式有关。

在一个视图中,我有:

def index(request, page=1):
    latest_posts = Post.objects.all().order_by('-pub_date')
    paginator = Paginator(latest_posts, 5)
    try:
        posts = paginator.page(page)
    except (EmptyPage, InvalidPage):
        posts = paginator.page(paginator.num_pages)
    return render_to_response('blog/index.html', {'posts' : posts})

在模板内部:

{% for post in posts.object_list %}
    {# some rendering jazz #}
{% endfor %}

这与 SQLite 配合得很好,但 Postgres 给了我:

Caught TypeError while rendering: 'NoneType' object is not callable

为了使事情进一步复杂化,当我将 Queryset 调用切换为:

latest_posts = Post.objects.all()

一切都很好。我尝试重新阅读文档,但一无所获,尽管我承认此时我有点沮丧。我缺少什么?

提前致谢。

I have some django code that runs fine on a SQLite database or on a MySQL database, but it runs into problems with Postgres, and it's making me crazy that no one has has this issue before. I think it may also be related to the way querysets are evaluated by the pager.

In a view I have:

def index(request, page=1):
    latest_posts = Post.objects.all().order_by('-pub_date')
    paginator = Paginator(latest_posts, 5)
    try:
        posts = paginator.page(page)
    except (EmptyPage, InvalidPage):
        posts = paginator.page(paginator.num_pages)
    return render_to_response('blog/index.html', {'posts' : posts})

And inside the template:

{% for post in posts.object_list %}
    {# some rendering jazz #}
{% endfor %}

This works fine with SQLite, but Postgres gives me:

Caught TypeError while rendering: 'NoneType' object is not callable

To further complicate things, when I switch the Queryset call to:

latest_posts = Post.objects.all()

Everything works great. I've tried re-reading the documentation, but found nothing, although I admit I'm a bit clouded by frustration at this point. What am I missing?

Thanks in advance.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

中二柚 2024-10-22 03:33:48

这对我来说是一个可怕的错误,不能归咎于 Postgresql - 这个问题是由于我的自定义模板标签之一处理 postgresql 数据库中的某些帖子的方式而出现的,而这些帖子在 SQLite 数据库中不存在。我仍在弄清楚这个问题,但这个问题是无效的。

This was a terrible mistake on my part, no blame goes to Postgresql - the issue was popping up with the way one of my custom template tags was handling certain posts in the postgresql database that weren't present in the SQLite one. I'm still figuring out the issue, but this question is invalid.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文