| From: | Davi Leal <davileal(at)terra(dot)es> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | ERROR: Conditional NOTIFY is not implemented |
| Date: | 2002-03-02 15:30:54 |
| Message-ID: | 200203021548.g22FmPvx021448@excalibur.ene.es |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Why I get this ERROR?. Maybe I do not use the accurate syntax?.
postgresql 7.1.3
I use Debian GNU/Linux (woody) on Intel.
Regards,
Davi Leal
$ createdb test
CREATE DATABASE
$ psql test
test=# CREATE TABLE prod
test-# (
test(# id serial
test(# );
NOTICE: CREATE TABLE will create implicit sequence 'prod_id_seq' for SERIAL
column 'prod.id'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'prod_id_key' for
table
'prod'
CREATE
test=#
test=#
test=# CREATE RULE pr AS ON DELETE TO prod DO (NOTIFY TBL2);
CREATE
test=#
test=#
test=# INSERT INTO prod DEFAULT VALUES;
INSERT 19315 1
test=# INSERT INTO prod DEFAULT VALUES;
INSERT 19316 1
test=#
test=# SELECT * FROM prod;
id
----
1
2
(2 rows)
test=# DELETE FROM prod WHERE id=1;
ERROR: Conditional NOTIFY is not implemented
test=# \q
$
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Serkan Bektaş | 2002-03-02 15:55:01 | HELP!.. "semget(key=2, num=17, 03600) failed: No space left on device" |
| Previous Message | Justin Clift | 2002-03-02 15:01:30 | Re: PostgreSQL favicon.ico |