Re: Updatable Views - DEFAULT doesn't inherit from table???

From: Csaba Együd <csegyud(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Updatable Views - DEFAULT doesn't inherit from table???
Date: 2008-12-05 14:09:00
Message-ID: ghbclp$17kr$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

""Grzegorz Jaśkiewicz"" <gryzman(at)gmail(dot)com> a következőket írta üzenetében
news:2f4958ff0812050549p6b86bc1dqc81c9bc726617198(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
> maybe that constraint ?? CONSTRAINT fk_products_qtyunitid FOREIGN KEY
> (qtyunitid) REFERENCES whm.qtyunits (id) MATCH FULL ON UPDATE
> CASCADE ON DELETE CASCADE,
>
> Also, that table seem to be far away from perfect, too many fields,
> you should chop it into few smaller tables.
>
>
> 2008/12/5 Csaba Együd <csegyud(at)gmail(dot)com>:

Hi, thx for your reply too. Not that I guess because there is a default row
in qtyunits with id=-1.

Too many fields: How would you chop this table?

thx,
-- Csaba

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2008-12-05 14:23:30 Planner picking topsey turvey plan?
Previous Message William Temperley 2008-12-05 14:08:45 <IDLE> in transaction - safest way to kill