Rules

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?

Responses

  • Re: Rules at 2001-11-28 21:49:09 from Tom Lane
  • Re: Rules at 2001-11-28 21:56:18 from Stephan Szabo

Browse pgsql-general by date

  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 ...

Browse pgsql-hackers by date

  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