agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedMissing data for column
7+ messages / 5 participants
[nested] [flat]
* Missing data for column
@ 2004-01-09 07:15 azwa@nc.com.my
0 siblings, 1 reply; 7+ messages in thread
From: azwa@nc.com.my @ 2004-01-09 07:15 UTC (permalink / raw)
To: pgsql-sql
Hi,
i got an error below after running copy command . the table structure as
following :
Table "biosadm.custinv_temp
Column | Type |
-------------+---------------+-
yr | integer |
custname | text |
invstatus | text |
custlo | text |
invno | integer |
invdate | date |
amount | numeric(10,2) |
acc | text |
salesperson | text |
ERROR: copy: line 1, Missing data for column "subsidiary"
Does anybody have an idea??? TQ
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Missing data for column
@ 2004-01-09 09:54 Michael Glaesemann <grzm@myrealbox.com>
parent: azwa@nc.com.my
0 siblings, 0 replies; 7+ messages in thread
From: Michael Glaesemann @ 2004-01-09 09:54 UTC (permalink / raw)
To: azwa@nc.com.my; +Cc: pgsql-sql
On Jan 9, 2004, at 4:15 PM, azwa@nc.com.my wrote:
> Hi,
>
> i got an error below after running copy command . the table structure
> as
> following :
>
> Table "biosadm.custinv_temp
> Column | Type |
> -------------+---------------+-
> yr | integer |
> custname | text |
> invstatus | text |
> custlo | text |
> invno | integer |
> invdate | date |
> amount | numeric(10,2) |
> acc | text |
> salesperson | text |
>
> ERROR: copy: line 1, Missing data for column "subsidiary"
Could you include the COPY command you're using, as well as the first
couple of lines of the file you're copying from? It's hard to know what
the problem is without this.
Regards,
Michael Glaesemann
grzm myrealbox com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Missing data for column
@ 2004-01-12 01:07 azwa@nc.com.my
0 siblings, 0 replies; 7+ messages in thread
From: azwa@nc.com.my @ 2004-01-12 01:07 UTC (permalink / raw)
To: pgsql-sql
Hi,
Sorry for the late respond. i've solved my problem. the error comes out
when the data has subsidiary column but
there is no subsidiary column in table. tq
Michael Glaesemann <grzm@myrealbox.com>
01/09/2004 06:54 PM ZE9
To: azwa@nc.com.my
cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Missing data for column
On Jan 9, 2004, at 4:15 PM, azwa@nc.com.my wrote:
> Hi,
>
> i got an error below after running copy command . the table structure
> as
> following :
>
> Table "biosadm.custinv_temp
> Column | Type |
> -------------+---------------+-
> yr | integer |
> custname | text |
> invstatus | text |
> custlo | text |
> invno | integer |
> invdate | date |
> amount | numeric(10,2) |
> acc | text |
> salesperson | text |
>
> ERROR: copy: line 1, Missing data for column "subsidiary"
Could you include the COPY command you're using, as well as the first
couple of lines of the file you're copying from? It's hard to know what
the problem is without this.
Regards,
Michael Glaesemann
grzm myrealbox com
^ permalink raw reply [nested|flat] 7+ messages in thread
* missing data for column
@ 2016-07-01 20:20 tel medola <tel.medola@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: tel medola @ 2016-07-01 20:20 UTC (permalink / raw)
To: pgsql-sql
Hi.
I tried to import records using the "\copy" or "copy" binary file, but I'm
not getting.
The postgres is prompting me that the column is missing, but it is in
binary file (already opened it to check).
I tried the command "\copy", "copy". I also tried to pass the columns as a
parameter but did not succeed.
Example below:
COPY queue_log FROM '/Central001/queue_log3.bin';
ERROR: missing data for column "callid"
CONTEXT: COPY queue_log, line 1: "PGCOPY"
Could someone please help me?
PS:If there is any way to convert the binary file to text lat would
also, because
this way I could import in other ways.
Thank you.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: missing data for column
@ 2016-07-01 20:30 Adrian Klaver <adrian.klaver@aklaver.com>
parent: tel medola <tel.medola@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Adrian Klaver @ 2016-07-01 20:30 UTC (permalink / raw)
To: tel medola <tel.medola@gmail.com>; pgsql-sql
On 07/01/2016 01:20 PM, tel medola wrote:
> Hi.
> I tried to import records using the "\copy" or "copy" binary file, but
> I'm not getting.
> The postgres is prompting me that the column is missing, but it is in
> binary file (already opened it to check).
> I tried the command "\copy", "copy". I also tried to pass the columns as
> a parameter but did not succeed.
>
> Example below:
> COPY queue_log FROM '/Central001/queue_log3.bin';
Have you looked at:
https://www.postgresql.org/docs/9.4/static/sql-copy.html
Binary Format
>
> ERROR: missing data for column "callid"
> CONTEXT: COPY queue_log, line 1: "PGCOPY"
>
> Could someone please help me?
If the example you show is complete I do see WITH FORMAT binary
>
>
> PS:If there is any way to convert the binary file to text lat would
> also, because this way I could import in other ways.
Where is the binary file coming from?
>
> Thank you.
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: missing data for column
@ 2016-07-01 20:42 tel medola <tel.medola@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 0 replies; 7+ messages in thread
From: tel medola @ 2016-07-01 20:42 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-sql
Thanks Adrian.
My postgres is crash and I can no longer read the tables. I can no longer climb
the base or anything. I just remember that these tables were exported before
the crash and with headache, I forgot to pass the correct parameters.
Thanks and sorry.
2016-07-01 17:30 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:
> On 07/01/2016 01:20 PM, tel medola wrote:
>
>> Hi.
>> I tried to import records using the "\copy" or "copy" binary file, but
>> I'm not getting.
>> The postgres is prompting me that the column is missing, but it is in
>> binary file (already opened it to check).
>> I tried the command "\copy", "copy". I also tried to pass the columns as
>> a parameter but did not succeed.
>>
>> Example below:
>> COPY queue_log FROM '/Central001/queue_log3.bin';
>>
>
> Have you looked at:
>
> https://www.postgresql.org/docs/9.4/static/sql-copy.html
>
> Binary Format
>
>
>
>> ERROR: missing data for column "callid"
>> CONTEXT: COPY queue_log, line 1: "PGCOPY"
>>
>> Could someone please help me?
>>
>
> If the example you show is complete I do see WITH FORMAT binary
>
>>
>>
>> PS:If there is any way to convert the binary file to text lat would
>> also, because this way I could import in other ways.
>>
>
> Where is the binary file coming from?
>
>
>> Thank you.
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: missing data for column
@ 2016-07-01 22:20 Steve Midgley <science@misuse.org>
parent: tel medola <tel.medola@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Steve Midgley @ 2016-07-01 22:20 UTC (permalink / raw)
To: tel medola <tel.medola@gmail.com>; +Cc: pgsql-sql
You could experiment (in a sandbox environment!!) with removing columns
that are not being found in the backup file (like 'callid') and see if you
can get something to load?
Do you remember if there were any DDL statements in the backup? Could you
load this backup from into an empty database?
Steve
On Fri, Jul 1, 2016 at 1:20 PM, tel medola <tel.medola@gmail.com> wrote:
> Hi.
> I tried to import records using the "\copy" or "copy" binary file, but I'm
> not getting.
> The postgres is prompting me that the column is missing, but it is in
> binary file (already opened it to check).
> I tried the command "\copy", "copy". I also tried to pass the columns as a
> parameter but did not succeed.
>
> Example below:
> COPY queue_log FROM '/Central001/queue_log3.bin';
>
> ERROR: missing data for column "callid"
> CONTEXT: COPY queue_log, line 1: "PGCOPY"
>
> Could someone please help me?
>
>
> PS:If there is any way to convert the binary file to text lat would also, because
> this way I could import in other ways.
>
> Thank you.
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2016-07-01 22:20 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-09 07:15 Missing data for column azwa@nc.com.my
2004-01-09 09:54 ` Michael Glaesemann <grzm@myrealbox.com>
2004-01-12 01:07 Re: Missing data for column azwa@nc.com.my
2016-07-01 20:20 missing data for column tel medola <tel.medola@gmail.com>
2016-07-01 20:30 ` Re: missing data for column Adrian Klaver <adrian.klaver@aklaver.com>
2016-07-01 20:42 ` Re: missing data for column tel medola <tel.medola@gmail.com>
2016-07-01 22:20 ` Re: missing data for column Steve Midgley <science@misuse.org>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox