Re: Import: empty string and expression - Mailing list pgadmin-hackers

From Quan Zongliang
Subject Re: Import: empty string and expression
Date
Msg-id 20090226182630.3B8B.4125B4E5@gmail.com
Whole thread Raw
In response to Re: Import: empty string and expression  (Dave Page <dpage@pgadmin.org>)
Responses Re: Import: empty string and expression
List pgadmin-hackers
> Have a set  of radio buttons and a textbox perhaps:
> NULL AS:  NULL  O   empty string O    constant   O    [                ]
> NULL AS:  NULL  O    constant   O    [                ]
My plan is the user can set this option for every column.
Because different column has different set(nullable or not) and different type.

> I wouldn't bother with ERROR for any type - let the server detect
> errors and reject data accordingly.
With COPY command, it stops operation at the first error.
Maybe the user don't want this. Especially when they want to import a huge size file.

> I wouldn't worry about those yet. Let's learn to walk first, and fly later :-)
Yes, I think so, too.

-----------------------------------------------
Quan Zongliang
quanzongliang@gmail.com
CIT Japan:  http://www.cit.co.jp
CIT China:  http://www.citbj.com.cn


pgadmin-hackers by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Server Status window work
Next
From: Quan Zongliang
Date:
Subject: Re: Import: empty string and expression