Re: [BUGS] BUG #2451: Short column names return no values within function

2006-05-23 Thread Michael Fuhr
On Tue, May 23, 2006 at 03:27:01AM +, Alex Weslowski wrote: > Below is code for duplicating this error. Fields "Peg" and "Rs03" and "Rs12" > are absent from returned record (either Record or Cursor) even though the > values in the table are not null. The function declares variables with the s

Re: [BUGS] BUG #2451: Short column names return no values within function

2006-05-23 Thread Tom Lane
"Alex Weslowski" <[EMAIL PROTECTED]> writes: > DECLARE > peg VARCHAR(5) := ''; > rs03 VARCHAR(3) := ''; > rs12 VARCHAR(3) := ''; > rec RECORD; > BEGIN > FOR rec IN SELECT Symbol, RS03, RS12, Peg > FROM TestBug WHERE Date=d > ORDER BY RS12 DESC LOOP The pro

[BUGS] missing or erroneous pg_hba.conf file

2006-05-23 Thread qinyan
 你好:     我是 一名中国学生,正在做网格方面的东西,做到最后当我执行命令时,显示如下 2006-05-21 20:19:21,650 ERROR service.ReliableFileTransferImpl [main,:73]Unable to setup database driver with pooling.A connection error has occurred: FATAL:  missing or erroneous pg_hba.conf file 2006-05-21 20:19:23,213 WARN  service.ReliableFileTr

[BUGS] BUG #2451: Short column names return no values within function

2006-05-23 Thread Alex Weslowski
The following bug has been logged online: Bug reference: 2451 Logged by: Alex Weslowski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows XP Description:Short column names return no values within function Details: Below is code for d