Postgres Pro
Downloads
Home   >   mailing lists

SELECT triggers - Table Partitioning - Mailing list pgsql-novice

From Majid Azimi
Subject SELECT triggers - Table Partitioning
Date
Msg-id 4CCF3236.9080508@gmail.com
Whole thread Raw
Responses Re: SELECT triggers - Table Partitioning  (Yogesh Sharma <ysharma@catprosystems.com>)
List pgsql-novice
Tree view 
Hi guys.

In the documentation for triggers there is a sentence that says "you
can't create select triggers". could someone explain why?
When we use Table Partitioning how can we redirect SELECT queries to
specific tables. If we don't have SELECT triggers then it will search
all tables inherited from main table thus there is no performance
optimization in SELECT queries.
Is there any solution?

pgsql-novice by date:

Previous
From: Andreas
Date:
Subject: Re: How to have two not null constraints at the same time
Next
From: Yogesh Sharma
Date:
Subject: Re: SELECT triggers - Table Partitioning