Re: [GENERAL] How to use views&rules to dynamically choose which table to update

On Apr 01, 2006, at 12:57 am, Stephan Szabo wrote: What should it do if you try to insert something that is neither french nor english? I think an unconditional instead nothing rule might work to supplement the two conditional ones if doing nothing is okay, but I haven't tried. Wahey! The

Re: [GENERAL] How to use views&rules to dynamically choose which table to update

Hi David On Apr 01, 2006, at 12:13 am, David Fetter wrote: Wow. That's confusing. You're telling me! :D How about using table partitioning for this? Thanks for your suggestion. I've had a look at partitioning but the

Re: [GENERAL] How to use views&rules to dynamically choose which table to update

On Sat, Apr 01, 2006 at 12:04:26AM +0100, Ashley Moran wrote: > I'm still relatively new to Postgres (at least when it comes to > clever stuff - especially rules) so I hope I've missed something here. > > Basically I'm still trying to combine multiple databases with > identical schemas into on

[GENERAL] How to use views&rules to dynamically choose which table to update

I'm still relatively new to Postgres (at least when it comes to clever stuff - especially rules) so I hope I've missed something here. Basically I'm still trying to combine multiple databases with identical schemas into one schema, adding a column to each table to indicate which schema it c