milar to Microsoft's SQL Server. Sybase also declares deep cooperation with
Novell (SuSE distribution). I don't think Oracle does not bother with this.
Regards,
Mariusz Czułada
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi,
I tried to create rule on a view. It should contain a WHERE clause.
Unfortunately it does not work:
a_4m=# CREATE RULE sharp_p1_rule AS ON SELECT TO sharp
a_4m-# WHERE part_key = 1
a_4m-# DO
a_4m-# INSTEAD SELECT * FROM sharp_p1;
ERROR: ON SELECT rule may not use OLD
a_4m=# CREATE RU
Hi,
In a database I have to create new schemas with exactely the same structure as
the default one. Of course, I could reverse a schema with pg_dump, then apply
the script to the newly created one. The problem is the base schema sometimes
changes so I should generate scripts every time. Also I
