[HACKERS] Too problems when using Postgresql8.3.7,Please help!

2010-08-03 Thread Richard
he LSN where the error occured contained the wrong pageaddr, the pageaddr was 8K before it's real address.What was wrong? -- Richard 2010-08-03 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Two problems when using Postgresql8.3.7, Please help me!

2010-08-03 Thread Richard
he LSN where the error occured contained the wrong pageaddr, the pageaddr was 8K before it's real address.What was wrong? 2010-08-04 Richard

[HACKERS] Online backup cause boot failure, anyone know why?

2010-08-05 Thread Richard
et this before? Please help me! -- Richard 2010-08-05 -- 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] Online backup cause boot failure, anyone know why?

2010-08-05 Thread Richard
PS : I am using PG 8.3.7 -- Richard 2010-08-05 - 发件人:Richard 发送日期:2010-08-05 21:19:27 收件人:pgsql-hackers 抄送: 主题:Online backup cause boot failure, anyone know why? I want to create a

[HACKERS] Re: Re: [HACKERS] Online backup cause boot failure, anyone know why?

2010-08-05 Thread Richard
what? -- Richard 2010-08-05 - 发件人:Andrew Dunstan 发送日期:2010-08-05 21:40:13 收件人:Richard 抄送:pgsql-hackers 主题:Re: [HACKERS] Online backup cause boot failure, anyone know why? On 08/05/2010 09:19 AM, Richard

Re: [HACKERS] Online backup cause boot failure, anyone know why?

2010-08-05 Thread Richard
? -- Richard 2010-08-05 - 发件人:Tom Lane 发送日期:2010-08-05 22:04:30 收件人:Richard 抄送:pgsql-hackers 主题:Re: [HACKERS] Online backup cause boot failure, anyone know why? "Richard" writes: > PS : I am using PG 8.3.7 I believe there&#x

[HACKERS] Re: Re: [HACKERS] Re: Re: [HACKERS] Online backup cause boot failure,anyone know why?

2010-08-05 Thread Richard
the running error log not the XLOG. -- Richard 2010-08-05 - 发件人:Robert Haas 发送日期:2010-08-05 22:07:45 收件人:Richard 抄送:Andrew Dunstan; pgsql-hackers 主题:Re: [HACKERS] Re: Re: [HACKERS] Online

Re: [HACKERS] Online backup cause boot failure, anyone know why?

2010-08-05 Thread Richard
atter? -- Richard 2010-08-05 - 发件人:Tom Lane 发送日期:2010-08-05 22:04:30 收件人:Richard 抄送:pgsql-hackers 主题:Re: [HACKERS] Online backup cause boot failure, anyone know why? "Richard" writes: > PS : I am using PG 8.3.7 I believe there&#

[HACKERS] Re: Re: Re: [HACKERS] Re: Re: [HACKERS] Online backup cause bootfailure,anyone know why?

2010-08-05 Thread Richard
should not be missing some XLOG, can be the XLOG file or buffer was corrupted. -- Richard 2010-08-05 - 发件人:Robert Haas 发送日期:2010-08-05 22:38:37 收件人:Richard 抄送:Andrew Dunstan; pgsql-hackers 主题:Re:

Re: [HACKERS] Online backup cause boot failure, anyone know why?

2010-08-05 Thread Richard
I am sorry, my English is poor. I was confused by what you said. What do you mean by saying "that'd break it"! -- Richard 2010-08-05 - 发件人:Tom Lane 发送日期:2010-08-05 22:44:50

Re: [HACKERS] Online backup cause boot failure, anyone know why?

2010-08-05 Thread Richard
I am sorry, my English is poor. I was confused by what you said. What do you mean by saying "that'd break it"! -- Richard 2010-08-05 - 发件人:Tom Lane 发送日期:2010-08-05 22:44:50

Re: [HACKERS] Online backup cause boot failure, anyone know why?

2010-08-05 Thread Richard
All jods are done by client code, not manually. I still did't not understand what you said. What break what? Thandks! -- Richard 2010-08-05 - 发件人:Heikki Linnakangas 发送日期:2010-08-05

[HACKERS] Re: Re: [HACKERS] Online backup cause boot failure, anyone know why?

