Re: [HACKERS] PostgreSQL Backup problems with tsearch2

2003-11-10 Thread Ian Barwick
the process. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Request for supported platforms

2002-10-29 Thread Ian Barwick
| zero | Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Please help

2002-10-21 Thread Ian Barwick
you have a problem with semaphores? See: http://www.ca.postgresql.org/docs/faq-english.html#3.4 (A lack of available semaphores can also produce the message No space left on device.) Sorry I can't help any further. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] Request for supported platforms

2002-10-27 Thread Ian Barwick
://home.akademie.de/~IBarwick/IRIX_65_regression.diffs Otherwise no apparent problems and the server started fine. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Request for supported platforms

2002-10-28 Thread Ian Barwick
, would you retest the CVS version of PostgreSQL to see if all the regression tests pass now? For confirmation: IIRC CVS now requires the latest Bison (1.75)? (The Irix machine has 1.35). Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5

[HACKERS] Boolean casting in 7.3 - changed?

2002-11-26 Thread Ian Barwick
query works in 7.1.3 and 7.2.1, but I haven't seen any mention of a change in 7.3 (at least not in the release notes). Apologies if this has been discussed to death previously, but it might be worth mentioning somewhere as a gotcha. Ian Barwick [EMAIL PROTECTED] ---(end

Re: [HACKERS] Boolean casting in 7.3 - changed?

2002-11-26 Thread Ian Barwick
On Wednesday 27 November 2002 06:23, Tom Lane wrote: Ian Barwick [EMAIL PROTECTED] writes: in 7.3 the following no longer works: template1= select 0::bool; ERROR: Cannot cast type integer to boolean Note that both old and new versions reject select 0::int4

Re: [HACKERS] Boolean casting in 7.3 - changed?

2002-11-28 Thread Ian Barwick
On Thursday 28 November 2002 00:18, Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: Ian Barwick writes: Casting integers to boolean (for example, 0::bool) is no longer allowed, use '0'::bool instead. This advice would probably only cause more confusion, because we are now

[HACKERS] Q: unknown expression type 108 ?

2002-12-05 Thread Ian Barwick
work in 7.1.3 with no apparent problems. Question: what does unknown expression type 108 mean and why should it suddenly occur in 7.3? A bit of Googling reveals the same message occurs when using subselects in constraints, but that doesn't seem related to this case. Ian Barwick [EMAIL PROTECTED

Re: [HACKERS] Q: unknown expression type 108 ?

2002-12-06 Thread Ian Barwick
On Friday 06 December 2002 20:50, Tom Lane wrote: Ian Barwick [EMAIL PROTECTED] writes: ERROR: ExecEvalExpr: unknown expression type 108 This is fixed as of yesterday --- see thread on (I think) pgsql-general for the patch. Many thanks. Applied and appears to work

Re: [HACKERS] [INTERFACES] Patch for DBD::Pg pg_relcheck problem

2002-12-10 Thread Ian Barwick
(crossposting to hackers) On Tuesday 10 December 2002 00:47, Tom Lane wrote: In the next protocol version update (hopefully 7.4) I would like to see the basic version string (eg, "7.3.1" or "7.4devel") delivered to the client automatically during connection startup and then

Re: [HACKERS] [INTERFACES] Patch for DBD::Pg pg_relcheck problem

2002-12-10 Thread Ian Barwick
(no followup to [EMAIL PROTECTED], getting a little OT there) On Tuesday 10 December 2002 16:54, Lee Kindness wrote: Ian Barwick writes: Something along the lines of char *PQversion(const PGconn *conn) ? Probably: int PQversion(const PGconn *conn)

Re: [HACKERS] psql and readline

2003-01-08 Thread Ian Barwick
can use \e to edit the query in your favourite editor. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] psql and readline

