From: | "Albert Bartoszko" <albertb(at)nt(dot)kegel(dot)com(dot)pl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Rules |
Date: | 2001-11-28 14:07:51 |
Message-ID: | 3c04ef83@news.vogel.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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];
[postgres(at)komuna examples]$
What is wrong?
From | Date | Subject | |
---|---|---|---|
Next Message | wsheldah | 2001-11-28 14:10:28 | Re: Starting PosgreSQL at bootup time |
Previous Message | Antonio Fiol Bonnín | 2001-11-28 13:40:12 | Re: Not existing relations ... |
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Bertheau | 2001-11-28 14:13:43 | Re: Week number |
Previous Message | Larry Rosenman | 2001-11-28 13:17:23 | Re: Call for platform testing |