nevermind.. guess there was a problem with the query condition itself
regards
- Amol
On 05/04/10 22:42, Amol Chiplunkar wrote:
Hi,
I notice that for the following:
Table Base with say columns col1, col2
Table Child1 inherits(Base)
Table Child2 inherits(Base)
With check constraints and
Hi,
I notice that for the following:
Table Base with say columns col1, col2
Table Child1 inherits(Base)
Table Child2 inherits(Base)
With check constraints and rules to insert the rows to appropriate
tables defined.
Inserts work as expected.
select * from Base; returns rows from both the child
A crude way would be to put it in a block and ignore the exception
BEGIN
-- create temp table
EXCEPTION
WHEN DUPLICATE_TABLE THEN
-- Table already exists,
NULL;
END;
thx
- Amol
Szymon Guz wrote:
I want to create a temp table in a trigger... but this mu
Hi,
My postgres 8.1.4 installation does not have the crosstab
functions. Most likely due to unavailability of contrib/tablefunc
module.
Is there a std version of tablefunc .so that can be downloaded and used ?
thanks
- Amol
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
