Re: [BUGS] hstore: null value is treated as empty string by avals function

On Mon, Sep 27, 2010 at 2:36 PM, Alexey Bashtanov wrote: > hstore: null value is treated as empty string by avals function > > # select avals('gfds'=>null) = array[null], avals('gfds'=>null) = > array[''], version(); >  ?column? | ?column? | >    version > --+--+---

Re: [BUGS] BUG #5674: initdb failed if path contains symlink

On Fri, Sep 24, 2010 at 3:01 PM, Itagaki Takahiro wrote: > Windows 7 supports symbolic links like UNIX, > but initdb cannot initialize a database cluster > if the path (-D) contains symlinks. The bug might come from the following bug by Microsoft: http://connect.microsoft.com/VisualStudio/feedbac

Re: [BUGS] BUG #5678: libpq.so.4 is needed for pgadmin3

On Mon, 2010-09-27 at 14:39 +0530, fazal rahman wrote: > [r...@adserver ~]# /etc/init.d/postgresql startStarting postgresql It should be init.d/postgresql-9.0 ? -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community:

Re: [BUGS] BUG #5674: initdb failed if path contains symlink

On Mon, Sep 27, 2010 at 12:05, Itagaki Takahiro wrote: > On Fri, Sep 24, 2010 at 3:01 PM, Itagaki Takahiro > wrote: >> Windows 7 supports symbolic links like UNIX, >> but initdb cannot initialize a database cluster >> if the path (-D) contains symlinks. > > The bug might come from the following b

Re: [BUGS] BUG #5678: libpq.so.4 is needed for pgadmin3

Hello, Thank you for your support.Thats working fine.Thanks again *But there is a problem while connecting a new server from pgadmin, it's showing that * "Connecting to database..failed " Same error while connecting through command mode also like [r...@adserver ~]# /etc/init.d/postgresql start

Re: [BUGS] BUG #5678: libpq.so.4 is needed for pgadmin3

It should be init.d/postgresql-9.0 ? - The voice input and output is very good in this http://www.tomtop.com/black-ps3-wireless-bluetooth-headset-for-playstation-3.html?aid=z Wireless PS3 Headset . It is compatible with all PS3 games.Buy from Reliable http://www.tomtop.com/google-android-7

Re: [BUGS] BUG #5674: initdb failed if path contains symlink

Magnus Hagander writes: > On Mon, Sep 27, 2010 at 12:05, Itagaki Takahiro > wrote: >> The bug might come from the following bug by Microsoft: >> http://connect.microsoft.com/VisualStudio/feedback/details/595553/stat-function-returns-error-for-directory-symbolic-links >> >> Note that initdb in 8.

Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running

We're happy to see the problem resolved on your end. :-) -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company *http://www.linkedin.com/in/asheshvashi* On Mon, Sep 27, 2010 at 8:57 PM, Llewellyn,

Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running

On Mon, Sep 27, 2010 at 12:44 PM, Ashesh Vashi < ashesh.va...@enterprisedb.com> wrote: > We're happy to see the problem resolved on your end. :-)-- > However, it doesn't seem that we've actually done anything about the underlying issue with pg_ctl. -- Robert Haas EnterpriseDB: http://www.enterpr

Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running

Hi Ashesh Yes, this appears to be the issue that the password in the pgpass.conf file for the postgres user had not been changed when the windows account password was reset. Problem now resolved. Many thanks Mark Llewellyn From: Ashesh Vashi [mailto:ashesh.va.

[BUGS] Planner producing 100% duplicate subplans when unneeded

This is all on Postgres 9.0.0: I'm working on the definition for a view that, as part of its output, includes three columns that each contain a sum of values in a table that are in one of a few different states -- essentially: for each parent, give me the sum of children in the foo state, a second

[BUGS] BUG #5680: Failure to start: too many private dirs demanded

The following bug has been logged online: Bug reference: 5680 Logged by: Alexey Parshin Email address: alex...@gmail.com PostgreSQL version: 9.0.0 Operating system: Gentoo Linux Description:Failure to start: too many private dirs demanded Details: PostgreSQL (fresh

Re: [BUGS] BUG #5680: Failure to start: too many private dirs demanded

Excerpts from Alexey Parshin's message of lun sep 27 16:56:01 -0400 2010: > > The following bug has been logged online: > > Bug reference: 5680 > Logged by: Alexey Parshin > Email address: alex...@gmail.com > PostgreSQL version: 9.0.0 > Operating system: Gentoo Linux > Descri

Re: [BUGS] BUG #5674: initdb failed if path contains symlink

> Magnus Hagander writes: >> But how likely is that to bite us elsewhere then? Initdb works well if the link is a junction (mklink /J). We use junctions for tablespaces, but don't use symbolic links. So, there are no problems unless users create symlinks by themselves. On Mon, Sep 27, 2010 at 11

[BUGS] psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'

seb=> select version(); version -- PostgreSQL 8.4.4 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.re

Re: [BUGS] BUG #5679: pgAdminIII 1.12.0 hangs

Hi, Thanks for the quick response. Steps leading to hang... 1. Start pgAdminIII 2. Double-click localhost server node. 3. Select a database. 4. Click SQL on tool bar (also happens selecting Query Tool from Tools menu or if I use keyboard shortcut Ctrl+E). 5. Wait cursor appears. 6. pgAdminI

Re: [BUGS] BUG #5679: pgAdminIII 1.12.0 hangs

On 28/09/10 09:04, Henk Dekker wrote: > Hi, > > Thanks for the quick response. > > Steps leading to hang... OK. When you say "select a database", are you double-clicking on it to connect to that database? Does the red "x" disappear off it, showing it to be connected? Does the problem happen

Re: [BUGS] BUG #5679: pgAdminIII 1.12.0 hangs

Please reply to the list, not just to me. I've CC'd the list in on my reply and preserved your message below, but it's best to CC the list in from the start. Just use "reply all" in your email program. Anyway: the fact that just SQL editing is failing is very odd. Do you have other 64-bit Windows

Re: [BUGS] psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'

On Tue, Sep 28, 2010 at 12:41 PM, Sergey Burladyan wrote: > seb=> DISCARD ALL ; > ERROR:  DISCARD ALL cannot run inside a transaction block > > DISCARD is not mentioned anywhere in the src/bin/psql/common.c > in command_no_begin(const char *query) function. Thank you for the bug report! Fixed and