alter table

From: "Diego Cattelan" <netmaniac(at)libero(dot)it>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: alter table
Date: 2003-03-21 08:41:55
Message-ID: 001601c2ef85$bb739c00$b40a0a0a@XMan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

template1=#create database gesart;
template1=#create user xuser;
template1=# \c gesart xuser

gesart=>create table a(n integer);

CREATE TABLE
gesart=>alter table a add column c integer references xxxxxxx(id);

NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ALTER TABLE

The table xxxxxxx doesn't exist.

Is that correct or postgreSQL should report an error ?

PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message DEEPANSHU GARG 2003-03-21 11:14:07 Security problem with Postgres sql
Previous Message Neil Conway 2003-03-21 07:14:50 Re: Bug report