<p>Ah, I was not aware it was auto-generated, but yes that type does not exist:</p>
<pre><code>postgres=# create database test;
CREATE DATABASE
postgres=# \c test
You are now connected to database "test" as user "postgres".
test=# CREATE TABLE location (
test(# contact_id BIGINTSERIAL PRIMARY KEY NOT NULL,
test(# username VARCHAR(64) DEFAULT '' NOT NULL,
test(# domain VARCHAR(64) DEFAULT '' NOT NULL,
test(# contact VARCHAR(255) DEFAULT '' NOT NULL,
test(# received VARCHAR(128) DEFAULT NULL,
test(# path VARCHAR(255) DEFAULT NULL,
test(# expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2020-05-28 21:32:15' NOT NULL,
test(# q REAL DEFAULT 1.0 NOT NULL,
test(# callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
test(# cseq INTEGER DEFAULT 13 NOT NULL,
test(# last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '1900-01-01 00:00:01' NOT NULL,
test(# flags INTEGER DEFAULT 0 NOT NULL,
test(# cflags VARCHAR(255) DEFAULT NULL,
test(# user_agent VARCHAR(255) DEFAULT '' NOT NULL,
test(# socket VARCHAR(64) DEFAULT NULL,
test(# methods INTEGER DEFAULT NULL,
test(# sip_instance VARCHAR(255) DEFAULT NULL,
test(# attr VARCHAR(255) DEFAULT NULL,
test(# CONSTRAINT location_account_contact_idx UNIQUE (username, domain, contact, callid)
test(# );
ERROR: type "bigintserial" does not exist
LINE 2: contact_id BIGINTSERIAL PRIMARY KEY NOT NULL,
^
test=# select version()
test-# ;
version
-----------------------------------------------------------------------------------------------
PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit
(1 row)
</code></pre>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/OpenSIPS/opensips/pull/792#issuecomment-184274924">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AFOciWKisb-lDRRO11XYwvyCq0pHQkuXks5pke-8gaJpZM4HZby4.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/OpenSIPS/opensips/pull/792#issuecomment-184274924"></link>
<meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>