2003-01-08 Thread Ian Barwick
On Wednesday 08 January 2003 13:02, Alexander M. Pravking wrote: On Wed, Jan 08, 2003 at 10:53:51AM +0100, Ian Barwick wrote: On Wednesday 08 January 2003 07:55, Christopher Kings-Lynne wrote: Hi, Is there any way of making the 'up' arrow retrieve all of the last multiline query

Re: [HACKERS] A modest proposal for a FAQ addition

2003-01-12 Thread Ian Barwick
attached. Err, from the patch: CHAR(n) stores trailing spaces, while VARCHAR(n) trims them. Surely this should read something like: CHAR(n) automatically pads strings with trailing blanks to the defined column length. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] A modest proposal for a FAQ addition

2003-01-12 Thread Ian Barwick
insert the string 'hello' (5 characters) into a column defined as CHAR(8) it will become 'hello ' (8 characters) and simple comparisions with the original 'hello' will fail. Always define columns with VARCHAR(n) unless you have specific reasons for using CHAR(n). Ian Barwick [EMAIL PROTECTED

Re: [mail] Re: [HACKERS] Windows Build System

2003-01-31 Thread Ian Barwick
environment::. --QUOTE END-- Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] Todo claim: psql tab completion on schema names

2003-02-15 Thread Ian Barwick
? - pg_catalog.pg_table_is_visible() works on non-table relations as well, right? Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Todo claim: psql tab completion on schema names

2003-02-15 Thread Ian Barwick
not produce a list of indexes, same for \dv etc. I see no particular reason why this is so and can provide patches if relevant. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

[HACKERS] Q: pg_catalog views, OIDs and search_path

2003-02-17 Thread Ian Barwick
is intuitive. \d should of course operate on schema names too, to enable completion of relation names not in the search path; tentative patch will follow. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list

[HACKERS] Linking to current docs

2003-02-23 Thread Ian Barwick
would be involved ;-). Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Linking to current docs

