Question 1: If table A has as its primary key "a_pk" and table B
inherits table A, then table B also has as its primary key a_pk. Is
that correct?
Question 2: If I want table C to have a foreign key on both A and B, is
the following syntax correct? (I'm using 7.0.3)
CREATE TABLE c (
Peter Eisentraut wrote:
>
> Daniel J. Kressin writes:
>
> > I know that you can make table names case-sensitive by putting them
> > in quotes. Is there a way (compile-time option, anything?) to make
> > them case-sensitive by default (i.e. without quotes)?
>
&
I have a table with an inet column, which I entered in order initially,
so they came out like:
1.2.3.4
1.2.3.5
1.2.3.40
1.2.3.41
After updating, say, 1.2.3.5, it moves to the end. I understand why,
that's not the problem. Adding an 'ORDER BY host(ip)' clause causes the
ordering to be:
Larry Rosenman wrote:
>
> I believe this is fixed in 7.1.
>
> LER
Is there a workaround for 7.0.x? Short of adding extra columns to store
the separate octets and sorting on them?
--
Dan
Kressin .---.
/___ \/ __ \ | Unix SysAdmin
