Re: [GENERAL] pgpass file type restrictions

ally want is a named pipe. I don't see any reason in principle to disallow use of a named pipe as a password file. It could be a bit of a footgun, though, since writing to the fifo would block until it was opened by the client, so you'd need to be very careful about that. cheers andrew -- An

Re: [GENERAL] pgpass file type restrictions

4b0d7bec13553ded89 > Author: Bruce Momjian <br...@momjian.us> > Date: Fri Jun 10 03:02:30 2005 + > > Add the "PGPASSFILE" environment variable to specify to the password > file. > > Andrew Dunstan > > an

Re: [GENERAL] json function question

On 02/24/2016 09:41 AM, Tom Lane wrote: However, it looks to me like row_to_json already does pretty much the right thing with nested array/record types: regression=# select row_to_json(row(1,array[2,3],'(0,1)'::int8_tbl,array[(1,2),(3,4)]::int8_tbl[]));

Re: [GENERAL] json function question

On 02/24/2016 09:11 AM, David G. Johnston wrote: On Wednesday, February 24, 2016, Andrew Dunstan <and...@dunslane.net <mailto:and...@dunslane.net>> wrote: Having json(b)_populate_record recursively process nested complex objects would be a large undertaking. One thing

Re: [GENERAL] json function question

On 02/23/2016 02:54 PM, Tom Lane wrote: Dan S writes: I have this table, data and query: create table test ( id int, txt text, txt_arr text[], f float ); insert into test values

Re: [GENERAL] [PERFORM] pg bouncer issue what does sv_used column means

Please do not cross-post on the PostgreSQL lists. Pick the most appropriate list to post to and just post there. cheers andrew -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] JSON does not support infinite date values

On 02/26/2015 11:03 AM, Tim Smith wrote: FYI although I remain a +1 on KISS and emitting infinity, for those of you still yearning after a standards-based implementation, there is a StackOverflow post which hints at sections 3.5 and 3.7 of ISO8601:2004. Unfortunatley I can't find a link to

Re: [GENERAL] JSON does not support infinite date values

On 02/26/2015 07:02 AM, Andres Freund wrote: Hi, On 2015-02-26 11:55:20 +, Tim Smith wrote: As far as I'm aware, JSON has no data types as such, and so why is Postgres (9.4.1) attempting to impose its own nonsense constraints ? impose its own nonsense constraints - breathe slowly in, and

Re: [GENERAL] JSON does not support infinite date values

On 02/26/2015 10:16 AM, Tom Lane wrote: Andres Freund and...@2ndquadrant.com writes: On 2015-02-26 11:55:20 +, Tim Smith wrote: As far as I'm aware, JSON has no data types as such, and so why is Postgres (9.4.1) attempting to impose its own nonsense constraints ? impose its own nonsense

Re: [GENERAL] JSON does not support infinite date values

On 02/26/2015 10:38 AM, Tom Lane wrote: Yeah, I think so. The sequence 'infinity'::timestamp to JSON to ISO-8601-only consumer is going to fail no matter what; there is no need for us to force a failure at the first step. Especially when doing so excludes other, perfectly useful use-cases.

Re: [HACKERS] [GENERAL] ON_ERROR_ROLLBACK

On 12/30/2014 09:20 AM, Tom Lane wrote: Bernd Helmle maili...@oopsware.de writes: --On 29. Dezember 2014 12:55:11 -0500 Tom Lane t...@sss.pgh.pa.us wrote: Given the lack of previous complaints, this probably isn't backpatching material, but it sure seems like a bit of attention to consistency

[GENERAL] Re: [HACKERS] COPY TO returning empty result with parallel ALTER TABLE

On 11/04/2014 01:51 PM, Tom Lane wrote: Bernd Helmle maili...@oopsware.de writes: --On 3. November 2014 18:15:04 +0100 Sven Wegener sven.wege...@stealer.net wrote: I've check git master and 9.x and all show the same behaviour. I came up with the patch below, which is against curent git

