From: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | daisychain rows to detect value |
Date: | 2017-03-27 09:58:35 |
Message-ID: | 201703271058.35123.gary.stainburn@ringways.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I have a table of network ports. These ports are part of something, be it a
cabinet patch panel, or a network switch.
np_connects_to references a hardware ID, which can be the cabinet,
switch,router etc. containing the port.
no_port is the name of the port.
np_untagged_vlan is the VLAN ID for the port, with NULL being allowed.
Each port can then be patched to another port.
For example:
np_connects_to | np_port | np_patch_to | np_patch_port | np_untagged_vlan
---------------+---------+-------------+---------------+-----------------
1 | 01 | | | 1
2 | 23B | 1 | 01 |
3 | 23A | 2 | 23B |
Row 1 shows a switch port set to VLAN 1.
Row 2 shows a port in cabiner 'A' (Panel B port 23) which is patched to the
switch port.
Row 3 shows a port in cabinet 'B' (Panel A port 23) which is the other end
cabinet A port 23B
Is there a way to be able to propogate the untagged VLAN to any port patched
to it?
--
https://fundraise.cancerresearchuk.org/page/garys-march-march
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-03-27 15:59:37 | Re: daisychain rows to detect value |
Previous Message | Aniruddha Deshpande | 2017-03-27 08:29:51 | Column widening without outage |