We need to change the maximum length of table/column name lengths, and it looks
as if changing NAMEDATALEN in src/include/postgres_ext.h and recompiling
postgres.
2 questions:
a) Do I need to dump the database and reload ? (my guess is yes but only a
guess ...)
b) any caveats or warnings abou
Sima asked:
<...>
>
> While starting the postgreSQL service, i get the error message as
>
> Could not open process token "error code-5"
>
> Appreciate if any one can help me out on this issue.
>
Without more information its hard to say -- you might provide some information
about what operati
FWIW, we've got a billing database with several moderate tables, one is 48
million rows with about 75k per day; and some much larger tables that are
effectively partitioned by date so that some client software (Excel, etc.)
doesn't choke on them. And we've got some spatial tables that dwarf the
Suresh Gupta asked:
>
> I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to 8.2.5. I
> don't want to disturb the first version now. I want to install second
> one separately and need to test with my application. If it works fine, I
> will activate only the latest one and other version
David --
>
> I want to have a table with a timestamp field that automatically gets the
> value of now() on insert. The timestamp will never be updated. I assume I
> need to create a trigger to do this. If there is an easier way, please
> advise.
Perhaps, make the column so it has a default va