Re: [GENERAL] Postgres as In-Memory Database?

On 11/17/2013 07:02 PM, Stefan Keller wrote: 2013/11/18 Andreas Brandl m...@3.141592654.de mailto:m...@3.141592654.de wrote: What is your use-case? It's geospatial data from OpenStreetMap stored in a schema optimized for PostGIS extension (produced by osm2pgsql). BTW: Having said (to

Re: [GENERAL] [HACKERS] PLJava for Postgres 9.2.

On 05/16/2013 05:59 PM, Paul Hammond wrote: Hi all, I've downloaded PLJava, the latest version, which doesn't seem to have a binary distribution at all for 9.2, so I'm trying to build it from the source for Postgres 9.2. I have the DB itself installed on Windows 7 64 bit as a binary

[GENERAL] Re: [HACKERS] Namespace of array of user defined types is confused by the parser in insert?

On 04/24/2012 05:12 AM, Krzysztof Nienartowicz wrote: These types are qualified when created - the error does not happen on creation - there are two types in two different namespaces - it happens only on insert where it is not possible to qualify the type's namespace. It looks like a bug in

[GENERAL] Re: [HACKERS] Namespace of array of user defined types is confused by the parser in insert?

[redirected to pgsql-general] On 04/23/2012 09:42 AM, Krzysztof Nienartowicz wrote: Hello, Sorry for re-posting - I initially posted this in pgsql.sql - probably this group is more appropriate. pgsql-general probably would be best. -hackers is for discussion of internals and development,

Re: [HACKERS] [GENERAL] Issues with generate_series using integer boundaries

On 02/07/2011 06:38 AM, Thom Brown wrote: On 7 February 2011 09:04, Itagaki Takahiroitagaki.takah...@gmail.com wrote: On Fri, Feb 4, 2011 at 21:32, Thom Brownt...@linux.com wrote: The issue is that generate_series will not return if the series hits either the upper or lower boundary during

Re: [HACKERS] [GENERAL] Issues with generate_series using integer boundaries

On 02/08/2011 08:19 PM, Itagaki Takahiro wrote: On Wed, Feb 9, 2011 at 10:17, Andrew Dunstanand...@dunslane.net wrote: Isn't this all really a bug fix that should be backpatched, rather than a commitfest item? Sure, but we don't have any bug trackers... Quite right, but the commitfest

Re: [GENERAL] [HACKERS] Retiring from the PostgreSQL core team

Jan Wieck wrote: To whom it may concern, this is to inform the PostgreSQL community of my retirement from my PostgreSQL core team position. Over the past years I have not been able to dedicate as much time to PostgreSQL as everyone would have liked. The main reason for that was that I was

Re: [GENERAL] Installing PL/pgSQL by default

Tom Lane wrote: Bruce Momjian br...@momjian.us writes: One problem is that because system oids are used, it isn't possible to drop the language: I assume we still want to allow the language to be uninstalled, for security purposes. Yes. That behavior is not acceptable. Why aren't

Re: [HACKERS] [GENERAL] Updating column on row update

Tom Lane wrote: Thom Brown thombr...@gmail.com writes: As for having plpgsql installed by default, are there any security implications? Well, that's pretty much exactly the question --- are there? It would certainly make it easier for someone to exploit any other security weakness

Re: [HACKERS] [GENERAL] Updating column on row update

Tom Lane wrote: [ thinks for awhile... ] Actually, CREATE LANGUAGE is unique among creation commands in that the common cases have no parameters, at least not since we added pg_pltemplate. So you could imagine defining CINE for a language as disallowing any parameters and having these

