[HACKERS] How to make the user-defined function or type being accessed in the global database server?

2011-02-20 Thread 页公倒龙
Hello, I had defined user-defined function and type in database A by using user Root.when i want to access the function and type in another database B by using the same user Root, but found that i could't access them. How to make the user-defined function or type being accessed in the global

Re: [HACKERS] How to make the user-defined function or type being accessed in the global database server?

2011-02-20 Thread Heikki Linnakangas
On 20.02.2011 08:03, wrote: Hello, I had defined user-defined function and type in database A by using user Root.when i want to access the function and type in another database B by using the same user Root, but found that i could't access them. How to make the user-defined function

[HACKERS] Void binary patch

2011-02-20 Thread Radosław Smogura
Just patch for missing procedures for void send/recv Regards, Radek diff --git a/src/backend/utils/adt/pseudotypes.c b/src/backend/utils/adt/pseudotypes.c index d9329f8..614eb98 100644 --- a/src/backend/utils/adt/pseudotypes.c +++ b/src/backend/utils/adt/pseudotypes.c @@ -212,7 +212,20 @@

Re: [HACKERS] using a lot of maintenance_work_mem

2011-02-20 Thread Devrim GÜNDÜZ
On Wed, 2011-02-16 at 23:24 +0200, Peter Eisentraut wrote: But before expending time on that, I'd want to see some evidence that it's actually helpful for production situations. I'm a bit dubious that you're going to gain much here. If you want to build an index on a 500GB table and

[HACKERS] Cannot *start* server because of a typo in pg_hba.conf

2011-02-20 Thread Devrim GÜNDÜZ
Yesterday I spent about half an hour to dig an issue on my laptop -- 9.0 instance did not start, and there were nothing in the logs. Eventually I straced postmaster on start, and noticed an extra char in the pg_hba.conf, which caused postmaster not to start. Is it possible to drop something to

Re: [HACKERS] Sync Rep v17

2011-02-20 Thread Florian Pflug
On Feb20, 2011, at 08:12 , Jaime Casanova wrote: considering that synchronous_replication to on means that we *want* durability, and that synchronous_commit to off means we don't *care* about durability. Then the real question here is: in the presence of synchronous_replication to on (which

Re: [HACKERS] Update PostgreSQL shared memory usage table for 9.0?

2011-02-20 Thread Kevin Grittner
Bruce Momjian wrote: This documentation This page was missed in the SSI documentation update. I don't want to get distracted by it today, but we'll need to get this done for 9.1. I guess I need to grep the sgml files for other mentions of max_locks_per_transaction for other possible

Re: [HACKERS] using a lot of maintenance_work_mem

2011-02-20 Thread Bruce Momjian
Devrim G?ND?Z wrote: On Wed, 2011-02-16 at 23:24 +0200, Peter Eisentraut wrote: But before expending time on that, I'd want to see some evidence that it's actually helpful for production situations. I'm a bit dubious that you're going to gain much here. If you want to build an

Re: [HACKERS] work_mem / maintenance_work_mem maximums

2011-02-20 Thread Bruce Momjian
Josh Berkus wrote: Is this a TODO? Can we easily fix the tuplesort.c code? Easily, no. But that's not a reason for it to not be a TODO. I, too, would like to be able to make use of 32GB of work_mem effectively. [ repost to the right thread.] Well, I figure it will be hard to allow

Re: [HACKERS] using a lot of maintenance_work_mem

2011-02-20 Thread Bernd Helmle
--On 20. Februar 2011 09:32:02 -0500 Bruce Momjian br...@momjian.us wrote: Well, I figure it will be hard to allow larger maximums, but can we make the GUC variable maximums be more realistic? Right now it is MAX_KILOBYTES (INT_MAX). This is something i proposed some time ago, too. At

Re: [HACKERS] using a lot of maintenance_work_mem

2011-02-20 Thread Bernd Helmle
--On 20. Februar 2011 15:48:06 +0100 Bernd Helmle maili...@oopsware.de wrote: Well, I figure it will be hard to allow larger maximums, but can we make the GUC variable maximums be more realistic? Right now it is MAX_KILOBYTES (INT_MAX). This is something i proposed some time ago, too. At

Re: [HACKERS] using a lot of maintenance_work_mem

2011-02-20 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Well, I figure it will be hard to allow larger maximums, but can we make the GUC variable maximums be more realistic? Right now it is MAX_KILOBYTES (INT_MAX). You seem to be confusing one limitation in one code path with the overall meaning of

Re: [HACKERS] Update PostgreSQL shared memory usage table for 9.0?

2011-02-20 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Bruce Momjian wrote: Can someone update the PostgreSQL shared memory usage table for 9.0? http://www.postgresql.org/docs/9.0/static/kernel-resources.html#SYSVIPC Right now it says Approximate shared memory bytes required (as of 8.3). This

Re: [HACKERS] Cannot *start* server because of a typo in pg_hba.conf

2011-02-20 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= dev...@gunduz.org writes: Yesterday I spent about half an hour to dig an issue on my laptop -- 9.0 instance did not start, and there were nothing in the logs. Eventually I straced postmaster on start, and noticed an extra char in the pg_hba.conf, which caused

Re: [HACKERS] SR standby hangs

2011-02-20 Thread Greg Stark
On Fri, Feb 18, 2011 at 6:59 PM, Andrew Dunstan amduns...@nc.rr.com wrote: The server is running as a warm standby, and the client's application tries to connect to both the master and the slave, accepting whichever lets it connect (hence hot standby is not turned on). ...   #2  

Re: [HACKERS] Cannot *start* server because of a typo in pg_hba.conf

2011-02-20 Thread Devrim GÜNDÜZ
On Sun, 2011-02-20 at 10:39 -0500, Tom Lane wrote: Is it possible to drop something to (startup) log file and mention about the syntax error in hba file? That information would certainly be logged somewhere. Maybe you looked in the wrong log file? Or you're using one of those

Re: [HACKERS] Cannot *start* server because of a typo in pg_hba.conf

2011-02-20 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= dev...@gunduz.org writes: On Sun, 2011-02-20 at 10:39 -0500, Tom Lane wrote: That information would certainly be logged somewhere. Maybe you looked in the wrong log file? Or you're using one of those configurations where early output to stderr goes to

Re: [HACKERS] Cannot *start* server because of a typo in pg_hba.conf

2011-02-20 Thread Devrim GÜNDÜZ
On Sun, 2011-02-20 at 12:45 -0500, Tom Lane wrote: None of them logged anything to anywhere. You can reproduce it on your machine, too. No, I can't. I get something like this on stderr: LOG: invalid connection type zlocal Err, please try putting an extra char before the first

Re: [HACKERS] Cannot *start* server because of a typo in pg_hba.conf

2011-02-20 Thread Thom Brown
2011/2/20 Devrim GÜNDÜZ dev...@gunduz.org: On Sun, 2011-02-20 at 12:45 -0500, Tom Lane wrote: None of them logged anything to anywhere. You can reproduce it on your machine, too. No, I can't.  I get something like this on stderr: LOG:  invalid connection type zlocal Err, please try

Re: [HACKERS] Cannot *start* server because of a typo in pg_hba.conf

2011-02-20 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= dev...@gunduz.org writes: On Sun, 2011-02-20 at 12:45 -0500, Tom Lane wrote: No, I can't. I get something like this on stderr: LOG: invalid connection type zlocal Err, please try putting an extra char before the first comment line, like: w#

Re: [HACKERS] SQL/MED - file_fdw

2011-02-20 Thread Tom Lane
Shigeru HANADA han...@metrosystems.co.jp writes: [ 20110218-file_fdw.patch ] I've adjusted this to fit the extensions infrastructure and the committed version of the FDW API patch, and applied it. * You might forget some combination or unspecified options in file_fdw_validator(). For

Re: [HACKERS] Fix for fuzzystrmatch

2011-02-20 Thread Tom Lane
Alexander Korotkov aekorot...@gmail.com writes: Hacker, I found two issues in fuzzystrmatch contrib. 1) Incorrect s_data shift in levenshtein calculation with threshold with multibyte characters. i index was used instead of start_column. 2) Missing dependency of fuzzystrmatch.o on

Re: [HACKERS] pg_basebackup and wal streaming

2011-02-20 Thread Dimitri Fontaine
Hi, Magnus Hagander mag...@hagander.net writes: Better late than never (or?), here's the final cleanup of pg_streamrecv for moving into the main distribution, per discussion back in late dec or early jan. It also includes the stream logs in parallel to backup part that was not completed on

Re: [HACKERS] using a lot of maintenance_work_mem

2011-02-20 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Tom Lane wrote: You seem to be confusing one limitation in one code path with the overall meaning of maintenance_work_mem. Oh, OK, so sorts are limited, but not hash sizes? Are there any other uses? Should this be documented somehow? What is the

Re: [HACKERS] review: FDW API

2011-02-20 Thread Tom Lane
I wrote: Robert Haas robertmh...@gmail.com writes: On Fri, Feb 18, 2011 at 10:47 AM, Tom Lane t...@sss.pgh.pa.us wrote: The main downside of that is that relation relkinds would have to become fixed (because there would be no practical way of updating RTEs in stored rules), which means the

Re: [HACKERS] Sync Rep v17

2011-02-20 Thread Jaime Casanova
On Sun, Feb 20, 2011 at 7:20 AM, Florian Pflug f...@phlo.org wrote: On Feb20, 2011, at 08:12 , Jaime Casanova wrote: considering that synchronous_replication to on means that we *want* durability, and that synchronous_commit to off means we don't *care* about durability. Then the real question

Re: [HACKERS] using a lot of maintenance_work_mem

2011-02-20 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Well, I figure it will be hard to allow larger maximums, but can we make the GUC variable maximums be more realistic? Right now it is MAX_KILOBYTES (INT_MAX). You seem to be confusing one limitation in one code path with the

Re: [HACKERS] Sync Rep v17

2011-02-20 Thread Florian Pflug
On Feb21, 2011, at 00:09 , Jaime Casanova wrote: On Sun, Feb 20, 2011 at 7:20 AM, Florian Pflug f...@phlo.org wrote: On Feb20, 2011, at 08:12 , Jaime Casanova wrote: considering that synchronous_replication to on means that we *want* durability, and that synchronous_commit to off means we

Re: [HACKERS] SSI bug?

2011-02-20 Thread Kevin Grittner
Kevin Grittner wrote: I'm proceeding on this basis. Result attached. I found myself passing around the tuple xmin value just about everywhere that the predicate lock target tag was being passed, so it finally dawned on me that this logically belonged as part of the target tag. That simplified

[HACKERS] contrib/unaccent regression test failed

2011-02-20 Thread Itagaki Takahiro
I found make installcheck for contrib/unaccent in master is failed on my machine, The regressions.diffs attached. I'm not sure the reason because BuildFarm machines are all OK, but we might need some checks in addition to database encoding. * OS: Linux 2.6.35.10-74.fc14.x86_64 #1 SMP Thu Dec 23

Re: [HACKERS] Update PostgreSQL shared memory usage table for 9.0?

2011-02-20 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Bruce Momjian wrote: Can someone update the PostgreSQL shared memory usage table for 9.0? http://www.postgresql.org/docs/9.0/static/kernel-resources.html#SYSVIPC Right now it says Approximate shared memory bytes required (as of

Re: [HACKERS] Void binary patch

2011-02-20 Thread David Fetter
On Sun, Feb 20, 2011 at 11:20:22AM +0100, Radosław Smogura wrote: Just patch for missing procedures for void send/recv Regards, Radek Thanks! :) Style note: the project doesn't use // as a comment-to-end-of-line in C because some supported compilers don't understand it. Cheers, David. --

Re: [HACKERS] using a lot of maintenance_work_mem

2011-02-20 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Tom Lane wrote: You seem to be confusing one limitation in one code path with the overall meaning of maintenance_work_mem. Oh, OK, so sorts are limited, but not hash sizes? Are there any other uses? Should this be documented

Re: [HACKERS] COPY ENCODING revisited

2011-02-20 Thread Itagaki Takahiro
On Fri, Feb 18, 2011 at 20:12, Itagaki Takahiro itagaki.takah...@gmail.com wrote: + extern char *pg_any_to_server(const char *s, int len, int encoding); + extern char *pg_server_to_any(const char *s, int len, int encoding); I applied the version with additional codes for file_fdw. -- Itagaki