From: | frank_lupo <frank_lupo(at)email(dot)it> |
---|---|
To: | dpage <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | RE: PGA2: add Locks, fix depend |
Date: | 2003-04-16 14:07:44 |
Message-ID: | HDFWKW$DE654296CA5849B7205B7D659F87F043@email.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-04-16 15:05:13 | Re: PGA2: add Locks, fix depend |
Previous Message | Dave Page | 2003-04-16 13:48:28 | Re: comment on pgAdminIII source |