2003-02-24 Thread Ian Barwick
On Sunday 23 February 2003 20:52, Dave Page wrote: -Original Message- From: Ian Barwick [mailto:[EMAIL PROTECTED] Would it be possible to modify the new docs to provide similar functionality? E.g. something like http://www.postgresql.org/docs/view.php?version=currentidoc=0file

Re: [HACKERS] Schemas: status report, call for developers

2002-05-01 Thread Ian Barwick
a critical look at anything I do. Yours Ian Barwick ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Schemas: status report, call for developers

2002-05-02 Thread Ian Barwick
++--+ foo| bar| r| foo2 | bar| r| (2 rows) i.e. user joe can see which objects exist in schema foo2, even though he has no USAGE privilege. (Is this behaviour intended?) Yours Ian Barwick ---(end of broadcast

Re: [HACKERS] Set Returning Functions (SRF) - request for patch review and comment

2002-05-11 Thread Ian Barwick
On Monday 06 May 2002 18:51, Joe Conway wrote: (...) Request for help: - So far I've tested with SQL and C functions. (...) Can you post an example of a function in C? (I'm trying out your patch from Friday). Thanks, Ian Barwick ---(end

Re: [HACKERS] Set Returning Functions (SRF) - request for patch review

2002-05-12 Thread Ian Barwick
See contrib/dblink. The version in cvs HEAD has two that return sets -- dblink() which returns an int, and dblink_get_pkey() which returns text. Thanks, now I can see what I was doing wrong Yours Ian Barwick ---(end of broadcast)--- TIP 4

[HACKERS] Q: unexpected result from SRF in SQL

2002-05-26 Thread Ian Barwick
(1); bar --- 139059784 (1 row) What is this number? It often varies from query to query. Possibly an error-in-disguise because of something to do with the calling context? Just curious ;-) Ian Barwick ---(end of broadcast)--- TIP

Re: [HACKERS] Q: unexpected result from SRF in SQL

2002-05-26 Thread Ian Barwick
why I posted the question is that I had defined a function that should have worked, but kept giving me back strange numbers, so I spent a whole five minutes trying to debug the function before I realised I was calling it in the wrong way (doh). An error here would be a Good Idea, IMHO. Ian Barwick

Re: [HACKERS] Schemas: status report, call for developers

2002-05-26 Thread Ian Barwick
On Wednesday 01 May 2002 06:38, Tom Lane wrote: Ian Barwick [EMAIL PROTECTED] writes: How can I restrict the query to the schemas in the current search path, i.e. the schema names returned by SELECT current_schemas() ? Well, this is the issue open for public discussion. We could define

[HACKERS] No bison and NAMEDATALEN 31: initdb failure?

2002-07-29 Thread Ian Barwick
for, so I'm not sure if this is intended behaviour. Questions: - Does src/include/postgres_ext.h count as a parser definition file? - If not shouldn't the above warning include something like And don't even think about changing NAMEDATALEN? Apologies if I've missed something obvious. Ian Barwick

Re: [HACKERS] No bison and NAMEDATALEN 31: initdb failure?

2002-07-31 Thread Ian Barwick
On Tuesday 30 July 2002 00:23, Tom Lane wrote: Ian Barwick [EMAIL PROTECTED] writes: - Does src/include/postgres_ext.h count as a parser definition file? No, it doesn't. Your experience sounds like you may have neglected to do a full rebuild after altering NAMEDATALEN. (By default, we

Re: [HACKERS] psql and output from \?

2002-03-14 Thread Ian Barwick
ready? Patch attached (diff against CVS, replacing previous patch). Ian Barwick Index: help.c === RCS file: /projects/cvsroot/pgsql/src/bin/psql/help.c,v retrieving revision 1.48 diff -c -r1.48 help.c *** help.c 2002/03/11 18:26:20

[HACKERS] Unexpected subquery behaviour

2004-07-26 Thread Ian Barwick
IN (SELECT bar.id FROM bar); ERROR: column bar.id does not exist test= ALTER TABLE bar RENAME foo_id TO id; ALTER TABLE test= SELECT * FROM foo WHERE id IN (SELECT id FROM bar); id 1 (1 row) Is this known behaviour, and is there a rationale behind it? Ian Barwick [EMAIL PROTECTED

Re: [HACKERS] Unexpected subquery behaviour

2004-07-26 Thread Ian Barwick
On Tue, 27 Jul 2004 01:33:44 +0200, Andreas Joseph Krogh [EMAIL PROTECTED] wrote: On Tuesday 27 July 2004 01:15, Ian Barwick wrote: Apologies if this has been covered previously. Given a statement like this: SELECT * FROM foo WHERE id IN (SELECT id FROM bar) I would expect it to fail

Re: [HACKERS] Unexpected subquery behaviour

2004-07-26 Thread Ian Barwick
On Mon, 26 Jul 2004 16:32:33 -0700 (PDT), Stephan Szabo [EMAIL PROTECTED] wrote: On Tue, 27 Jul 2004, Ian Barwick wrote: Apologies if this has been covered previously. Given a statement like this: SELECT * FROM foo WHERE id IN (SELECT id FROM bar) I would expect it to fail if bar

[HACKERS] 8.0b4: COMMIT outside of a transaction echoes ROLLBACK

2004-10-26 Thread Ian Barwick
test= commit; COMMIT test= commit; WARNING: there is no transaction in progress ROLLBACK Is there any reason ROLLBACK and not COMMIT is echoed here? Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] 8.0b4: COMMIT outside of a transaction echoes ROLLBACK

2004-10-27 Thread Ian Barwick
On Tue, 26 Oct 2004 21:42:19 -0400 (EDT), Bruce Momjian [EMAIL PROTECTED] wrote: Ian Barwick wrote: just wondering: test= select version(); version

Re: [HACKERS] 8.0b4: COMMIT outside of a transaction echoes ROLLBACK

2004-10-31 Thread Ian Barwick
, can do nasty things to one's blood pressure. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] [PATCHES] CVS should die

2004-11-05 Thread Ian Barwick
not the only one. Version 1.1 has a flat-file based backend which is not prone to BDB-permission-related problems, see: http://svnbook.red-bean.com/svnbook-1.1/ch05.html#svn-ch-5-sect-1.4 . It's only been around a few months though and the docs mention possible issues with scalability. Ian Barwick [EMAIL

Re: [HACKERS] psql: recall previous command?

2005-02-21 Thread Ian Barwick
thing in the case of a multiple line command, for example. Just checking: do you mean something like the \e and \p commands? test= SELECT \timing Timing is off. test- 'Hello World'; ?column? - Hello World (1 row) test= \p SELECT 'Hello World'; test= Ian Barwick

Re: [HACKERS] Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE constraint

2006-06-06 Thread Ian Barwick
exiting abnormally, index corruption with duplicate primary keys) on servers with defective RAM chips. Ian Barwick ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

Re: [HACKERS] SOLUTION: Insert a Euro symbol as UTF-8 from a latin1 charset.

2003-06-13 Thread Ian Barwick
' will display the Euro sign (assuming your terminal can print it). Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] SOLUTION: Insert a Euro symbol as UTF-8 from a latin1 charset.

2003-06-16 Thread Ian Barwick
' will display the Euro sign (assuming your terminal can print it). Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] [HACKERS] [pgsql-advocacy] Need concrete Why Postgres not MySQL bullet list

2003-08-21 Thread Ian Barwick
be missing something). Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] [GENERAL] [pgsql-advocacy] Need concrete Why Postgres not MySQL bullet list

2003-08-21 Thread Ian Barwick
On Thursday 21 August 2003 11:15, Shridhar Daithankar wrote: On 21 Aug 2003 at 0:22, Ian Barwick wrote: * DDL - Data definition language (table creation statements etc.) in MySQL are not transaction based and cannot be rolled back. Just wondering, what other databases has transactable

Re: [HACKERS] [BUGS] Autocomplete TAB on Postgres7.4beta5 not working?

2003-10-28 Thread Ian Barwick
live with that (one more character), at least until I finish the brainwave input extension ;-). Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs

Re: [HACKERS] [BUGS] Autocomplete TAB on Postgres7.4beta5 not working?

2003-10-28 Thread Ian Barwick
with tab expansion frequently and I'm sure it would annoy me intensely if I got all the system tables as well every time. Mind you that's only my personal preference, I thought it might be unpopular but as no one has commented since... I can submit a correction but not today or tomorrow. Ian Barwick

Re: [HACKERS] perl namespace for postgres specific modules?

2006-08-11 Thread Ian Barwick
, Msql and Oracle, has Postgres rather than PostgreSQL (though there are only two modules in it, one of which dates from 1998, see http://cpan.org/modules/by-module/Postgres/ ). Ian Barwick ---(end of broadcast)--- TIP 3: Have you checked our extensive

Re: [HACKERS] why table.name is translated to (name.*)::name?

2010-03-30 Thread Ian Barwick
as a 'gotcha', as name is hardly an uncommon column name, but it's not an issue which can easily researched... Ian Barwick -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] 9.0b1: ERROR: btree index keys must be ordered by attribute

2010-05-09 Thread Ian Barwick
(Ubuntu 4.3.2-1ubuntu12) 4.3.2, 32-bit Ubuntu 8.10 running on a VIA C7-M Processor (netbook). Regards Ian Barwick -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] 9.0b1: ERROR: btree index keys must be ordered by attribute

2010-05-09 Thread Ian Barwick
2010/5/9 David Fetter da...@fetter.org: On Sun, May 09, 2010 at 05:48:27PM +0900, Ian Barwick wrote: Hi I've just compiled the 9.0 beta1 source tarball and am testing my custom application against it (which has been running on PostgreSQL since 7.3 or so). The below statement results

