Re: virtual table - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: virtual table
Date
Msg-id 3EF6C3D6.7080904@klaster.net
Whole thread Raw
In response to Re: virtual table  (Richard Huxton <dev@archonet.com>)
Responses Re: virtual table
List pgsql-sql
Dnia 2003-06-23 10:54, Użytkownik Richard Huxton napisał:

> Hmm - I think your problem is going to come before that. Any time you do an 
> INSERT, PostgreSQL is going to need to know the types of all the columns 
> involved.
> 
> For this sort of thing, I try to keep all the related bits (initial function, 
> views, triggers) in the same text-file to encourage me to remember to update 
> them all together.
I also do this - it isn't really difficult with well written scripts. I was 
just wondering if I don't waste my time tracking all the changes.

> 
> It sounds like this table1 is only being used during transfer. Is there any 
> reason why you aren't just inserting the required rows into table2.
My queries are ordinary transportation problems with 0 up to 2 changes. I 
found it's better (for performance reason) to find all possible relations as 
single rows and split them at the end into simple connections. Maybe I should 
dig into this problem again and rewrite my queries...

Regards,
Tomasz Myrta




pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: virtual table
Next
From: Richard Huxton
Date:
Subject: Re: Urgent Help : Use of return from function/procedure.