[GENERAL] Help me get started with moving away from Firebird

I was able to create all the domains, tables, views, etc, but I have trouble creating stored procedures and triggers. Also, a question, does Postgres support events, for example in Firebird I could do something like this and then receive the event in the GUI: if ((NEW.MUSED_M_>=NEW.MLIMIT_M_) an

Re: [GENERAL] Trying to move away from Firebird

Thanks for the links Adrian. I was able to convert a bunch of triggers after reading the documentation. Yes, it looks like POST_EVENT is the smaller brother of NOTIFY. http://www.postgresql.org/docs/9.0/static/sql-notify.html

[GENERAL] Trying to move away from Firebird

I was able to create all the domains, tables, views, etc, but I have trouble creating stored procedures and triggers. Also, a question, does Postgres support events, for example in Firebird I could do something like this and then receive the event in the GUI: if ((NEW.MUSED_M_>=NEW.MLIMIT_M_) an

Re: [GENERAL] PostgreSQL vs Firebird SQL

> Is this running as an embedded engine or a standalone server? One thing > about Firebird is that since it is embeddable, in that mode other > application bugs could corrupt the database. In the other case, I would > expect you may want to run hardware diagnostics to rule out hardware > problems

[GENERAL] PostgreSQL vs Firebird SQL

I have a Firebird SQL database running on one of my servers which has about 50k inserts, about 100k updates and about 30k deletes every day. There are about 4 million records in 24 tables. I have a bunch of stored procedures, triggers, events and views that I'm using. Firebird works fairly well, bu