[SQL] Sometimes referential integrity seems not to work

In a database I am working, I sometimes have to delete all the records in some tables. According to the referential integrity defined in the creation of the tables, postmaster should not delete the records, but it does. I have used the following commands: "delete from table_1" and "truncate table_

[SQL] Getting the row_count value outside of a function

I can get the row_count value inside of a function, but I can´t get it outside of a function. How can I do this? Regards, Enio ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining