[GENERAL] on delete rules on a view problem

2005-07-20 Thread Rose, Juergen
Hi all, I'am a bit puzzled. I have a view and some delete rules defined on it. Now my problem is, only one gets executed (the first one) and the other ones seem not to be executed at all. I use a subselect within those rules (which works fine for the first one by the way) and I wonder if this c

[GENERAL] Insert into ... Select ... From ... too intelligent transaction

2005-07-21 Thread Rose, Juergen
Hi all, I'm still working on my updateable views, which work fine now even I have a trigger to use because my delete rules wont work, but thats not my current, more important problem. I use some updateable views to handle my data (which are amazingly slow), which gives me ultimate flexibility

Re: [GENERAL] Insert into ... Select ... From ... too intelligent transaction

2005-07-22 Thread Rose, Juergen
> # [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200: > > I use some updateable views to handle my data (which are amazingly > > slow), which gives me ultimate flexibility to handle my data. > > > > there are some insert rules which use currval() to get the last > > sequence id for my data which I h

Re: [GENERAL] Insert into ... Select ... From ... too intelligent transaction

2005-07-22 Thread Rose, Juergen
> # [EMAIL PROTECTED] / 2005-07-22 09:10:01 +0200: > > > # [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200: > > > > I use some updateable views to handle my data (which > are amazingly > > > > slow), which gives me ultimate flexibility to handle my data. > > > > > > > > there are some insert ru

[GENERAL] pg_dump on 7.4

2006-05-26 Thread Rose, Juergen
Hi, We have a running postgresql 7.4 on our server (SuSE Linux 9), and at the moment there is no chance to upgrade. Through an unusual combination of constraints (spanning over schemas) the dump cannot be imported without errors anymore. Are there any statically compiled 8.x binaries (with wh