2010-08-05 Thread Richard
Sorry, wrong word, it should be job. You mean the wrong type of checkpoint causes XLOG file recovery fail? I was confused, the XLOG files seem corrupted, is it also caused by the checkpoint type? If so , why it can do this? -- Richard 2010-08-05

[HACKERS] Possible to inline setof SQL UDFs?

2007-05-23 Thread richard
I'm curious if there is a reason that SQL setof UDFs couldn't be inlined? For example, given a sable setof SQL UDF like CREATE TYPE uids AS (uid integer); CREATE FUNCTION needs_secure(integer, integer) RETURNS SETOF uids AS $_$ SELECT uid FROM needs nsec WHERE nsec.foo = $1 AND nsec.bar = $2 $

[HACKERS] Tsearch2 index size

2006-11-02 Thread richard
abuse you give. No. Wait. No abuse please. Richard Whidden ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[HACKERS] Shared memory and memory context question

2006-02-05 Thread richard
his problem has been solved before, as I have searched through the mailing lists and through the source, but am not sure which is the best way to resolve it. Thanks for your help. Regards, Richard ---(end of broadcast)--- TIP 9: In versions below 8

Re: [HACKERS] Shared memory and memory context question

2006-02-05 Thread richard
ed structures. These structures are created by one writer but then read by a number of readers, and later may be removed by the original writer. So, as you can imagine, I could store the forest in the db, although it might be a mess. First I will look through the buffer management system, and see

[HACKERS] v814 + OSX10.4.6 builds OK, but fails launch ...

2006-05-24 Thread Richard
5 known? suggestion? cheers, richard - -- /"\ \ / ASCII Ribbon Campaign X against HTML email, vCards / \ & micro$oft attachments [GPG] OpenMacNews at gmail dot com fingerprint: 50C9 1C46 2F8F DE42 2EDB D460 95F7 DDBD 3671 08C6 -BEGIN PGP SIGNATURE-

Re: [HACKERS] v814 + OSX10.4.6 builds OK, but fails launch ...

2006-05-24 Thread Richard
oblems ... > Is there anything out of the ordinary > about the filesystem or directory path you installed PG on? 'out of the ordinary' ... well, not from my perspective, or from that, apparently, of v813. cheers, richard - -- /"\ \ / ASCII Ribbon Campaign X against HTML ema

Re: [HACKERS] v814 + OSX10.4.6 builds OK, but fails launch ...

2006-05-24 Thread Richard
ey're all similarly configured ... fwiw, v813 is OK on all boxes. > Look at the postmaster -> postgres symlink; > is it where it's supposed to be? seems to be: /usr/local/pgsql/bin > ls -al postmaster lrwxrwx--- 1 root wheel 8 2006-05-24 07:48 postmaster ->

Re: [HACKERS] v814 + OSX10.4.6 builds OK, but fails launch ...

2006-05-24 Thread Richard
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 >> /usr/local/pgsql/bin > ls -al postmaster >> lrwxrwx--- 1 root wheel 8 2006-05-24 07:48 postmaster -> postgres > > Hm, is it significant that that symlink is set for no access by world? hmmm, too. > I don't remember if Darwin enforces a

[HACKERS] CurrentUserId may be invalid during the rest of a session

2017-08-31 Thread Richard Guo
00551d53 in RelnameGetRelid (relname=0x1d3f288 "t1") at namespace.c:673 #6 0x005514a7 in RangeVarGetRelidExtended (relation=0x1d3f2a8, lockmode=1, missing_ok=1 '\001', nowait=0 '\000', callback=0x0, callback_arg=0x0) at namespace.c:326 Is this expected behavior? Thanks -Richard

[HACKERS] patch: add MAP_HUGETLB to mmap() where supported (WIP)

2013-09-13 Thread Richard Poole
d to touch most of the buffers, this patch saves nearly 8MB of memory per backend and improves performances by just over 2% on average. It is still WIP as there are a couple of points that Andres has pointed out to me that haven't been addressed yet; also, the documentation is incomplete. Richa

[HACKERS] stray SIGALRM

2013-06-14 Thread Richard Poole
us what's a good way to fix it without losing the benefits of that commit. Thanks Alvaro and Andres for helping me get from "why is my copy getting these signals" to understanding what's actually going on. Richard -- Richard Poole http://www.2ndQuadrant.c

