| 06:55.21 | *** join/#asterisk-dev Juggie (~Juggie@unaffiliated/juggie) |
| 07:10.12 | *** join/#asterisk-dev seanbright (~sean@asterisk/contributor-and-bug-marshal/seanbright) |
| 07:10.12 | *** mode/#asterisk-dev [+o seanbright] by sturgeon.freenode.net |
| 09:59.23 | *** join/#asterisk-dev tzafrir_laptop (~tzafrir@local.xorcom.com) |
| 09:59.23 | *** mode/#asterisk-dev [+o tzafrir_laptop] by ChanServ |
| 12:29.25 | *** join/#asterisk-dev kpfleming (~kpfleming@unaffiliated/kpfleming) |
| 12:35.18 | *** join/#asterisk-dev jmls (~julian@host217-36-208-155.in-addr.btopenworld.com) |
| 12:35.25 | jmls | good afternoon all |
| 12:36.33 | jmls | can cdr_postgres handle custom CDR fields like sqlite3 ? |
| 13:01.24 | *** join/#asterisk-dev luckman212 (~luckman21@2001:470:8abb:0:211:32ff:fe10:cdc1) |
| 13:51.54 | jmls | reason I ask is that I got this error : |
| 13:52.01 | jmls | ERROR[4387][C-00000001] cdr_pgsql.c: Reason: ERROR: invalid input syntax for type timestamp: "" LINE 1: ...gup',1,1,'ANSWERED',3,'1348406454.1','1348406454.1',1,'','') |
| 13:52.48 | jmls | are cdr fields dependant on position ? |
| 13:55.55 | *** join/#asterisk-dev jmls1 (~julian@host217-36-208-155.in-addr.btopenworld.com) |
| 14:06.44 | *** part/#asterisk-dev jmls1 (~julian@host217-36-208-155.in-addr.btopenworld.com) |
| 14:21.29 | *** join/#asterisk-dev jmls1 (~julian@host217-36-208-155.in-addr.btopenworld.com) |
| 14:21.58 | jmls1 | urgh. bloody internet. did I miss any answers ? :P |
| 14:32.15 | WIMPy | no |
| 14:32.51 | WIMPy | It's unlikely that you miss ANYTHING in here on weekends. |
| 14:33.24 | jmls1 | heh |
| 14:34.17 | jmls1 | knows that WIMPy is around ... |
| 14:34.32 | jmls1 | so, does cdr for postgres support custom columns ? |
| 14:34.36 | jmls1 | :-D |
| 14:35.05 | jmls1 | mysql does. sqlite3 does. manager does. |
| 14:35.18 | jmls1 | so, I'm kinda hoping ... |
| 14:38.37 | WIMPy | I have no ida. |
| 14:38.53 | WIMPy | Otherwise I would have answered. |
| 14:48.09 | *** join/#asterisk-dev wudles (~wudles@gateway.secureinstrument.com) |
| 14:56.58 | jmls1 | that's a cop out! |
| 14:56.59 | jmls1 | ;) |
| 15:24.48 | jmls1 | ok, think there's a bug here! |
| 15:24.50 | jmls1 | cdr show pgsql status |
| 15:24.51 | jmls1 | Usage: cdr show pgsql status |
| 15:24.51 | jmls1 | <PROTECTED> |
| 15:25.06 | jmls1 | so, I type "cdr show pgsql status" |
| 15:25.25 | jmls1 | and I get the error "Usage: cdr show pgsql status" |
| 15:25.33 | jmls1 | :P |
| 15:48.11 | jmls1 | right. I think I've found the problem |
| 15:48.31 | jmls1 | I have some "other" fields in my schema, such as created_at and updated_at |
| 15:49.38 | jmls1 | these are read by cdr_pgsql.c, but obviously don't exist in the asterisk cdr , so are passed as '', which then causes a problem as '' does not work as a datetime ... |
| 15:52.45 | jmls1 | give em a default of now() and it starts to behave again |
| 19:44.53 | *** join/#asterisk-dev mjordan (~mjordan@user-69-1-6-49.knology.net) |
| 19:44.53 | *** mode/#asterisk-dev [+o mjordan] by ChanServ |
| 19:47.51 | *** join/#asterisk-dev tzafrir_laptop (~tzafrir@212.179.75.202) |
| 19:47.51 | *** mode/#asterisk-dev [+o tzafrir_laptop] by ChanServ |
| 20:29.37 | *** join/#asterisk-dev spditner (~simon@206-248-134-65.dsl.teksavvy.com) |
| 20:30.09 | jmls1 | to answer my own question, if there is a pgql field in the cdr table matching a CDR(foo) then it gets updated just fine ;) |
| 20:40.32 | *** join/#asterisk-dev blitzrage (~Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 20:40.32 | *** mode/#asterisk-dev [+o blitzrage] by ChanServ |
| 21:55.59 | *** part/#asterisk-dev mjordan (~mjordan@user-69-1-6-49.knology.net) |