Re: Error Relation xxxx does not exist when trying to insert new row

Il 31/05/2017 15:57, William Colls ha scritto:
>
> voipms=> \d
> List of relations
> Schema | Name | Type | Owner
> --------+----------------+-------+--------
> public | CallDetail | table | voipms
> public | my_first_table | table | voipms
> (2 rows)
>
> voipms=> INSERT INTO CallDetail
> (datetime,Description,account,callerid,destination,Duration,rate,total)
> VALUES ('2017-03-31 14:51:22','Inbound
> DID','157974','Joe6132227566','6135091304','28','0.01000000','0.00500000');
> ERROR: relation "calldetail" does not exist
> LINE 1: INSERT INTO CallDetail (datetime,Description,account,calleri...
>
>
>
Try changing
INSERT INTO CallDetail
(datetime,Description,account,callerid,destination,Duration,rate,total)
VALUES ('2017-03-31 14:51:22','Inbound
DID','157974','Joe6132227566','6135091304','28','0.01000000','0.00500000');
in
INSERT INTO "CallDetail"
(datetime,"Description",account,callerid,destination,"Duration",rate,total)
VALUES ('2017-03-31 14:51:22','Inbound
DID','157974','Joe6132227566','6135091304','28','0.01000000','0.00500000');

generally speaking, in order to avoid this kind of issues, I prefer
using only lowercase names for everything (databases, tables, column
names, etc)

HTH,
Moreno.