Oops, one other thing:



That was left by Alvaro Herrera on the same PostGres maillisting. I was thinking regular expression 'cause I miss read but when I used it I was thinking relation name...

Thanks for the tip. I actually joined the PostGres maillisting (http://www.postgresql.org/community/lists/) (pgsql-sql listing) and this guy (Andreas Kretschmer) helped me out - he's bloody...

Well I searched for PostGres Forums (plus I don't like joining forums - I only like DaniWeb :icon_biggrin:) and I didn't find any good ones (is there a place in DaniWeb this post should go?) but...

So creating a Trigger for PostGres isn't as easy as I thought it would be. I would have used to following query:

--create view Observation_Key
CREATE VIEW Observation_Key
AS SELECT...

Hi all, I'm not sure how to phrase this question... I have a table that requires a foreign key of anything table - this foreign key is automatically generated and the key field in the 'foreign'...