Re: [HACKERS] HISTIGNORE for psql

Hello, On Fri, 18 Aug 2017, Vesa-Matti J Kari wrote: > A quick patch is attached. Not sure about the quality, hacked this > together in about four hours, trying to figure out how to do it correctly > the PostgreSQL way. Sorry, I guess I have written too many Python scripts. I

Re: [HACKERS] HISTIGNORE for psql

Hello, On Thu, 17 Aug 2017, Pavel Stehule wrote: > 2017-08-17 9:23 GMT+02:00 Vesa-Matti J Kari : > > Bash has HISTIGNORE feature that allows you to exclude certain commands > from the command history (e.g. shutdown, reboot, rm *). > > Would it make any s

[HACKERS] HISTIGNORE for psql

Hello, Bash has HISTIGNORE feature that allows you to exclude certain commands from the command history (e.g. shutdown, reboot, rm *). Would it make any sense to add such a feature to psql (e.g. to ignore DROP, DELETE commands)? Regards, vmk -- *

Re: [HACKERS] postgresql transactons not fully isolated

On 06/20/2017 12:33 PM, Merlin Moncure wrote: > postgres=# create table ints (n int); > CREATE TABLE > postgres=# insert into ints values (1); > INSERT 0 1 > postgres=# insert into ints values (2); > INSERT 0 1 > > T1: BEGIN > T1: UPDATE ints SET n = n + 1; > T2: BEGIN > T2: DELETE FROM ints wher

[HACKERS] Re: Postgresql bug report - unexpected behavior of suppress_redundant_updates_trigger

On 06/19/2017 11:40 AM, Dilip Kumar wrote: > ... Artus de benque ... wrote: >> ...=# UPDATE test_table SET field = rpad('', 2001, 'a') WHERE id = 1; > > Seems like in "suppress_redundant_updates_trigger" we are comparing > toasted tuple with the new tuple and that is the cause of the bug. Somethi

Re: [HACKERS] TAP: allow overriding PostgresNode in get_new_node

On 06/02/2017 12:50 PM, Robert Haas wrote: > On Thu, Jun 1, 2017 at 3:36 AM, Michael Paquier >> >> +$pgnclass = 'PostgresNode' unless defined $pgnclass; >> I'd rather leave any code of this kind for the module maintainers, > > Craig's proposal is a standard Perl idiom, though. Would it not be

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

On Thu, Nov 28, 2013 at 5:15 AM, Andres Freund wrote: > Hi, > > Do you still have the core file around? If so could you 'p > *ShmemVariableCache' and 'p *ControlFile'? > So sorry, I didn't see this message until just today. Seems it was accidentally archived before hitting my eyeballs. I see tha

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

On Mon, Nov 25, 2013 at 11:46 AM, Alvaro Herrera wrote: > J Smith escribió: > >> We did have some long-running transactions, yes. We refactored a bit >> and removed them and the problem ceased on our end. We ended up >> reverting our changes for the sake of running

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

On Mon, Nov 25, 2013 at 6:47 AM, Andres Freund wrote: > Hi, > > On 2013-11-24 16:56:26 -0500, J Smith wrote: > >> Nov 23 14:38:32 dev postgres[23810]: [4-1] user=dev,db=dev ERROR: could not >> access status of transaction 13514992 >> Nov 23 14:38:32 dev postgres

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

coredumper worked like a charm. Useful tool, that is... although as a bit of advice, I'd try not to run it on Postgres if your various memory settings are tweaked towards production use -- the core dump that was captured on my server weighed in at 16 GB. Anyways, I've attached both the log entries

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

On Tue, Nov 19, 2013 at 10:16 AM, J Smith wrote: > Alright, we'll look into doing that heading into the weekend. > Interestingly, we haven't experienced the issue since our main Java > developer made some modifications to our backend system. I'm not > entirely sure wha

Re: [HACKERS] Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1

On Thu, Nov 21, 2013 at 10:27 AM, Andres Freund wrote: > > I don't think so - for one, pg_subtrans isn't really the problems with > that bug, for another, it won't cause missing files. Also, you're not > using replication, right? > Actually, this server is a master being replicated to a standby.

Re: [HACKERS] Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1

On Tue, Nov 19, 2013 at 9:22 AM, Andres Freund wrote: > On 2013-11-19 15:20:01 +0100, Andres Freund wrote: >> Imo something the attached patch should be done. The description I came >> up with is: >> >> Fix Hot-Standby initialization of clog and subtrans. > G'day Andres. This wouldn't happen

Re: [HACKERS] Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1

On Thu, Nov 21, 2013 at 12:23 PM, Andres Freund wrote: > > It's still not this issue in that case, but I might have an idea... Do > you have hot_standby_feedback enabled? > Nope, hot_standby_feedback is set to its default setting which is off. At any rate, I'm going to try and capture a backtrac

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

re-SELECTing a table during a transaction. We'll rollback this change and re-compile Postgres with google-coredumper and let it run over the weekend and see where we stand. Cheers On Tue, Nov 19, 2013 at 9:14 AM, Robert Haas wrote: > On Fri, Nov 15, 2013 at 4:01 PM, J Smith wrote: >&g

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

On Fri, Nov 15, 2013 at 3:21 PM, Robert Haas wrote: > > I think what would help the most is if you could arrange to obtain a > stack backtrace at the point when the error is thrown. Maybe put a > long sleep call in just before the error happens, and when it gets > stuck there, attach gdb and run

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

Looks like we got another set of errors overnight. Here's the log file from the errors. (Log file scrubbed slightly to remove private data, but still representative of the problem I believe.) Nov 13 05:34:34 dev postgres[6084]: [4-1] user=dev,db=dev ERROR: could not access status of transaction 63

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

On Tue, Nov 12, 2013 at 11:55 AM, Andres Freund wrote: > Hi, > > On 2013-11-12 11:46:19 -0500, J Smith wrote: >> > * Does SELECT count(*) FROM pg_prepared_xacts; return 0? >> >> Yes it does. > > Could you show the output? Do you actually use prepared xact

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

On Tue, Nov 12, 2013 at 11:54 AM, Stephen Frost wrote: > > Did you also upgrade to PostGIS 2.x as part of this..? Seems like it'd > be unrelated, but one never knows. Any chance you could distill this > down into a small test case which exhibits the problem? I'm guessing > 'no', but figured I'd

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

G'day Andres. On Tue, Nov 12, 2013 at 11:13 AM, Andres Freund wrote: > Hi, > > On 2013-11-12 10:56:55 -0500, J Smith wrote: >> G'day list. Didn't get any interest in pgsql-general, thought I'd try >> my luck here, which perhaps would be more fitting i

Re: [HACKERS] Errors on missing pg_subtrans/ files with 9.3

On Tue, Nov 12, 2013 at 11:25 AM, Stephen Frost wrote: > > How was this upgrade done? If you used pg_upgrade, what version of the > pg_upgrade code did you use? As I recall, there was a bug in older > versions which could exhibit in this way.. > > http://wiki.postgresql.org/wiki/20110408pg_upgra

[HACKERS] Errors on missing pg_subtrans/ files with 9.3

G'day list. Didn't get any interest in pgsql-general, thought I'd try my luck here, which perhaps would be more fitting in case I've stumbled upon an edge case issue or something... I've recently upgraded a number of servers from PostgreSQL 9.2.5 to 9.3.1 and have started getting the following err

Re: [HACKERS] Strange hanging bug in a simple milter

Hello, On Mon, 23 Sep 2013, Stephen Frost wrote: > I've now committed a fix for this issue. I cloned the 9.4devel branch and linked my authmilter and a test program (based on Heikki's earlier design) against the libpq that comes with it. After hours of pretty extensive stress testing using 2,

Re: [HACKERS] Strange hanging bug in a simple milter

Hello, On Mon, 9 Sep 2013, Heikki Linnakangas wrote: > I managed to set that up and got it running. Many thanks for taking the time. > But it works fine for me, does not hang. Okay. Have you tried increasing the iterations for the smtp sender scripts? And could you please specify what is your

[HACKERS] Strange hanging bug in a simple milter

