Postgres Pro
Downloads
Home   >   mailing lists

Re: unique constraint on views - Mailing list pgsql-sql

From Jyoti Seth
Subject Re: unique constraint on views
Date
Msg-id 002101c95b45$8ddc5cf0$a99516d0$@com
Whole thread Raw
In response to Re: unique constraint on views  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
Tree view 
I want to put unique constraint on columns of more than one table. 

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of A. Kretschmer
Sent: Wednesday, December 10, 2008 6:04 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] unique constraint on views

In response to Jyoti Seth :
> Hi All,
> 
> Is it possible to add unique constraint on updateable views in postgres?

Add the constraint to the base-table.

Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

pgsql-sql by date:

Previous
From: "Allan Kamau"
Date:
Subject: Re: Collapsing (select) row values into single text field.
Next
From: "Pascal Tufenkji"
Date:
Subject: Re: Is there a bug in PostgreSQL ?