fills the EC2
box's disk.
?:
https://dba.stackexchange.com/questions/221454/best-way-to-pg-dump-postgresql-on-rds-to-s3
Thanks for any and all advice!
Anthony
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/18/19 11:23 AM, Rob Sargent wrote:
On Sep 18, 2019, at 12:17 PM, Adrian Klaver wrote:
On 9/18/19 11:06 AM, Rob Sargent wrote:
On 9/18/19 11:50 AM, Ashkar Dev wrote:
Hi all thanks,
I meant maybe I create a web app with PostgreSQL that work locally for example
for a pharmacy that
her. Run a test case in one terminal and top in another to see the
effect om memory.
On Wed, Sep 18, 2019 at 2:36 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 9/18/19 11:32 AM, Anthony DeBarros wrote:
> Hi, folks -- I'm a longtime PostgreSQL user
imately) charge the pharmacist for any part PostgresQL.
--
Adrian Klaver
adrian.kla...@aklaver.com
access.
The system you currently have at least seems to limit access to a
specific program external to Postgres.
we use for Sybase. Or any other idea to not make detectable the
credentials? This was a request of our customers some years ago.
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
(according to df -h), then it goes back again, even faster than I am
freeing it up. Which makes me believe the system catalog is bloated now.
Probably due to all the other operations hitting the database.
Have you tried vacuuming the system catalogs?
Any advice is appreciated.
Thanks a lot!
--
Adrian Klaver
adrian.kla...@aklaver.com
-----------
*From:* Adrian Klaver
*Sent:* Thursday, September 19, 2019 2:06 PM
*To:* Julie Nishimura
*Subject:* Re: is it safe to drop 25 tb schema with cascade option?
On 9/19/19 1:30 PM, Julie Nishimura wrote:
Adrian, thanks for your reply. We d
ww.postgresql.org/docs/8.2/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND
there are some queries that can will show you the XID status for tables
and the database.
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/19/19 2:42 PM, Tom Lane wrote:
Adrian Klaver writes:
On 9/19/19 2:24 PM, Julie Nishimura wrote:
Or you meant we need to run vacuum on 'my_db_name' without parameters,
that it runs for every table? I am just not sure how long it will take
to run for 39 tb...:(
Not sure. The b
| f
11 | landscaping | f
12 | electrical| f
13 | plumbing | f
14 | handyman | f
(14 rows)
select distinct
c.id,
c.name,
case when cs.user_id = 8 then true else
t assignment
To get above I believe you will need to use GET CURRENT DIAGNOSTICS
PG_CONTEXT:
https://www.postgresql.org/docs/11/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
and example:
https://www.postgresql.org/docs/11/plpgsql-control-structures.html#PLPGSQL-CALL-STACK
Kind regards
Thiemo
--
Adrian Klaver
adrian.kla...@aklaver.com
ere are no rows and no duplicate errors when running
the second time.
Can we see the actual function/query?
Also the schema of the table(s) involved?
corey
--
Adrian Klaver
adrian.kla...@aklaver.com
');
to_char
2020-04-05 02:00:00+00
because to_char only deals with a timestamp and loses the timezone
info and you end up with something very wrong.
Any ideas?
Thanks for any help.
Paul
--
Adrian Klaver
adrian.kla...@aklaver.com
y solution consisting of:
- disabling auto vacuums before a migration
- kill current pids with a vacuum
- do our migration
- enable back auto vacuum.
We find this solution awful, error-prone and "complex" to have.
Are there any other way except having manuals vacuum being played
during the nigh
only ??
Follow the install from source instructions here:
https://github.com/citusdata/pg_auto_failover
Thanks,
Sonam
On Wed, Sep 18, 2019, 8:31 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 9/18/19 7:56 AM, Sonam Sharma wrote:
> Adrian,
>
>
is STRICTLY PROHIBITED. If you
have received this transmission in error, please immediately notify us
by reply e-mail, and destroy the original transmission and its
attachments without reading them or saving them to disk. Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/23/19 2:00 PM, Kevin Brannen wrote:
Adrian Klaver wrote:
On 9/23/19 12:04 PM, Kevin Brannen wrote:
I thought I’d get a jump on testing this since we’re a little slow
sometimes. ??
I’ve spun up a new VM with Centos 6.10 (the latest). I found
https://yum.postgresql.org/testing/12/redhat
his?
I can try to duplicate it if this doesn't provide the details needed.
corey
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/23/19 2:34 PM, Corey Taylor wrote:
On Mon, Sep 23, 2019 at 4:31 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Hmm, are there triggers on wss_entries that are UPDATEing/DELETEing
entries elsewhere?
No, that table is pretty much stand-alone. What we're
On 9/23/19 3:43 PM, Corey Taylor wrote:
On Mon, Sep 23, 2019 at 4:50 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Smaller hammer:
https://www.postgresql.org/docs/11/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS
"auto
On 9/23/19 3:56 PM, Corey Taylor wrote:
On Mon, Sep 23, 2019 at 5:51 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Usually what is seen here is the opposite, that tables are restored and
ANALYZE is not run and performance on the subsequent queries is poor
d
On 9/23/19 5:28 PM, Corey Taylor wrote:
On Mon, Sep 23, 2019 at 7:23 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
"Once restored, it is wise to run ANALYZE on each restored table so the
optimizer has useful statistics; see Section 24.1.3 and Section 24.1.
w.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
tel_daten_katkey_seq', maxikatkey, false)
in that the next value used will be 330722 not 330723.
RESTART is also transactional whereas SETVAL() is not.
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/23/19 7:40 PM, Andrew Gierth wrote:
"Adrian" == Adrian Klaver writes:
Adrian> This has come up before and the general suggestion has been to
Adrian> have a column for a naive(timestamp w/o tz) timestamp and a
Adrian> column for the timezone.
No, that&#x
under and Leader,
GNUKhata <https://gnukhata.in/>
//(Opensource Accounting, Billing and Inventory Management Software)//
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/24/19 10:40 PM, Matthias Apitz wrote:
El día martes, septiembre 24, 2019 a las 08:01:46a. m. -0700, Adrian Klaver
escribió:
On 9/24/19 7:47 AM, Matthias Apitz wrote:
Hello,
We have in a database some 400 tables, 75 of them have a 'serial'
column, like the one in the exa
bout 9.1, not 8.4.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/25/19 8:04 AM, Rob Sargent wrote:
On Sep 25, 2019, at 8:24 AM, Krishnakant Mane <mailto:kkm...@riseup.net>> wrote:
On 25/09/19 7:50 PM, Adrian Klaver wrote:
On 9/25/19 12:15 AM, Krishnakant Mane wrote:
Hello all,
I have been using postgresql for an enterprise quality
ql-archive.org/PostgreSQL-general-f1843780.html> at
Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
n
There is no port provided. By default that would be 5432. In your *.yaml
file you have port 5433.
So do you have more then once instance of Postgres running?
Or is the environment variable PGPORT set to 5433?
2) In the *.yaml file you have host=localhost.
On the chance hosts is not set correctly what happens if you change this
to host=127.0.0.1?
Looking forward to your kind help
Marco
--
Adrian Klaver
adrian.kla...@aklaver.com
type: postgres
datasource: host=localhost port=5433 user=fabmnet_admin
password=pwd dbname=fabmnetdb
sslmode=verify-full
How to correctly set up SSL connection to PostgresSQL-11 db?
Looking forward to your kind help
Marco
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/25/19 10:44 PM, Thiemo Kellner wrote:
Hello Adrian
Quoting Adrian Klaver :
To get above I believe you will need to use GET CURRENT DIAGNOSTICS
PG_CONTEXT:
I actually use "get stacked diagnostics" to retrieve the exception
place. And it works. I am not sure why I did no see
-
Sent from the PostgreSQL - general mailing list archive
<https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html> at
Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
log in as.
I do not undertand...
Marco
--
Adrian Klaver
adrian.kla...@aklaver.com
in the interface between
fabric-ca-server and PostgreSQL-11 db. In fabric-ca-server-config.yaml,
in postgresql.conf, in both or somewhere else.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/25/19 10:12 PM, Matthias Apitz wrote:
El día miércoles, septiembre 25, 2019 a las 07:42:11a. m. -0700, Adrian Klaver
escribió:
sisis$# DECLARE
sisis$#maxikatkey integer := ( select max(katkey) from titel_daten );
sisis$#result integer := 1;
sisis$# BEGIN
sisis$#maxikatkey
row_to_json
---
{"test":"fooa bar"}
(1 row)
Do you possibly have an overloaded function of the same name(ROW_to_json())?
Thanks!
-mark-
--
Adrian Klaver
adrian.kla...@aklaver.com
then once instance of Postgres
running. Partly because of this:
psql --cluster 11/fabmnet
and then later:
psql -h 127.0.0.1 -d fabmnetdb -U postgres
Not sure they are pointing at the same thing.
At command line what does:
ps ax | grep post
show.
Thanks again for your kind help.
Marco
o you possibly have an overloaded function of the same
name(ROW_to_json())?
>
> Thanks!
> -mark-
>
>
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
what /usr/bin/python might be.) The
default will probably be changed to Python 3 in a distant future release
of PostgreSQL, depending on the progress of the migration to Python 3 in
the Python community."
Best Regards.
Keisuke Kuroda
--
Adrian Klaver
adrian.kla...@aklaver.com
ards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
--
Adrian Klaver
adrian.kla...@aklaver.com
l-11-fabmnet.log : 2019-09-27 17:07:27.159
CEST [6626] [unknown]@[unknown] LOG: could not accept SSL connection:
sslv3 alert bad certificate
Why it says "sslv3 alert bad certificate" if it's exactly the same
certificate used when connecting to the same database with ssl
And if this is the case, why?
No you connected to localhost, though without SSL. Try again with
sslmode=require and I am pretty sure you will connect with SSL, but no
cert verification.
Marco
--
Adrian Klaver
adrian.kla...@aklaver.com
edger.org/g/main
Marco
--
Adrian Klaver
adrian.kla...@aklaver.com
above, have you installed any
extensions lately?
--
Adrian Klaver
adrian.kla...@aklaver.com
information but try running:
select oprcode, pg_get_functiondef(oprcode) from pg_operator where
oprname = '+' and oprcode = 'pg_catalog.day_inc'::regproc;
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/28/19 12:07 AM, Marco Ippolito wrote:
Hi Adrian,
Il giorno ven 27 set 2019 alle ore 21:39 Adrian Klaver
mailto:adrian.kla...@aklaver.com>> ha scritto:
On 9/27/19 11:02 AM, Marco Ippolito wrote:
> Thank you very much Adrian.
> Two things:
>
> 1)
be set to TRUE.
Where is the project id?
I would be interested in seeing other peoples approaches on this, also.
Any thoughts?
--
Adrian Klaver
adrian.kla...@aklaver.com
;proc'
ELSE 'func'
END as "Type"
FROM pg_catalog.pg_proc p
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE p.proname OPERATOR(pg_catalog.~) '^(pg_catalog.day_inc)$'
AND pg_catalog.pg_function_is_visible(p.oid)
ORDER BY 1, 2, 4;
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
numeric
func
pg_catalog
day_inc
anyelement
ndays numeric, adate anyelement
func
--
Adrian Klaver
adrian.kla...@aklaver.com
ave no idea. Per my post upstream I would test your Postgres setup
first without bringing in the fabric server:
psql "host=localhost port=5433 dbname=fabmnet_ca user=postgres
sslmode=require"
Changing sslmode to whatever you need.
--
Adrian Klaver
adrian.kla...@aklaver.com
around to fixing that. I could see changing the definition
of -n to include the schema itself at the same time.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
a.txt test.backup
That will give you a plain text version of the restore.
--Mike
--
Adrian Klaver
adrian.kla...@aklaver.com
to my home
directory is instantaneous
System is Centos 7
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
and only seeing pg_upgrade go to 99% every 3-4 seconds
I had no other processes using io or high cpu.
Has anyone got any pointers of what could be the issue ?
Ps running cp on /var/lib/pgsql/9.5/data/base/24602/25140 to my home
directory is instantaneous
System is Centos 7
Thanks
--
Adr
On 10/2/19 4:58 PM, Glenn Pierce wrote:
Please reply to list also.
Ccing list.
On Thu, 3 Oct 2019, 00:11 Adrian Klaver, <mailto:adrian.kla...@aklaver.com>> wrote:
On 10/2/19 3:30 PM, Glenn Pierce wrote:
> I have been trying to upgrade postgres 9.5 to 9.6 wit
chance of database corruption after this event ?
The source(backend/storage/ipc/pmsignal.c ) says:
"/* Out of slots ... should never happen, else postmaster.c messed up */
elog(FATAL, "no free slots in PMChildFlags array");
"
Someone else will need to comment on what 'messed up' could be.
Regards,
Bhargav
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/2/19 5:47 PM, Adrian Klaver wrote:
On 10/2/19 4:58 PM, Glenn Pierce wrote:
Please reply to list also.
Ccing list.
On Thu, 3 Oct 2019, 00:11 Adrian Klaver, <mailto:adrian.kla...@aklaver.com>> wrote:
On 10/2/19 3:30 PM, Glenn Pierce wrote:
> I have been tryin
hanks a lot for your help!
Regards
--
Arnaud
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/3/19 7:13 AM, Arnaud L. wrote:
Le 03/10/2019 à 15:54, Adrian Klaver a écrit :
On 10/2/19 11:51 PM, Arnaud L. wrote:
Well, this problem is still bugging me, and this time I've tried with
a local file. Unfortunately, it did not help.
To further rule out filesystem problems, I first
-postgresql-downloads
Just looks like the community page has not been updated to reflect.
Regards,
Igor Neyman
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/4/19 12:19 AM, Arnaud L. wrote:
Le 03/10/2019 à 16:32, Adrian Klaver a écrit :
I may have missed it before, but where is the Postgres server located?
On the same local area network. Not on the computer running the script
(so direct COPY TO is not an option).
Given that this seems
On 10/7/19 12:41 AM, Arnaud L. wrote:
Le 04/10/2019 à 19:08, Adrian Klaver a écrit :
On 10/4/19 12:19 AM, Arnaud L. wrote:
OK I can do that. I thought I nailed it down to this line because it
started failing when this line was ~5th in the script, and it kept
failing on that very same line
On 10/8/19 12:06 AM, Arnaud L. wrote:
Le 07/10/2019 à 16:36, Adrian Klaver a écrit :
So you are saying that you have not run the problematic line by itself?
It hung during last night's run.
I had modified my batch script to run the \copy commands separately,
i.e. it now reads as :
ps
r:
hostssl all testuser 111.222.333.444/32 md5
This is better still:
hostssl testdb testuser 111.222.333.444/32 md5
Better still (IMHO) is to keep it local and use ssh tunnel, but I
understand that might be difficult and not necessarily desirable,
depending on the context.
Regards
Bob
ch table had its ACLs modified?
Also, why do grants and revokes have an object_type of 'TABLE' instead
of lower case names like 'table' for all other event types?
Thanks,
Miles Elam
--
Adrian Klaver
adrian.kla...@aklaver.com
ACLs modified?
What is the code for trigger and function?
Also, why do grants and revokes have an object_type of 'TABLE' instead
of lower case names like 'table' for all other event types?
Thanks,
Miles Elam
--
Adrian Klaver
adrian.kla...@aklaver.com
for PostgreSQL being
logged by pglogger (https://sourceforge.net/p/pgutilsl/wiki/Home/)
pgutils and especially pgutilsL are small but it is a beginning after
all. :-)
Kind regards
Thiemo
--
Adrian Klaver
adrian.kla...@aklaver.com
will now output those columns,
whereas previously they would be displayed only if selected explicitly.
"
Thanks,
IvanK.
--
Adrian Klaver
adrian.kla...@aklaver.com
formation.
I dont now it it'll ever complete this query though, it usually takes
~100 seconds, and here it has already been running for 9 hours.
Regards
--
Arnaud
--
Adrian Klaver
adrian.kla...@aklaver.com
nt_trigger_ddl_commands();
END;
$$;
CREATE EVENT TRIGGER aa_ddl_info ON ddl_command_end
EXECUTE PROCEDURE ddl_log();
On Wed, Oct 9, 2019 at 2:27 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 10/9/19 1:56 PM, Miles Elam wrote:
> GRANT and REVOKE trigger on a d
e quotes \34 inside fields, in a csv file.
Ex :
"value1","some text","other text with "double quotes" inside","last field"
I don't know of any definition of CSV format by which that's legal data.
The typical rule is that double quotes that are data must be doubled;
at least, that's what COPY expects by default. You can also get COPY
to handle variants like backslash-quote.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
plication Server, pgBouncer and database server are all configured
with UTC only.
=>show timezone;
TimeZone
--
UTC
Thanks in advance,
Regards, Amarendra
--
Adrian Klaver
adrian.kla...@aklaver.com
resql.org/docs/11/datatype-json.html
"When converting textual JSON input into jsonb, the primitive types
described by RFC 7159 are effectively mapped onto native PostgreSQL
types, as shown in Table 8.23. ..."
Table 8.23.
JSON primitive type PostgreSQL type Notes
...
numbe
es, it shows the last query that was executed. By default the query
text is truncated at 1024 characters; this value can be changed via the
parameter track_activity_query_size."
Thanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
ools (QA for zipcodes in Germany) <https://wambachers-osm.website/fools>
Postcode Boundaries of Germany <https://wambachers-osm.website/pcoundaries>
OSM Software Watchlist
<https://wambachers-osm.website/index.php/osm-software-watchlist>
--
Adrian Klaver
adrian.kla...@aklaver.com
e Boundaries of Germany <https://wambachers-osm.website/pcoundaries>
OSM Software Watchlist
<https://wambachers-osm.website/index.php/osm-software-watchlist>
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/11/19 1:56 PM, wambac...@posteo.de wrote:
Hi Adrin,
Am 11.10.19 um 21:42 schrieb Adrian Klaver:
On 10/11/19 10:28 AM, wambac...@posteo.de wrote:
Hi, after a crash i get this errpor: DELETE FROM planet_osm_line
WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
any idea
alue 3243289204 in pg_toast_1340113
HINWEIS: wno_recover_pol: 2019-10-11 22:40:42.696463+02 rows=600
osm_id=303611045
HINWEIS: wno_recover_pol: 2019-10-11 22:42:19.535747+02 rows=700
osm_id=439078923
...
until now "only" 3 damaged records :)
regards
walter
--
Adrian Klaver
adrian.kla...@aklaver.com
d an interval
instead, and we may be able to tell you how to fix it.
--
Andrew (irc:RhodiumToad)
--
Adrian Klaver
adrian.kla...@aklaver.com
?
When I search on CMS_SYSPRM it comes related to bmc.com, is that in the
mix also?
Tried changing lc_time, timezone and datestyle .. but nothing seems to work
Thanks
Danny
-Original Message-
From: Adrian Klaver
Sent: Saturday, October 12, 2019 7:27 PM
To: Abraham, Danny ; Andre
SET
postgres=# select date('20191001') - date('20190101');
?column?
--
273
(1 row)
--
Adrian Klaver
adrian.kla...@aklaver.com
ng explicitly SET by something. Since
'PostgreSQL JDBC Driver' is the Postgres JDBC driver name I would start
there.
Regards, Amarendra
On Fri, Oct 11, 2019 at 7:33 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 10/11/19 4:49 AM, Amarendra Konda wrot
/11/sql-vacuum.html
--
Adrian Klaver
adrian.kla...@aklaver.com
DBA – ELFEC S.A.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/16/19 12:51 PM, Rob Sargent wrote:
On 10/16/19 1:40 PM, Adrian Klaver wrote:
On 10/14/19 3:27 PM, Lizeth Solis Aramayo wrote:
Good afternoon,
I am working with postgresql 9.6.15 and I need to restore in a 9.6.5
version, I got an error, and I found this page to install a patch
What
On 10/16/19 12:55 PM, Ron wrote:
On 10/16/19 2:40 PM, Adrian Klaver wrote:
On 10/14/19 3:27 PM, Lizeth Solis Aramayo wrote:
Good afternoon,
I am working with postgresql 9.6.15 and I need to restore in a 9.6.5
version, I got an error, and I found this page to install a patch
What commands
why you can't upgrade the 9.6.5 to 9.6.15? I dont know how.
-Mensaje original-----
De: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Enviado el: miércoles, 16 de octubre de 2019 15:41
Para: Lizeth Solis Aramayo; pgsql-gene...@postgresql.org
Asunto: Re: CVE-2018-1058
On 10/14/19
uld just be an update.
Or do I need to update them manually on Master and Replicated servers ?
I didn´t find any info about this on Docs and because that I´m posting about
this.
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
ad
son why you can't upgrade the 9.6.5 to 9.6.15? I dont know how.
--
Adrian Klaver
adrian.kla...@aklaver.com
ot sure how compatible RH 6.5
and RH 7.6 are with each other.
Your best bet would be to upgrade the 9.6.5 --> 9.6.15. There have been
a lot of bug fixes in between.
-Mensaje original-----
De: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Enviado el: miércoles, 16 de octubre de 2019 18:3
cause that PK did not exist anymore ?
The only question is, what are correct steps to do when you need to change a
PK on replicated database, just that.
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
quicker.
If you want to see all that is involved:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/commands/dbcommands.c;h=f47a13d1844ca36d81ba9815f807646a44750de4;hb=86ca7f81f7dfc17f04698189dec8973d358bc711
Start at line 767
Thank you!
-Julie
--
Adrian
row before insert
trigger? Can be some optimisation here?
https://www.postgresql.org/docs/11/xfunc-volatility.html
--
Adrian Klaver
adrian.kla...@aklaver.com
l psycopg2 (instead of psycopg2-binary) with the
libpq (v12) installed, so the psycopg2 is build against libpq (v12).
Even so, it's not working as expected.
Environment:
Ubuntu 16.04 LTS
PostgreSQL 9.6.15
Patroni 1.6.0
pgBouncer 1.11.0
keepalived 2.0.18
HAProxy 1.6.3
I've also tried to catch different types of exceptions with no luck.
I would appreciate any guidance on this matter. I can give you more info
if needed.
Thank!
--
Adrian Klaver
adrian.kla...@aklaver.com
cific behaviour should set the
attribute as needed.
Drivers are not required to support this attribute, but any driver which
does not support it must arrange to return undef as the attribute value."
Thanks anyway.
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/18/19 8:15 AM, Rob Sargent wrote:
On 10/18/19 8:51 AM, Adrian Klaver wrote:
On 10/18/19 7:42 AM, Matthias Apitz wrote:
El día viernes, octubre 18, 2019 a las 03:01:58p. m. +0200, Tom Lane
escribió:
Matthias Apitz writes:
When we export char columns with our Perl tools, they come out
ate keys were lost).
I believe that anything that can be catastrophically broken by users
not following upgrade instructions precisely is a serious problem, and
can lead to serious problems. I am sure that this is not the only
project using JSONB which have had users destroy their own data in
such a completely preventable fashion.
Ariadne
--
Adrian Klaver
adrian.kla...@aklaver.com
On 10/18/19 4:31 PM, Ariadne Conill wrote:
Hello,
On Fri, Oct 18, 2019 at 6:01 PM Adrian Klaver wrote:
On 10/18/19 3:11 PM, Ariadne Conill wrote:
Hello,
On Fri, Oct 18, 2019 at 5:01 PM David G. Johnston
wrote:
On Fri, Oct 18, 2019 at 2:50 PM Christoph Moench-Tegeder
wrote
901 - 1000 of 4934 matches
Mail list logo
