ib/pq/listen_example , which is probably
less effort than assembling this collection of hacks and trying to
make it reliable. Most PostgreSQL APIs have support for notifications.
--
Stuart Bishop <stu...@stuartbishop.net>
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
g 'wal-e backup-fetch'. And since you are already using
wal-e for log shipping, you get full PITR available.
pg_dump for a logical backup is also a possibility, although with 13TB
you probably don't want to hold a transaction open that long and are
better off with wal-e, barman or other binary b
ottleneck, then you need to fix it. Probably by knowing which
files have changed and only resyncing them,for example using timestamps
from the database or storing 'incoming' files in a separate area from your
'archive'. Once you have this sorted you can do your backups every few
minutes and reduce your potential data loss.
--
Stuart Bishop <stu...@stuartbishop.net>
http://www.stuartbishop.net/
t is deemed unacceptable, perhaps the ability
to turn them off on an existing database is easily doable (a one way
operation).
--
Stuart Bishop <stu...@stuartbishop.net>
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
temd and/or the
startup scripts. If it doesn't work, the problem is elsewhere (eg.
some required path like /var/run or /tmp or /var/log/postgresql
doesn't exist or has peculiar permissions). If nothing else, you
should get more informative output rather than systemd hiding it away
somewhere
on site).
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
and up to 750
connections for the time being)
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
like to use configuration management tools like puppet
to deploy something like that, but I suppose that's a topic for another day.
Yeah... integration with configuration management is going to be
interesting when PG allows you to modify config from the SQL command
line...
--
Stuart Bishop stu
schedulers if
you haven't already - IIRC switching to deadline resolved one of our
load problems.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
, but the WAL file had not yet been
shipped and the output logged. I imagine streaming replication happily
reconnected soon after. This is all quite normal.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general
with Ubuntu 12.04 (precise) and Ubuntu 13.04 (raring). If you
want PostgreSQL 9.2 or 9.3, you are currently best off installing
Ubuntu 12.04 (precise) and following the instructions at
https://wiki.postgresql.org/wiki/Apt
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net
On Thu, Aug 29, 2013 at 2:44 PM, Tatsuo Ishii is...@postgresql.org wrote:
I have a question about hot_standby_feedback parameter. In my
understanding, if this parameter is on, a long running transaction on
standby will not be canceled even if the transaction conflicts.
As you can see vacuum
doing this is probably obvious from your
log files.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
did not attempt to pull down WAL files
that had already been shipped and were available locally. This would
save resources when you need them most - the hot standbys have fallen
behind.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list
.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
version when it isn't, such as when you are connecting to a remote
server). You shouldn't need to invoke anything from /usr/lib directly,
unless you are doing something particularly low level.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing
without
the hot standby lagging far behind the master.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--+-
hot_standby | on
hot_standby_feedback | on
max_standby_archive_delay| 3
max_standby_streaming_delay | 3
wal_receiver_status_interval | 10
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list
On Thu, Feb 14, 2013 at 7:21 AM, Sergey Konoplev gray...@gmail.com wrote:
On Wed, Feb 13, 2013 at 12:53 AM, Stuart Bishop stu...@stuartbishop.net
wrote:
I'm unable to offload my backups to one of my PG 9.1 hot standbys
using purely streaming replication. After a few hours, usually
fighting over ownership of this directory. The
Debian and Ubuntu packages pipe PostgreSQL's stderr here, and are not
configured to use syslog nor PostgreSQL's builtin log rotation.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql
/plpy.execute.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. You
might be able to confirm and/or work around the issue by getting your
own stanza added to the top of the generated site.py, explicitly
importing the problematic modules right at the top before any buildout
magic happens.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net
for the initial
patch release.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
believe the problem
is being fixed, by letting the history files be shipped along with the
WAL files.
http://archives.postgresql.org/pgsql-general/2011-12/msg00456.php
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general
.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to
conflict with recovery
DETAIL: User was holding a relation lock for too long.
Can anyone shed some insight? My understanding of hot_standby_feedback
is that it should make this sort of query cancellation never happen.
On Tue, Aug 14, 2012 at 6:34 PM, Stuart Bishop stu...@stuartbishop.net wrote
. I'm successfully using pg_dump on other
hot standbys that take half a day to dump with tables active enough
that they certainly should have triggered autovacuums.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general
, start it up.
Does this look correct to people?
Am I going to end up in trouble copying files into pg_xlog like this on a
busy system?
Is it overengineered? eg. will a master ensure everything is streamed to
connected hot standbys before a graceful shutdown?
--
Stuart Bishop stu
that is
not a hot standby if it started in recovery mode).
It seems difficult or impossible to calculate this on the master.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
statically linked with an old libssl. I haven't
had time to investigate so I've disabled SSL for now, even though
replication appears to work apart from the disconnections.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql
(encode the querys into a
single line of ascii, lossy is ok). I like my logs both readable and
greppable.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
. There are counter examples too, where the Python code is much
cleaner and in some cases lets you do things impossible in plpgSQL.
Access to the Python standard library gives you a great toolkit, and
it being 'unsafe' you can do stuff you would otherwise need to write
and deploy C extensions for.
--
Stuart Bishop
On Fri, May 4, 2012 at 4:09 PM, Stuart Bishop stu...@stuartbishop.net wrote:
On Fri, Apr 27, 2012 at 4:42 PM, Frank Lanitz fr...@frank.uvena.de wrote:
Hi folks,
Just looking for a nice server side solution to implement some
fundamental logic for an application. plpythonu looks in this tmers
by a REINDEX if you don't have enough disk space to run
CLUSTER. And neither of these will do anything if the space is still
live because some old transaction might still need to access the old
tuples.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing
and the lag time will increase).
Is there some way to get this same information on the master?
pg_stat_replication contains the log information, but I can't see how
to map this to a timestamp.
Is there a better way of measuring this?
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net
On Thu, Feb 23, 2012 at 2:58 AM, Greg Williamson
gwilliamso...@yahoo.com wrote:
Stuart Bishop shaped the aether to ask:
Hi.
I need to measure how far in the past a hot standby is, async
streaming replication.
Not sure if this will help, but we are using repmgr
https://github.com
pgpool-ii. It sits as a proxy between
the client and the databases, and as queries are executed
simultaneously, a synchronous replication setup should be just as fast
as an unreplicated setup.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing
On Mon, Jan 23, 2012 at 9:37 PM, Simon Riggs si...@2ndquadrant.com wrote:
On Mon, Jan 23, 2012 at 2:30 PM, Stuart Bishop stu...@stuartbishop.net
wrote:
On Sat, Jan 21, 2012 at 3:31 AM, Jerry Richards
jerry.richa...@teotech.com wrote:
Is synchronous postgresql replication slower than
On Sat, Nov 5, 2011 at 1:26 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Stuart Bishop stu...@stuartbishop.net writes:
We also found this problem did not occur on one of our staging
systems, which had a default statistics target of 100. Lowering the
statistics on the relavant columns from 1000
getting tools on a
suitable server yet.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
webapp which
I know can safely go through pgbouncer in transaction pooling mode.
Or would there be some way of detecting if the current session has
access to stuff that persists across transactions and this feature
could be added to the existing connection pools?
--
Stuart Bishop stu
is going to have to run with hardware and software in this
universe with all its limitations.
Maybe I should start a business in providing UUID collision insurance?
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general
up in contrib or core.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
signature.asc
Description: OpenPGP digital signature
On Wed, Oct 7, 2009 at 3:09 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Stuart Bishop wrote:
I don't think the committed patch touches anything involved in what
you're testing, but if you could grab CVS tip from the 8.4 branch (or
the snapshot from ftp.postgresql.org:/pub/snapshot
On Mon, Oct 5, 2009 at 11:00 PM, Alvaro Herrera alvhe...@commandprompt.com
wrote:
Stuart Bishop wrote:
On Mon, Oct 5, 2009 at 4:22 PM, Alban Hertroys
dal...@solfertje.student.utwente.nl wrote:
A similar issue was discussed just recently here:
http://archives.postgresql.org/pgsql-general
On Tue, Oct 6, 2009 at 8:28 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Stuart Bishop wrote:
On Mon, Oct 5, 2009 at 11:00 PM, Alvaro Herrera alvhe...@commandprompt.com
wrote:
Stuart Bishop wrote:
On Mon, Oct 5, 2009 at 4:22 PM, Alban Hertroys
dal...@solfertje.student.utwente.nl
will have been recreated a few instants ago using
'createdb --template test_template_db'.
One of the statement logs is at http://paste.ubuntu.com/285983/ - I
can't see anything unusual
going on but it might help diagnose the problem.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net
On Mon, Oct 5, 2009 at 4:22 PM, Alban Hertroys
dal...@solfertje.student.utwente.nl wrote:
On 5 Oct 2009, at 8:58, Stuart Bishop wrote:
I'm running our products test suite against PostgreSQL 8.4.1. The test
suite runs fine against 8.3.7.
With 8.4.1, some of our tests are failing
Hi.
Is anyone aware of a connection pool or load balancer for PostgreSQL
that supports ident based authentication? Neither pgpool-ii nor
pgbouncer support this according to their docs, so I was wondering
what else is out there.
--
Stuart Bishop stu...@stuartbishop.net
http
Hi.
Is anyone aware of a connection pool or load balancer for PostgreSQL
that supports ident based authentication? Neither pgpool-ii nor
pgbouncer support this according to their docs, so I was wondering
what else is out there.
--
Stuart Bishop stu...@stuartbishop.net
http
postgresql releases always get a new package. This allows you to
have multiple major versions installed and running simultaneously.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
aware we have no hardware alerts and the box has been running smoothly
for quite some time.
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
- th.
s = u'ァ'
print unicodedata.name(s)
KATAKANA LETTER SMALL A
--
Stuart Bishop stu...@stuartbishop.net
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Mar 31, 2009 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Stuart Bishop stu...@stuartbishop.net writes:
I just had a brief outage on a production server running 8.3.6, which
I suspect was triggered by me running a table bloat report making lots
of pgstattuple calls.
The first I got
On Tue, Mar 31, 2009 at 11:10 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Stuart Bishop stu...@stuartbishop.net writes:
On Tue, Mar 31, 2009 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What's the actual size of that relation now? Is it growing rapidly?
(I'm trying to figure out whether those
On Tue, Mar 3, 2009 at 11:53 AM, Sanjay Arora sanjay.k.ar...@gmail.com wrote:
Is it possible to host postgreSQL on Amazon's cloud? What are the issues
involved?
Runs just fine under Ubuntu. We haven't tried it under serious load though.
--
Stuart Bishop stu...@stuartbishop.net
http
, the alternative is 'DROP _sl
CASCADE;', which doesn't do a full cleanup. Is there no supported
disaster recovery procedure?
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Mon, Oct 13, 2008 at 5:05 PM, Stuart Bishop [EMAIL PROTECTED] wrote:
So what was the final recommended process for building a stand alone
database from a pg_dump of a replicated node?
So if I'm reading this thread correctly, the alternative is 'DROP _sl
CASCADE;', which doesn't do a full
.
plpythonu is unrestricted, so if you have the ability to create plpythonu=
stored procedures you effectively have full filesystem access on your
database server as the user your database is running as. So don't put
open('/etc/passwd','w') in your plpythonu code.
--=20
Stuart Bishop [EMAIL PROTECTED
messages in the system only a millisecond apart.
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
signature.asc
Description: OpenPGP digital signature
, no there is not. Beyond the simple number and string times
everything gets cast to a string (arrays, tsvectors, etc.). I have no idea
if anyone is working on this for 8.3 or later.
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
signature.asc
Description: OpenPGP digital
! I can't wait to be able to upgrade
and wish I had time to do the preliminary migration right now.).
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
signature.asc
Description: OpenPGP digital signature
or not.)
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
signature.asc
Description: OpenPGP digital signature
or failing depending on the existence
of an index seems rather wrong to me.)
Only relevant discussion on this I can find is
http://archives.postgresql.org/pgsql-hackers/2007-01/msg01581.php. There
appear to be no replies visible though :-(
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net
creating more things that could
go wrong.
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
signature.asc
Description: OpenPGP digital signature
/+source/postgresql-8.1/+bugs might be
more appropriate.
--
Stuart Bishop [EMAIL PROTECTED] http://www.canonical.com/
Canonical Ltd.http://www.ubuntu.com/
signature.asc
Description: OpenPGP digital signature
similar issues I need to deal with on our staging server, which each
day automatically needs to have the database reset with a fresh dump of our
production database, code updates rolled out and schema and data migration
patches applied.
--
Stuart Bishop [EMAIL PROTECTED]
http
as the primary
contact which is how I imagine Postgres developers would like things set up.
Current email interface documentation for Malone is on our wiki at
https://wiki.launchpad.canonical.com/MaloneEmailInterfaceUserDoc
We use it internally the way you describe.
--
Stuart Bishop [EMAIL
because it is simply comparing the ASCII codes.
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
signature.asc
Description: OpenPGP digital signature
) RETURNS char(40) AS '
import sha
return sha.new(args[0]).hexdigest()
' LANGUAGE plpythonu IMMUTABLE RETURNS NULL ON NULL INPUT;
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
signature.asc
Description: OpenPGP digital signature
,(param2 = 'true'));
but it's not working.
CREATE UNIQUE INDEX foo ON table(param1, (NULLIF(param2, false)))
- --
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.5 (GNU/Linux)
iD8DBQFCk/6KAfqZj7rGN0oRAvZ
to be to transform line endings in the string to the
one-true-format expected by Python's guts:
http://mail.python.org/pipermail/python-dev/2005-January/051214.html
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
---(end of broadcast
need Java on the boxes running PostgreSQL, that will probably be
the decisive factor - Java licencing makes it difficult for free
distributions to provide easy installation and support.
--
Stuart Bishop [EMAIL PROTECTED] http://www.canonical.com/
Canonical Ltd. http
Martijn van Oosterhout wrote:
On Wed, Jan 19, 2005 at 06:28:25PM +1100, Stuart Bishop wrote:
Michael Fuhr wrote:
If Python's behavior is intentional then the newline burden would
seem to be on the user or on plpythonu. I think Tom's point is
that that's just silly
Changing this behavior
be a 2.3.6. If it was championed and
it decided that the above example is a bug and not a feature and a patch
produced, it could get into 2.4.1 due April and 2.5+
I suspect this means fixing this problem in plpythonu for 8.1.
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net
to it, wouldn't it?
--
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Tom Lane wrote:
Stuart Bishop [EMAIL PROTECTED] writes:
Marc G. Fournier wrote:
| A current list of *known* supported platforms can be found at:
| http://developer.postgresql.org/supported-platforms.html
I notice that Ubuntu is not yet on this list. I can confirm that
PostgreSQL 7.4.5
(hoary) on all platforms. Version freeze for hoary is today, so that
version is fixed and the 8 series won't be officially supported until
the following release (October 2005), although installing the Debian
packages should work just fine.
- --
Stuart Bishop [EMAIL PROTECTED] http
.
People are used to months being ambiguous so it is less likely to cause
upsets, although it still bites people because their toolkits definition
of 'month' does not match their business rules of 'month' (which might
be 30 days, 31 days, 4 weeks, calendar month rounded down).
- --
Stuart Bishop
then have the issue that '2am April 3rd + 1 day == 3am Aril
3rd + 1 day'.
- --
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFBge+sAfqZj7rGN0oRAgInAJsEuYkxX6/jsaszquhjEX/PH3nXvACfVBW9
Z3sfU5XGgxSOI77vuOOOzKA=
=euY6
' language plpythonu;
Works just fine here on 7.4.5
- --
Stuart Bishop [EMAIL PROTECTED]
http://www.stuartbishop.net/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFBdfmqAfqZj7rGN0oRAiipAJ9X3IoxinVNx/JRwF9OlzSsZMAATQCgh636
b4kuADMg75BBHqaDjV55c+4=
=LMiW
-END PGP SIGNATURE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stuart Bishop wrote:
| create or replace function BatchBalanceStatus(int, int, int) returns
| varchar as '
| ~balance, needed, freestock = args
| ~if balance 0:
| ~return Unhandled
| ~elif freestock = needed:
| ~return OK
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Stuart Bishop [EMAIL PROTECTED] writes:
|
|I'm trying to determine the best way of saying 'The current time in UTC
|with no time zone information'.
|
|
| Isn't that a contradiction in terms?
Not at all - I want 'now' in UTC time
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Stuart Bishop [EMAIL PROTECTED] writes:
|
|How much overhead is there in storing a timestamp with timezone as
|opposed to one without?
|
|
| Exactly zero. You have a misconception about what the datatype really
| does --- see other
. However, PostgreSQL parses this into the much more confusing
timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone)
which is what is appearing on my generated documentation.
Is there any magic string like 'NOW'::timestamp or CURRENT_TIMESTAMP
which returns UTC time?
- --
Stuart Bishop
86 matches
Mail list logo