Re: [HACKERS] proposal: generic function, constructor function

2008-01-19 Thread Pavel Stehule
On 19/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote: > "Pavel Stehule" <[EMAIL PROTECTED]> writes: > > But I am not able create function with > > ANY params. Is it possible do it via CREATE FUNCTION .. ? > > It's a reserved word :-(. Try "any" > > regards, tom lane > I did

Re: [HACKERS] proposal: generic function, constructor function

2008-01-19 Thread Oleg Bartunov
On Sat, 19 Jan 2008, Pavel Stehule wrote: On 19/01/2008, Tom Lane <[EMAIL PROTECTED]> wrote: "Pavel Stehule" <[EMAIL PROTECTED]> writes: But I am not able create function with ANY params. Is it possible do it via CREATE FUNCTION .. ? It's a reserved word :-(. Try "any"

Re: [HACKERS] proposal: generic function, constructor function

2008-01-19 Thread Pavel Stehule
> > do you have any sample, please, > > Tom said, try "any". Don't forget about double quotes > I am blind thank you Pavel ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postg

[HACKERS] SHM_HUGETLB on Linux 2.6.

2008-01-19 Thread Kurt Roeckx
Hi, Has anyone tried to use the huge tlb support of the Linux 2.6 kernel? If you compile the kernel with support for it (CONFIG_HUGETLBFS), you can call shmget() with a SHM_HUGETLB parameter so that it will use larger pages. Has anyone tried to use it? Is it worth trying to set it up? Kurt -

[HACKERS] sun to buy mysql

2008-01-19 Thread ohp
Hi all, I'm surprised no one mentioned here that Sun was ready to buy Mysql for $1 billion. Could it change something for postresql? if yes, what? Best regards, -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 15, Chemin des Monges+33-5-61-50-97-01 (Fax) 31190 AU

Re: [HACKERS] Recent pg_regress changes break testing under SELinux

2008-01-19 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander <[EMAIL PROTECTED]> writes: Yeah, agreed. The original idea was to have a shortcut created by the installer to do that for you. ... Well, there is a way to run it from the msvc build. The idea was to be able to run after a binary install. Granted it doesn't make

Re: [HACKERS] sun to buy mysql

2008-01-19 Thread Jonah H. Harris
On Jan 19, 2008 10:01 AM, <[EMAIL PROTECTED]> wrote: > I'm surprised no one mentioned here that Sun was ready to buy Mysql for $1 > billion. > Could it change something for postresql? if yes, what? Nobody mentioned it here, because this is the hackers list. It is mentioned in-depth on -advocacy.

[HACKERS] message string fixes

2008-01-19 Thread Alvaro Herrera
Hi, While translating the backend's message catalog I found several things that should probably be improved. For example, in regis.c there are several strings talking about "regis pattern". I had never heard of regis patterns. Turns out they are a fast regex subset, used AFAICT only by the ispe

Re: [HACKERS] [pgtranslation-translators] message string fixes

2008-01-19 Thread Alvaro Herrera
Further fix attached. I think "of character type" suggests that the column must be of type char, which is not the case -- varchar and text work fine too AFAICS. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development,

[HACKERS] [PATCH] Add size/acl information when listing databases

2008-01-19 Thread Andrew Gilligan
Greetings, Attached is a rather small change to src/bin/psql/describe.c to show database size and permissions when using the psql \l command. Typical output would be: List of databases Name| Owner | Encoding | Size | Access privileges -

Re: [HACKERS] [PATCH] Add size/acl information when listing databases

2008-01-19 Thread Tom Lane
Andrew Gilligan <[EMAIL PROTECTED]> writes: > Attached is a rather small change to src/bin/psql/describe.c to > show database size and permissions when using the psql \l command. Doesn't this slow down \l by several orders of magnitude? There's also the small problem that the query will fail enti

Re: [HACKERS] message string fixes

2008-01-19 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > For example, in regis.c there are several strings talking about "regis > pattern". I had never heard of regis patterns. Turns out they are a > fast regex subset, used AFAICT only by the ispell code. Searching the > web I don't find any other reference

Re: [HACKERS] [PATCH] Add size/acl information when listing databases

2008-01-19 Thread Andrew Gilligan
On 20 Jan 2008, at 02:06, Tom Lane wrote: Andrew Gilligan <[EMAIL PROTECTED]> writes: Attached is a rather small change to src/bin/psql/describe.c to show database size and permissions when using the psql \l command. Doesn't this slow down \l by several orders of magnitude? There's also the

Re: [HACKERS] [PATCH] Add size/acl information when listing databases

2008-01-19 Thread Tom Lane
Andrew Gilligan <[EMAIL PROTECTED]> writes: > Showing the size on \l+ probably makes more sense, but I imagine that > would require a very different approach due to the permissions changes? I haven't experimented, but perhaps something along the lines of case when has_database_privilege(c

Re: [HACKERS] [PATCH] Add size/acl information when listing databases

2008-01-19 Thread Andrew Gilligan
On 20 Jan 2008, at 04:34, Tom Lane wrote: Andrew Gilligan <[EMAIL PROTECTED]> writes: Showing the size on \l+ probably makes more sense, but I imagine that would require a very different approach due to the permissions changes? I haven't experimented, but perhaps something along the lines o