[asterisk-bugs] [Asterisk 0017557]: voicemail_odbc_postgresql step 11 typo

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17557 
====================================================================== 
Reported By:                cmaj
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17557
Category:                   Documentation
Reproducibility:            N/A
Severity:                   text
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.2.9 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-06-25 12:52 CDT
Last Modified:              2010-06-25 14:06 CDT
====================================================================== 
Summary:                    voicemail_odbc_postgresql step 11 typo
Description: 
Example sanity check query looks for undefined column "id" -- should be
"callerid".

Please change this:

[jsmith2 at localhost ODBC]$ echo "SELECT id, msgnum, dir, duration FROM
voicemessages WHERE msgnum = 1" | isql testing

To this:

[jsmith2 at localhost ODBC]$ echo "SELECT callerid, msgnum, dir, duration
FROM voicemessages WHERE msgnum = 1" | isql testing

Thank you!
====================================================================== 

---------------------------------------------------------------------- 
 (0123903) tilghman (administrator) - 2010-06-25 14:06
 https://issues.asterisk.org/view.php?id=17557#c123903 
---------------------------------------------------------------------- 
This is actually specific to 1.6.2 and forward.  In previous versions, the
"id" column was required, because we did not support multi-column unique
indexes.  Starting in 1.6.2, we started supporting that, so the requirement
(and specification) of the id column was dropped. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-06-25 14:06 tilghman       Note Added: 0123903                          
======================================================================