[HACKERS] File IO - why does PG do things in pages?

2009-11-26 Thread Dan Eloff
Hi Hackers, I've familiarized myself a little with the architecture of postgresql, largely because it's interesting. There's one thing I can't quite figure out though, and it seems that there's no better group of people in the world to ask about it. At the lower levels in PG, reading from the dis

[HACKERS] Limitations on trigger functions

2008-08-16 Thread Dan Eloff
I came across this bug tonight: -- Function: pre_delete_main() CREATE FUNCTION pre_delete_main() RETURNS TRIGGER AS $BODY$BEGIN DROP TABLE bug_referring_table; RETURN OLD; END;$BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100; -- Table: bug_referenced_table CREATE TABLE bug_referenced_table (