Re: [HACKERS] Hypothetical Indexes - PostgreSQL extension - PGCON 2010

2010-12-03 Thread Richard Huxton
od for indexing hypothetical data ;-) -- Richard Huxton Archonet Ltd -- 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] "writable CTEs"

2010-12-22 Thread Richard Broersma
On Wed, Dec 22, 2010 at 10:44 AM, Marko Tiikkaja wrote: > I'd prefer something short but easily understandable, but those two might be > mutually exclusive. Volatile CTE's doesn't add any more clarity either. Maybe "Round Trip Reduction" CTE's. :) -- Regards

[HACKERS] Seeking Mentors for Funded Reviewers

2011-01-24 Thread Richard Broersma
posted to Hackers. Would anyone be available to assist with this? Thoughts? -- Regards, Richard Broersma Jr. -- 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] Seeking Mentors for Funded Reviewers

2011-01-24 Thread Richard Broersma
On Mon, Jan 24, 2011 at 5:53 PM, Josh Berkus wrote: > On 1/24/11 12:17 PM, Richard Broersma wrote: > > PgUS is preparing to fund a grant for PgUS members to learn and > > participate in the patch review process. We looking for experienced > > reviewers that can assist a

Re: [RRR] [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-25 Thread Richard Broersma
alleviate your concern? -- Regards, Richard Broersma Jr.

Re: [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-25 Thread Richard Broersma
prospective mentors the ablility to spend more time with mentee's. -- Regards, Richard Broersma Jr.

Re: [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-25 Thread Richard Broersma
n a way that will meet the requirements of the 501c. It needs to be a learning experience and there needs to be a well defined criteria of what will be delivered by the person awarded with the grant. -- Regards, Richard Broersma Jr.

Re: [HACKERS] psql \set vs \copy - bug or expected behaviour?

2012-08-17 Thread Richard Huxton
ing Bruce, but I fear this is one itch that'll go unscratched. Rest assured I'm not about to storm off and replace all my installations with MySQL :-) -- Richard Huxton Archonet Ltd -- 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] Avoiding bad prepared-statement plans.

2010-02-09 Thread Richard Huxton
turns out better than the specific plan (due to bad stats or config settings or just planner limitations). The question is (I guess): How many more winners will there be than losers? -- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Avoiding bad prepared-statement plans.

2010-02-09 Thread Richard Huxton
On 09/02/10 14:25, Jeroen Vermeulen wrote: Richard Huxton wrote: = Actual-cost threshold = Also stop using the generic plan if the statement takes a long time to run in practice. Do you mean: 1. Rollback the current query and start again 2. Mark the plan as a bad one and plan again next

Re: [HACKERS] Re: [COMMITTERS] pgsql: Reduce the chatter to the log when starting a standby server.

2010-02-12 Thread Richard Huxton
struck me: 1. Why have a separate recovery.conf file rather than just put the commands inline? We can use the include directive to have them in a separate file if required. 2. Why have a finish.replication file, rather than "SELECT pg_finish_replication()"? -- Richard Huxton Archon

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

2010-02-14 Thread Richard Huxton
; $foo1 = $seq_fn->($seq1); $foo2 = $seq_fn->($seq2); -- Richard Huxton Archonet Ltd -- 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] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

2010-02-15 Thread Richard Huxton
On 15/02/10 10:32, Tim Bunce wrote: On Mon, Feb 15, 2010 at 07:31:14AM +, Richard Huxton wrote: Is there any value in having a two-stage interface? $seq_fn = get_call('nextval(regclass)'); $foo1 = $seq_fn->($seq1); $foo2 = $seq_fn->($seq2);

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

2010-02-16 Thread Richard Huxton
t about what's going on? SEARCHPATH->function() SCHEMA('public')->function2() Or did "SP" mean "Stored Procedure"? On a (kind of) related note, it might be worthwhile to mention search_path in the docs and point out it has the same pros/cons as unix file pa

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

2010-02-16 Thread Richard Huxton
On 16/02/10 17:51, David E. Wheeler wrote: On Feb 16, 2010, at 9:43 AM, Richard Huxton wrote: Perhaps it would be better to be explicit about what's going on? SEARCHPATH->function() SCHEMA('public')->function2() Or did "SP" mean "Stored Procedure"

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

2010-02-18 Thread Richard Huxton
- not sure those carry any extra info. It also treads on the toes of "PG->not_a_function" should such a beast be needed. I like "F->funcname" or "FN->funcname" myself. -- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers mailing list (pgsql-hackers@po

Re: [HACKERS] FW: Unable to install PostgreSQL on Windows Server 2003 SP2

2010-02-24 Thread Richard Huxton
nstall the adminpack etc. over the top of your now working installation. If you didn't find the data directory, create it, grant permissions to "postgres" and then try a full re-install. -- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgr

[HACKERS] Probably badly timed suggestion: pl/perl calling style same as C style

2010-02-24 Thread Richard Huxton
CT; CREATE FUNCTION add_one(integer) RETURNS integer AS 'My::Package', 'add_one' LANGUAGE plperl STRICT; -- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] plperl.on_init - bug or just me?

2010-02-25 Thread Richard Huxton
unction "add_one_e" -- plperlu - TestModule::add_one richardh=# SELECT add_one_u(1); add_one_u --- 2 (1 row) -- Richard Huxton Archonet Ltd -- 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] plperl.on_init - bug or just me?

2010-02-25 Thread Richard Huxton
On 25/02/10 17:10, Andrew Dunstan wrote: Richard Huxton wrote: Presumably "Safe" just clamps down and my sub isn't marked as acceptable. Is this intended, or am I doing something stupid? It's intended (at least by me). Also, please see the recent discussion about load

Re: [HACKERS] Hot Standby query cancellation and Streaming Replication integration

2010-02-26 Thread Richard Huxton
ably meaning we need *another* config setting to prevent excessive bloat on a heavily updated table on the master. -- Richard Huxton Archonet Ltd -- 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] Hot Standby query cancellation and Streaming Replication integration

2010-02-26 Thread Richard Huxton
x27;s hard to do, but that would really be the most robust fix possible. Something like snapshotting a filesystem, so updates continue while you're still looking at a static version. -- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)

Re: [HACKERS] Hot Standby query cancellation and Streaming Replication integration

2010-02-26 Thread Richard Huxton
On 26/02/10 14:45, Heikki Linnakangas wrote: Richard Huxton wrote: On 26/02/10 08:33, Greg Smith wrote: I'm not sure what you might be expecting from the above combination, but what actually happens is that many of the SELECT statements on the table *that isn't even being updated* ar

Re: [HACKERS] Hot Standby query cancellation and Streaming Replication integration

2010-02-26 Thread Richard Huxton
queued WAL before letting new transactions start. Or perhaps it replays any vacuum activity it comes across and then stops. That should sync with #2 assuming the slave doesn't lag the master too much. 5. I've been mixing "defer" and "delay", as do the docs. We should

Re: [HACKERS] SQL command to edit postgresql.conf, with comments

2010-10-12 Thread Richard Broersma
7;t know, maybe this is already possible. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- 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] Domains versus arrays versus typmods

2010-10-20 Thread Richard Huxton
g system rather than a new app I'm pretty sure it would have confused me for a lot longer than it did. -- Richard Huxton Archonet Ltd -- 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] CREATE CONSTRAINT TRIGGER

2010-11-05 Thread Richard Broersma
CONSTRAINT TRIGGER documentation that says the trigger function must explicitly raise an exception to create the notification that the custom constraint was violated. Would this be a good place for it? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.p

[HACKERS] Questions about the internal of fastpath function call

2011-05-08 Thread lee Richard
Hi, I am reading the source code of fastpath to understand the internal of fastpath. I can not understand how does it send result to the client, I hope somebody can help me on this. I see it call it invoke the function in HandleFunctionRequest() -> retval = FunctionCallInvoke(&fcinfo); -> Se

Re: [HACKERS] Questions about the internal of fastpath function call

2011-05-08 Thread lee Richard
the client, and why it call FunctionCall1() again when it want to send the result. Regards Clipper 2011/5/8 Merlin Moncure > On Sun, May 8, 2011 at 8:01 AM, lee Richard > wrote: > > Hi, > > > > I am reading the source code of fastpath to understand the internal of

