[BUGS] Error while loading shared libraries

2008-07-26 Thread yulytenorio
Hello, I have installed postgresql, version 8.3.3. and when I run: su -l postgres -c "/usr/local/pgsql/bin/createuser -d -a nobody", I get this error: sh-2.05b# su -l postgres -c "/usr/local/pgsql/bin/createuser -d -a nobody" /usr/local/pgsql/bin/createuser: error while loading shared libraries

[BUGS] BUG #4324: Default value for a column is not returned in select when column has not been explicitly set

2008-07-26 Thread Jeff Galyan
The following bug has been logged online: Bug reference: 4324 Logged by: Jeff Galyan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Linux Description:Default value for a column is not returned in select when column has not been explicitly

Re: [BUGS] BUG #4324: Default value for a column is not returned in select when column has not been explicitly set

2008-07-26 Thread Pavel Stehule
Hello, can you send any samples? This works for me: postgres=# select version(); version PostgreSQL 8.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (

Re: [BUGS] Error while loading shared libraries

2008-07-26 Thread Craig Ringer
[EMAIL PROTECTED] wrote: > Hello, > I have installed postgresql, version 8.3.3. Some information you left out would be useful, such as: - Operating system - Version of operating system - How you obtained and installed PostgreSQL (from where, how you built it if you built it yourself, etc) - ... a

Re: [BUGS] BUG #4324: Default value for a column is not returned in select when column has not been explicitly set

2008-07-26 Thread Tom Lane
"Jeff Galyan" <[EMAIL PROTECTED]> writes: > Take an existing table with some data in it and add a nullable column of > type boolean with default value true. In 8.2, 'select bool_column from > my_table' would have returned 'true' for all rows where the column had not > been explicitly set (which sh