Witam, wdrażam q-in-q, problem polega na tym....
CREATE TABLE networks
(
id integer NOT NULL DEFAULT
nextval(('networks_id_seq'::text)::regclass),
name character varying(255) NOT NULL DEFAULT ''::character
varying,
address bigint NOT NULL DEFAULT 0,
mask character varying(16) NOT NULL DEFAULT ''::character varying,
interface character varying(16) NOT NULL DEFAULT ''::character
varying,
gateway character varying(16) NOT NULL DEFAULT ''::character
varying,
dns character varying(16) NOT NULL DEFAULT ''::character varying,
dns2 character varying(16) NOT NULL DEFAULT ''::character varying,
domain character varying(64) NOT NULL DEFAULT ''::character
varying,
wins character varying(16) NOT NULL DEFAULT ''::character varying,
dhcpstart character varying(16) NOT NULL DEFAULT ''::character
varying,
dhcpend character varying(16) NOT NULL DEFAULT ''::character
varying,
disabled smallint NOT NULL DEFAULT 0,
notes text NOT NULL DEFAULT ''::text,
CONSTRAINT networks_pkey PRIMARY KEY (id),
CONSTRAINT networks_address_key UNIQUE (address),
CONSTRAINT networks_name_key UNIQUE (name)
)
chce tam zapisać wartość "bge1:vlan1703:vlan104" - czyli 21 znaków
Proponuje rozszerzyć pole do varying(25)
Pozdrawiam Miłosz