Hello PostgreSQL gurus, (I have already posted a very similar message to comp.mail.sendmail newsgroup on August 22nd, but I haven't received any responses there. I have also tried pgsql-interfa...@postgresql.org but to no avail. Solving this problem requires some Sendmail/Postfix experience becau

Re: [HACKERS] [GENERAL] postgres FDW cost estimation options unrecognized in 9.3-beta1

On Fri, Jul 26, 2013 at 3:28 PM, Tom Lane wrote: > Lonni J Friedman writes: >> nightly=# ALTER SERVER cuda_db10 OPTIONS (SET use_remote_estimate 'true') ; >> ERROR: option "use_remote_estimate" not found > >> Am I doing something wrong, or is this a

[HACKERS] Seg fault when processing large SPI cursor (PG9.13)

nt = 1; // 2^0 unsigned int i, j, end, stored; unsigned int result_counter = 0; float8 l1_norm; bool is_null = true; bool nulls[4]; Datum result_tuple_datum[4]; HeapTuple new_tuple; MemoryContext function_context; ResultCandidate *candidate, **candidates, *top,

Re: [HACKERS] unaccent extension missing some accents

On Mon, Nov 7, 2011 at 11:53 AM, Florian Pflug wrote: > > Various issues with OSX and UTF-8 locales seems to come up quite often, yet > we're not really in a position to do anything about them. > > Thus, I think we should warn about these issues and save people the trouble > of finding out about t

Re: [HACKERS] unaccent extension missing some accents

On Mon, Nov 7, 2011 at 11:59 AM, Tom Lane wrote: > > If you have time to check that the patch I just committed fixes your > problem, it'd be worth doing.  I did not test it on OS X ... Looks good to me, thanks. Would it even really be worth it to look into any of the other locale issues on OSX,

Re: [HACKERS] unaccent extension missing some accents

On Mon, Nov 7, 2011 at 11:12 AM, Tom Lane wrote: > I looked at this a bit and realized that sscanf is actually doing a > couple of critical things for us, which are lost in translation when > doing it like this: > > 1. It ignores whitespace other than the dividing tab.  If we don't > continue to d

Re: [HACKERS] unaccent extension missing some accents

Alright, I wrote up another patch that uses strchr to parse out the lines of the unaccent.rules file, foregoing sscanf completely. Hopefully this looks a bit better than using swscanf. As for the other problems with isspace and such on OSX, it might be worth looking at the python portability fixes

Re: [HACKERS] unaccent extension missing some accents

On 2011-11-06, at 7:15 PM, Tom Lane wrote: > > swscanf doesn't seem like an acceptable approach: it's a function that > is relied on nowhere else in PG, so it adds new portability risks of its > own. It doesn't exist on some platforms that we support (like the one > I'm typing this message on) an

Re: [HACKERS] unaccent extension missing some accents

On Sun, Nov 6, 2011 at 1:18 PM, Florian Pflug wrote: > > What's the locale of the database you're seeing this in, and which charset > does it use? > > I think scanf() uses isspace() and friends, and last time I looked the > locale definitions where all pretty bogus on OSX. So maybe scanf() somehow

Re: [HACKERS] unaccent extension missing some accents

Gah! Accidentally hit Send. Let me finish that last message before sending this time! G'day list. I've been messing around with the unaccent extension and I've noticed that some of the characters listed in the unaccent.rules file aren't actually being unaccented on my system. Here are the syste

[HACKERS] unaccent extension missing some accents

G'day list. I've been messing around with the unaccent extension and I've noticed that some of the characters listed in the unaccent.rules file aren't actually being unaccented on my system. Here are the system details and whatnot. - OSX 10.7.2 - the server is compiled via macports. Tried using

Re: [HACKERS] IDLE in transaction introspection

On Tue, Nov 01, 2011 at 10:13:52AM -0400, Andrew Dunstan wrote: > > > On 11/01/2011 09:52 AM, Tom Lane wrote: > >Simon Riggs writes: > >>Why not leave it exactly as it is, and add a previous_query column? > >>That gives you exactly what you need without breaking anything. > >That would cost twic

Re: [HACKERS] Thoughts on "SELECT * EXCLUDING (...) FROM ..."?

On Mon, Oct 31, 2011 at 09:14:48AM -0400, Andrew Dunstan wrote: > The fact is that if you have 100 columns and want 95 of them, it's > very tedious to have to specify them all, especially for ad hoc > queries where the house SQL standards really don't matter that much. > It's made more tedious by t

Re: [HACKERS] sha1, sha2 functions into core?

On Fri, Sep 02, 2011 at 02:05:45PM -0500, k...@rice.edu wrote: > On Fri, Sep 02, 2011 at 09:54:07PM +0300, Peter Eisentraut wrote: > > On ons, 2011-08-31 at 13:12 -0500, Ross J. Reedstrom wrote: > > > Hmm, this thread seems to have petered out without a conclusion. Just >

Re: [HACKERS] sha1, sha2 functions into core?

On Fri, Aug 12, 2011 at 10:14:58PM +0300, Marko Kreen wrote: > On Thu, Aug 11, 2011 at 5:46 PM, Tom Lane wrote: > > Marko Kreen writes: > >> On Wed, Aug 10, 2011 at 9:19 PM, Tom Lane wrote: > >>> ... which this approach would create, because digest() isn't restricted > >>> to just those algorith

Re: [HACKERS] Fwd: Keywords in pg_hba.conf should be field-specific

On Tue, Jun 21, 2011 at 10:15:50AM -0400, Alvaro Herrera wrote: > Excerpts from Pavel Stehule's message of mar jun 21 10:04:26 -0400 2011: > > 2011/6/21 Alvaro Herrera : > > > Excerpts from Pavel Stehule's message of mar jun 21 00:59:44 -0400 2011: > > > > > >> yes - it has a sense. Quoting changes

Re: [HACKERS] Boolean operators without commutators vs. ALL/ANY

On Fri, Jun 17, 2011 at 05:21:10PM +0200, Florian Pflug wrote: > On Jun17, 2011, at 17:15 , Ross J. Reedstrom wrote: > > On Fri, Jun 17, 2011 at 10:20:04AM -0400, Alvaro Herrera wrote: > >> Excerpts from Florian Pflug's message of vie jun 17 10:03:56 -0400 2011: > >&g

Re: [HACKERS] Boolean operators without commutators vs. ALL/ANY

On Fri, Jun 17, 2011 at 10:20:04AM -0400, Alvaro Herrera wrote: > Excerpts from Florian Pflug's message of vie jun 17 10:03:56 -0400 2011: > > > How is that worse than the situation with "=~" and "~="? > > With =~ it is to the right, with ~= it is to the left. To throw my user opinion into this

Re: [HACKERS] FOREIGN TABLE doc fix

Right, but I think he needs the "it's not easy, here's the whole workflow" overview first. Ross -- Ross Reedstrom, Ph.D. reeds...@rice.edu Systems Engineer & Admin, Research Scientistphone: 713-348-6166 Connexions http://cnx.org

Re: [HACKERS] pg_upgrade using appname to lock out other users

On Thu, Jun 16, 2011 at 09:48:12AM -0400, Bruce Momjian wrote: > Tom Lane wrote: > > "Ross J. Reedstrom" writes: > > > As an operations guy, the idea of an upgrade using a random, > > > non-repeatable port selection gives me the hebejeebees. > > &g

Re: [HACKERS] pg_upgrade using appname to lock out other users

On Wed, Jun 15, 2011 at 09:14:16PM -0400, Stephen Frost wrote: > Bruce, > > * Bruce Momjian (br...@momjian.us) wrote: > > I have researched this and need feedback. > > In general, I like the whole idea of using random/special ports for the > duration of the upgrade. I agree that we need to kee

Re: [HACKERS] Boolean operators without commutators vs. ALL/ANY

On Sun, Jun 12, 2011 at 6:46 AM, Florian Pflug wrote: > (B) There should be a way to use ANY()/ALL() with the > array elements becoming the left arguments of the operator. FWIW, in case people were unaware, this is getting close to Perl 6 junctions/superpositions. See:

Re: [HACKERS] Range Types and extensions

On Mon, Jun 06, 2011 at 12:53:49PM -0400, Robert Haas wrote: > > I don't have clear feeling on this question in general, but if we're > going to break this up into pieces, it's important that they be > logical pieces. Putting half the feature in core and half into an > extension just because we c

Re: [HACKERS] Domains versus polymorphic functions, redux

On Fri, Jun 03, 2011 at 11:22:34AM -0400, Robert Haas wrote: > On Fri, Jun 3, 2011 at 1:14 AM, Noah Misch wrote: > > No, there's no need to do that.  The domain "is" an array, not merely > > something > > that can be coerced to an array.  Therefore, it can be chosen as the > > polymorphic > > ty

Re: [HACKERS] BLOB support

On Thu, Jun 02, 2011 at 01:43:16PM -0400, Tom Lane wrote: > =?utf-8?q?Rados=C5=82aw_Smogura?= writes: > > Tom Lane Thursday 02 of June 2011 16:42:42 > >> Yes. I think the appropriate problem statement is "provide streaming > >> access to large field values, as an alternative to just fetching/sto

Re: [HACKERS] [PERFORM] Hash Anti Join performance degradation

On Wed, Jun 01, 2011 at 04:58:36PM -0400, Robert Haas wrote: > On Wed, Jun 1, 2011 at 4:47 PM, Tom Lane wrote: > > Robert Haas writes: > >> I guess the real issue here is that m1.id < m2.id has to be evaluated > >> as a filter condition rather than a join qual. > > > > Well, if you can invent an

Re: [HACKERS] creating CHECK constraints as NOT VALID

On Tue, May 31, 2011 at 11:35:01AM -0500, Kevin Grittner wrote: > Alvaro Herrera wrote: > > > This patch allows you to initially declare a CHECK constraint as > > NOT VALID, similar to what we already allow for foreign keys. > > That is, you create the constraint without scanning the table and

