Postgresql temporary table

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

客户关系管理
e-Commerce
会计
库存
PoS
Project
MRP

All apps

所有帖文人徽章

标签（查看所有）

odoo accounting v14 pos v15

关于此论坛区

帮助

Postgresql temporary table

postgresql table temporary

1 回复

7036 查看

Zbik

Is possible manipulation on postgresql temporary table in odoo?

Presumably, the creation is not a problem, but how to organize views?

I would be grateful for any suggestion or an example.

Jaime Vasquez

In posgresql you can use temporary views and or tables but they are not accessible from Odoo.

Odoo has it's special temporary tables, they are typically used for wizards. To use a temporary table you can define it as a normal class, just use the following type of inheritance: models.TransientModel (new api) or osv.osv_memory (old api).

The views are defined as normal views.

see:
http://findnerd.com/list/view/-How-to-create-an-osv-memory-wizard-systems-in-Odoo-9-/12288/

http://stackoverflow.com/questions/28237145/using-popup-window-to-get-user-inputs-and-use-those-inputs-in-buttons-function

HTH

Zbik

编写者

Thank you for your answer. I'm not interested in wizard with model Transient. I seek solutions with temporary table and access records per session, not per user.

喜欢讨论吗？不要只阅读，加入进来！

立即创建账户，享受专属功能，与我们的精彩社区互动！

相关帖文	回复	查看
Openerp database list in postgresql 已解决 database postgresql table	5 4月 23	16288
what postgresql table for Devis? 已解决 accounting postgresql table	1 11月 16	3167
Postgres Large pg_toast, public.mail_message, pubic.mail_message_message_id.index tables postgresql size table	0 3月 15	5634
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 2月 25	1594
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 1月 25	8221

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！