Re: Postgresql VIEWs

[prev] [thread] [next] [Date index for 2005/02/09]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



Justin Tocci wrote:
| [...]
|
| Andreas Fromm asked about primary keys being missing in VIEWs. I always
| have at least one primary key in my VIEWs, otherwise it would be
| difficult to do anything but SELECT. Mostly, when combining two TABLEs
| in one VIEW, I still only need one primary key because I can follow the
| relationship to edit the TABLE that doesn't have it's primary in the VIEW.
|
What do you mean with "I always have at least one PK in my VIEW"? Do you
mean that you always define one of the table's PK as one column of the
views?

- --
Grüße,

Andreas Fromm

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCCcUdUmBtSMq5cGURAsj4AKDPeVTsZCCTnoGNwupZTqbg7b+EsACgh5a9
h5WSqGeP8WvW/g2I4b5xjTo=
=LQLH
-----END PGP SIGNATURE-----