Re: [GENERAL] Locking for function creation

2006-12-04 Thread Mark Morgan Lloyd
Richard Huxton wrote: > > Mark Morgan Lloyd wrote: > > > > If I might ask a related question- assuming that a client has grabbed a > > restrictive lock during a transaction that e.g. is create/replacing > > functions, > > what happens to other sessions th

[GENERAL] pgpool and ODBC

2006-01-09 Thread Mark Morgan Lloyd
ooted without breaking ODBC how does one prevent this from being a single point of failure? -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] ---(end of broadcast)---

[GENERAL] psql client binary

2006-02-26 Thread Mark Morgan Lloyd
Hopefully not to grievous an FAQ: can anybody point me at a precompiled binary of the psql terminal-based front-end to run on NT hopefully not requiring Cygwin, or has this been effectively replaced by pgAdmin? -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the

Re: [GENERAL] psql client binary

2006-02-26 Thread Mark Morgan Lloyd
Bruce Momjian wrote: > > Mark Morgan Lloyd wrote: > > Hopefully not to grievous an FAQ: can anybody point me at a precompiled > > binary of the psql terminal-based front-end to run on NT hopefully not > > requiring Cygwin, or has this been effectively replaced by pgAdm

[GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
have PostGIS or PL/R on the hacker's server, or- heaven forfend- both, is the best way to get at the production server still to use dblink? -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] --

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
way to merge their functionality in complex work would be to use a "farm". I hasten to say that I don't anticipate trying that, at least /this/ year, I'm just trying to think ahead :-) -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
atever you want with those results. Thanks Michael, interesting thoughts. -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] ---(end of broadcast)--- TIP 9: I

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
under User Mode Linux. Historically my preference has usually been to build from source, but even then there are cases where installing some prerequisite implies unwelcome mutilation of a stable machine- not strictly database-related but having to install gd and then finding that requires an u

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
the most recent distro by far, but I've got reasons for sticking with it. Otherwise most desktops here have Debian on them and I agree that having competent binary package management helps, although it's not a universal panacea. -- Mark Morgan Lloyd markMLl .AT. tele

Re: [GENERAL] Procedural language functions across servers

2006-07-10 Thread Mark Morgan Lloyd
uns a complex query including references to a() and b() which themselves initiate complex queries on backend servers A and B, can I tell X's planner to run a(A) and b(B) simultaneously, or is the only way to have these in distinct sessions storing their results in tables on X? -- Mark Morgan L

Re: [GENERAL] NT4 client problem

2006-09-06 Thread Mark Morgan Lloyd
ing to NT4W machines and possibly also '98 on the psql-odbc ML. I'm helping out in a very small way by doing some testing, I suggest you join us there. Current driver version is 8.02.0101 possibly with an updated DLL from Inoue-san's website. -- Mark Morgan Lloyd markMLl .AT. telemet

<    1   2