Skip site navigation (1) Skip section navigation (2)

RE: PGA2: add Locks, fix depend

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 (view raw or flat)
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


pgadmin-hackers by date

Next:From: Dave PageDate: 2003-04-16 15:05:13
Subject: Re: PGA2: add Locks, fix depend
Previous:From: Dave PageDate: 2003-04-16 13:48:28
Subject: Re: comment on pgAdminIII source

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group