The following bug has been logged online:

Bug reference:      4752
Logged by:          Fujii Masao
Email address:      masao.fu...@gmail.com
PostgreSQL version: PostgreSQL 8.4d
Operating system:   Red Hat Enterprise Linux Server release 5.1 (Tikanga)
Description:        sourceline in pg_settings indicates wrong number
Details: 

Hi,

sourceline (in pg_settings) of the parameter line without '\n' indicates
wrong number as follows.

 $ nl $PGDATA/postgresql.conf
     1  shared_buffers = 32MB         <-- this line doesn't contain '\n'
 $ psql -c "SELECT sourceline FROM pg_settings WHERE name =
'shared_buffers'"
  sourceline
 ------------
           0
 (1 row)

On the other hand, if the line has '\n', sourceline indicates the correct
number.

 $ echo "shared_buffers = 32MB" > $PGDATA/postgresql.conf
 $ nl $PGDATA/postgresql.conf
     1  shared_buffers = 32MB         <-- this line contains '\n'
 $ psql -c "SELECT sourceline FROM pg_settings WHERE name =
'shared_buffers'"
   sourceline
 ------------
           1
 (1 row)

Is this bug?

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to