Re: [GENERAL] Migrating Access to Postgres

2003-10-01 Thread Fabrizio Mazzoni
Hello .. i did the migration and my advice is that you forget about the automatic translation tools... I took the access database and recreated all af the tables and relationships between them manually in postgres. I also added all the necessary indexes at design time .. Basiclly you have to

Re: [GENERAL] PGAdmin III 1.0.0 Released

2003-10-01 Thread Dann Corbit
Not everyone will be upgraded to version 7.3 or higher. Does not work with older versions of PostgreSQL. Just a heads up for people still using something older than 7.3. You might have mentioned that in your release announcement. -Original Message- From: Matthew T. O'Connor

Re: [GENERAL] Divide by zero...

2003-10-01 Thread Jan Wieck
Robert Creager wrote: When grilled further on (Tue, 30 Sep 2003 09:26:19 -0400), Mike Leahy [EMAIL PROTECTED] confessed: I have a query that calculates various using variables from a survey database. As with any survey, there are many instantces of null values. I'm wondering if there is any

[GENERAL] Can anyone recommend a good PostGres admin tool?

2003-10-01 Thread Rick Seeger
We're looking for a (preferrably free) Windows (or browser) based PG admin tool to use in our office. I've only ever used the psql command line interface, so I don't have any experience with the GUI tools out there. Any help appreciated. Cheers, Rick ---(end of

Re: [GENERAL] Can anyone recommend a good PostGres admin tool?

2003-10-01 Thread Robby Russell
Rick Seeger wrote: We're looking for a (preferrably free) Windows (or browser) based PG admin tool to use in our office. I've only ever used the psql command line interface, so I don't have any experience with the GUI tools out there. Any help appreciated. Cheers, Rick Rick, This might help you:

Re: [GENERAL] Can anyone recommend a good PostGres admin tool?

2003-10-01 Thread Martin Marques
El Mié 01 Oct 2003 19:58, Rick Seeger escribió: We're looking for a (preferrably free) Windows (or browser) based PG admin tool to use in our office. I've only ever used the psql command line interface, so I don't have any experience with the GUI tools out there. Any help appreciated. From

[GENERAL] Server recommendations

2003-10-01 Thread Dennis Gearon
Anyone got links to good db server boxes, not rackmount though? Include any for HP, Gateway, etc. -- You are behaving like a man, is an insult from some women, a compliment from a good woman. ---(end of broadcast)--- TIP 9: the planner will

[GENERAL] BLOBs, pg_dump pg_restore

2003-10-01 Thread Howard Lowndes
My situation is that I am interacting PHP 4.1.2 to PostgreSQL 7.2.2 I have no difficulty inserting and managing BLOBs into the Large Object system table, and I have a user table called images which maintains the relationship between the BLOB loid and the identity that relates to it in my user

Re: [GENERAL] BLOBs, pg_dump pg_restore

2003-10-01 Thread Howard Lowndes
On Wed, 1 Oct 2003, Joshua D. Drake wrote: Hello, We usually have a table called something like file_objects that contains information like the loid, content-type, filesize etc... that we reference. Yes, that's what I also have got: test= \d images Table images

Re: [GENERAL] BLOBs, pg_dump pg_restore

2003-10-01 Thread Tom Lane
Howard Lowndes [EMAIL PROTECTED] writes: Now, my concern is that if I use pg_dump with the --clean or --create, and the --blobs options, and then try a pg_restore from the resulting archive file, I believe the BLOBs will take up a different loid to the one they came from, and hence the

Re: [GENERAL] BLOBs, pg_dump pg_restore

2003-10-01 Thread Howard Lowndes
On Wed, 1 Oct 2003, Tom Lane wrote: Howard Lowndes [EMAIL PROTECTED] writes: Now, my concern is that if I use pg_dump with the --clean or --create, and the --blobs options, and then try a pg_restore from the resulting archive file, I believe the BLOBs will take up a different loid to the

Re: [GENERAL] BLOBs, pg_dump pg_restore

2003-10-01 Thread Tom Lane
Howard Lowndes [EMAIL PROTECTED] writes: On Wed, 1 Oct 2003, Tom Lane wrote: No, because pg_restore has logic to adjust the references to match the new BLOB OIDs. If you have a test case where this fails to work, let's see it ... No, I don't have any example, it is an enquiry. What I am