Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-15 Thread Hiroshi Saito
Hi Ahhh, This problem is reproduced. :-( Sorry, I neglect it. Then, the following is considered as management. http://winpg.jp/~saito/pg_work/OSSP_win32/getrand.c I will consult to Ralf-san tonight. or weekend... Regards, Hiroshi Saito - Original Message - From: Tom Lane [EMAIL

[BUGS] problem in installing pgsql-8.3.1

2008-05-15 Thread shohorab hossain
Dear sir/madam, This is to inform you that I am an oracle database user/administrator. But I am going to join in a company where I have to administrate postgresql database. I am new to this database system.  For few days I am trying to install postgresql-8.3.1 in RHEL4. My machine

[BUGS] BUG #4169: Problem in installing

2008-05-15 Thread shohorab hossain
The following bug has been logged online: Bug reference: 4169 Logged by: shohorab hossain Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: RHEL4 Description:Problem in installing Details: For few days I am trying to install

[BUGS] problem in installing pgsql-8.3.1

2008-05-15 Thread shohorab hossain
Dear sir/madam, This is to inform you that I am an oracle database user/administrator. But I am going to join in a company where I have to administrate postgresql database. I am new to this database system.  For few days I am trying to install postgresql-8.3.1 in RHEL4. My machine

[BUGS] BUG #4172: postgres stops working after restart

2008-05-15 Thread alex
The following bug has been logged online: Bug reference: 4172 Logged by: alex Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: windows xp Description:postgres stops working after restart Details: I installed 8.3.1 fine and the service

Re: [BUGS] BUG #4169: Problem in installing

2008-05-15 Thread Tom Lane
shohorab hossain [EMAIL PROTECTED] writes: I am facing the problem during the building step of source. The problem is that when I start building with gmake command, it continuously shows messages in console like ‘checking for …………. yes / no’ and I have waited approximately for 3

[BUGS] problem in installing pgsql-8.3.1

2008-05-15 Thread shohorab hossain
Dear sir/madam, This is to inform you that I am an oracle database user/administrator. But I am going to join in a company where I have to administrate postgresql database. I am new to this database system.  For few days I am trying to install postgresql-8.3.1 in RHEL4. My machine

Re: [BUGS] problem in installing pgsql-8.3.1

2008-05-15 Thread John R Pierce
shohorab hossain wrote: Dear sir/madam, This is to inform you that I am an oracle database user/administrator. But I am going to join in a company where I have to administrate postgresql database. I am new to this database system. For few days I am trying to install postgresql-8.3.1 in

Re: [BUGS] BUG #4172: postgres stops working after restart

2008-05-15 Thread Heikki Linnakangas
alex wrote: The following bug has been logged online: Bug reference: 4172 Logged by: alex Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: windows xp Description:postgres stops working after restart Details: I installed 8.3.1 fine and

Re: [BUGS] BUG #4172: postgres stops working after restart

2008-05-15 Thread John R Pierce
Heikki Linnakangas wrote: The log folder doesn't show any error problems. When I run the psql.exe on the command line i get: psql: could not connect to server: Connection refused (0x274D/10061) Is the server running on host ??? and accepting TCP/IP connections on port

Re: [BUGS] BUG #4170: Rows estimation which are cast from TEXT is inaccurate.

2008-05-15 Thread Tom Lane
Tashuhito Kasahara [EMAIL PROTECTED] writes: test=# EXPLAIN SELECT * FROM test WHERE t '2008-05-14 23:55:00'::text::timestamp; QUERY PLAN Seq Scan on test (cost=0.00..2209.00

[BUGS] BUG #4173: Illogical error message with aggregates + order by

2008-05-15 Thread Chris West (Faux)
The following bug has been logged online: Bug reference: 4173 Logged by: Chris West (Faux) Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: linux (debian lenny) Description:Illogical error message with aggregates + order by Details: --

[BUGS] mingw compile error

2008-05-15 Thread Bob Rossi
Hi, I noticed that if I build postgresql-8.3.1 on mingw with --disable-shared --without-zlib, I get a compiler error when it goes to build the regress test in src/test/regress. The problem is here, $(NAME)$(DLSUFFIX): $(shlib) rm -f $(NAME)$(DLSUFFIX) $(LN_S) $(shlib)

Re: [BUGS] [ADMIN] problem in installing pgsql-8.3.1

2008-05-15 Thread Devrim GÜNDÜZ
Hi, On Thu, 2008-05-15 at 04:21 -0700, shohorab hossain wrote: For few days I am trying to install postgresql-8.3.1 in RHEL4. My machine configuration is Intel Pentium IV. I have followed the installation document of postgresql that was included with source distribution. I am facing the

Re: [BUGS] BUG #4173: Illogical error message with aggregates + order by

2008-05-15 Thread Tom Lane
Chris West (Faux) [EMAIL PROTECTED] writes: Consider the following SQL: select count(bar) from foo order by bar; For this input, both postgresql-8.2* and -8.3.* output: ERROR: column foo.bar must appear in the GROUP BY clause or be used in an aggregate function It's complaining about

Re: [BUGS] mingw compile error

2008-05-15 Thread Tom Lane
Bob Rossi [EMAIL PROTECTED] writes: I noticed that if I build postgresql-8.3.1 on mingw with --disable-shared --without-zlib, I get a compiler error when it goes to build the regress test in src/test/regress. That's the least of your problems --- the regression tests wouldn't work anyway,

Re: [BUGS] [ADMIN] problem in installing pgsql-8.3.1

2008-05-15 Thread John R Pierce
Devrim GÜNDÜZ wrote: Hi, On Thu, 2008-05-15 at 04:21 -0700, shohorab hossain wrote: For few days I am trying to install postgresql-8.3.1 in RHEL4. My machine configuration is Intel Pentium IV. I have followed the installation document of postgresql that was included with source

Re: [BUGS] BUG #4173: Illogical error message with aggregates + order by

2008-05-15 Thread Faux
On Thu, 15 May 2008 17:34:11 +0100, Tom Lane [EMAIL PROTECTED] wrote: It's complaining about the occurrence of bar in ORDER BY, which is not within an aggregate function. I'm not sure that we can do much with the wording of the message. What would be more helpful here is a syntax error

Re: [BUGS] mingw compile error

2008-05-15 Thread Bob Rossi
On Thu, May 15, 2008 at 12:37:42PM -0400, Tom Lane wrote: Bob Rossi [EMAIL PROTECTED] writes: I noticed that if I build postgresql-8.3.1 on mingw with --disable-shared --without-zlib, I get a compiler error when it goes to build the regress test in src/test/regress. That's the least of

Re: [BUGS] BUG #4169: Problem in installing

2008-05-15 Thread shohorab hossain
You are genius boss. Problem solved.   Thank you very much. - Original Message From: Tom Lane [EMAIL PROTECTED] To: shohorab hossain [EMAIL PROTECTED] Cc: pgsql-bugs@postgresql.org Sent: Thursday, May 15, 2008 20:26:48 Subject: Re: [BUGS] BUG #4169: Problem in installing shohorab

Re: [BUGS] [DOCS] problem in installing pgsql-8.3.1

2008-05-15 Thread shohorab hossain
Problem is solved. Problem was in my system clock setting. Make get into a loop like this when the source files all appeared to have timestamps in the future.   Thank you all very much.     With regards: Shohorab Hossain - Original Message From: shohorab hossain [EMAIL PROTECTED] To: