RE: PGA2: add Locks, fix depend

> Hi Frank,
>
> I've committed this patch - thanks.
>
> I found something that looks a little odd in the dependency code
> however. In the screen shot attached, note the index that's listed
> twice, and the inclusion of the m_o_w column.
>
> -- Table: public.ca_tenant
> CREATE TABLE public.ca_tenant (
> id int4 DEFAULT nextval('ca_tenant_id'::text) NOT NULL,
> unit_id int4,
> name varchar(64),
> d_o_b date,
> p_o_b text,
> doctor varchar(64),
> doc_phone varchar(32),
> doc_fax varchar(32),
> surgery text,
> medical_notes text,
> care_notes text,
> carer_phone varchar(32),
> carer_fax varchar(32),
> general_notes text,
> m_o_w char(1) DEFAULT 'N',
> last_mod_by name,
> last_mod_ts timestamptz,
> CONSTRAINT ca_tenant_id_idx PRIMARY KEY (id)
> ) WITH OIDS;
> GRANT ALL ON TABLE public.ca_tenant TO PUBLIC;
> GRANT
ALL ON

T
ABLE public.ca_tenant TO postgres;
>
> -- Index: public.ca_tenant_idx
> CREATE INDEX ca_tenant_idx ON ca_tenant USING btree (id, unit_id);
>
> -- Trigger: set_last_mod ON public.ca_tenant
> CREATE TRIGGER set_last_mod BEFORE INSERT OR UPDATE ON public.ca_tenant
> FOR EACH ROW EXECUTE PROCEDURE set_last_mod();
> COMMENT ON TRIGGER set_last_mod ON public.ca_tenant IS 'Set the last
> modification timestamp and username.'
>
> Any ideas?
>
> Regards, Dave.
>
> > -----Original Message-----
> > From: frank_lupo [mailto:frank_lupo(at)email(dot)it]
> > Sent: 16 April 2003 08:39
> > To: pgadmin-hackers
> > Subject: [pgadmin-hackers] PGA2: add Locks, fix depend
> >
> >
> > I have add a new tab (frmmain) for show locks in
> > server,database,schema,user.
> >
> > Fix depend add column object.
> >

The index is listed twice because two columns are
referenc

e
d in one index.
For m_o_w column is present default value.

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Prova la Pasta di Gragnano, la prima al mondo: gustosa e massimo rendimento.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=984&d=16-4