Re: [HACKERS] Questions about the internal of fastpath function call

2011-05-08 Thread lee Richard
end a vector result from fastpath function call? 2011/5/9 Tom Lane > lee Richard writes: > > I still can not see how it return a single return value to the client, > and > > why it call FunctionCall1() again when it want to send the result. > > pq_endmessage is where the by

Re: [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-26 Thread Richard Broersma
ding the reviewer. The utlimate goal is to add more people to the ranks of reviewers. > Are the mentors restricted to being US members? > The mentors can be anyone. If the possibility exists that PgUS can fund mentors, then prospective mentors will need to be or become members of PgUS. -- Regards, Richard Broersma Jr.

Re: [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-26 Thread Richard Broersma
this effect already taken place among the volunteering patch writers? -- Regards, Richard Broersma Jr.

Re: [RRR] [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-26 Thread Richard Broersma
rning a new skill. And hopefully, such a person might continue to offer support for the project after the initial experience. -- Regards, Richard Broersma Jr.

Re: [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-26 Thread Richard Broersma
er (student). The mentors are part of the educational process. -- Regards, Richard Broersma Jr.

Re: [RRR] [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-26 Thread Richard Broersma
up to do it has some intrinsic > motivation. > > http://www.nytimes.com/2005/05/15/books/chapters/0515-1st-levitt.html > Interesting. -- Regards, Richard Broersma Jr.

Re: [RRR] [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-26 Thread Richard Broersma
ach to community for assistance. In addition, third party organizations should maintain a healthy disconnection from the community. Is this correct? -- Regards, Richard Broersma Jr.

Re: [RRR] [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-26 Thread Richard Broersma
entees should be opaque to the community so as to prevent distraction. There should be no appearance of community endorsement of such programs. -- Regards, Richard Broersma Jr.

Re: [HACKERS] A different approach to extension NO USER DATA feature

2011-02-07 Thread Richard Huxton
configuration-for-extension. It allows the extension to decide whether to load the new config or reject it. It lets you test/demonstrate multiple configurations fairly simply. The "system_data" column scenario can then be a default implementation of read_your_config(). -- Richard Huxton Ar

Re: [HACKERS] Check constraints on non-immutable keys

2010-06-30 Thread Richard Huxton
p can no longer restore the oldest record :-( IMHO The real solution would be something that could strip/rewrite the constraint on restore rather than trying to prevent people being stupid though. People *will* just tag their functions as immutable to get them to work. -- Richard Huxton

Re: [HACKERS] Check constraints on non-immutable keys

2010-06-30 Thread Richard Huxton
On 30/06/10 18:11, Magnus Hagander wrote: On Wed, Jun 30, 2010 at 18:33, Richard Huxton wrote: IMHO The real solution would be something that could strip/rewrite the constraint on restore rather than trying to prevent people being stupid though. People *will* just tag their functions as

Re: [HACKERS] standard_conforming_strings

2010-07-14 Thread Richard Huxton
e alpha testing cycles on it." Should we do this? Patch attached. Any reason not to add a line to the 9.0 docs/release notes saying "WARNING: The PGDG currently plan to change this setting's default in 9.1"? -- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers m

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Richard Huxton
Trying to format the data in the backend is probably just going to frustrate writers of different clients (of which I think we have quite a few now). * These functions could then be back-ported as an admin-pack too for clients/apps that wanted cross-version compatibility for these sorts of th

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Richard Huxton
tgres from the existing psql Arse. It's little details like this that demonstrate why I'm a user and not a hacker :-) -- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [HACKERS] reducing NUMERIC size for 9.1

2010-07-16 Thread Richard Huxton
olumns that get placed after the numeric. If you went from 10 bytes down to 8, that should be visible. -- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] psql \set vs \copy - bug or expected behaviour?

2011-10-21 Thread Richard Huxton
7; COPY (SELECT :x) TO STDOUT; -- Doesn't work \copy (SELECT :x) TO '/tmp/test2.txt' === end script === -- Richard Huxton Archonet Ltd -- 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] Time bug with small years

2011-11-24 Thread Richard Huxton
=# select '1894-01-01'::timestamp with time zone; timestamptz -- 1894-01-01 00:00:00-05:17:32 Floating-point timestamps? Although I thought integer was the default for 9.x - hmm INSTALL says since 8.4 -- Richard Huxton Archonet Ltd -- Sent via pgs

[HACKERS] Escaping ":" in .pgpass - code or docs bug?

2011-12-16 Thread Richard Huxton
" password retrieved from file "/home/richardh/.pgpass" I'm a bit puzzled how it manages without the escaping in the first case. There's a lack of consistency though that either needs documenting or fixing. [1] http://www.postgresql.org/docs/9.1/static/libpq-

Re: [HACKERS] Escaping ":" in .pgpass - code or docs bug?

2011-12-19 Thread Richard Huxton
ms to have noticed before now. -- Richard Huxton Archonet Ltd -- 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] modifying the tbale function

2007-03-19 Thread Richard Huxton
eries-like function): To support this I think we'd need to do something like: create function mygs(int, int) returns setof int language plperl with srfstate as $$ ... $$; Is this not what we do with aggregate functions at present? -- Richard Huxton Ar

Re: [HACKERS] Stats for multi-column indexes

2007-03-20 Thread Richard Huxton
think everyone can agree on. Being able to say that values in different columns are related just gives the planner more information to work with. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Group Commit

2007-03-27 Thread Richard Huxton
end time spent waiting to commit". I don't know how simple it is to measure/estimate the time spent for "# of transactions that finish while an fsync is taking place". -- Richard Huxton Archonet Ltd ---(end of broadcast)---

Re: [PATCHES] [HACKERS] Full page writes improvement, code update

2007-03-30 Thread Richard Huxton
p not pick up a partially-written page? Assuming it's being written to as the backup is in progress. (We are talking about when disk blocks are smaller than PG blocks here, so can't guarantee an atomic write for a PG block?) -- Richard Huxton Archonet Ltd -

Re: [PATCHES] [HACKERS] Full page writes improvement, code update

2007-03-30 Thread Richard Huxton
Simon Riggs wrote: On Fri, 2007-03-30 at 11:27 +0100, Richard Huxton wrote: Is that always true? Could the backup not pick up a partially-written page? Assuming it's being written to as the backup is in progress. (We are talking about when disk blocks are smaller than PG blocks her

Re: [HACKERS] Auto Partitioning

2007-04-06 Thread Richard Troy
d uniqueness, etc, but might also well think of a given attribute as the primary key. Use of constraints in lieu of "primary key" come to mind... 'Course, maybe I missed the point! -smile- 'Nother thought: CYA _can_ have odeous performance costs if over-implemented. It's a

Re: [HACKERS] Can't ri_KeysEqual() consider two nulls as equal?

2007-04-18 Thread Richard Huxton
ot; rather than "equal". -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [HACKERS] Getting parse Error at or near character "and"

2007-05-02 Thread Richard Huxton
friend 4ever wrote: Hi, I am getting the parse error while i try to execute a simple sql query in postgres. This isn't a question for the hackers list. Try the general, or jdbc lists. -- Richard Huxton Archonet Ltd ---(end of broa

Re: [HACKERS] Getting parse Error at or near character "and"

2007-05-02 Thread Richard Huxton
ickest way to find out what the error is would be to provide the *actual* query, not something very much like it. Perhaps turn statement logging on in your postgresql.conf if it isn't already. -- Richard Huxton Archonet Ltd ---(end of broadcast)--

Re: [HACKERS] Behavior of GENERATED columns per SQL2003

2007-05-11 Thread Richard Huxton
ey could play a part in foreign keys that would be useful too. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] Concurrently updating an updatable view

2007-05-14 Thread Richard Huxton
with re-checking clauses involving subqueries or joins I'd guess. I'm trying to decide if it's unexpected or just plain wrong, and I think I'd have to argue wrong. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP

Re: [HACKERS] Concurrently updating an updatable view

2007-05-14 Thread Richard Huxton
Richard Huxton wrote: Heikki Linnakangas wrote: The problem is that the new tuple version is checked only against the condition in the update rule, id=OLD.id, but not the condition in the original update-claus, dt='a'. Yeah, that's confusing :(. Bit more than just normal rul

Re: [HACKERS] Concurrently updating an updatable view

2007-05-14 Thread Richard Huxton
Hiroshi Inoue wrote: Richard Huxton wrote: Heikki Linnakangas wrote: The problem is that the new tuple version is checked only against the condition in the update rule, id=OLD.id, but not the condition in the original update-claus, dt='a'. Yeah, that's confusing :(. Bit

Re: [HACKERS] Concurrently updating an updatable view

2007-05-15 Thread Richard Huxton
x27;m suspicious if UPDATABLE VIEWS can be implemented using the rule system. Remember this affects all self-referential joins on an UPDATE (and DELETE?) not just views. It's just that a rule is more likely to produce that type of query. -- Richard Huxton Ar

Re: [HACKERS] Not ready for 8.3

2007-05-16 Thread Richard Huxton
don't claim to have looked at it in detail it seems to pretty much do what it claims to. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [HACKERS] Not ready for 8.3

2007-05-16 Thread Richard Huxton
Dave Page wrote: Richard Huxton wrote: Magnus Hagander wrote: It's been on my list to rewrite the whole archive system for a while for various reasons. There is quite a bit of crossover with the patch tracker I proposed so I was hoping to look at both together. Let me know when you sta

Re: [HACKERS] Role members

2007-05-21 Thread Richard Huxton
want to decide how to handle the "inherits" flag. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Role members

2007-05-21 Thread Richard Huxton
he current role a member of role X rather than list all the roles that are members of X. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Do we need a TODO? (was Re: [HACKERS] Concurrently updating an updatable view)

2007-05-22 Thread Richard Huxton
self-referential updates" Hiroshi originally noted the problem in one of his views here: http://archives.postgresql.org/pgsql-hackers/2007-05/msg00507.php -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 9: In versions belo

Re: [HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-23 Thread Richard Huxton
( pg_cancel_backend() ). For the rest, that's what ssh is for imho. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-23 Thread Richard Huxton
Zdenek Kotala wrote: Richard Huxton wrote: For the rest, that's what ssh is for imho. And what you will do when you don't have ssh access on this machine and 5432 is only one way how to administrate a server? (Windows is another story.) If I've not got ssh access to the ma

Re: [HACKERS] exit

2007-05-29 Thread Richard Huxton
Marcos Fabrício Corso wrote: I would like to leave the list ... Not really a question worth posting several lists. If you don't know how to unsubscribe, try starting with the form linked from here. http://www.postgresql.org/community/lists/ -- Richard Huxton Archone

Re: [HACKERS] timestamp datatyp problem

2007-05-31 Thread Richard Huxton
1BC and 1AD). Presumably this can only happen if using floating-point datetimes and not 64-bit integers? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] libpq and Binary Data Formats

2007-06-04 Thread Richard Huxton
binary data types in libpq. Um - speaking as a user, not a developer, I don't actually see a description of what problem(s) you are suggesting be solved. Are you saying there should be better documentation, or a new format? -- Richard Huxton Archonet Ltd ---(e

Re: [HACKERS] libpq and Binary Data Formats

2007-06-05 Thread Richard Huxton
re in making changes. However, I've seen a lot of changes come and go and I think you'll need to make progress on those 4 points to get anywhere. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [HACKERS] Worries about delayed-commit semantics

2007-06-22 Thread Richard Huxton
er possibility: "synchronous_commit = off" Ooo, I like that. Any other takers? I like "synchronous_commit = off", it even has a little girlfriend getting spin while being accurate :) Or perhaps "sync_on_commit = off"? Less girlfriend-spe

Re: [HACKERS] Worries about delayed-commit semantics

2007-06-22 Thread Richard Huxton
thing else?)* It's obvious to people on the -hackers list what we're talking about, but is it so clear to a newbie, perhaps non-English speaker? * I can see people thinking this means something like "commit_delay". -- Richard Huxton Archonet Ltd --

Re: [HACKERS] Proposal: In-Place upgrade concept

2007-07-03 Thread Richard Huxton
auditing what features are in use (or have changed between versions). Or are these examples of changes that will only be allowed e.g. every other major version. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: Have you checked our

  1   2   3   4   5   >