From: | Sze Yuen Wong <swong_(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Newbie Questions, PostgreSQL |
Date: | 1998-10-15 17:13:07 |
Message-ID: | 19981015171308.23853.rocketmail@send203.yahoomail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm new to PostgreSQL and I've got the following questions:
1.What is wrong with the following PostgreSQL statement?
CREATE RULE r1 AS ON INSERT TO TBL1 DO [INSERT INTO TBL2 values
(new.i);
NOTIFY TBL2];
I got the following error messages following its execution:
ERROR: parser: parse error at pr near ""
ERROR: parser: parse error at pr near "]"
++++++++++++++++++++++++++++++++++++++++++++++++++++
2. When I type \E and \e to the psql prompt, there does not
seem to be any difference: both invoke vi and execute my SQL
statement upon exit from vi. My understanding is that \E should do
execution following editing whereas \e does do editing. Am I right?
Thank you very much.
Sze Wong
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Taral | 1998-10-15 18:30:34 | RE: [GENERAL] Newbie Questions, PostgreSQL |
Previous Message | Andrea Antibo | 1998-10-15 07:34:39 | Re: [GENERAL] make[2]: *** [psql] Error 1 |