From: | jim(at)reptiles(dot)org (Jim Mercer) |
---|---|
To: | maillist(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian) |
Cc: | jim(at)reptiles(dot)org, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] inet and cidr type problems |
Date: | 1999-07-07 06:10:38 |
Message-ID: | m111kuk-00080OC@mailbox.reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
> > i have been playing with the inet and cidr types, and i have noticed a couple
> > problems, and would entertain suggestions as to how to fix them without
> > necessarily breaking how other people might be using them.
> >
> > - a table with an element of type inet, will show "0.0.0.0/0" as "00/0"
>
> This was fixed in 6.5.
>
> > i suspect this can be fixed in src/backend/adt/network.c or some such.
> >
> > - when creating a table with either type inet or type cidr as a primary, unique
> > key, the elements "198.68.123.0/24" and "198.68.123.0/27" are considered
> > equal.
>
> This has been addressed in 6.5 too.
cool.
i'm not sure how to query the bug list, so can you tell me if the following
problems have been addressed?
- ALTER TABLE tab_name RENAME TO new_name;
this command does not deal with extended tables (my name for when
a table physically exceeds 2Gig, on unix, and creates a second (third)
extent in the .../data/base/dbname dir.
- VACUUM VERBOSE;
has problems with extended tables, something like "cannot truncate
extended file".
--
[ Jim Mercer Reptilian Research jim(at)reptiles(dot)org +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail. ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 1999-07-07 06:58:18 | Re: [GENERAL] Auto-timeout on all queries |
Previous Message | Kane Tao | 1999-07-07 03:59:54 | Re: [GENERAL] Auto-timeout on all queries |
From | Date | Subject | |
---|---|---|---|
Next Message | Ansley, Michael | 1999-07-07 07:01:44 | RE: Joins and links |
Previous Message | Leon | 1999-07-07 06:03:40 | Re: [HACKERS] Fwd: Joins and links |