<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
the sql scripts to create the tables are in
utils/kamctl/{mysql|postgres|...}<br>
<br>
The one you were looking at are probably from ser side and should be
removed.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 21/11/14 02:13, Måns Nilsson wrote:<br>
</div>
<blockquote cite="mid:20141121011339.GC11942@besserwisser.org"
type="cite">
<pre wrap="">Greetings,
I'm fighting a number of errors in the 'acc' table like so:
Nov 21 01:43:05 landsort postgres[53327]: [4-1] ERROR: column "time" of relation "acc" does not exist at character 78
That is, I believe, the default column name.
Thing is, though, that the DDL that I used to build the table, is the
one in in scripts/ and it does not does not contain that string:
(on master but it is the same in 4.2 which is what I've got in production)
$ for d in mysql oracle postgres ; do egrep '\btime\b' scripts/${d}/*create* ; done
$
How are those files generated?
How do I come about to submitting an useful patch?
What is the desired datatype for the time column?
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</body>
</html>