When COPYing data to a table which uses foreign keys, if there
is a reference to a key which is not there, the copy fails
(as expected) but there is no error message.
Hmm. Looking at it more, seems like there is an error message
when using:
COPY "f" FROM '/home/lee/f.dat';
but _not_ when using:
[EMAIL PROTECTED] (Lee Harr) writes:
> When COPYing data to a table which uses foreign keys, if there
> is a reference to a key which is not there, the copy fails
> (as expected) but there is no error message.
> Hmm. Looking at it more, seems like there is an error message
> when using:
> COPY "f
I wrote:
> [EMAIL PROTECTED] (Lee Harr) writes:
>> When COPYing data to a table which uses foreign keys, if there
>> is a reference to a key which is not there, the copy fails
>> (as expected) but there is no error message.
>> Hmm. Looking at it more, seems like there is an error message
>> when
Coax <[EMAIL PROTECTED]> writes:
> [ insert with an ON INSERT DO UPDATE ... rule ]
> Here's the output of PG7.1.2:
> test=# INSERT INTO forum
>(group_forum_id,posted_by,subject,body,date,is_followup_to,thread_id,most_recent_date)
> VALUES ('88760', '192470', 'asdfasdfsqdf', 'blah',
>'1014405669
Hi Andy,
I agree with you totally.
Don't yet know how to implement it, and don't have much spare time to do so
yet either. I'm working on some stuff which will mean there are more people
to help with the techdocs site and get things done (if it works), therefore
improving the present techdoc
Hi Peter,
Haven't yet had the time to properly try this out. Did a quick initial
installation of PostgreSQL 7.2 with cygwin 1.3.9, and got the same error as
yourself.
I've had reports of PostgreSQL 7.1.3 working on cygwin however, but haven't
gotten around to trying that myself yet. There i
When useing COPY FROM 'file'
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ACK! must rember which MTA I'm useing...
When useing COPY FROM 'file' DELIMITER '\254' copyfrom reads past the
delimiter and ends up with parse errors when trying to do the insert
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ACK! must rember which MTA I'm useing...
When useing COPY FROM 'file' DELIMITER '\254' copyfrom reads past the
delimiter and ends up with parse errors when trying to do the insert
What the ?? why dind' tthat go through with the body of the text.. *sigh*
I'll resend in the AM..
---
Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> When useing COPY FROM 'file' DELIMITER '\254' copyfrom reads past the
> delimiter and ends up with parse errors when trying to do the insert
Are you perhaps operating in a multibyte encoding in which \254 is
just the first byte of a multibyte charac
10 matches
Mail list logo