Re: [HACKERS] [PATCH] Bug in XPATH() if expression returns a scalar value

On Tue, May 31, 2011 at 04:19:29PM +0200, Florian Pflug wrote: > Sorry for the self-reply but I figured it'd be helpful to add information > that I discovered only after my initial post. > > On May30, 2011, at 15:17 , Florian Pflug wrote: > > The XPath expression 'name(/*)', for example, is suppos

Re: [HACKERS] tackling full page writes

On Wed, May 25, 2011 at 01:29:05PM -0400, Robert Haas wrote: > On Wed, May 25, 2011 at 1:06 PM, Greg Smith wrote: > > On 05/24/2011 04:34 PM, Robert Haas wrote: > > > I've been looking into a similar refactoring of the names here, where we > > bundle all of these speed over safety things (fsync,

Re: [HACKERS] LOCK DATABASE

On Thu, May 19, 2011 at 04:13:12PM -0400, Alvaro Herrera wrote: > Excerpts from Robert Haas's message of jue may 19 15:32:57 -0400 2011: > > > > That's a bit of a self-defeating argument though, since it implies > > that the effect of taking an exclusive lock via LockSharedObject() > > will not si

Re: [HACKERS] Pull up aggregate subquery

On Mon, May 23, 2011 at 11:08:40PM -0400, Robert Haas wrote: > > I don't really like the idea of adding a GUC for this, unless we > convince ourselves that nothing else is sensible. I mean, that leads > to conversations like this: > > Newbie: My query is slow. > Hacker: Turn on enable_magic_pixi

Re: [HACKERS] Collation mega-cleanups

On Tue, May 10, 2011 at 07:21:16PM +0200, Andres Freund wrote: > On Tuesday, May 10, 2011 07:08:23 PM Ross J. Reedstrom wrote: > > On Mon, May 09, 2011 at 03:57:12PM -0400, Robert Haas wrote: > > > On Mon, May 9, 2011 at 2:58 PM, Bruce Momjian wrote: > > > > Tom this

Re: [HACKERS] 4.1beta1: ANYARRAY disallowed for DOMAIN types which happen to be arrays

Given: CREATE DOMAIN int_array AS int[]; The operator [] works fine in 4.1beta1: SELECT (ARRAY[1,2,3]::int_array)[1]; proving that int_array is an array type with element type int. It is inconsistent that other array functions and operators don't work. On Mon, 2011-05-09 at 23:32 -0400, T

Re: [HACKERS] Collation mega-cleanups

On Mon, May 09, 2011 at 03:57:12PM -0400, Robert Haas wrote: > On Mon, May 9, 2011 at 2:58 PM, Bruce Momjian wrote: > > Tom this collation stuff has seen more post-feature-commit cleanups than > > I think any patch I remember.  Is there anything we can learn from this? > > How about "don't commit

[HACKERS] Server Programming Interface underspecified in 4.1beta1

The documentation for the Server Programming Interface is underspecified such that it is impossible to create real extensions using only the documented interface. For example, in the example 43.5 http://www.postgresql.org/docs/9.1/static/spi-examples.html a variable of type SPITupleTable is being

[HACKERS] 4.1beta1: ANYARRAY disallowed for DOMAIN types which happen to be arrays

E.1.2.2. Casting * Tighten casting checks for domains based on arrays (Tom Lane) When a domain is based on an array type,..., such a domain type is no longer allowed to match an anyarray parameter of a polymorphic function, except by explicitly down

Re: [HACKERS] Formatting Curmudgeons WAS: MMAP Buffers

On Thu, Apr 21, 2011 at 11:16:45AM -0400, Tom Lane wrote: > Robert Haas writes: > > On Thu, Apr 21, 2011 at 2:43 AM, Peter Eisentraut wrote: > >> I think to really address that problem, you need to think about shorter > >> release cycles overall, like every 6 months. �Otherwise, the current 12 >

Re: [HACKERS] [COMMITTERS] pgsql: Document the all-balls IPv6 address.

On Fri, Mar 18, 2011 at 11:00:19PM -0400, Tom Lane wrote: > Robert Haas writes: > > On Fri, Mar 18, 2011 at 10:19 PM, Andrew Dunstan > > wrote: > >> On 03/18/2011 09:18 PM, Robert Haas wrote: > >>> "all balls" seems like a colloquialism best avoided in our documentation. > > >> It's already the

Re: [HACKERS] Sync Rep v19

On Fri, Mar 11, 2011 at 09:03:33AM -0500, Robert Haas wrote: > On Fri, Mar 11, 2011 at 8:21 AM, Fujii Masao wrote: > > > > In that case, the last write WAL timestamp would become equal to the > > last replay WAL timestamp. So we can see that there is no lag. > > Oh, I see (I think). You're talki

Re: [HACKERS] [DOCS] Sync rep doc corrections

On Mon, Mar 07, 2011 at 03:45:17PM -0300, Alvaro Herrera wrote: > Excerpts from Tom Lane's message of lun mar 07 15:16:31 -0300 2011: > > > If we do that then it becomes worth wondering what the -docs list is for > > at all. Maybe we *should* get rid of it; I dunno. I see your point > > about ho

Re: [HACKERS] Linux filesystem performance and checkpoint sorting

On Fri, Feb 4, 2011 at 12:31 PM, Greg Smith wrote: > -Switching from ext3 to xfs gave over a 3X speedup on the smaller test set: >  from the 600-700 TPS range to around 2200 TPS.  TPS rate on the larger data > set actually slowed down a touch on XFS, around 10%.  Still, such a huge win > when it's

Re: [HACKERS] ALTER EXTENSION UPGRADE, v3

On Thu, Feb 03, 2011 at 04:31:08PM +0100, Dimitri Fontaine wrote: > "Ross J. Reedstrom" writes: > > Hmm, how about allowing a list of files to execute? That allows the > > Sure. I still don't see why doing it in the control file is better than > in the Makefile,

Re: [HACKERS] ALTER EXTENSION UPGRADE, v3

On Thu, Feb 03, 2011 at 10:21:28AM +0200, Anssi Kääriäinen wrote: > On 02/02/2011 08:22 PM, Dimitri Fontaine wrote: >> Either one line in the Makefile or a new file with the \i equivalent >> lines, that would maybe look like: >> >>SELECT pg_execute_sql_file('upgrade.v14.sql'); >>SELECT pg_e

Re: [HACKERS] arrays as pl/perl input arguments [PATCH]

On Thu, Jan 13, 2011 at 2:06 AM, Martijn van Oosterhout wrote: > I played with this a little and it is fairly easy to make a variable > such that $a is the string representation and $a[0] the first value of > the array. The problem is that you can't pass such a variable into a > subroutine. I pla

Re: [HACKERS] Allowing multiple concurrent base backups

On Tue, Jan 11, 2011 at 11:06:18AM -0800, Josh Berkus wrote: > > > It makes it very convenient to set up standbys, without having to worry > > that you'll conflict e.g with a nightly backup. I don't imagine people > > will use streaming base backups for very large databases anyway. > > Also, imag

Re: [HACKERS] pg_dump -X

On Friday 24 December 2010 05:35:26 Robert Haas wrote: > Back in 2006, we have this commit: > > commit 2b25e1169f44368c120931787628d51731b5cc8c > Author: Peter Eisentraut > Date: Sat Oct 7 20:59:05 2006 + > > The -X option in pg_dump was supposed to be a workaround for the lack > of po

Re: [HACKERS] Patch to add a primary key using an existing index

On Fri, Dec 03, 2010 at 05:16:04PM -0500, Robert Treat wrote: > On Fri, Dec 3, 2010 at 4:41 PM, Josh Berkus wrote: > > > However, I don't see why we need (column_list). Surely the index has a > > column list already? > > > > ALTER TABLE table_name ADD CONSTRAINT pk_name PRIMARY KEY USING index_na

Re: [HACKERS] contrib: auth_delay module

On Fri, Nov 19, 2010 at 04:57:03PM +0900, KaiGai Kohei wrote: > (2010/11/18 2:17), Robert Haas wrote: > > > >If KaiGai updates the code per previous discussion, would you be > >willing to take a crack at adding documentation? > > > >P.S. Your email client seems to be setting the Reply-To address to

Re: [HACKERS] contrib: auth_delay module

On Tue, Nov 16, 2010 at 09:41:37PM -0500, Robert Haas wrote: > On Tue, Nov 16, 2010 at 8:15 PM, KaiGai Kohei wrote: > > If we don't need a PoC module for each new hooks, I'm not strongly > > motivated to push it into contrib tree. > > How about your opinion? > > I'd say let it go, unless someone

Re: [HACKERS] plperl arginfo

On Thu, Oct 28, 2010 at 11:34 AM, Tom Lane wrote: > Andrew Dunstan writes: >> On 10/28/2010 11:54 AM, Pavel Stehule wrote: >>> Alternatively, maybe the feature could be exposed in a way where you >>> don't actually calculate the values unless requested, ie provide some >>> sort of inquiry functio

Re: [HACKERS] SHOW TABLES

On Thu, Jul 15, 2010 at 04:20:12PM +0100, Simon Riggs wrote: > > Just for the record, I've never ever met anyone that said "Oh, this \d > syntax makes so much sense. I'm a real convert to Postgres now you've > shown me this". The reaction is always the opposite one; always > negative. Which detrac

Re: [HACKERS] log files and permissions

On Thu, Jul 1, 2010 at 12:19 PM, Michael Tharp wrote: > That said, as Martin mentions one can easily place the log directory outside > of the data directory and set appropriate directory permissions. If I can offer my $0.02, I recently solved such a problem on SuSE Linux with apache logs. I used

Re: [HACKERS] Admission Control

On Sat, Jun 26, 2010 at 01:19:57PM -0400, Robert Haas wrote: > > I'm not sure. What does seem clear is that it's fundamentally at odds > with the "admission control" approach Kevin is advocating. When you > start to run short on a resource (perhaps memory), you have to decide > between (a) waiti

Re: [HACKERS] New PGXN Extension site

On Tue, Jun 15, 2010 at 03:42:59PM -0700, David E. Wheeler wrote: > On Jun 15, 2010, at 3:22 PM, Bruce Momjian wrote: > > > I totaly agreed you need funding, and you are very well qualified to do > > this, and it is a badly needed facility. > > Thanks. > > > The problem I had is that the effort

Re: [HACKERS] New PGXN Extension site

On Tue, Jun 15, 2010 at 01:25:33PM -0700, David E. Wheeler wrote: > On Jun 15, 2010, at 1:12 PM, Bruce Momjian wrote: > > > This was just posted to announce. Seems the community now has to > > compete with another extension-based infrastructure if we ever get > > around to developing one of our o

Re: [HACKERS] no universally correct setting for fsync

On Mon, May 10, 2010 at 01:35:32PM -0700, Josh Berkus wrote: > deleted, > or on a reporting read-only clone of your database which gets > recreated very > night and is not used for failover. High quality hardware alone s/very/every/ or s/very night/periodically/ Ross -- Ross Re

Re: [HACKERS] Add column if not exists (CINE)

On Tue, Apr 27, 2010 at 08:18:13PM -0400, Robert Haas wrote: > On Tue, Apr 27, 2010 at 6:45 PM, Kjell Rune Skaaraas > wrote: [snip] > > I saw some indications that this might be a minority opinion, well I would > > like to cast a vote FOR this functionality. The workarounds are ugly, the > > so

Re: [HACKERS] psql: Add setting to make '+' on \d implicit

On Fri, Apr 23, 2010 at 10:58:40AM -0500, Terry Brown wrote: > I asked on IRC if there was any way to make \d behave like \d+ by default, > and davidfetter said no but suggest it here. > > endpoint_david pointed out you could use \d- to get the old behavior if you > wanted to temporarily negate

Re: [HACKERS] Alias to rollback keyword

On Wed, Mar 31, 2010 at 10:34:41PM -0400, Bruce Momjian wrote: > Matthew Altus wrote: > > Hey, > > > > After dealing with a production fault and having to rollback all the time, > > I > > kept typing a different word instead of rollback. So I created a patch to > > accept this word as an alias

Re: [HACKERS] function to display ddl

On Sun, Feb 14, 2010 at 05:08:05PM +0100, Yeb Havinga wrote: > Little, Douglas wrote: > > > >Hi, > > > > > > > >Is there a PG command or fuction that will return table ddl? > > > If you just want the definition,in psql type \d tablename. > To dump ddl the pg_dump with proper arguments can dump jus

Re: [HACKERS] [PATCH] Output configuration status after ./configure run.

On Wed, Feb 10, 2010 at 07:01:19PM +0200, Priit Laes wrote: > > It might avoid the 'UU, I forgot to enable python support.', > after you have waited a while for the build to finish... > +1 from me, for that very reason! Ross -- Ross Reedstrom, Ph.D. reed

Re: [HACKERS] MySQL-ism help patch for psql

On Mon, Jan 25, 2010 at 10:49:55AM -0600, Ross J. Reedstrom wrote: > On Mon, Jan 25, 2010 at 06:06:53PM +0200, Alastair Bell Turner wrote: > <..> > > without having to add a switch to their command lines. It's not going > > to have anything to say to experienced

Re: [HACKERS] MySQL-ism help patch for psql

On Mon, Jan 25, 2010 at 06:06:53PM +0200, Alastair Bell Turner wrote: <..> > without having to add a switch to their command lines. It's not going > to have anything to say to experienced psql users anyway so it would > probably not bug anyone enough to turn it off. I would so use this feature goi

Re: [HACKERS] xml2 still essential for us

PostgreSQL's XML is in great shape by then, but we'll see! PostgreSQL is a great tool and y'all are doing great work in maintaining and improving it. The community has also been very helpful since I got over my shyness about asking for help. _Greg J. Greg Davidson Ancient Mariner

Re: [HACKERS] dbt2-shell script problem

PM, Jonas J wrote: > > I get the dbt2 project from the git tree. And i'm trying to make it work > > with postgres. The problem is in one of the dbt2 shell scripts. Since I > dont > > understand of Shell Script Programing, here is my problem: (I will post > the > >

Re: [HACKERS] primary key display in psql

On Wed, Jan 13, 2010 at 05:03:33PM -0500, Robert Haas wrote: > On Wed, Jan 13, 2010 at 4:47 PM, Tom Lane wrote: > > > > Spelling out "primary key" would seem to be more in keeping with existing > > entries in that column, eg we have "not null" not "NN". > > > > I think this is a sensible proposal

[HACKERS] xml2 still essential for us

sideration, _Greg J. Greg Davidson -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] dbt2-shell script problem

RG} ;; t) TABLESPACES_FLAG="-t" ;; esac done if [ "x${DBDATA}" = "x" ]; then usage exit 1 fi if [ ! "x${PORT}" = "x" ]; then PORTARG="-p ${PORT}" fi # Load tables # This background stuff is

Re: [HACKERS] New PostgreSQL Committers

On Mon, Dec 07, 2009 at 10:49:13AM +, Dave Page wrote: > On behalf of the core team, I'm pleased to announce that the > > Congratulations! > +1 Congrats to you all, and thanks for the contributions, both past and future. As an aside, this sort of thing is one of the best signs to an external

Re: [HACKERS] A sniffer for the buffer

umber). Then all blocks that PostgreSQL request to the buffer layer I will capture. Do DTrace can give my this information? Thanks in advance, Jonas Jeske 2009/12/8 Greg Smith > Jonas J wrote: > >> I took a look in the code again and made some changes. For the readBuffe

[HACKERS] A sniffer for the buffer

Hi, I'm a Computer Science student and I'm currently studying databases buffer managers. I want to do some experiments and see how the pages access works in PostgreSQL. (and I also will do some I/O experiments) So, I want to do a "sniffer" on the Storage Layer of Postgresql. It should work telli

Re: [HACKERS] SE-PgSQL patch review

On Tue, Nov 24, 2009 at 03:12:43PM +0900, KaiGai Kohei wrote: > Itagaki Takahiro wrote: > > * CREATE TABLE tbl (col integer AS SECURITY_CONTEXT = '...') > > Is the syntax " SECURITY_CONTEXT" natural in English? > > We need to put a reserved token, such as "AS", prior to the SECURITY_CONTEXT > to

Re: [HACKERS] plruby code and postgres ?

On Thu, Nov 19, 2009 at 05:15:05PM -0700, u235sentinel wrote: > Does anyone have a link for pl/ruby? I found a link under the postgres > documentation and found a web site from there talking about the code. > However when I clicked on the link to download it I noticed ftp wouldn't > respond on

[HACKERS] array casts that worked in 8.3 no longer work

ts of specializations of it). Is there an efficient (and maybe even easy) way to legally convert such arrays? Thanks for any suggestions you may have, _Greg J. Greg Davidson P.S. If you want a more complete example to refer to, here it is: CREATE TYPE base_refs; CREATE OR REPLACE FUNCTION base_r

Re: [HACKERS] postgresql regular expr bug?

On Sun, Jun 14, 2009 at 1:15 AM, Pavel Stehule wrote: > can somebody explain this behave? > > postgres=# select '10' ~ e'^\\d+$'; > ?column? > -- > t > (1 row) > ok > > postgres=# select '10' ~ '[0..9]+$'; > ?column? > -- > t > (1 row) > ok > > postgres=# select '10' ~ '^[0..9]+

[HACKERS] 8.4beta[12] set returning function fails -- was O.K. with 8.3

Dear PostgreSQL Hackers, Through PostgreSQL 8.3, both of the following functions worked, using generate_series(array_lower($1, 1), array_upper($1, 1)) i instead of generate_subscripts($1, 1). With PostgreSQL 8.4, both are accepted, but only the second one works, regardless of whether I use gene

  1   2   3   4   5   6   >