On Wednesday, July 12, 2017 6:31:09 AM EDT Jeroen Ooms wrote:
> I maintain static libraries for libpq for the R programming language
> (we need static linking to ship with the binary packages).
> Unfortunately currently the standard postgres makefile only generates
> a shared library for libpq, not
On Thursday, June 22, 2017 12:32:14 PM EDT Kang Yuzhe wrote:
> Here is a sample what I did after applying the patch.
>
> testdb=# BEGIN;
> BEGIN
> testdb=#
> testdb=# MERGE INTO Stock USING Buy ON Stock.item_id = Buy.item_id
> testdb-# WHEN MATCHED THEN UPDATE SET balance = balance + Buy.volume
>
On Tuesday, April 11, 2017 1:36:44 PM EDT Robert Haas wrote:
> I apologize for any disruption this may cause, but I'm hopeful that it
> won't be too bad.
Spoken like a true American - apologizing for taking vacation :-)
Enjoy your time off. You probably deserved it, and more than the week you're
On Monday, March 20, 2017 3:30:49 PM EDT Robert Haas wrote:
> On Sat, Mar 18, 2017 at 4:12 PM, Magnus Hagander
wrote:
> > createdb, dropdb - also not clear they're about postgres, more likely to
> > be
> > used by mistake but not that bad. That said, do they add any *value*
> > beyond
> > what yo
On Monday, January 9, 2017 7:39:49 PM EST Joel Jacobson wrote:
> On Mon, Jan 9, 2017 at 6:03 PM, Craig Ringer wrote:
> > Immutable functions can and do use functionality from all over the
> > server. They just don't depend on user-visible mutable _state_
> > elsewhere in the server.
>
> OK, fair
On Monday, January 9, 2017 7:06:21 AM EST Craig Ringer wrote:
> On 9 Jan. 2017 05:51, "Jan de Visser" wrote:
>
> On Sunday, January 8, 2017 6:28:17 AM EST Joel Jacobson wrote:
> > I don't want to learn the complicated details of C, that's true.
>
> An
On Sunday, January 8, 2017 6:28:17 AM EST Joel Jacobson wrote:
> I don't want to learn the complicated details of C, that's true.
And this is where I think you're wrong, and why conversion would be hard. C
has very few complicated details. I don't think it has any, frankly. It
basically says "If
On 2016-11-09 10:47 AM, Tom Lane wrote:
Amit Langote writes:
On Wed, Nov 9, 2016 at 11:47 PM, Tom Lane wrote:
Hmm, that's from 2009. I thought I remembered something much more recent,
like last year or so.
This perhaps:
* Re: Bootstrap DATA is a pita *
https://www.postgresql.org/message-id
On 2016-01-15 10:25 AM, Robert Haas wrote:
On Fri, Jan 15, 2016 at 10:12 AM, Benedikt Grundmann
wrote:
Today we discovered that we had a backend whose client had gone away, the
automatic query watching process had send both pg_cancel and
pg_terminate_backend but nevertheless the process was sit
On August 25, 2015 08:36:52 PM Tom Lane wrote:
> Jan de Visser writes:
> > On August 25, 2015 09:31:35 PM Michael Paquier wrote:
> >> This patch had feedback, but there has been no update in the last
> >> month, so I am now marking it as returned with feedback.
> >
On August 25, 2015 09:31:35 PM Michael Paquier wrote:
> On Thu, Jul 23, 2015 at 5:06 PM, Heikki Linnakangas wrote:
> > Other comments:
> > [...]
>
> This patch had feedback, but there has been no update in the last
> month, so I am now marking it as returned with feedback.
It was suggested that t
On July 6, 2015 09:23:12 AM Stephen Frost wrote:
> > I wonder whether we should consider inventing similar views for
> > pg_hba.conf and pg_ident.conf.
>
> Yes. That's definitely something that I'd been hoping someone would
> work on.
There actually is a patch in the current CF that provides a v
On July 3, 2015 06:21:09 PM Tom Lane wrote:
> I wonder whether we should consider inventing similar views for
> pg_hba.conf and pg_ident.conf.
(Apologies for the flurry of emails).
Was there not an attempt at a view for pg_hba.conf which ended in a lot of
bikeshedding and no decisions?
--
Sen
On July 3, 2015 09:24:36 PM Jan de Visser wrote:
> On July 3, 2015 06:21:09 PM Tom Lane wrote:
> > BTW, this version of this patch neglects to update the comments in
> > miscadmin.h, and it makes the return convention for
> > ProcessConfigFileInternal completely unintelligibl
On July 3, 2015 06:21:09 PM Tom Lane wrote:
> Jan de Visser writes:
> > Attached a new patch, rebased against the current head. Errors in
> > pg_hba.conf and pg_ident.conf are now also noticed.
> >
> > I checked the documentation for pg_ctl reload, and the only pla
On Fri, Jul 3, 2015 at 4:47 PM, I wrote:
> Attached a new patch, rebased against the current head. Errors in
> pg_hba.conf and pg_ident.conf are now also noticed.
>
> I checked the documentation for pg_ctl reload, and the only place where
> it's explained seems to be runtime.sgml and that descript
it of functionality wouldn't make much
sense.
On Sat, Apr 25, 2015 at 10:03 AM, Jan de Visser wrote:
> On April 22, 2015 06:04:42 PM Payal Singh wrote:
> > The following review has been posted through the commitfest application:
> > make installcheck-world: not test
On June 14, 2015 02:07:16 PM Bruce Momjian wrote:
> If you ever had trouble understanding a git manual page, this humorous
> random git man page generator is full of fun:
>
> http://git-man-page-generator.lokaltog.net/
>
> Try a few "generate" runs to find one that seems logical. :-)
To m
On June 13, 2015 09:30:12 PM Bruce Momjian wrote:
> Are there other countries where this would be appropriate?
I'm pretty sure Hungarian uses the family name-given name ordering, and it's
also sometimes used in French, and therefore you often see French family names
spelled in all caps.
--
On May 19, 2015 09:31:32 PM Greg Sabino Mullane wrote:
> Jan de Visser wrote:
> >> Well, one could argue that it *is* their problem, as they should be using
> >> the standard Postgres way for placeholders, which is $1, $2, $3...
> >
> > Shirley you are jok
On May 19, 2015 07:04:56 PM Greg Sabino Mullane wrote:
> Bruno Harbulot asked for a devil's advocate by saying:
> > My main point was that this is not specific to JDBC. Considering that even
> > PostgreSQL's own ECPG is affected, the issue goes probably deeper than it
> > seems. I'm just not convin
On April 29, 2015 03:09:51 PM Andrew Dunstan wrote:
> On 04/29/2015 01:19 PM, Robert Haas wrote:
> > On Mon, Apr 27, 2015 at 6:41 PM, Andrew Dunstan
wrote:
> >> There's one exception I, at least, have to this rule, namely when there's
> >> a
> >> corresponding compound if or else. I personally fi
On April 22, 2015 06:04:42 PM Payal Singh wrote:
> The following review has been posted through the commitfest application:
> make installcheck-world: not tested
> Implements feature: tested, failed
> Spec compliant: not tested
> Documentation:tested, failed
>
> Error
On April 22, 2015 11:14:08 AM Heikki Linnakangas wrote:
> On 04/16/2015 06:51 AM, Alvaro Herrera wrote:
> > Seems reasonable, but why are you sleeping 1s if pg_ctl -w is in use? I
> > thought the -w would wait until promotion has taken effect, so there's
> > no need to sleep additional time.
>
>
On April 21, 2015 09:34:51 PM Jan de Visser wrote:
> On April 21, 2015 09:01:14 PM Jan de Visser wrote:
> > On April 21, 2015 07:32:05 PM Payal Singh wrote:
... snip ...
>
> Urgh. It appears you are right. Will fix.
>
> jan
Attached a new attempt. This was one from the cat
On April 21, 2015 09:01:14 PM Jan de Visser wrote:
> On April 21, 2015 07:32:05 PM Payal Singh wrote:
> > I'm trying to review this patch and applied
> > http://www.postgresql.org/message-id/attachment/37123/Let_pg_ctl_check_the
> > _r esult_of_a_postmaster_config_reloa
(Please don't top post)
On April 21, 2015 07:32:05 PM Payal Singh wrote:
> I'm trying to review this patch and applied
> http://www.postgresql.org/message-id/attachment/37123/Let_pg_ctl_check_the_r
> esult_of_a_postmaster_config_reload.patch to postgres. gmake check passed
> but while starting pos
On March 4, 2015 11:08:09 PM Andres Freund wrote:
> Let's get the basic feature (notification of failed reloads) done
> first. That will be required with or without including the error
> message. Then we can get more fancy later, if somebody really wants to
> invest the time.
Except for also fixi
On March 3, 2015 06:34:33 PM Jim Nasby wrote:
> On 3/3/15 5:24 PM, Jan de Visser wrote:> On March 3, 2015 04:57:58 PM
> Jim Nasby wrote:
> >> On 3/3/15 11:48 AM, Andres Freund wrote:
> >>> I'm saying that you'll need a way to notice that a reload was
On March 3, 2015 04:57:58 PM Jim Nasby wrote:
> On 3/3/15 11:48 AM, Andres Freund wrote:
> > I'm saying that you'll need a way to notice that a reload was processed
> > or not. And that can't really be the message itself, there has to be
> > some other field; like the timestamp Tom proposes.
>
On March 3, 2015 11:09:29 AM Jim Nasby wrote:
> On 3/3/15 9:26 AM, Andres Freund wrote:
> > On 2015-03-03 15:21:24 +, Greg Stark wrote:
> >> Fwiw this concerns me slightly. I'm sure a lot of people are doing
> >> things like "kill -HUP `cat .../postmaster.pid`" or the equivalent.
> >
> > postm
On March 3, 2015 10:29:43 AM Tom Lane wrote:
> Andres Freund writes:
> > On 2015-03-03 15:21:24 +, Greg Stark wrote:
> >> Fwiw this concerns me slightly. I'm sure a lot of people are doing
> >> things like "kill -HUP `cat .../postmaster.pid`" or the equivalent.
> >
> > postmaster.pid already
On March 2, 2015 12:56:23 AM Jan de Visser wrote:
>
> Here's my first crack at this. Notes:
> 1/ I haven't done the '-W' flag Tom mentions yet.
> 2/ Likewise haven't touched pg_reload_conf()
> 3/ Design details: I introduced a new struct in pg_ct
On March 2, 2015 12:44:40 PM Tom Lane wrote:
> No, it doesn't, but pg_malloc0 does. Consult the code if you're confused:
> src/common/fe_memutils.c
Doh! I read pg_malloc( ), not pg_malloc0.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscrip
On March 2, 2015 09:50:49 AM Tom Lane wrote:
> However, you could and should use pg_malloc0, which takes care of that
> for you...
I am (using pg_malloc, that is). So, just to be sure: pg_malloc memsets the
block to 0, right?
My question was more along the lines if memsetting to 0 to ensure tha
On March 2, 2015 12:56:23 AM Jan de Visser wrote:
... stuff ...
I seem to have mis-clicked something in the CF app - I created two entries
somehow. I think one got created when I entered the msgid of Tom's original
message with the enclosing '<...>'. If that's the cas
On February 19, 2015 08:26:45 PM Tom Lane wrote:
> Bug #12788 reminded me of a problem I think we've discussed before:
> if you use "pg_ctl reload" to trigger reload of the postmaster's
> config files, and there's something wrong with those files, there's
> no warning to you of that. The postmaste
On February 19, 2015 08:26:45 PM Tom Lane wrote:
> I don't have the time to pursue this idea myself, but perhaps someone
> looking for a not-too-complicated project could take it on.
I can have a crack at this. What's the process? Do I add it to a CF once I
have a patch, or do I do that beforehan
wrote:
> > I can write the network program.
> > ...
Oh my. The worst kind of top-poster: the kind that copies *your* reply from
the bottom to the top and top-posts above that.
Shudder...
:)
ja
--(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-men
re's no value X in the
> index so that A < X < B". Maybe there's a better word for that.
http://en.wikipedia.org/wiki/Monotonic
jan
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
---
On Monday 11 September 2006 11:05, Thomas Hallgren wrote:
> Jan de Visser wrote:
> > On Friday 08 September 2006 15:18, Gevik Babakhani wrote:
> >> 2a) Three input formats are supported.
> >> example:
> >> insert into tbl (fld) values('1dfb39af-b56a-40b8-
t. I am just saying that you shouldn't limit yourself to
any particular input formats. I understand that the example I gave is not a
full GUID. As I said, I use that result as a base for a 128 bit GUID.
Aargh.
jan
--
------------
would work just fine.
jan
--
----------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast)---
On Friday 08 September 2006 21:34, [EMAIL PROTECTED] wrote:
> On Fri, Sep 08, 2006 at 09:24:19PM -0400, Jan de Visser wrote:
> > On Friday 08 September 2006 15:18, Gevik Babakhani wrote:
> > > 2a) Three input formats are supported.
> > > example:
> > > insert
.rmi.server.UID());
3b732da7:10d9029b3eb:-8000
bsh %
So forms that use colons instead of dashes seem appropriate.
Or better still, make it configurable.
jan
--
----------
Jan de Visser [EMAI
al things will muck up file
timestamps by copying :)
jan
--
----------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
--
cited
> about writing a patch no one sees a real need for.
Make that five. I'll bless the day I can get rid of my recursive plsql
functions.
jan
--
--
Jan de Vi
the ability to test 8.0 on the same machine? We did some
> extensive modifications to the signal stuff between 8.0 and 8.1, it'd be
> interesting to see if that changed things.
I seem to remember we made ourselves dependend on 8.1 somehow, but will check.
jan
--
--
On Monday 13 March 2006 09:26, Jan de Visser wrote:
> On Sunday 12 March 2006 09:40, Magnus Hagander wrote:
> > Looking a my system while testing this it still loooked like it was
> > hanging on that plac ein the code, even though I saw no problems. So I'm
> > not convi
reads. So I don't think this patch will actually work :-( But it's
> worth a try.
I'm afraid you're right. Hangs again :(
jan
--
--------------
Jan de Visser [EMAIL PROTECTED]
it's
> worth a try.
>
> (Oh, and I moved the thread over to -hackers, seems more correct at this
> time)
Thanks Magnus,
I'll try tomorrow. Will let you know ASAP (8:30 EST I guess :).
If
52 matches
Mail list logo
