PostgreSQLのトリガを試そうと思って、マニュアルの例をやってみたところ、 test=# CREATE TRIGGER if_dist_exists test-# BEFORE INSERT OR UPDATE ON films FOR EACH ROW test-# EXECUTE PROCEDURE check_primary_key ('did', 'distributors', 'did');
ERROR: CreateTrigger: function check_primary_key() does not exist
[postgres bin]$ postmaster start /usr/bin/postmaster does not know where to find the database system data. You must specify the directory that contains the database system either by specifying the -D invocation option or by setting the PGDATA environment variable.
[postgres bin]$ pg_ctl start pg_ctl: No database directory or environment variable $PGDATA is specified
tar.gzを展開する場合はconfigureすると、以下のエラーです。 NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it!
To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory.
Sorry, the host 'localhost' could not be looked up. Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option