>I have hardly used savepoints in any application, but if I understand
>it correctly, isn't it something which is typically used
>in a persistent connection. I wonder how it is applicable in a web
>based stateless application like Amazon.com, unless
>even web based application have database lev
Also
https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
and https://www.postgresql.org/docs/10/static/logical-replication.html for
other options as well.
On Fri, Oct 5, 2018 at 7:35 AM Fabio Pardi wrote:
> Hi,
>
> I think you are looking for:
>
> https://www.postgre
Also, modified time doesn't need to be the current time, if it starts as
"null" and is set on the first update, and all subsequent updates, the
pre-update modified time could be used to help key the history pk.
Jim
On Tue, Sep 25, 2018 at 1:45 AM James Keener wrote:
> v3 U
digimer wrote:
> On 2018-09-25 1:33 a.m., James Keener wrote:
> > Do you need a single field for the pk or can you just make it the
> > (original_table_pk, modified_time)? Alternatively, you could generate
> > a uuid v3 from the (original_table_pk, modified_time) using
Do you need a single field for the pk or can you just make it the
(original_table_pk, modified_time)? Alternatively, you could generate a
uuid v3 from the (original_table_pk, modified_time) using something like
uuid_generate_v3(uuid_nil(), original_table_pk || ":" || modified_time)?
>
> You may dislike the outcome, but it was not ignored.
I can accept that I don't like the outcome, but I can point to maybe a
dozen people in the last
exchange worried about the CoC being used to further political goals, and
the only response
was "well, the CoC Committee will handle it reasona
> following a long consultation process
It's not a consultation if any dissenting voice is simply ignored. Don't
sugar-coat or politicize it like this -- it was rammed down everyone's throats.
That is core's right, but don't act as everyone's opinions and concerns were
taken into consideration.
The preceding's pretty simple. An attacker goes after an individual,
> presumably without provocation and/or asymetrically. The attacked
> person is on this mailing list. IMHO this attacker must choose between
> continuing his attacks, and belonging to the Postgres community.
>
> What's tougher is
> To many of us, we absolutely are a community. Remember, there are people
> here who have been around for 20+ years, of which many have become close
> friends, having started working on PostgreSQL as a hobby. We have always
> seen the project as a community of like-minded technologists, and welcom
I didn't realize they had replied personally to me.
-- Forwarded message --
From: James Keener
Date: Fri, Sep 14, 2018 at 10:43 AM
Subject: Re: Code of Conduct plan
To: Dave Page
If that business is publicly bringing the project into disrepute, or
> harassing other c
>
> And if you believe strongly that a given statement you may have made is
> not objectionable...you should be willing to defend it in an adjudication
> investigation.
So because someone doesn't like what I say in a venue 100% separate from
postgres, I have to subject myself, and waste my time,
> > I fail to see how that makes everyone here part of a community anymore
> than
> > I'm part of the "community" of regulars at a bar I walk into for the
> first
> > time.
>
> Does the bartender get to kick you out if you get into a fight? Or if
> you're rude or inappropriate towards the waitress
>
> Yes, I believe so. Isn't that what "To that end, we have established this Code
> of Conduct for community interaction and participation in the project’s
> work and the community at large." basically says?
>
No? What's the "community at large"? To me that sounds like "all
interactions" whether
Yes. They can. The people who make the majority of the contributions to the
> software can decide what happens, because without them there is no
> software. If you want to spend 20 years of your life
>
So everyone who moderates this group and that will be part of the CoC
committee will have had to
> Community is people who joined it
We're not a "community." We're people using email to get help with or
discuss technical aspects of PostgreSQL. The types of discussions that
would normally be held within a "community" would be entirely off-topic
here. We should be professional to each other he
> Now, you may say that (2) would be rejected by the committee, but I would
>> counter that it's still a stain on me and something that will forever
>> appear
>> along side my name in search results and that the amount of time and
>> stress it'd take me to defend myself would make my voluntarily le
I understand the concern, however, if you look at how attacks happen
> it is frequently through other sites. Specifically under/poorly
> moderated sites. For specific examples, people who have issues with
> people on Quora will frequently go after them on Facebook and Twitter.
>
> these aren't a s
I find a lot of neo-con/trumpian political stances moronic, short-sighted, and
anti-intellectual and therefore consider them offensive, an affront on my way
of life, and a stain on my country.
1) Can I report anyone holding such views and discussing them on a 3rd party
forum?
2) Could I be re
> he doesn't want the overhead, dependencies and worries of anything like
an external DB with a DBA, etc... . He also wants this to be fast.
So they're trading consistency concerns for ... not having a central db?
Even if your shop requires a DBA for any DB, it sounds like a really bad
deal.
Jim
Being libre software that doesn't necessitate a closed source operating system.
Jim
On July 15, 2018 12:59:08 PM EDT, Dmitry Igrishin wrote:
>Hello all,
>
>Colleagues. There is an idea to develop a commercial IDE for PostgreSQL
>under Windows.
>At the initial stage, not so much an IDE, as an ass
Can you explain what you're looking for? Beyond manually editing the schema
dump to import correctly into postgres and the loading in INSERT dumps or
MySQL file (TSV?) dumps, what are you looking for? Do you have any
odd/incompatible data types?
Jim
On Mon, Jun 25, 2018 at 11:47 AM, chiru r wrot
ase just tell me the site i will do it right away and i have marked
>it junked so many times , i will keep spamming it until my email
>address is removed from the list
>
>Bye
>
>________
>From: James Keener
>Sent: Wednesday, June 20, 2018 3:11 AM
&g
Seriously, stop spamming the list and stop cursing and acting like a petulant
child. Go to the site and unsubscribe or use a mail client that understands the
standard list headers.
On June 19, 2018 6:06:59 PM EDT, Asif Ali wrote:
>how the fuck i unsubscribe to this mailing list , i get more tha
I accidentally didn't send this to the whole list. I'll let Chris resend
his response if he'd like.
On Tue, Jun 5, 2018 at 1:58 PM, James Keener wrote:
> I think the fundamental outcome is likely to be that people who cause
>> trouble are likely to get trouble.
> Your example is flawed because:
>
> Multi-Partner has nothing to do with sexuality unless you want to make the
> argument that your belief is that a relationship should be between one
> person and another and in this argument a man and a woman which has
> literally nothing to do with the word mul
I'm sorry for the double post.
> If you read the reporting guidelines, it is requested that someone filing a
report provides as much evidence as possible, and that is a really
important provision, both for the person reporting and for the committee
to review and adjudicate fairly.
What does fairl
> [T]he
main goal is to ensure that if someone is being harassed by a community
member, they have an appropriate avenue to safely report it and ensure
the CoC committee will review
To be honest, this is a bigger problem. Why would someone not feel comfortable
contacting the core team? Why would t
On June 5, 2018 12:36:37 PM EDT, "Joshua D. Drake"
wrote:
>On 06/05/2018 09:32 AM, Tom Lane wrote:
>> James Keener writes:
>>> I don't participate too much here, but I've never see a group
>implement
>>> a code of conduct go well.
>&g
> Nobody is claiming that the CoC is perfect, or that it can anticipate
every situation; it's just a framework for handling disputes about
abusive and/or antisocial behavior
1) Antisocial is a cop-outs word that is so broad as to be useless. That
previous sentence can be classified as antisocial
making decisions based on technical merit and not the person who proposed an
idea or submitted a patch.
We can't control the behavior of the internet as a whole. We can control our
codebase and our gatekeepers.
Jim
On June 5, 2018 12:06:54 PM EDT, James Keener wrote:
>Do we need a
Do we need a code of conduct like this, or so we need a more general dispute
resolution process? Something that is public and aimed at mediating disputes
(even ones about bad conduct) and removing repeat offenders. To be honest,
larger issues of harassment should be handled by the police.
A co
I don't think I fully understand. Do you mean all pk using a single
sequence? I'm not sure how this would avoid nulls or grouping fields.
Jim
On Fri, Jun 1, 2018 at 12:52 PM, Guyren Howe wrote:
> It’s come to my attention that what seems an obvious and useful database
> design pattern — 1:1 rel
A bit of pedanticism:
> So we would like to know how you recommend copying PostgreSQL database
files in Windows OS to perform file system level backups.
(For Example – The recommended way in Linux is to use tar format.)
That is not what a file-system-level back up is, and not what tar does at
a
What requirements do you have? Would enabling full disk encryption suite your
needs?
On April 20, 2018 11:14:30 AM CDT, Tatsuo Ishii wrote:
>> Could someone throw light on the postgresql instance wide or database
>wide
>> encryption please? Is this possible in postgresql and been in use in
>> pr
Is setting it as an environment variable an option?
https://www.postgresql.org/docs/9.1/static/libpq-envars.html
Alternatively, a service file?
https://www.postgresql.org/docs/9.0/static/libpq-pgservice.html
Jim
On April 13, 2018 2:43:01 PM EDT, David Gauthier
wrote:
>Hi:
>
>PG v9.5.2 on RHE
Well, it's not a problem, it's the way it's designed and it's a sensible
design. Check https://www.postgresql.org/docs/9.3/static/libpq-envars.html for
more info on doing what you want.
On March 5, 2018 7:55:46 AM EST, "Łukasz Jarych" wrote:
>Hi Guys,
>
>do you have also problem that every time
I believe postgrest can, and you can always use jwt in your application, but
postgresql doesn't natively support them.
On January 24, 2018 4:27:23 PM EST, Julio Cesar Tenganan Daza
wrote:
>Hello,
>
>I would like to know if is possible to use Token (JWT) authentication
>mechanism in Postgres? In
Do you have any indecies?
https://www.postgresql.org/docs/current/static/indexes-expressional.html
might be helpful to you.
Also, EXPLAIN will help you understand how your query is being run and
where it can be improved.
https://www.postgresql.org/docs/current/static/using-explain.html
http://pos
If shp2pgsql doesn't run on windows, qgis might be an option?
Jim
On January 2, 2018 6:24:45 PM EST, "Ramamoorthi, Meenakshi"
wrote:
>Hi All:
>
>I wanted to know if there are any tools available to upload the shape
>files from windows platform and then deposit it into PostgreSQL
>database on a
What are the errors you're getting?
I don't think unique key is the correct syntax.
https://www.postgresql.org/docs/current/static/indexes-unique.html
I also don't think the key can be named the same as the field.
Jim
On December 24, 2017 12:52:39 PM EST, Michelle Konzack
wrote:
>Hello *
>
>
Connections are synchronous. You can have multiple connections to the database
at a time.
Jim
On December 22, 2017 2:20:03 PM EST, hmidi slim wrote:
>But is it possible to make simultanoues select queries from the same
>connection?
>
>2017-12-22 20:00 GMT+01:00 Andreas Kretschmer
>:
>
>> On 22
> postgres remains so damn difficult and time wasting to quickly get up
and running vs other db's and docs don't help much
See, I feel exactly the opposite. The docs are some of the best of any database
or open source software I've used. Postgres also does the "right" thing almost
all the time
Would a storage block level incremental like zfs work?
On December 19, 2017 11:12:48 AM EST, Rakesh Kumar
wrote:
>
>> There are multiple solutions to doing incremental backups with
>> PostgreSQL, so I'm not sure why you're saying that they don't exist,
>> because that's really not accurate.
>
>P
x27;A'::bytea,
'\xc1'::bytea);` and then sort by the result of this function.
Jim
On Tue, Dec 12, 2017 at 10:47 AM, John McKown
wrote:
> On Tue, Dec 12, 2017 at 9:43 AM, James Keener wrote:
>
>> Sorry for spamming the list. It appears that I'm an idiot. Sorry :(
&g
er by a collate "en_US.utf8";
a
--
12 Days of Christmas
12 drummers
a
aardvark
Anne
b
Isaac
island
Jim
job
(10 rows)
On Tue, Dec 12, 2017 at 10:36 AM, James Keener wrote:
> en_US.utf8. is still 0-9A-Za-z and in my example set (as it's my defaul
017 at 10:24 AM, John McKown
wrote:
> On Tue, Dec 12, 2017 at 9:11 AM, James Keener wrote:
>
>> The default C locale on Linux (I don't know Windows) will sort "digits",
>>> then alphabetic with the lower then upper case of each letter in order
>>> like
>
> The default C locale on Linux (I don't know Windows) will sort "digits",
> then alphabetic with the lower then upper case of each letter in order
> like: "aAbB...zZ"
>
That's no true at all! The C locales are 0-9A-Za-z
#include
> #include
> #include
> #include
> #include
>
>
> static int
The two non elegant ways I can think of is checking the modification time on
the files representing the database and a query that checks the pk of all
tables. If they're ordered pk you could store the max of them and then compare,
otherwise the max of an updated at column would work as well.
Ji
My initial inclination is to always build the simplest to understand system
first. Space is cheap and pg is pretty efficient, engineering time is expensive
and debugging time doubly so with a side of anxiety when production goes down.
Also, it will allow more flexibility later on to describe you
49 matches
Mail list logo
