Re: [GENERAL] tsearch CVS and differences to version for 7.3.x

2003-09-07 Thread Nigel J. Andrews
On Sun, 7 Sep 2003, Tom Lane wrote: > "Nigel J. Andrews" <[EMAIL PROTECTED]> writes: > > One thing that started worrying me having found what looks like a bug in > > to_tsquery_name from the 7.3-stable version of tsearch v2 is the question of > > bug fixes applied only to the latest [HEAD presumab

Re: [GENERAL] default EXECUTE privilege

2003-09-07 Thread Sergey Suleymanov
> Tom Lane writes: Tom> We decided that was the most useful default. Well, not too useful when "SECURITY DEFINER" is used. Anyway thank you for explanation. -- Sergey Suleymanov ---(end of broadcast)--- TIP 6: Have you searched

Re: [GENERAL] why does count take so long?

2003-09-07 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > Joseph Shraibman <[EMAIL PROTECTED]> wrote: >> It looks like the aggregate took 10 secs all by itself. What's taking >> so long? > It looks like there are 8 million log records that need to be counted. Yeah, but I think he's complaining about the

Re: [GENERAL] Unix domain instead of TCP socket connections with JDBC.

2003-09-07 Thread Tom Lane
[EMAIL PROTECTED] (Alex Martinoff) writes: > ... Using a TCP socket > instead of a unix socket seems to slow down requests that return large > result sets by a factor of 3 on the same machine. Seems like a kernel bug to me. All modern TCP stacks have shortcuts for local connections. What platfo

Re: [GENERAL] Cannot createdb

2003-09-07 Thread mathan
> Hi there I'm Dr. Azmir from Kuala Lumpur. > I'm using RH 9.0 with postgresql intalled in it. > My problem is I can't createuser and createdb with it. > The error message "psql: FATAL: user "name" does not exist > createdb: database creation failed" You should cre

Re: [GENERAL] Cannot createdb

2003-09-07 Thread Andrew L. Gould
On Sunday 07 September 2003 05:59 am, Dr. Azmir wrote: > Hi there I'm Dr. Azmir from Kuala Lumpur. > I'm using RH 9.0 with postgresql intalled in it. > My problem is I can't createuser and createdb with it. > The error message "psql: FATAL: user "name" does not exist >

[GENERAL] Cannot createdb

2003-09-07 Thread Dr. Azmir
Hi there I'm Dr. Azmir from Kuala Lumpur. I'm using RH 9.0 with postgresql intalled in it. My problem is I can't createuser and createdb with it. The error message "psql: FATAL: user "name" does not exist createdb: database creation failed" will pop up. Why? Kindly

[GENERAL] Inquiry From Form [pgsql]

2003-09-07 Thread Azkia H.Syed
Scenario: I want to modify the PostgreSQL source code to customize per customer requirements, add new features and then package PostgreSQL with my own developed application. Then I want to sell/lease that sw/hw package to customer. I will only sell/lease software binaries to the customer and not

[GENERAL] Unix domain instead of TCP socket connections with JDBC.

2003-09-07 Thread Alex Martinoff
Using the org.postgresql.Driver JDBC driver is it possible to connect to Postgres using a unix domain socket instead of a TCP socket (so you don't have to start the postmaster with -i)? Using a TCP socket instead of a unix socket seems to slow down requests that return large result sets by a factor

[GENERAL] 7.4 binary version

2003-09-07 Thread Relaxin
Is there a binary version of 7.4 that I can run under cgywin? ---(end of broadcast)--- TIP 8: explain analyze is your friend