"David Andersen" <[EMAIL PROTECTED]> writes:
> I am attempting to alter pg_enum.enumlabel to Text, but I seem to run into a
> strange permission problem with regards to system tables. I am not allowed
> to modify them even if I am a superuser.
ALTER TABLE is hardly gonna be sufficient on a system
Hi again,
I am attempting to alter pg_enum.enumlabel to Text, but I seem to run into a
strange permission problem with regards to system tables. I am not allowed
to modify them even if I am a superuser. Some output to make sure I do not
make any novice mistakes:
C:\Program Files\PostgreSQL\8.3\bi
Hi Tom,
Thanks a lot for the tip! I will try this. You probably saved be a few days
of work!
Regards,
David
On Sat, Jul 26, 2008 at 11:44 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "David Andersen" <[EMAIL PROTECTED]> writes:
> > One of the side tables is text with length of up to 900 character
"David Andersen" <[EMAIL PROTECTED]> writes:
> One of the side tables is text with length of up to 900 characters. My
> question is whether I could build PostgreSQL with NAMEDATALEN (which
> controls the max size of Enums) equal to 900?
I wouldn't recommend it. Consider changing pg_enum.enumlabe
Hi All,
This is my first post so please be gentle if I make any mistakes.
I know that ENUMs were not intended to be used instead of joins, but I
believe that I my case there will be huge saves on using Enums. Every night
I will drop the database and rebuild it from CSV files. The database will be
