Bugs item #1922377, was opened at 2008-03-21 17:11
Message generated for change (Comment added) made by nielsnes
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1922377&group_id=56967

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL 2.22
Status: Open
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: mmckennirey (mmckennirey)
Assigned to: Niels Nes (nielsnes)
Summary: COPY INTO using a schema fails

Initial Comment:
Using COPY fails when trying to upload data into a table within a schema
 
 CREATE TABLE test (
 column1 VARCHAR(32),
 column2 VARCHAR(32)
 );
 
COPY INTO test FROM  '/location/file.csv' USING DELIMITERS ',', '\n';
 
succeeds.
 
 CREATE SCHEMA abc;
 
 CREATE TABLE abc.test (
 column1 VARCHAR(32),
 column2 VARCHAR(32)
 );
 
COPY INTO abc.test FROM  '/location/file.csv' USING DELIMITERS ',', '\n';
 
 fails with
 
 !SQLException:sql:table test not found
 !SQLException:importTable:failed to import table

----------------------------------------------------------------------

>Comment By: Niels Nes (nielsnes)
Date: 2008-03-21 17:42

Message:
Logged In: YES 
user_id=43556
Originator: NO

We now pass the full schema and table to the import function. This test
was added to the src/test/bugs directory. 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1922377&group_id=56967

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to