Re: [SQL] How to influence the planner

2007-09-01 Thread Richard Huxton
Richard Ray wrote: When is enable_seqscan = off appropriate Never(*) It's not for normal usage, the various enable_xxx settings do let you experiment with different options if you think the planner is making a mistake. (*) OK, sooner or later, if you have enough systems and enough perfor

Re: [SQL] Request into several DBMS simultaneously on DDL and DML

2007-09-01 Thread Dmitry Turin
Good day, Richard. DT> As result, __new type of system information__ appears: As result, new type of system information appears - field, refering to other field by foreign key, indeed contain two values: (1) usual value, assinged into field by user select FieldFK, ... insert

Re: [SQL] pg & Delphi

2007-09-01 Thread Dmitry Turin
Very thanks to all. Some questions: RH> You should be able to connect via ODBC. I don't know Delphi well (i used only BDE). What Delphi's object should be used to connect via ODBS (instead of BDE-components TTable, TDatabase) ? JT> Delphi should let you use dlls written in other languages. JT> So