[pgadmin-support] DBMigration-Wizard & Access 2002

2003-10-28 Thread Albin Blaschka
Hello, We found a problem with the Database Migration wizard and Access 2002: If we have a sequence in a table in Access 2002 and use the Migration Wizard to put the table into Postgres, the SQL-Statement for inserting the next value in the table is wrong. For example: Migration Wizard produces:

[pgadmin-support] Problem in pgAdmin III with paste

2003-10-28 Thread Carlos Leyán B.
I can´t paste from clipboard in sql window I use pgAdmin III 1.0.1.0 (spanish) in Windows XP Sp1, PostgreSQL 7.3 (cygwin) Also I miss an 'About pgAdmin...' in Help to see the version Thanks Carlos Chile ---(end of broadcast)--- TIP 6: Have yo

Re: [pgadmin-support] Problem in pgAdmin III with paste

2003-10-28 Thread Andreas Pflug
Carlos Leyán B. wrote: I can´t paste from clipboard in sql window I use pgAdmin III 1.0.1.0 (spanish) in Windows XP Sp1, PostgreSQL 7.3 (cygwin) From which application? Try the newest snapshot, recently we had a fix for some ancient apps. Also I miss an 'About pgAdmin...' in Help to see the v

Re: [pgadmin-support] DBMigration-Wizard & Access 2002

2003-10-28 Thread Christopher Kings-Lynne
mycolumn int4 DEFAULT nextval("'mycolumn_seq'"::text) NOT NULL ^^^^ this is the error -> ' " and correct it should be: mycolumn int4 DEFAULT nextval('myschema.mycolumn_seq'::text) NOT NULL ^^