Search Postgresql Archives

Re: Another user error?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/1/20 11:04 AM, Rich Shepard wrote:
On Sun, 1 Nov 2020, Francisco Olarte wrote:

This is nearly impossible to diagnose without a chunk of the query (
i,e, the first lines and the last ones ).

Francisco,

$ psql -d bustrac -f locations.sql

It smells to missing parentheses. If you use some editor witch matches
them, try adding one BEFORE the semicolon. If it matches something
above you've got it.

Here're the last two lines:
(2297,1,'Principal place of business','600 SE Bay Boulevard',null,'Newport','OR','97365','541-265-7758','541-265-4235',null), (2298,1,'Principal place of business','7200 NE Airport Way',null,'Portland','OR','97218',null,null,null);

Also need the beginning lines including the INSERT part.


And psql found a few missing terminating parentheses and commas which were
fixed. I expected this last run to successfully complete.

Regards,

Rich





--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux