diff options
author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-06-25 20:17:37 +0000 |
---|---|---|
committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-06-25 20:17:37 +0000 |
commit | 9caa33b1d80fb14add6bc70f77943be46f1d7e0d (patch) | |
tree | 3b92933326a48c411e5790948f4c3e4857e96c19 | |
parent | afd58e641f89aa90044f23c185fc28194cdda416 (diff) |
Make the structure of the table specified before match the queries and results.
(closes issue #17557)
Reported by: cmaj
git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.4@272562 f38db490-d61c-443f-a65b-d21fe96a405b
-rw-r--r-- | doc/voicemail_odbc_postgresql.txt | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/voicemail_odbc_postgresql.txt b/doc/voicemail_odbc_postgresql.txt index 622501365..030810478 100644 --- a/doc/voicemail_odbc_postgresql.txt +++ b/doc/voicemail_odbc_postgresql.txt @@ -252,7 +252,7 @@ CREATE TRIGGER vm_cleanup AFTER DELETE OR UPDATE ON voicemessages FOR EACH ROW E 11) Just as a sanity check, make sure you check the voicemessages table via the isql utility. -[jsmith2@localhost ODBC]$ echo "SELECT id, msgnum, dir, duration FROM voicemessages WHERE msgnum = 1" | isql testing +[jsmith2@localhost ODBC]$ echo "SELECT uniqueid, msgnum, dir, duration FROM voicemessages WHERE msgnum = 1" | isql testing +---------------------------------------+ | Connected! | | | @@ -262,7 +262,7 @@ isql utility. | | +---------------------------------------+ SQL> +------------+------------+---------------------------------------------------------------------------------+---------------------+ -| id | msgnum | dir | duration | +| uniqueid | msgnum | dir | duration | +------------+------------+---------------------------------------------------------------------------------+---------------------+ +------------+------------+---------------------------------------------------------------------------------+---------------------+ SQLRowCount returns 0 @@ -370,9 +370,9 @@ Type: \copyright for distribution terms \q to quit asterisk=# SELECT * FROM voicemessages; - id | msgnum | dir | context | macrocontext | callerid | origtime | duration | mailboxuser | mailboxcontext | recording | label | read | sip_id | pabx_id | iax_id -----+--------+--------------------------------------------------+---------+--------------+-----------------------+------------+----------+-------------+----------------+-----------+-------+------+--------+---------+-------- - 26 | 0 | /var/spool/asterisk/voicemail/odbctest/101/INBOX | odbc | | "linksys" <linksys> | 1167794179 | 7 | 101 | odbctest | 16599 | | f | | | + uniqueid | msgnum | dir | context | macrocontext | callerid | origtime | duration | mailboxuser | mailboxcontext | recording | label | read | sip_id | pabx_id | iax_id +----------+--------+--------------------------------------------------+---------+--------------+-----------------------+------------+----------+-------------+----------------+-----------+-------+------+--------+---------+-------- + 26 | 0 | /var/spool/asterisk/voicemail/odbctest/101/INBOX | odbc | | "linksys" <linksys> | 1167794179 | 7 | 101 | odbctest | 16599 | | f | | | (1 row) Did you notice the the recording column is just a number? When a recording |