Re: virtual table

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