| From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
|---|---|
| To: | Taral <taral(at)mail(dot)utexas(dot)edu> |
| Cc: | Sze Yuen Wong <swong_(at)yahoo(dot)com>, pgsql-general(at)postgreSQL(dot)org |
| Subject: | RE: [GENERAL] Newbie Questions, PostgreSQL |
| Date: | 1998-10-16 12:23:08 |
| Message-ID: | Pine.BSF.4.05.9810160822340.4514-100000@hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 15 Oct 1998, Taral wrote:
> > 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 "]"
>
> You want " and ", not [ and ]. And you will need to specify LANGUAGE "SQL"
> as well, I think.
And, up until v6.4 (to be released), I *thought* that rules were actually
broken...
Marc G. Fournier scrappy(at)hub(dot)org
Systems Administrator @ hub.org
scrappy(at){postgresql|isc}.org ICQ#7615664
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 1998-10-16 12:27:13 | Re: [GENERAL] v6.4-BETA2 Compile error |
| Previous Message | Marc G. Fournier | 1998-10-16 12:20:58 | Re: [GENERAL] Upgrading 6.3.1->6.3.2 |