On Thu, Oct 10, 2019 at 10:22:22AM +0530, Shankar Bhaskaran wrote:
> We are planning to use postgres 10.7 version as that is the latest
> version supported on Aurora DB. Since we have an on premise installation
> also , i was trying to download the same version of postgres for windows
> and linux.
On 2019-10-09 10:16:37 -0400, Tom Lane wrote:
> Andreas Joseph Krogh writes:
> > Attached is output from "bt full". Is this helpful?
>
> Well, it shows that the failure is occurring while trying to evaluate
> a variable in a trigger's WHEN clause during
> "UPDATE origo_email_delivery SET folder_
Hi ,
We are planning to use postgres 10.7 version as that is the latest
version supported on Aurora DB. Since we have an on premise installation
also , i was trying to download the same version of postgres for windows
and linux.
Unfortunately that version is not available in the download site as w
On 10/9/19 5:02 PM, Thiemo Kellner wrote:
Hi all
I do not mean to spam so please tell me if this is not the right place
for release announcements of OSS software for PostgreSQL. Be it as may,
I am happy to have:
For future reference:
https://www.postgresql.org/list/pgsql-announce/
- pg
Hi all
I do not mean to spam so please tell me if this is not the right place
for release announcements of OSS software for PostgreSQL. Be it as
may, I am happy to have:
- pgutils out: providing very basic functionality for PostgreSQL
base applications (https://sourceforge.net/p/pgutils/
PASCAL CROZET writes:
> Ive experience issues with double 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
Hi, and thanks for responding,
> First off- please try to craft a new email in the future...
My apologies to you and the group - I'll do that in future.
> > 1) Is my lecturer full of it or does he really have a point?
> He's full of it, as far as I can tell anyway, based on what you've
> shared
Using my example below from another thread, GRANTs and REVOKEs leave all
fields NULL except for command_tag (set to 'GRANT' or 'REVOKE'),
object_type (set to upper case target like 'TABLE'), and in_extension (set
to whatever is appropriate, but typically false).
-
CREATE TABLE IF NOT EXISTS d
On 10/9/19 1:56 PM, Miles Elam wrote:
GRANT and REVOKE trigger on a ddl_command_end event trigger but don't
provide any information beyond whether it was a table, schema, function,
etc. that was affected. No object IDs or the like are included. How
would you find out which table had its ACLs mo
On 10/9/19 2:20 PM, PASCAL CROZET wrote:
Hi, MailingList
PG 9.3 under Ubuntu 14.04 (I know, that’s obsolete, but we’re planning
to move to pg 10 or more during 2020)
I’ve experience issues with double quotes \34 inside fields, in a csv file.
Ex :
"value1","some text","other text with "doubl
Hi, MailingList
PG 9.3 under Ubuntu 14.04 (I know, that’s obsolete, but we’re planning to move
to pg 10 or more during 2020)
I’ve experience issues with double quotes \34 inside fields, in a csv file.
Ex :
"value1","some text","other text with "double quotes" inside","last field"
When I import
GRANT and REVOKE trigger on a ddl_command_end event trigger but don't
provide any information beyond whether it was a table, schema, function,
etc. that was affected. No object IDs or the like are included. How would
you find out which table had its ACLs modified?
Also, why do grants and revokes h
On 10/9/19 11:39 AM, Timmy Siu wrote:
Dear Bob,
Thank you.?? hostssl works out of the box!?? It does not require extra
That depends on how you installed Postgres. My guess is whatever package
manager/installer you used did the setup/configuration for you. That
would be:
1) In postgresql.co
On 09/10/2019 20:45, Alan Hodgson wrote:
> Assuming you're not a troll ...
>
> On Wed, 2019-10-09 at 20:06 +0100, Pól Ua Laoínecháin wrote:
>> 1) Is my lecturer full of it or does he really have a point?
> He's more than full of it. PostgreSQL has had a few bugs over the year
> that could have resu
Assuming you're not a troll ...
On Wed, 2019-10-09 at 20:06 +0100, Pól Ua Laoínecháin wrote:
> 1) Is my lecturer full of it or does he really have a point?
>
He's more than full of it. PostgreSQL has had a few bugs over the year
that could have resulted in data corruption, but they're pretty rar
Greetings,
First off- please try to craft a new email in the future rather than
respond to an existing one. You may not realize this but there's some
headers that get copied when you do a reply that cause the email to show
up as being a reply, even if you remove all the "obvious" bits from it.
*
On Wed, Oct 09, 2019 at 02:59:17PM -0400, melvin6925 wrote:
> Have you tried a VACUUM FULL of the db?Sent via the Samsung Galaxy S?? 6, an
> AT&T 4G LTE smartphone
> Original message From: stan Date: 10/9/19
> 14:54 (GMT-05:00) To: melvin6925 Subject: Re: I
> messed up and m
Hi all,
I recently started a Masters in Computer Science (and not at the
institution in my email address).
One of my courses is "Advanced Databases" - yummy I thought - it's not
even compulsory for me but I just *_had_* to take this module. The
lecturer is a bit of an Oracle fan-boy (ACE director
Dear Bob,
Thank you.?? hostssl works out of the box!?? It does not require extra
configuration.?? I can connect to my own pgsql server via pgadmin 4.?? I
personally feel that Postgresql v11 is much clever than Mysql v5.7 (I
haven't tried its v8).
I also have tested postgres against TCP Wrappe
On 2019-Oct-07, Moreno Andreo wrote:
> Unfortunately, it didn't work :(
>
> db0=# select * from failing_table where ctid='(3160,31)' for update;
> ERROR: MultiXactId 12800 has not been created yet -- apparent wraparound
Oh well. It was a long shot anyway ...
> Since the probability we are int
I was going to try to do some testing on very large databases, and I tried to
load the Mouse Gerome DB. It failed, and now I know why :-) I filled the
disk up. Presently, with virtually nothing in any database the postgres
storage location has 43G allocated. The DB was also crashed but i did free
u
How repmgr and pglogical are different and which one is more efficient way
of replication ?
Can someone please help
Andreas Joseph Krogh writes:
> Is it OK if I send you the table/trigger-definitions off-list?
Sure, but please share with Andres [cc'ed] as well.
regards, tom lane
På onsdag 09. oktober 2019 kl. 16:16:37, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes:
> Attached is output from "bt full". Is this helpful?
Well, it shows that the failure is occurring while trying to evaluate
a variable in a trigger's WHEN clause during
"UPDATE or
Andreas Joseph Krogh writes:
> Attached is output from "bt full". Is this helpful?
Well, it shows that the failure is occurring while trying to evaluate
a variable in a trigger's WHEN clause during
"UPDATE origo_email_delivery SET folder_id=$1, created=$2\nWHERE entity_id IN
($3)\nRETURNING ent
Greetings,
* Allan Jensen (pgl...@winge-jensen.dk) wrote:
> I have GSSAPI-login and user mapping to postgres working fine.
Great!
> Whenever i login to postgres I get a line like the following in the
> logfile:
>
> connection authorized: user=testrole database=testdb SSL enabled
> (protocol=TLS
Hi Timmy
You need to use CIDR form in your pg_hba.conf. So:
host all testuser 111.222.333.444/32 md5
Most likely you would probably want to ensure ssl connection if coming
over untrusted network. So, at minimum, this is better:
hostssl all testuser 111.222.333.444/32 md5
This is better s
Dear All Users,
* How do I allow an external client IP address access to my pgsql server?
According to my own experience and test, if I set the external client IP
address to, for example, 111.222.333.444 in the file
/etc/postgresql/11/main/pg_hba.conf, it will not be able to connect to
the s
On Mon, Oct 7, 2019 at 10:12 PM Bruce Momjian wrote:
> Do the Postgres docs need improvement here?
I don't know, but I would probably add a flag column in the firing
matrix to indicate when the related function will return a null tuple.
Luca
På tirsdag 08. oktober 2019 kl. 17:24:21, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes:
> Will running a debug-enabled build slow things noticably down?
gcc promises that the generated code is the same with or without debug.
I think clang does too. With other compile
Hi,
I have GSSAPI-login and user mapping to postgres working fine.
Whenever i login to postgres I get a line like the following in the
logfile:
connection authorized: user=testrole database=testdb SSL enabled
(protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256,
compression=off)
What both
Hello,
use correct locale identifier, in your case it should be:
create collation "case_insensitive" (provider=icu,
locale="en-US-u-ks-level2", deterministic = false);
See
http://www.unicode.org/reports/tr35/tr35-collation.html#Setting_Options
for available options.
--
Pavel
Dne 09.10.2019
Igal Sapir wrote:
> I am trying to test a simple case insensitive comparison. Most likely the
> collation that I chose is wrong, but I'm not sure how to choose the correct
> one (for English/US?). Here is my snippet:
>
> create collation case_insensitive(
> provider=icu, locale='en-US-x-icu'
Using the datatype citext might be an alternative solution
Igal Sapir schreef op October 8, 2019 10:51:52 PM UTC:
>I am trying to test a simple case insensitive comparison. Most likely
>the
>collation that I chose is wrong, but I'm not sure how to choose the
>correct
>one (for English/US?). Her
34 matches
Mail list logo