Re: [GENERAL] [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing

Devrim GÜNDÜZ wrote: Hi, I just released new RPM sets, which is based on today's CVS snapshot (Sep 7, 12:00AM PDT). These packages *do* require a dump/reload, even from previous 8.4 packages, since I now enabled --enable-integer-datetimes in PGDG RPMs by default (and IIRC there is a

Re: [GENERAL] [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing

Joshua D. Drake wrote: Andrew Dunstan wrote: Hasn't integer-datetimes been the default for a while? Of course, a catversion bump will force a dump/reload regardless of that. Unfortunately not. It is the default on some versions of linux such as Debian/Ubuntu. The point I

Re: [GENERAL] [HACKERS] Errors with run_build.pl - 8.3RC2

cinu wrote: Hi All, I was running the run_Build.pl script that is specific to Buildfarm and encountered errors. I am listing out the names of the logfiles and the errors that I have seen. Can anyone give me some clarity on these errors? Even though these errors are existing, at the end the

Re: [GENERAL] postgres8.3beta encodding problem?

Martijn van Oosterhout wrote: On Tue, Dec 18, 2007 at 10:35:39AM -0500, Tom Lane wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: Ok, but that doesn't apply in this case, his database appears to be LATIN1 and this character is valid for that encoding... You know what,

Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

Greg Sabino Mullane wrote: Just as a followup, I reported this as a bug and it is being looked at and discussed: http://rt.perl.org/rt3//Public/Bug/Display.html?id=47576 Appears there is no easy resolution yet. We might be able to do something with the suggested workaround. I will

Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

Andrew Dunstan wrote: Greg Sabino Mullane wrote: Just as a followup, I reported this as a bug and it is being looked at and discussed: http://rt.perl.org/rt3//Public/Bug/Display.html?id=47576 Appears there is no easy resolution yet. We might be able to do something

Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

Greg Sabino Mullane wrote: Ugh, in testing I see some nastiness here without any explicit require. It looks like there's an implicit require if the text contains certain chars. Exactly. Looks like it's going to be very hard, unless someone has some brilliant insight I'm missing

Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

Greg Sabino Mullane wrote: Yes, we might want to consider making utf8 come pre-loaded for plperl. There is no direct or easy way to do it (we don't have finer-grained control than the 'require' opcode), but we could probably dial back restrictions, 'use' it, and then reset the Safe

Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

Andrew Dunstan wrote: Greg Sabino Mullane wrote: Yes, we might want to consider making utf8 come pre-loaded for plperl. There is no direct or easy way to do it (we don't have finer-grained control than the 'require' opcode), but we could probably dial back restrictions, 'use

Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

Andrew Dunstan wrote: Ugh, in testing I see some nastiness here without any explicit require. It looks like there's an implicit require if the text contains certain chars. I'll see what I can do to fix the bug, although I'm not sure if it's possible. Looks like it's going to be very

[GENERAL] Re: [HACKERS] SOS, help me please, one problem towards the postgresql developement on windows

[removing -hackers, as this question really doesn't seem to belong there] shieldy wrote: thankyou very much. but the method, you said, is adding a alias name, so it can not work. and as i need to add many functions likes this, so the best way is to compile the whole postgresql. eventhough, i

Re: [GENERAL] [HACKERS] Kill a Long Running Query

Mageshwaran wrote: Hi , Any body tell me how to kill a long running query in postgresql, is there any statement to kill a query, and also tell me how to log slow queries to a log file. First. please do not cross-post like this. Pick the correct list and use it. Second, this query

[GENERAL] Re: [HACKERS] 5 Weeks till feature freeze or (do you know where your patch is?)

Joshua D. Drake wrote: Andrew Dunstan: Something with COPY? Andrew? The only thing I can think of is to remove the support for ancient COPY syntax from psql's \copy, as suggested here: http://archives.postgresql.org/pgsql-hackers/2007-02/msg01078.php That's hardly a feature - more

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: And actually, when I look at the API docs, our case now seems to be documented. Or am I misreading our situation. I have: If you call CreateFile on a file that is pending deletion as a result of a previous call to

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

Richard Troy wrote: On Thu, 11 Jan 2007, Tom Lane wrote: ...snip... (You know, of course, that my opinion is that no sane person would run a production database on Windows in the first place. So the data-loss risk to me seems less of a problem than the unexpected-failures problem. It's not

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI Installer

Devrim GUNDUZ wrote: OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI RPM interface for the repositories. So our installer will help them a lot. Also, our installer will have an option to download and install the prebuilt binaries from PostgreSQL FTP site (and possible

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

Marc G. Fournier wrote: More seriously, I know under FreeBSD, one of the first things that gets done after installing is to customize the kernel to get rid of all the 'cruft' part of the generic kernel, I take it that this isn't something that ppl do with Linux? The Linux kernel has

Re: [Dbdpg-general] Re: [GENERAL] 'prepare' is not quite schema-safe

Vlad wrote: i.e. the following perl code won't work correctly with DBD::Pg 1.40+ $dbh-do(SET search_path TO one); my $sth1 = $dbh-prepare_cached(SELECT * FROM test WHERE item = ?); $sth1-execute(one); $dbh-do(set search_path to two); my $sth2 = $dbh-prepare_cached(SELECT * FROM test WHERE item =

Re: [Dbdpg-general] Re: [GENERAL] 'prepare' is not quite schema-safe

Andrew Dunstan wrote: Vlad wrote: i.e. the following perl code won't work correctly with DBD::Pg 1.40+ $dbh-do(SET search_path TO one); my $sth1 = $dbh-prepare_cached(SELECT * FROM test WHERE item = ?); $sth1-execute(one); $dbh-do(set search_path to two); my $sth2 = $dbh-prepare_cached(SELECT

Re: [GENERAL] [HACKERS] plPHP in core?

Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: On Fri, 1 Apr 2005, Joshua D. Drake wrote: Are we interested in having plPHP in core? Is there a reason why it can no longer operate as a standalone language out of pgfoundry, like pl/java and pl/perl? I have said

Re: [GENERAL] [HACKERS] plPHP in core?

Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: ... If there are no license or build issues I'm in favor. Peter has pointed out that the problem of circular dependencies is a showstopper for integrating plPHP. The build order has to be Postgres PHP (since its

Re: [GENERAL] [HACKERS] plPHP in core?

Robert Treat wrote: On Monday 04 April 2005 12:01, Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: ... If there are no license or build issues I'm in favor. Peter has pointed out that the problem of circular dependencies is a showstopper for integrating plPHP. The build

Re: [GENERAL] [HACKERS] Adding Reply-To: listname to Lists

Doug McNaught said: Marc G. Fournier [EMAIL PROTECTED] writes: No, the poster will still be included as part of the headers ... what happens, at least under Pine, is that I am prompted whther I want to honor the reply-to, if I hit 'y', then the other headers *are* strip'd and the mail is set

Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

Christopher Kings-Lynne said: But you would have to assign the copyright to them If someone is going to make money from my code, I prefer it to be me, or at least that everyone has a chance to do so rather than just one company. Well, then for the same reason we should write a Perl

Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

Shachar Shemesh wrote: Tom Lane wrote: These tools are a not insignificant part of our Plan for World Domination ;-) so it would be good if somebody stepped up to the plate and volunteered to take care of 'em. Anybody? Which brings me to another question I have a bunch of perl scripts, as

Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

Andrew Dunstan wrote: Christopher Kings-Lynne said: But you would have to assign the copyright to them If someone is going to make money from my code, I prefer it to be me, or at least that everyone has a chance to do so rather than just one company. Well, then for the same

Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

Jan Wieck wrote: Christopher Kings-Lynne wrote: ... on projects.postgresql.org, or similar.They really aren't doing any good in /contrib. I've already set up a category conversion tools on pgFoundry, and my idea was one project per target system. I reckon that by far the best way to