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 o

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 [mailto:

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 an

[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 broadca

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: ht

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. >Fro

[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 ign

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

2003-10-01 Thread Andrew Rawnsley
I've found DBVisualizer to be an excellent tool. Its Java based, and not specific to Postgres. There are free and payware options. http://www.minq.se/ (I don't work for them.) On Wednesday, October 1, 2003, at 06:58 PM, Rick Seeger wrote: We're looking for a (preferrably free) Windows (or brow

[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 t

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 loi

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. Wha