Re: [HACKERS] 9.0b1: ERROR: btree index keys must be ordered by attribute

2010-05-09 Thread Ian Barwick
Hi 2010/5/10 Tom Lane t...@sss.pgh.pa.us: Ian Barwick barw...@gmail.com writes: 2010/5/9 David Fetter da...@fetter.org: A self-contained way to reproduce this, ideally small, would be fantastic :) s/fantastic/absolutely required to do anything with this report/ Yes, I appreciate that :) I

Re: [HACKERS] 9.0b1: ERROR: btree index keys must be ordered by attribute

2010-05-09 Thread Ian Barwick
2010/5/10 Ian Barwick barw...@gmail.com: SELECT ov.object_id FROM object_version ov WHERE ov.object_id = 1 AND ov.version ='0 AND ov.object_status_id = ( SELECT MAX(ov1.object_status_id) FROM object_version ov1 WHERE ov1.object_id=ov.object_id AND ov1

Re: [HACKERS] 9.0b1: ERROR: btree index keys must be ordered by attribute

2010-06-13 Thread Ian Barwick
was fixed by Tom. Thanks for the update, I can confirm the issue no longer occurs in beta2. Regards Ian Barwick -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] 8.4b1: Query returning results in different order to 8.3

2009-04-18 Thread Ian Barwick
2009/4/19 Tom Lane t...@sss.pgh.pa.us Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: Ian Barwick wrote: Note I'm not sure whether this is a bug, or whether the assumption made for the original query (that the row order returned by the subquery would be carried over

Re: [HACKERS] Autonomous Transaction (WIP)

2014-04-07 Thread Ian Barwick
a typo. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

[HACKERS] Doc typo in 9.28. Event Trigger Functions

2014-04-08 Thread Ian Barwick
Just a single missing 's'. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml new file mode 100644 index 6e2fbda..b5807f3 *** a/doc/src/sgml

[HACKERS] Patch: add psql tab completion for event triggers

2014-04-08 Thread Ian Barwick
: CREATE EVENT TRIGGER foo ON {event} ^I Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml new file mode 100644 index 6e2fbda..b5807f3

Re: [HACKERS] Patch: add psql tab completion for event triggers

2014-04-08 Thread Ian Barwick
On 08/04/14 18:22, Ian Barwick wrote: As it was kind of annoying not to have this when playing around with event triggers. This also tightens up the existing tab completion for ALTER TRIGGER, which contained redundant code for table name completion, and which was also causing a spurious RENAME

Re: [HACKERS] Patch: add psql tab completion for event triggers

2014-04-09 Thread Ian Barwick
On 10/04/14 00:23, Robert Haas wrote: On Tue, Apr 8, 2014 at 5:27 AM, Ian Barwick i...@2ndquadrant.com wrote: On 08/04/14 18:22, Ian Barwick wrote: As it was kind of annoying not to have this when playing around with event triggers. This also tightens up the existing tab completion for ALTER

Re: [HACKERS] Perfomance degradation 9.3 (vs 9.2) for FreeBSD

2014-04-24 Thread Ian Barwick
Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] pgaudit - an auditing extension for PostgreSQL

2014-05-02 Thread Ian Barwick
log via ereport(). 2. To implement per-object auditing configuration, it would be nice to use extensible reloptions (or an equivalent mechanism) Details such as output format, command classification etc. are provisional and open to further discussion. Authors: Ian Barwick, Abhijit Menon-Sen

[HACKERS] RETURNING PRIMARY KEY syntax extension

2014-06-08 Thread Ian Barwick
by that point and the primary key cannot change. A patch is attached which implements this, and will be added to the next commitfest. A separate patch will be submitted to the JDBC project. Example usage shown below. Regards Ian Barwick

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

