On Thu, 29 Oct 2020, Rob Sargent wrote:
Would it be rude to suggest that you re-visit how that file was made?
Seems you'll be in the same boat "next time".
Rob,
Part of the files was exported from the old version of the database. New
rows were from different text files, each with a different
On 10/29/20 2:07 PM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Is it just the 50 line version?
Adrian,
Nope.
If it is, what happens if you go back to original 1925 line version
and correct the NULL issue in the line 26 and run it again?
I'm finding typos and column
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Is it just the 50 line version?
Adrian,
Nope.
If it is, what happens if you go back to original 1925 line version and
correct the NULL issue in the line 26 and run it again?
I'm finding typos and column tranposition errors that I had not spotted w
On 10/29/20 10:52 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Is orgs-1.sql just the INSERT?
Yes.
Is it just the 50 line version?
If it is, what happens if you go back to original 1925 line version and
correct the NULL issue in the line 26 and run it again?
How
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Is orgs-1.sql just the INSERT?
Yes.
How is that file being fed to psql?
$ psql -d bustrac -f orgs-1.sql
Rich
On 10/29/20 10:39 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Rich Shepard wrote:
psql:organizations.sql:1926: ERROR: syntax error at or near ";"
LINE 1925: ...m',null,'Port','Opportunity',null);
^
I'm not seeing why that's an error. All previ
On Thu, Oct 29, 2020, 10:39 Rich Shepard wrote:
> On Thu, 29 Oct 2020, Rich Shepard wrote:
>
> > psql:organizations.sql:1926: ERROR: syntax error at or near ";"
> > LINE 1925: ...m',null,'Port','Opportunity',null);
> ^
> > I'm not seeing why that'
Rich Shepard writes:
> Found the problem in line 26 of 1925 rows: a non-null column had 'null'
> entered rather than one of the allowed values. That row was in the original
> database and I've no idea when I might have changed that.
> Why postgres didn't highlight that until I had only a 50-line
On Thu, 29 Oct 2020, Rich Shepard wrote:
psql:organizations.sql:1926: ERROR: syntax error at or near ";"
LINE 1925: ...m',null,'Port','Opportunity',null);
^
I'm not seeing why that's an error. All previous rows terminate with a comma
and I don't
On 10/29/20 9:59 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Adrian Klaver wrote:
INSERT INTO products (product_no, name, price) VALUES
(
(1, 'Cheese', 9.99),
(2, 'Bread', 1.99),
(3, 'Milk', 2.99)
);
then you should have gotten a different error. Something like:
ERROR: column "p
On Thu, 29 Oct 2020, Adrian Klaver wrote:
INSERT INTO products (product_no, name, price) VALUES
(
(1, 'Cheese', 9.99),
(2, 'Bread', 1.99),
(3, 'Milk', 2.99)
);
then you should have gotten a different error. Something like:
ERROR: column "product_no" is of type integer but expressi
On Thu, 29 Oct 2020, David G. Johnston wrote:
As your general syntax seems correct I would suspect an issue in the data
values - like having a single quote in an organization name that isn't
properly escaped (doubled). I'd first make sure insert one record works
then begin bisecting your values,
On 10/29/20 9:35 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Paul Förster wrote:
insert ...
(
(v1, v2, v3),
(v4, v5, v6),
(v7, v8, v9) <= this is the bracket pair that Emacs shows as
matching.
); <= this is the missing bracket.
Paul/Adrian/Tom:
First thing I did was look a
On Thu, Oct 29, 2020 at 9:37 AM Rich Shepard
wrote:
> On Thu, 29 Oct 2020, David G. Johnston wrote:
>
> > That said seeing the first few rows, in addition to the last few, would
> > help.
>
> David,
>
> insert into organizations
> (org_nbr,org_name,org_url,org_email,industry,status,comment) value
On Thu, 29 Oct 2020, David G. Johnston wrote:
That said seeing the first few rows, in addition to the last few, would
help.
David,
insert into organizations (org_nbr,org_name,org_url,org_email,industry,status,comment) values
(1,'Tidewater Contractors Inc',null,null,'Mining','Opportunity','GE
On Thu, 29 Oct 2020, Paul Förster wrote:
insert ...
(
(v1, v2, v3),
(v4, v5, v6),
(v7, v8, v9)<= this is the bracket pair that Emacs shows as matching.
); <= this is the missing bracket.
Paul/Adrian/Tom:
First thing I did was look at the postgres 12 manual. On page 155 I see:
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Pretty sure the thinking is that the opening parenthesis is further upstream,
say around VALUES?
Well, duh! Of course. I forgot to enclose all value rows. Mea culpa!
Thanks,
Rich
Hi David,
> On 29. Oct, 2020, at 17:21, David G. Johnston
> wrote:
>
> On Thu, Oct 29, 2020 at 9:16 AM Paul Förster wrote:
> But I guess that Emacs shows the matching closing bracket at the beginning of
> the line, which matches that single tuple. But you also need a closing
> bracket for th
On Thu, Oct 29, 2020 at 9:16 AM Paul Förster
wrote:
> But I guess that Emacs shows the matching closing bracket at the beginning
> of the line, which matches that single tuple. But you also need a closing
> bracket for the set of tuples like this:
>
> insert ...
> (
> (v1, v2, v3),
> (v4,
Hi Rich,
> On 29. Oct, 2020, at 17:08, Rich Shepard wrote:
>
> On Thu, 29 Oct 2020, Paul Förster wrote:
>
>>> (2698,'Port of
>>> Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
>> the last line has a closing parenthesis missing.
>
> Paul,
>
> I see a closing parent
On 10/29/20 9:08 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Paul Förster wrote:
(2698,'Port of
Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
the last line has a closing parenthesis missing.
Paul,
I see a closing parenthesis immediately in front of the semi-c
On Thu, 29 Oct 2020, Paul Förster wrote:
(2698,'Port of
Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
the last line has a closing parenthesis missing.
Paul,
I see a closing parenthesis immediately in front of the semi-colon and emacs
shows it matches the opening
Hi Rich,
> On 29. Oct, 2020, at 16:58, Rich Shepard wrote:
>
> On Thu, 29 Oct 2020, Rob Sargent wrote:
>
>> Can we see the last two line of the file (1924, 1925)?
>
> Rob,
>
> (2697,'Port of
> Newport','http://www.portofnewport.com',null,'Port','Opportunity',null),
> (2698,'Port of
> Portla
On Thu, 29 Oct 2020, Rob Sargent wrote:
Can we see the last two line of the file (1924, 1925)?
Rob,
(2697,'Port of
Newport','http://www.portofnewport.com',null,'Port','Opportunity',null),
(2698,'Port of
Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
Each line is
Rich Shepard writes:
> I'm loading data into tables with the 'insert' statement. There are many
> rows containing values and each is bracketed by parentheses except for the
> last row. That's terminated with a semicolon, but psql reports an error
> there:
> psql:organizations.sql:1926: ERROR: sy
On 10/29/20 9:43 AM, Rich Shepard wrote:
I'm loading data into tables with the 'insert' statement. There are many
rows containing values and each is bracketed by parentheses except for the
last row. That's terminated with a semicolon, but psql reports an error
there:
psql:organizations.sql:19
I'm loading data into tables with the 'insert' statement. There are many
rows containing values and each is bracketed by parentheses except for the
last row. That's terminated with a semicolon, but psql reports an error
there:
psql:organizations.sql:1926: ERROR: syntax error at or near ";"
LINE
27 matches
Mail list logo
