On 12/11/17 19:15, Karsten Hilbert wrote:
On Sat, Nov 11, 2017 at 01:03:18PM +, Mark Morgan Lloyd wrote:
Several legacy programs written in Delphi ground to a halt this morning,
which turned out to be because a Debian system had updated its copy of
PostgreSQL and restarted the server
On 11/11/17 16:45, Jan Claeys wrote:
On Sat, 2017-11-11 at 14:23 +, Mark Morgan Lloyd wrote:
I think that the "preventing upgrades" route is the one to follow,
since inhibiting the restart would obviously present a risk that
something loaded dynamically could get out of step. As a
puts a file in there and then ignores both it and
the associated control in /etc/default.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Or since I'm almost
certainly not the first person to be bitten by this, is there a
preferred hack in mitigation?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing lis
h the underlying platform would have
been very much to PostgreSQL's disadvantage,
OP: Please note that you do yourself no favours at all by posting a
subject line which could very easily be misinterpreted as spam.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above
titioning it to
make absolutely sure that the internal controller has touched every block.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
n unavoidable need
to use Arduino "shields" there's an interface called the Raspduino which
would help.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general m
Potentially useful publicity.
http://www.theregister.co.uk/2016/10/28/unmanned_warrior_esri_argcis_cloud_based_mapping/
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing
#x27;t given us a URL or
told us the name of the module.
Can anyone suggest a db federeted plugin for mysql/mariadb to store data
in pg. Changing applications is impossible, they are proprietary and
work only with specific databases only.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT
Mark Morgan Lloyd wrote:
Elsewhere, somebody was asking how people implemented version control
for stored procedures on (MS) SQL Server.
The consensus was that this is probably best managed by using scripts or
command files to generate stored procedures etc., but does anybody have
any
Mike Sofen wrote:
-Original Message-
From: Mark Morgan Lloyd Sent: Thursday, June 30, 2016 2:41 AM
Neil Anderson wrote:
On 2016-06-29 12:37 PM, Mark Morgan Lloyd wrote:
Elsewhere, somebody was asking how people implemented version control
for stored procedures on (MS) SQL
Neil Anderson wrote:
On 2016-06-29 12:37 PM, Mark Morgan Lloyd wrote:
Elsewhere, somebody was asking how people implemented version control
for stored procedures on (MS) SQL Server.
The consensus was that this is probably best managed by using scripts or
command files to generate stored
PostgreSQL?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
something called Virtual Iron (possibly based on
Xen), but it was swallowed by Oracle where it was under the wing of Wim
Coekaerts who I believe has just joined Microsoft.
Has anybody ever experimented with PostgreSQL on this sort of thing, and
is anybody aware of an open equivalent?
--
Mark Morgan
Jernigan, Kevin wrote:
On 3/25/16, 4:37 AM, "pgsql-general-ow...@postgresql.org on behalf of Mark Morgan
Lloyd" wrote:
Just because a corporate has a hundred sites cooperating for inventory
management doesn't mean that the canteen menus have to be stored on
Oracle RAC :-
has a hundred sites cooperating for inventory
management doesn't mean that the canteen menus have to be stored on
Oracle RAC :-)
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-gene
ation of
developers etc.) can in no way be interpreted as meaning that the
technology is not unavailable or unreliable.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailin
Jim Nasby wrote:
On 11/6/15 8:01 AM, Mark Morgan Lloyd wrote:
Purely out of curiosity, is there any way of using some sort of "web of
trust" (comparable with GPG or whatever) when verifying server and
client certificates, rather than going back to a centralised CA?
My apologies if
new server and get it cooperating with the rest, and some
sort of WoT might be plausible rather than having to wait for the root
administrator to send keys over a secure channel.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his emp
use it or not.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thomas Kellerer wrote:
Mark Morgan Lloyd schrieb am 25.09.2015 um 23:41:
I'm trying to get support for PostgreSQL's listen/notify into a
development environment, but since it supports multiple database
backends: can anybody comment on how many other servers have a
comparable facility
rbase, but I'm not in a position to investigate Oracle,
IBM, MS and the rest. I'd appreciate any general comments from somebody
who has broad SQL experience, I'm not asking for example code.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author'
I think part of the question is what the
"true Debian way" is to massage the configuration files to include
appropriate entries.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Merlin Moncure wrote:
On Fri, May 10, 2013 at 2:32 PM, Mark Morgan Lloyd
wrote:
Merlin Moncure wrote:
On Fri, May 10, 2013 at 4:41 AM, Mark Morgan Lloyd
wrote:
I don't know whether anybody active on the list has R (and in particular
PL/R) experience, but just in case... :-)
i) Some
Merlin Moncure wrote:
On Fri, May 10, 2013 at 4:41 AM, Mark Morgan Lloyd
wrote:
I don't know whether anybody active on the list has R (and in particular
PL/R) experience, but just in case... :-)
i) Something like APL can operate on an array with minimal regard for
index order
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Tom Lane wrote:
Mark Morgan Lloyd writes:
Do any special precautions need to be taken when PQNotifies is being
called, to make sure that nothing else is referencing the handle?
It's pretty much the same as any other operation on a PGconn: if there
could be more than one thread touchin
(GUI) timer is asynchronously polling for notifications.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
s reliable.
Please also pardon me for asking inappropriate questions like this one. As far
as I can recall, every issue I encountered before always finally proved that
PostgreSQL is flawless.
But at least it demonstrates that somebody's using that facility.
--
Mark Morgan Lloyd
markML
Albe Laurenz wrote:
Mark Morgan Lloyd wrote:
Apologies for this old chestnut, but I think it's a question more often
asked than answered.
If I want to install a minimal binary libpq.dll on a non-developer
machine to support Lazarus/FPC programs, where do I get it?
I definitely don'
I'm definitely not saying that it's a
Postgres issue. I've tried forcing random connection drops at the
application level in the past and have never been able to characterise
the problem.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author
server, or
to build from source. I'd rather not give them pgadmin or psql. I'd
prefer not to install ODBC since I need to get at listen/notify that it
doesn't support.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those
odbc.msi of the appropriate version. You might also need a
separate MDAC installer.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
es one authenticated by password?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
Chris Angelico wrote:
On Fri, Jul 27, 2012 at 7:09 PM, Mark Morgan Lloyd
wrote:
Chris Angelico wrote:
On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd
wrote:
Assuming a *nix server: if a monitoring program determines that an
established connection appears to be trying to so something
lect * from pg_settings) to '/tmp/settings.csv' with
csv header;
\copy: parse error at "select"
markMLl=>
However my psql and server are rather old which could be an issue
(8.1.19 to server 8.4 if I recall correctly).
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinio
Chris Angelico wrote:
On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd
wrote:
Assuming a *nix server: if a monitoring program determines that an
established connection appears to be trying to so something inappropriate,
what's the best way of terminating that session rapidly?
s
Assuming a *nix server: if a monitoring program determines that an
established connection appears to be trying to so something
inappropriate, what's the best way of terminating that session rapidly?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author&#
f Time calculation
is good to something like 250mSec so that's the limit of your accuracy,
but as soon as you start taking refraction and atmospheric turbulence
into account- even with the Sun high above the horizon- you're going to
degrade that.
--
Mark Morgan Lloyd
markMLl .
t;roll your own"
interface library, the libpq+pg combination has been in use for 10+
years, is actively maintained, and (hopefully) is bug- and
backdoor-free. Reinventing this particular wheel is definitely not
something that should be approached casually.
--
Mark Morgan Lloyd
markMLl .AT. t
s in
a development framework which isolates you from the low-level handles etc.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
ing "confirm your account" type emails will can it.
I suspect that we're supposed to do this every day- I'm sure that
Certain Corporates will have no compunction at using multiple votes.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the autho
r the
years: if anybody still has this example do you think you could post a
URL where it might be found?
My apologies for posting this here as well as in the ODBC ML.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
Steve Crawford wrote:
On 06/14/2011 05:13 AM, Mark Morgan Lloyd wrote:
Karsten Hilbert wrote:
On Tue, Jun 14, 2011 at 09:40:20AM +, Mark Morgan Lloyd wrote:
Is it possible to incorporate SET TIMEZONE into a query, so that
to_char(...'TZ') etc. is appropriately localised?
Y
Tom Lane wrote:
John R Pierce writes:
On 06/14/11 2:40 AM, Mark Morgan Lloyd wrote:
The development environment I'm working with uses short-lifetime
sessions, and it's proving difficult to get a set command and a query
associated with the same handle.
this environment doesn
Karsten Hilbert wrote:
On Tue, Jun 14, 2011 at 09:40:20AM +, Mark Morgan Lloyd wrote:
Is it possible to incorporate SET TIMEZONE into a query, so that
to_char(...'TZ') etc. is appropriately localised?
You seem to want "AT TIME ZONE".
Thanks for that. How can I do /t
me handle.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
one of the best postgres drivers ever written!)
I don't use Zeos, but a few months ago I was using listen/notify via
FPC's standard classes to good effect so I'd be surprised if there were
any problems.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are t
Greg Smith wrote:
On 05/01/2011 01:50 AM, Mark Morgan Lloyd wrote:
Somebody is making a very specific claim that Postgres can support a
limited number of rows
Did you find this via
http://www.reversecurity.com/2011/04/new-details-from-psn-hack.html ?
That was the only Google-indexed source
Tom Lane wrote:
Jasen Betts writes:
On 2011-05-01, Mark Morgan Lloyd wrote:
Somebody is making a very specific claim that Postgres can support a
limited number of rows:
"INPS (a data forensics team) said that there is 7 main Databases all
hosted at different data centers but linked o
Magnus Hagander wrote:
On Sun, May 1, 2011 at 07:50, Mark Morgan Lloyd
wrote:
Somebody is making a very specific claim that Postgres can support a limited
number of rows:
"INPS (a data forensics team) said that there is 7 main Databases all hosted
at different data centers but linked o
the most amount of data each
database could hold with no stability issues is aproximitely equal to
that of 10,348,439 Rows" http://pastebin.com/MtX1MDdh
Does anybody have any idea where they've got hold of this figure?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinio
one setting.
But out of curiosity will (ii) also mess up extract(epoch ...), or will
that consistently return the number of UTC seconds rather than adjusting
for the local timezone?
If it does, is there a "right" way of restricting the scope of a
timezone change to a single function
Tom Lane wrote:
Mark Morgan Lloyd writes:
SELECT to_char(('2011-03-01 12:00' AT TIME ZONE 'GMT0BST')::TIMESTAMP
WITH TIME ZONE, 'HH24:MI TZ');
to_char
---
12:00 GMT
(1 row)
You haven't said exactly what you were hoping to accomplish, but I
su
e, how can I get TZ indicating whether daylight saving
is in effect? Alternatively, is there a flag I can retrieve indicating
that a timestamp has been corrected for DST so that I can select an
alternative name for display?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above
Adrian Klaver wrote:
On Wednesday 24 November 2010 1:08:27 am Mark Morgan Lloyd wrote:
What is best practice when extracting both current and average from a
table? Demonstration table here contains data from a cheap weather station.
I can obviously get the current reading like this:
select
How are these
best merged to yield a single row? Some form of join, or window functions?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
using PostgreSQL
in this way for their raw data?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
pierce', 'John',
>>> 'Pierce'), ('104', 'elaura', 'Elian', 'Laura');
>>>
>>> SELECT username,firstname,lastname FROM users WHERE uid=103;
If you think about it one of those statements is giving the system
Mark Morgan Lloyd wrote:
I thought earlier that I could use finger as a hack for querying the
server, i.e. I could put e.g. a disc set name in /home/postgres/.plan.
However I then realised that I'd need %M to be expanded before %`, so
that I could do something like
\set PROMPT1 &#x
[ and %]. Multiple
pairs of these can occur within the prompt. For example:
testdb=> \set PROMPT1 '%[%033[1;33;40m%...@%/%R%[%033[0m%]%# '
results in a boldfaced (1;) yellow-on-black (33;40) prompt on
VT100-compatible, color-capable terminals.
Thanks, noted.
--
Mark Morgan Lloy
hubert depesz lubaczewski wrote:
On Fri, Jan 08, 2010 at 11:20:36AM +, Mark Morgan Lloyd wrote:
Is there any way of getting psql to display the name of the
currently-connected server in its prompt, and perhaps a custom string
identifying e.g. a disc set, without having to create a psqlrc
sing down every psql binary that's been
installed on the LAN in an attempt to protect users from self-harm: far
nicer if the default psql prompt could be loaded from the server.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those
appear to
have) fixed it: the app was a scheduler running on a Windows system and
contained a lot of pathnames with backslashes hence
standard_conforming_strings = on.
I'll play with the new system for a few days and if all goes well try to
migrate on New Year's Day.
--
Mark Morgan L
de is robust against the new
server and then decide on an upgrade schedule.
I'm building from scratch here so all options are as default except for
added Perl.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
Adrian Klaver wrote:
On Thursday 24 December 2009 11:20:35 am Mark Morgan Lloyd wrote:
I was hoping to finally get the servers updated from 8.2 to 8.4 over the
festive season, but by now I think I've left things too tight.
Is it necessary to update the (Windows) ODBC driver as well? I
from the app side but is there anything
obvious that I've missed?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
ebian i386, problems on SPARC and
PPC (form creation wizard broken, ODBC suspect) but I've not had time to
investigate properly.
To do the job properly I'd be using Lazarus.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of hi
LIKE would be appropriate here?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Oct 30, 2009 at 8:44 AM, Mark Morgan Lloyd
wrote:
What is the "correct" behavior of a serial column when a table is created
with LIKE? The manual is silent on this.
What appears to be happening with 8.2 is that the column in the new table
refers to the original sequence
What is the "correct" behavior of a serial column when a table is
created with LIKE? The manual is silent on this.
What appears to be happening with 8.2 is that the column in the new
table refers to the original sequence generator.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.c
always leave yourself
a way that you can extract a representative query after any
parameterisation and do an EXPLAIN to look for inefficiencies.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
r...@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--
I trust you've investigated Lazarus?
--
Mark Morgan Lloyd
markMLl .AT. tel
27;d recommend using libpq direct.
I have using an older Delphi (v3), ODBC itself I believe was fine but
the BDE layer introduced problems- apps needed to be rebooted evey month
or so.
Note that ODBC doesn't easily support any non-standard facilities, e.g.
listen/notify.
--
Mark
anguage.
Is there a "good" way to get round this?
Server is 8.2 on Linux x86, queries from psql.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
stgreSQL server. IIRC There were
still hooks for it in v6 although they've since been removed.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-genera
b. Does anybody have
any suggestions for tools well-matched to this sort of problem, i.e.
that can match patterns, store matched patterns or update counters,
backtrack where necessary, and so on?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's,
Richard Huxton wrote:
Mark Morgan Lloyd wrote:
Alternatively I appreciate that I could use PL/pgSQL but that would
assume that if I sent the sequence of operations to somebody else that
he also had it compiled into his server.
Well, pl/pgsql has been automatically included in all recent
ce of operations to somebody else that
he also had it compiled into his server.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
same model but certainly using the same drive hardware, PSUs etc. If
your boss won't spend the sort of money that these machines go for on
eBay then your company isn't serious about running a service for its
customers.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
by a bit of maths, that's likely to be a
big incentive for an upgrade when it comes out.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgres
ed access.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
cit count() as the second parameter
if using it to number rows, i.e. it doesn't have an "as many as
necessary" option.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-gener
hence rates of change. I've typically been
doing it manually or in a spreadsheet but there has to be a better way
e.g. by a join on offset row numbers.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues
Rodrigo De Le? wrote:
Pg is pretty smart for almost any case.
Which still doesn't say anything about best practice. In the end I found the
relevant part of the SQL spec, correct forms are HOUR and MINUTE where the
associated numbers are integers.
--
Mark Morgan Lloyd
markML
ger number of minutes?
All these forms appear to work. I've got no intention of jumping ship but am
curious as to the favoured and most portable style.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
rface for the latter.
--
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: In versions below 8.0, the planner will ignore your
the check_loaded.pl script could check that the table was cached and
return its name when available. However I guess that the script would probably
need to see the initial lseek or whatever as well... there's probably a whole
lot of non-obvious details that I've totally overlooked.
obably unnecessary if the
application program was aware that a table had been partitioned by age and
accessing old data could be slow.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
code for experimental
Berkeley code to do this sort of thing but as far as I know there has never
been anything publicly available.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
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
that a client has grabbed a
restrictive lock during a transaction that e.g. is create/replacing functions,
what happens to other sessions that attempt to run a select or update- will they
fail (i.e. an implicit NOWAIT) or will they wait until the lock is released?
Does this vary depending on whe
Richard Huxton wrote:
>
> Mark Morgan Lloyd wrote:
> > If there's a risk that multiple clients will try to execute a 'create or
> > replace function' simultaneously, what's the recommended practice for
> > putting it in a transaction and/or locking it?
tion is most likely to be involved with, an arbitrary
table, or a dummy table specifically reserved for this purpose?
--
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)---
Andreas Kretschmer schrieb:
>
> Mark Morgan Lloyd <[EMAIL PROTECTED]> wrote:
> > > test=# select now()::time;
> > > now
> > >
> > > 11:16:18.22527
> > > (1 row)
> >
> > Thanks Andreas, I've ended up
Andreas Kretschmer schrieb:
>
> Mark Morgan Lloyd <[EMAIL PROTECTED]> wrote:
> > What is the correct (or even any :-) way of converting a timestamp into a
> > time (without timezone etc.)?
>
> You can CAST it:
>
> test
o possibly include timezone
correction. Obviously this has worked fine for a number of years on 7.1, but 8.1
is objecting to the time() cast.
What is the correct (or even any :-) way of converting a timestamp into a time
(without timezone etc.)?
Any suggestions would be much appreciated.
--
M
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
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
1 - 100 of 111 matches
Mail list logo