2014-06-09 Thread Ian Barwick
On 09/06/14 14:47, David G Johnston wrote: Ian Barwick wrote Hi, The JDBC API provides the getGeneratedKeys() method as a way of retrieving primary key values without the need to explicitly specify the primary key column(s). This is a widely-used feature, however the implementation has

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

2014-06-12 Thread Ian Barwick
additional server-side syntax intended to make RETURNING * operations more efficient for certain use cases, but which is in itself not a JDBC change). Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

2014-06-12 Thread Ian Barwick
On 14/06/12 20:58, Jochem van Dieten wrote: On Thu, Jun 12, 2014 at 12:25 PM, Ian Barwick wrote: On 14/06/12 18:46, Jochem van Dieten wrote: I haven't checked the code, but I am hoping it will help with the problem where a RETURNING * is added to a statement

Re: [HACKERS] PL/pgSQL support to define multi variables once

2014-06-13 Thread Ian Barwick
, local_c text := 'a1'; BEGIN return local_a || local_b || local_c; end; $$ LANGUAGE plpgsql; Please submit this patch to the current commitfest: https://commitfest.postgresql.org/action/commitfest_view?id=22 Regards Ian Barwick -- Ian Barwick http://www

Re: [HACKERS] Doing better at HINTing an appropriate column within errorMissingColumn()

2014-06-16 Thread Ian Barwick
characters widely used is in tutorials, examples etc. However that's only my personal observation for one particular non-Roman language. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql

Re: [HACKERS] Doing better at HINTing an appropriate column within errorMissingColumn()

2014-06-16 Thread Ian Barwick
On 14/06/17 9:53, Tom Lane wrote: Michael Paquier michael.paqu...@gmail.com writes: On Tue, Jun 17, 2014 at 9:30 AM, Ian Barwick i...@2ndquadrant.com wrote: From what I've seen in the wild in Japan, Roman/ASCII characters are widely used for object/attribute names, as generally it's much less

Re: [HACKERS] Doing better at HINTing an appropriate column within errorMissingColumn()

2014-06-16 Thread Ian Barwick
On 14/06/17 11:57, Peter Geoghegan wrote: On Mon, Jun 16, 2014 at 7:09 PM, Ian Barwick i...@2ndquadrant.com wrote: Howver in this particular use case, as long as it doesn't produce false positives (I haven't looked at the patch) I don't think it would cause any problems (of the kind which

[HACKERS] [REVIEW] psql tab completion for DROP TRIGGER/RULE and ALTER TABLE ... DISABLE/ENABLE

2014-06-17 Thread Ian Barwick
' to 'Query_for_trigger_of_table' to hide them. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Re: [REVIEW] psql tab completion for DROP TRIGGER/RULE and ALTER TABLE ... DISABLE/ENABLE

2014-06-17 Thread Ian Barwick
On 14/06/18 7:51, Andreas Karlsson wrote: On 06/17/2014 01:36 PM, Ian Barwick wrote: One issue - the table's internal triggers will also be listed. which can result in something like this: This is a bit of an extreme case, but I don't think manually manipulating internal triggers (which can

[HACKERS] Possible index issue on 9.5 slave

2014-06-18 Thread Ian Barwick
tgg_user_login_key Index epp.tgg_user_login_key Column | Type | Definition +---+ login | character varying(32) | login unique, btree, for table epp.tgg_user Regards Ian Barwick -- Ian Barwick http://www

Re: [HACKERS] Possible index issue on 9.5 slave

2014-06-18 Thread Ian Barwick
On 19/06/14 11:58, Peter Geoghegan wrote: On Wed, Jun 18, 2014 at 6:54 PM, Ian Barwick i...@2ndquadrant.com wrote: I've just run into an index issue on 9.5 HEAD on a slave (master and slave both compiled from 66802246e22d51858cd543877fcfddf24e6812f2); details below (I have only found one index

Re: [HACKERS] Possible index issue on 9.5 slave

2014-06-18 Thread Ian Barwick
On 19/06/14 12:30, Peter Geoghegan wrote: On Wed, Jun 18, 2014 at 8:09 PM, Ian Barwick i...@2ndquadrant.com wrote: Interesting, I'll take a look later. I'm pretty suspicious of incompatibilities that may exist between the two sets of OS collations involved here. We aren't very clear

Re: [HACKERS] Possible index issue on 9.5 slave

2014-06-18 Thread Ian Barwick
On 19/06/14 12:35, Tom Lane wrote: Peter Geoghegan p...@heroku.com writes: On Wed, Jun 18, 2014 at 8:09 PM, Ian Barwick i...@2ndquadrant.com wrote: Interesting, I'll take a look later. I'm pretty suspicious of incompatibilities that may exist between the two sets of OS collations involved

Re: [HACKERS] replication commands and log_statements

2014-06-19 Thread Ian Barwick
with log_lock_waits, log_temp_files, log_disconnections etc. - It might be an idea to add a cross-reference to this parameter from the Streaming Replication Protocol page: http://www.postgresql.org/docs/devel/static/protocol-replication.html Regards Ian Barwick -- Ian Barwick http://www

Re: [HACKERS] tab completion for setting search_path

2014-06-22 Thread Ian Barwick
is entered, i.e. SET search_path TO pg_tab? Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

2014-06-25 Thread Ian Barwick
. Regards, I'll be submitting a revised version of this patch very shortly. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

2014-06-25 Thread Ian Barwick
On 25/06/14 16:04, Ian Barwick wrote: Hi On 14/06/25 15:13, Rushabh Lathia wrote: Hello All, I assigned my self as reviewer of the patch. I gone through the mail chain discussion and in that question has been raised about the feature and its implementation, so would like to know what

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2014-06-26 Thread Ian Barwick
of the others, but still more than nothing. https://www.mysql.com/products/enterprise/audit.html https://mariadb.com/kb/en/about-the-mariadb-audit-plugin/ Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

2014-06-26 Thread Ian Barwick
). On the other hand, it should be fairly straightforward to handle a list of keywords for expansion (e.g. RETURNING PRIMARY KEY, UNIQUE KEYS, SEQUENCE VALUES) should the need arise. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

2014-07-02 Thread Ian Barwick
is set. IOW, you can't assume that will give you the primary key. Damn, fooled by the name. Thanks for the info; I'll rework the patch accordingly. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

2014-07-02 Thread Ian Barwick
On 02/07/14 15:16, Ian Barwick wrote: On 14/07/01 23:13, Robert Haas wrote: On Tue, Jul 1, 2014 at 8:00 AM, Rushabh Lathia rushabh.lat...@gmail.com wrote: .) In map_primary_key_to_list() patch using INDEX_ATTR_BITMAP_IDENTITY_KEY bitmap to get the keycols. In IndexAttrBitmapKind there is also

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

2014-07-02 Thread Ian Barwick
to implement. Thoughts? Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] PL/pgSQL 2

2014-09-01 Thread Ian Barwick
) and not necessarily a pro/contra argument ;). Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2014-10-08 Thread Ian Barwick
pgAudit for submission this for the upcoming commitfest, it will be added within the next few days. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers

[HACKERS] psql tab completion: \c [ dbname [ username ] ]

2014-11-09 Thread Ian Barwick
but will happily do so if appropriate. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c new file mode 100644 index 886188c..56dc688 *** a/src

Re: [HACKERS] psql tab completion: \c [ dbname [ username ] ]

2014-11-10 Thread Ian Barwick
On 10/11/14 22:20, Robert Haas wrote: On Sun, Nov 9, 2014 at 6:13 PM, Ian Barwick i...@2ndquadrant.com wrote: Attached is a mighty trivial patch to extend psql tab completion for \c / \connect to generate a list of role names, as lack thereof was annoying me recently and I can't see any

[HACKERS] Comment header for src/test/regress/regress.c

2014-11-20 Thread Ian Barwick
I thought it might be useful to add a few words at the top of 'src/test/regress/regress.c' to explain what it does and to help differentiate it from 'pg_regress.c' and 'pg_regress_main.c'. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL

Re: [HACKERS] Comment header for src/test/regress/regress.c

2014-11-24 Thread Ian Barwick
On 14/11/21 22:10, Heikki Linnakangas wrote: On 11/21/2014 06:23 AM, Ian Barwick wrote: I thought it might be useful to add a few words at the top of 'src/test/regress/regress.c' to explain what it does and to help differentiate it from 'pg_regress.c' and 'pg_regress_main.c'. Makes sense

[HACKERS] pg_regress and --dbname option / multiple databases

2014-11-27 Thread Ian Barwick
the first database in the list. Is there a reason for this I'm not seeing? Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] pg_regress and --dbname option / multiple databases

2014-11-27 Thread Ian Barwick
On 28/11/14 00:02, Andrew Dunstan wrote: On 11/27/2014 04:12 AM, Ian Barwick wrote: Hi pg_regress provides the command line option --dbname, which is described in the help output thusly: --dbname=DBuse database DB (default regression) It does however accept multiple comma separated

[HACKERS] Testing DDL deparsing support

2014-11-27 Thread Ian Barwick
Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services diff --git a/src/test/regress/expected/.gitignore b/src/test/regress/expected/.gitignore index 93c56c8..2eeaf57 100644 --- a/src/test/regress/expected/.gitignore +++ b

Re: [HACKERS] Testing DDL deparsing support

2014-12-07 Thread Ian Barwick
On 14/12/07 12:43, Bruce Momjian wrote: On Tue, Dec 2, 2014 at 03:13:07PM -0300, Alvaro Herrera wrote: Robert Haas wrote: On Thu, Nov 27, 2014 at 11:43 PM, Ian Barwick i...@2ndquadrant.com wrote: A simple schedule to demonstrate this is available; execute from the src/test/regress

[HACKERS] psql tab completion: fix COMMENT ON ... IS IS IS

2014-12-28 Thread Ian Barwick
Hi Currently tab completion for 'COMMENT ON {object} foo IS' will result in the 'IS' being duplicated up to two times; not a world-shattering issue I know, but the fix is trivial and I stumble over it often enough to for it to mildly annoy me. Patch attached. Regards Ian Barwick -- Ian

Re: [HACKERS] psql tab completion: fix COMMENT ON ... IS IS IS

2014-12-31 Thread Ian Barwick
On 15/01/01 1:07, Robert Haas wrote: On Sun, Dec 28, 2014 at 7:44 PM, Ian Barwick i...@2ndquadrant.com wrote: Currently tab completion for 'COMMENT ON {object} foo IS' will result in the 'IS' being duplicated up to two times; not a world-shattering issue I know, but the fix is trivial and I

[HACKERS] Docs: CREATE TABLESPACE minor markup fix

2015-02-04 Thread Ian Barwick
Hi A superfluous '/' in an xref tag is producing an unintended '' in the Warning box on this page: http://www.postgresql.org/docs/current/interactive/sql-createtablespace.html Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

Re: [HACKERS] Docs: CREATE TABLESPACE minor markup fix

2015-02-04 Thread Ian Barwick
On 04/02/15 19:02, Fujii Masao wrote: On Wed, Feb 4, 2015 at 5:27 PM, Ian Barwick i...@2ndquadrant.com wrote: Hi A superfluous '/' in an xref tag is producing an unintended '' in the Warning box on this page: http://www.postgresql.org/docs/current/interactive/sql-createtablespace.html

[HACKERS] pg_basebackup, tablespace mapping and path canonicalization

2015-02-05 Thread Ian Barwick
else (including in CREATE TABLESPACE). The attached patch adds the missing canonicalization; I can't see any reason not to do this. Thoughts? Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training Services diff

  1   2   >