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
On 11/11/17 13:45, Christoph Berg wrote:
Re: Magnus Hagander 2017-11-11
'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 list (pgsql-general@pos
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 are the author's, not those
re 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 make changes to your subscription:
http:
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 mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
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 list
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. uk
[Opinions
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
of 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/pgsql
to be 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" <pgsql-general-ow...@postgresql.org on behalf of
markmll.pgsql-gene...@telemetry.co.uk> wrote:
Just because a corporate has a hundred sites cooperating for inven
ecause a corporate 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 pgsq
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 mailing list (pgsql-general@postgresql.or
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
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 employers or
er wants
to 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?
Minimal
, 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's, not those of his employers
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-general mailing list
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
Merlin Moncure wrote:
On Fri, May 10, 2013 at 4:41 AM, Mark Morgan Lloyd
markmll.pgsql-gene...@telemetry.co.uk 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
Merlin Moncure wrote:
On Fri, May 10, 2013 at 2:32 PM, Mark Morgan Lloyd
markmll.pgsql-gene...@telemetry.co.uk wrote:
Merlin Moncure wrote:
On Fri, May 10, 2013 at 4:41 AM, Mark Morgan Lloyd
markmll.pgsql-gene...@telemetry.co.uk wrote:
I don't know whether anybody active on the list has R
) 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 subscription:
http
Tom Lane wrote:
Mark Morgan Lloyd markmll.pgsql-gene...@telemetry.co.uk 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
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
markMLl .AT. telemetry.co .DOT. uk
[Opinions above
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's, not those of his employers
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't want
, 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 of his employers or colleagues
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 make changes to your
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's
Chris Angelico wrote:
On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd
markmll.pgsql-gene...@telemetry.co.uk 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
/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
[Opinions above are the author's, not those of his employers
Chris Angelico wrote:
On Fri, Jul 27, 2012 at 7:09 PM, Mark Morgan Lloyd
markmll.pgsql-gene...@telemetry.co.uk wrote:
Chris Angelico wrote:
On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd
markmll.pgsql-gene...@telemetry.co.uk wrote:
Assuming a *nix server: if a monitoring program
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.postgresql.org/mailpref/pgsql
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 .AT. telemetry.co .DOT. uk
[Opinions
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. telemetry.co .DOT. uk
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 make changes to your subscription:
http
a firewall that is
over-zealous catching 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
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 colleagues
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
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 /this/
select to_char
Tom Lane wrote:
John R Pierce pie...@hogranch.com 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
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?
You seem
, but zeos is 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
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
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
[Opinions above are the author's
Magnus Hagander wrote:
On Sun, May 1, 2011 at 07:50, Mark Morgan Lloyd
markmll.pgsql-gene...@telemetry.co.uk 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
Tom Lane wrote:
Jasen Betts ja...@xnet.co.nz writes:
On 2011-05-01, Mark Morgan Lloyd markmll.pgsql-gene...@telemetry.co.uk 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
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?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers
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 are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general
Tom Lane wrote:
Mark Morgan Lloyd markmll.pgsql-gene...@telemetry.co.uk 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
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)
To make changes to your
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
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 subscription:
http
');
SELECT username,firstname,lastname FROM users WHERE uid=103;
If you think about it one of those statements is giving the system
information which it can store (I'm not sure the way it does this is
really important) and re-use.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions
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 '`finger
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 of his employers or colleagues
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
= \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 Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers
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 Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions
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've got
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 colleagues]
--
Sent via pgsql
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 your subscription:
http://www.postgresql.org/mailpref
, 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 his employers or colleagues
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.co .DOT. uk
On Fri, Oct 30, 2009 at 8:44 AM, Mark Morgan Lloyd
markmll.pgsql-gene...@telemetry.co.uk 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
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
, 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. telemetry.co .DOT. uk
[Opinions above
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 pgsql-general mailing list (pgsql-general
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 Morgan Lloyd
markMLl
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
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 changes
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, not those of his employers
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
. 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-general@postgresql.org)
To make changes
. 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
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via
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@postgresql.org)
To make
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]
--
Sent
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-general mailing list (pgsql-general@postgresql.org
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
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]
---(end of broadcast)---
TIP 4: Have you
in the 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]
---(end
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]
---(end of broadcast
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.
Just my 2d-worth :-)
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions
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 desire
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? If a lock's incolved what
should this be applied
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 whether a select/update is within an explicit
transaction?
--
Mark Morgan Lloyd
markMLl
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 that attempt to run a select or update
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)---
TIP 2
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.
--
Mark Morgan
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=# select now();
now
---
2006-11-05 11:16
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 using CAST( ... AS TIME). I think the ::
notation might be fragile in this instance because
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. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues
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 Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's
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]
---(end of broadcast
1 - 100 of 110 matches
Mail list logo