Hi Ocke,

Yes, that works... thanks again. I think I had been assuming that when I
dragged my data to the "Tables" pane, OOo knew which particular schema
I had dragged them to. This assumption was incorrect.

- Jeremy

On Thu, Jan 05, 2006 at 07:38:45AM +0100, Ocke Janssen wrote:
> Hi Jeremy,
> 
> the problem here could be that the table name needs a schema in front of 
> it like schema.Table1
> 
> Best regards,
> 
> Ocke
> 
> 
> Jeremy Semeiks wrote:
> >Hello,
> >
> >I'm running OOo 2.0.1 on Debian Linux. I'm trying to use the "Copy
> >table" wizard to append data from a spreadsheet to a Postgres 8.0
> >table via ODBC and psqlodbc version 08.00.0102. I can read and write
> >to the table fine with the usual Base interface. However, when I click
> >"Attach data" and type the target table name in the Wizard and hit
> >Next, I get the following error message:
> >
> >     This table name is not valid in the current database
> >
> >This operation works properly with a native HSQL table. Suggestions?
> >
> >Thanks,
> >Jeremy
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >  
> 
> 
> -- 
> Ocke Janssen                      Tel: +49 40 23646 661, x66661
> Dipl. Inf(FH)                     Fax: +49 40 23646 550
> Sun Microsystems Inc.
> Sachsenfeld 4                     mailto:[EMAIL PROTECTED]
> D-20097 Hamburg                   http://www.sun.com/staroffice
> 
>                       Example isn't another way to teach, 
>                       it is the only way to teach.  
>                       Albert Einstein
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to