[BUGS] Postgres 9 Installation problems

2010-09-25 Thread r d
Hi, I updated PostgreSQL from 8.4.4 to 9.0.0 from repo (PGDG) via yum and it leaves some business unfinished IMHO. I have a Fedora Core FC12 (Linux 2.6.32.21-168.fc12.x86_64) up-to-date. So, after the upgrade, I found the following: a) The postgresql service is not present anymore, so I must st

Re: [BUGS] Postgres 9 Installation problems

2010-09-25 Thread Devrim GÜNDÜZ
Hi, On Sat, 2010-09-25 at 12:21 +0200, r d wrote: > a) The postgresql service is not present anymore, so I must start it > by hand like this: sudo /etc/init.d/postgresql-9.0 start > (and register the service by hand so that it does start with system > startup). As of PostgreSQL 9.0, parallel ins

Re: [BUGS] Postgres 9 Installation problems

2010-09-25 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes: > On Sat, 2010-09-25 at 12:21 +0200, r d wrote: >> --> I expect the installer to install the system service into the list >> ofervices/daemons which are started at boot. > Nope. RPMs have never ever added PostgreSQL to startup sequence by > default. Ri

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

2010-09-25 Thread faz
The following bug has been logged online: Bug reference: 5678 Logged by: faz Email address: fazal2...@gmail.com PostgreSQL version: 9.0 Operating system: CentOs Description:libpq.so.4 is needed for pgadmin3 Details: Hello, While i am trying to install Pgadmin3 afte

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

2010-09-25 Thread Devrim GÜNDÜZ
On Sat, 2010-09-25 at 10:23 +, faz wrote: > I had checked that , the libpq.so.5 is already located in the lib > files of postgresql 9.0 , but no libpq.so.4. So how can i solve this > problem? someone please help to do install pgadmin ! Which repository are you using? Only RPMForge? See below:

[BUGS] LEFT OUTER JOIN sub-SELECT produces a column != NULL when all NULLs are expected

2010-09-25 Thread Kirill Simonov
Hi, I found a bug where a column from a LEFT OUTER JOIN sub-SELECT is not equal to NULL when the whole row must be NULL because the join condition is not satisfied. Here is the test case: -- DROP TABLE IF EXISTS c; DROP TABLE IF EXISTS b; DROP TABLE IF EXISTS a;

Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)

2010-09-25 Thread stagirus
As a fundamental protocol, I prefer to keep any "attitudes" and "finger-pointing" off the table. Let us just focus on the real problem-solving. Though I am very versatile in speaking languages like C, C++ and Java, I assumed we all can speak and understand "English." You can also clearly see the

Re: [BUGS] libpq: system-wide root.crt

2010-09-25 Thread Peter Eisentraut
On fre, 2010-09-24 at 09:50 +0200, Magnus Hagander wrote: > > I'm thinking, libpq could really use a global (and, for that matter, a > > per-user) configuration file, where you could set defaults for some of > > the things that you currently have to use environment variables for, > > e.g., sslmode.

Re: [BUGS] BUG #5666: Pgadmin restore or back up database dont apper

2010-09-25 Thread Robert Haas
On Mon, Sep 20, 2010 at 2:28 PM, Oscar Miguel Amezcua Estrella wrote: > > The following bug has been logged online: > > Bug reference:      5666 > Logged by:          Oscar Miguel Amezcua Estrella > Email address:      obel...@gmail.com > PostgreSQL version: 9.0.1 > Operating system:   Opensuse 11