Re: How to union tables and have a field with UNIQUE constraint?

From: Katona Gabor <katonag(at)dragon(dot)klte(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to union tables and have a field with UNIQUE constraint?
Date: 2002-01-04 08:08:50
Message-ID: Pine.GSO.4.10.10201040857160.4534-100000@dragon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> I would argue that this should be disallowed, since it does not do
> anything useful and can only mislead people into thinking that it
> has some effect.
>
> Since triggers on a view won't do anything either, I don't see how one
> could expect REFERENCES to a view to work. The system ought to reject
> all this stuff as unimplemented.

OK, I understand the problem with referencing a view and I changed my code
to use CREATE TABLE AS instead of a view (the created table will change very
rarely, so I'll update it then via a trigger). Is this way ok now and will
work until the end of time :) ?
And thanks for the answers.

Gabor Katona

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-01-04 08:19:53 Re: maintaining a field for every UPDATION.
Previous Message Bhuvan A 2002-01-04 06:47:45 maintaining a field for every UPDATION.