Re: [pgadmin-support] Migrating from MS-Access to Postgresql

2002-03-28 Thread Dave Page
Title: Message   -Original Message-From: Dino Nardini [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 13:45To: Dave Page; 'Marc Cuypers'; [EMAIL PROTECTED]Subject: Re: [pgadmin-support] Migrating from MS-Access to Postgresql Hello,I ran into similiar problems when migr

Re: [pgadmin-support] Migrating from MS-Access to Postgresql

2002-03-28 Thread Dino Nardini
Hello, I ran into similiar problems when migrating tables from MSSQL to Postgres.  Typically I create table names such as "TableName" and column names such as "TableID" in MSSQL.  If there exists a table called "TableName" and a column called "TableID" why won't the following query work in postgre

Re: [pgadmin-support] Can't edit tables with timestamps

2002-03-28 Thread Dave Page
> -Original Message- > From: Thomas Sandford [mailto:[EMAIL PROTECTED]] > Sent: 28 March 2002 12:11 > To: Dave Page > Subject: Re: [pgadmin-support] Can't edit tables with timestamps > > > [ ... problems editing tables containing timestamps ... ] > > > Thought (which may have occured

Re: [pgadmin-support] Can't edit tables with timestamps

2002-03-28 Thread Dave Page
> -Original Message- > From: Thomas Sandford [mailto:[EMAIL PROTECTED]] > Sent: 28 March 2002 11:33 > To: [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Can't edit tables with timestamps > > > "Dave Page" <[EMAIL PROTECTED]> wrote: > > Thomas Sandford [mailto:[EMAIL PROTECTED]] wr

Re: [pgadmin-support] Can't edit tables with timestamps

2002-03-28 Thread Thomas Sandford
"Dave Page" <[EMAIL PROTECTED]> wrote: > Thomas Sandford [mailto:[EMAIL PROTECTED]] wrote: > > [... database table using timestamp field ...] > > COPY "testtable" FROM stdin; > > 1 \N 2002-03-27 20:15:52.00+00 > > 2 \N 2002-03-27 20:16:05.187532+00 > > \. > > > > You will

Re: [pgadmin-support] Source code

2002-03-28 Thread Dave Page
Hi, How did you download/extract it? I just downloaded a tarball, un-tar.gz'ed it with Winzip and VB reads it just fine here. Regards, Dave. > -Original Message- > From: Daniel Chang [mailto:[EMAIL PROTECTED] > ] > Sent: 28 March 2002 09:49 > To: [E

Re: [pgadmin-support] timestamp parse error --- *** Migration PLU

2002-03-28 Thread Dave Page
> -Original Message- > From: Samuele Brignoli [mailto:[EMAIL PROTECTED]] > Sent: 28 March 2002 09:36 > To: Dave Page; [EMAIL PROTECTED] > Subject: R: [pgadmin-support] timestamp parse error --- *** > Migration PLUG-IN *** > > > Dave, > > I still have problems with a database generat

R: [pgadmin-support] timestamp parse error --- *** Migration PLUG-IN ***

2002-03-28 Thread Samuele Brignoli
Dave, I still have problems with a database generated from sql server 2000. I cannot inser data with pgadmin II ( and with the migration plugin ) to timestamps fields. This error was generated : 28/03/2002 10.26.41 - Error in pgAdmin II:frmSQLOutput.cmdSav

Re: [pgadmin-support] Migrating from MS-Access to Postgresql

2002-03-28 Thread Dave Page
Title: Message Hi,   Either change your query to:   SELECT * FROM "Invoices"   or, on the first step in the Migration Wizard, use the options to shift names to lower case, and re-migrate your data.   Of course, if you only have a few tables/columns you could just rename them in pgAdmin.