From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Albert Bartoszko <albertb(at)nt(dot)kegel(dot)com(dot)pl> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Rules |
Date: | 2001-11-28 21:56:18 |
Message-ID: | 20011128135159.J34572-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Wed, 28 Nov 2001, Albert Bartoszko wrote:
> AFAIR (Postgres 6.5 - 7.1.3):
>
> cd /usr/src/postgresql-X.X.X/src/interfaces/libpq++/examples
> [postgres(at)xxx examples]$ /usr/local/pgsql/bin/psql
> Password:
> Welcome to psql, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> postgres=# \i testlibpq2.sql
> CREATE
> CREATE
> psql:testlibpq2.sql:5: ERROR: parser: parse error at or near ""
> psql:testlibpq2.sql:5: ERROR: parser: parse error at or near "]"
> postgres=# \q
> [postgres(at)komuna examples]$ cat testlibpq2.sql
> CREATE TABLE TBL1 (i int4);
>
> CREATE TABLE TBL2 (i int4);
>
> CREATE RULE r1 AS ON INSERT TO TBL1 DO [INSERT INTO TBL2 values (new.i);
> NOTIFY TBL2];
It works for me with () rather than [], although both are in the help.
From | Date | Subject | |
---|---|---|---|
Next Message | Mårten Gustafsson | 2001-11-28 22:52:14 | Re: [GENERAL] Rules |
Previous Message | Tom Lane | 2001-11-28 21:49:09 | Re: Rules |
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Studenmund | 2001-11-28 22:04:31 | Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens |
Previous Message | Tom Lane | 2001-11-28 21:49:09 | Re: Rules |