postgresql mail server and archiving software
Is the software that is used for this, the postgresql mail server and
archiver, available?
I which to setup a internal development mailing system that can be used
by engineers
as a forum for discussion, a mechanism for recording arguments used and
results, and
allowing new hire engineers to review why the hell things are being done
in any
particular way.
Thanks.
Richard
Hi
I migrated MS Access2000 .mdb file to postgreSQL 7.1.3.
I used PGAdminII_1.2.0 and Database Migration Vizard Plug-in.
There seems to be no problem.
For only one table there is a problem that;
*When I use PGAdminII to view the data there is no problem. My data is
there!!
*When I use MSAccess and ODBC link for that table it shows "#DELETED#" for
every field and every record.
Only the last record's first field is true data.
I attached the screenshots in a word document.
I couldn't find what is my wrong.
Can you help me ?
Serkan
Attachments:
SCREENSHOT.docapplication/msword; name=SCREENSHOT.docDownload+3-6
When you created the ODBC link, did you tell it which field is the primary
key? It allows you to not specify, but then Access has trouble keeping its
screen in sync with the back end.
Wes Sheldahl
Serkan Bektaş <sbektas@karincaint.com.tr>@postgresql.org on 02/18/2002
01:42:29 PM
Sent by: pgsql-general-owner@postgresql.org
To: <pgsql-general@postgresql.org>
cc:
Subject: [GENERAL] MDB 2 POSTGRESQL MIGRATION PROBLEM
Hi
I migrated MS Access2000 .mdb file to postgreSQL 7.1.3.
I used PGAdminII_1.2.0 and Database Migration Vizard Plug-in.
There seems to be no problem.
For only one table there is a problem that;
*When I use PGAdminII to view the data there is no problem. My data is
there!!
*When I use MSAccess and ODBC link for that table it shows "#DELETED#" for
every field and every record.
Only the last record's first field is true data.
I attached the screenshots in a word document.
I couldn't find what is my wrong.
Can you help me ?
Serkan
(See attached file: SCREENSHOT.doc)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Attachments:
SCREENSHOT.docapplication/msword; name="=?iso-8859-2?Q?SCREENSHOT.doc?="Download+3-6
Import Notes
Resolved by subject fallback
The field was primary key in my mdb and the type was autonumber.
it is primary key in PostgreSQL as seen above
- Table: Firma
CREATE TABLE "Firma" (
"SirketKodu" text NOT NULL,
"SirketAdi" text,
"Adres1" text,
"Adres2" text,
"Adres3" text,
"Il�e" text,
"Il" text,
"�lke" text,
"VergiDveNo" text,
"B�lgeNo" text,
"MuhasebeKodu" text,
"Vade" int2,
"Note" text,
"EksikBilgi" bool,
"Lade" float8,
"SirketKisaAd" text,
"E�antiyon" text,
"Grup" text,
"Ta�KaraIth" bool,
"Ta�KaraIhr" bool,
"Ta�HavaIth" bool,
"Ta�HavaIhr" bool,
"Ta�DenizIth" bool,
"Ta�DenizIhr" bool,
"Ta�DemirIth" bool,
"Ta�DemirIhr" bool,
"OrgG�mrIth" bool,
"OrgG�mIhr" bool,
"OrgTesvik" bool,
"Sigorta" bool,
"e-mail" text,
"www" text,
CONSTRAINT "Firma_pkey" PRIMARY KEY ("SirketKodu")
);
the design view in MSAccess for table Firma, field SirketKodu seems to be a
primary key too.
I ODBC linked it again and it dont ask me if there is a primary key in
MSACCESS.
I am confused !!!
Because other tables works well...
Serkan
-----Original Message-----
From: wsheldah@lexmark.com [mailto:wsheldah@lexmark.com]
Sent: 18 �ubat 2002 Pazartesi 22:33
To: Serkan Bektaďż˝
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] MDB 2 POSTGRESQL MIGRATION PROBLEM
When you created the ODBC link, did you tell it which field is the primary
key? It allows you to not specify, but then Access has trouble keeping its
screen in sync with the back end.
Wes Sheldahl
Serkan Bektaďż˝ <sbektas@karincaint.com.tr>@postgresql.org on 02/18/2002
01:42:29 PM
Sent by: pgsql-general-owner@postgresql.org
To: <pgsql-general@postgresql.org>
cc:
Subject: [GENERAL] MDB 2 POSTGRESQL MIGRATION PROBLEM
Hi
I migrated MS Access2000 .mdb file to postgreSQL 7.1.3.
I used PGAdminII_1.2.0 and Database Migration Vizard Plug-in.
There seems to be no problem.
For only one table there is a problem that;
*When I use PGAdminII to view the data there is no problem. My data is
there!!
*When I use MSAccess and ODBC link for that table it shows "#DELETED#" for
every field and every record.
Only the last record's first field is true data.
I attached the screenshots in a word document.
I couldn't find what is my wrong.
Can you help me ?
Serkan
(See attached file: SCREENSHOT.doc)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly