Re: pg_dump and grants to PUBLIC

> So pg_dump does not work well in 7.3.4, and I have to pg_dump or the
> global equivalent to upgrade to 7.4. A bit of a catch 22 in there.

No, because you will use the 7.4 dump to dump and restore to 7.4 from
the 7.3.

>
>> For full disclosure I run a consulting company for PostgreSQL but there
>> are many others on this list who I am sure would also be willing to help
>> you.
>
> I also run a consulting company, I just have dumb questions before I
> leap into chasms, that's all ;)
>
> Been doing Database stuff for 16 years now and I still don't know it
> all ;)
>
>>> - is the underlying data structure the same, or are there some major
>>> architectural changes that will toast existing applications?
>> I recall (I think) that a big difference between 7.3 and 7.4 is some
>> timestamp / timezone issues.
>
> OK. Sounds like I am hosed until I build a new home for the clients so
> that they can test the new environment (possibly postgreSQL v.8).
>
> TTYL,
> Blair.
>


--

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/