What query, exactly? Which PG version is this?
regards, tom lane
Its a query involving 15 relations, processing not more than 500 records. The
query is written in a .sql file and the file is executed as
\i initq.sql
Infact, know no .sql file is getting executed. All my .sqls
Sorry for resending, it got stalled.
Have subscribed to pgsql-general now.
What query, exactly? Which PG version is this?
regards, tom lane
Its a query involving 15 relations, processing not more than 500 records. The
query is written in a .sql file and the file is executed as
SIGSEGV in micro$oft world.
Thanks for your response.
How can this be resolved?
Regards
Swati
Hi,
I am getting the following error while processing a query.
server process PID 2236 was terminated by exception xc005
Please help me resolve this.
Regards
Swati
Hi,
I have a query with 20 relations, the GEQO is used to solve this query.
When the value of
pool-data[i].worth
was displayed, from random_init_pool() [geqo_pool.c], exactly the same value
was obtained for all individuals.
Also when the value of pool-data[i].worth was printed from
Hi,
I have a few queries on the use of the geqo.
1. Since the value of geqo_threshold is12, does the geqo get automatically
activated for queries with 12 or more joins?
2. Can the geqo threshold be set to a smaller value like 4 or 5?
3. How do we come to know whether the geqo has been used to
Thanks Andres, 1. Since the value of geqo_threshold is 12, does the geqo get
automatically
activated for queries with 12 or more joins?
No, not directly. It will get used for 12 joins with no predefined order.
This is a bit complicated by the fact that even a predefined order like:
a JOIN b
Hi,
I built and installed Postgresql 8.4.0 from source using Visual Studio 2005 on
Windows XP.
All build and installation steps executed successfully as mentioned in the
Postgresql Documentation, but server could not be started.
Given below is the detail of the problem I am facing.
From user
Hi,
Thank you all for your kind responses.
Things however aren't falling in place.
Will take a short break, rework, and get back.
Probably, with a new problem!
Thanks again,
Regards
Swati
Hi
When I write the following commands at the prompt,
createuser -S -d -R user1
createdb sample
I am asked to enter a password. I have not set any password anywhere. Which
password is it asking for?
Please help.
I have built from source on Windows XP.
Thanks is advance,
Regards
Swati
ah ok ..
Actually it should work if you set listen_addresses to '*' in postgresql.conf.
Did you change anything else in postgresql.conf or pg_hba.conf?
I am not too experienced with Windows so maybe someone with more knowledge is
able to find the trick (I installed 8.4 once with the one click
Yes,
Its the currently logged on user.
--- On Wed, 7/8/09, Andreas Wenk a.w...@netzmeister-st-pauli.de wrote:
From: Andreas Wenk a.w...@netzmeister-st-pauli.de
Subject: [Re: [GENERAL] Password?]
To: PG-General Mailing List pgsql-general@postgresql.org
Date: Wednesday, July 8, 2009, 3:54 PM
I think I can understand what you both have discussed.
But I am unable to unearth my mistake.
Regards
Swati
--- On Wed, 7/8/09, Andreas Wenk a.w...@netzmeister-st-pauli.de wrote:
From: Andreas Wenk a.w...@netzmeister-st-pauli.de
Subject: Re: [GENERAL] [Re: Password?]
To: Steve Atkins
Hi,
I started everything again from scratch.
1. Created a new user(Swati), with limited/ restricted rights.
Ensured that no password is set anywhere.
2. Ran initdb from the new user.
c:\postgresql\bininitdb -D c:\postgresql\data2
It displayed the DEBUG: start
Hi,
You may obtain the required files from:
http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/
for MS-VC++, by Hiroshi Saito
Copy uuid.h and uuid.lib from here to appropriate folders and it should work.
Swati Chande
15 matches
Mail list logo