[GENERAL] Trigger

Hi I am trying to create a trigger for a detail table to check that value what is entered exists in master table. For example into CustomerOrder table could not be enterd order for Customer what does not exists. How is it best done in PostgreSQL? I believe a trigger is what I must do. I looked

[GENERAL] Trigger

Hi I am trying to create a trigger for a detail table to check that value what is entered exists in master table. For example into CustomerOrder table could not be enterd order for Customer what does not exists. How is it best done in PostgreSQL? I believe a trigger is what I must do. I looked

[GENERAL] RE: Trigger

Hi On Tue, 7 Mar 2000, Andrzej Mazurkiewicz wrote: > Switch to v7.0 beta1 and use FOREIGN KEY. You will save a lot of time. > Before you really finish your development there will be 7.0 production (this > is my private estimation). > Andrzej Mazurkiewicz I am now using PostgreSQL 6.5.3 in RedHa

[GENERAL] Re: alter table

Hi > > > alter table tmp add column last text; I had this same problem, turned out that PostgreSQL don't have this feature :-( So only way is: DROP TABLE and then again CREATE TABLE with all the fields you need. Raigo

[GENERAL] stored procedure

Hi I can't find CREATE PROCEDURE in the guides. What is the way of creating stored procedures in PostgreSQL? Where can I find some examples? Also I would appreciate all examples on triggers. I have asked this before but I don't see all my messages appearing on the list. Please CC your reply

[GENERAL] Postgres manuals, guides etc.

Hi Is there a possibility to download all the PostgreSQL guides in one zip file? I searched postgres website but did not find this possibility .. maybe somebody can point me to the correct URL Thanks, Raigo