PostgreSQL error.(Openshift)

Started by andong, August 15, 2014, 10:11:29 AM

Previous topic - Next topic

andong

Error Message
Line #121: ERROR: operator + already exists
Line #122: ERROR: operator <> already exists
Line #646: ERROR: syntax error at or near "s"
LINE 4: ...r_holidays (title, event_date) VALUES ('New Year\'s', '0004-...
^
Line #648: ERROR: syntax error at or near "s"
LINE 2: ..._holidays (title, event_date) VALUES ('Valentine\'s Day', '0...
^
Line #649: ERROR: syntax error at or near "s"
LINE 2: ...olidays (title, event_date) VALUES ('St. Patrick\'s Day', '0...
^
Line #654: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #655: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #656: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #657: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #658: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #659: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #660: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #661: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #662: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #663: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #664: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #665: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #666: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #667: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #668: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #669: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #670: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #671: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #672: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #673: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #674: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #675: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #1859: ERROR: syntax error at or near "("
LINE 2: ...e, description, smiley_order, hidden) VALUES (':\'(', 'cry.g...

How to?

Oldiesmann

You can ignore the "Operator already exists" errors.

For the holidays, just replace \' with ''.
Michael Eshom
Christian Metal Fans

Advertisement: