Re: update

Yes, that is because PostgreSQL doesn't allow you to change these options. PostgreSQL 7.3 (released last Wednesday) will allow you use of Schemas, and you can also edit column defaults and null/not null. You can also now drop columns which you couldn't do in 7.2.x.

Regards, Dave.

> -----Original Message-----
> From: Çagil Seker [mailto:cagils(at)biznet(dot)com(dot)tr]
> Sent: 29 November 2002 14:19
> To: PGAdmin-Support-List (E-mail)
> Subject: Re: [pgadmin-support] update
>
>
>
> I create a DB. I cannot create a new schema (it is disabled).
> So I use public schema of that DB. I can create new tables
> and columns inside the public schema of my DB. But I cannot
> edit them. The properties tab allows me to edit only the name
> and comment for the columns for example, the other options
> are all disabled (gray shaded).
>
> Regards,
>
> Cagil.
>
>
> > -----Original Message-----
> > From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> > Sent: 29 Kasim 2002 Cuma 16:20
> > To: Çaðýl Þeker; PGAdmin-Support-List (E-mail)
> > Subject: RE: [pgadmin-support] update
> >
> >
> > The public schema is just a dummy on PostgreSQL 7.2, hence
> > you can't modify it.
> >
> > When you say you cannot change or edit a table, why not?
> What happens?
> >
> > Regards, Dave.
> >
> > > -----Original Message-----
> > > From: Çagil Seker [mailto:cagils(at)biznet(dot)com(dot)tr]
> > > Sent: 29 November 2002 14:10
> > > To: PGAdmin-Support-List (E-mail)
> > > Subject: Re: [pgadmin-support] update
> > >
> > >
> > >
> > > I think I have a problem with the security tab. I cannot
> > > change any security setting. I cannot create any schema. I
> > > cannot change/edit any table, column etc. And the security
> > > tab for public schema says PUBLIC group has only "create,
> > > usage" rights; but all the fields are disabled. I cannot add
> > > change a group or privilidge here. I'm stuck. What can I do?
> > > And sorry if I miss smt easy.
> > >
> > > Cagil.
> > >
> > >
> > > > -----Original Message-----
> > > > From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> > > > Sent: 29 Kasim 2002 Cuma 15:27
> > > > To: Çaðýl Þeker; PGAdmin-Support-List (E-mail)
> > > > Subject: RE: [pgadmin-support] update
> > > >
> > > >
> > > > Yes, pretty much everything that is supported by PostgreSQL is
> > > > supported by pgAdmin.
> > > >
> > > > Regards, Dave.
> > > >
> > > > > -----Original Message-----
> > > > > From: Çagil Seker [mailto:cagils(at)biznet(dot)com(dot)tr]
> > > > > Sent: 29 November 2002 13:19
> > > > > To: PGAdmin-Support-List (E-mail)
> > > > > Subject: [pgadmin-support] update
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > > Does pgadmin support update/change of tables and columns?
> > > > >
> > > > > Cagil Seker.
> > > > >
> > > > > ---------------------------(end of
> > > > > broadcast)---------------------------
> > > > > TIP 5: Have you checked our extensive FAQ?
> > > > >
> > > > http://www.postgresql.org/users-lounge/docs/faq.html
> > > >
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 2: you can get off all lists at once with the
> unregister command
> > > (send "unregister YourEmailAddressHere" to
> > > majordomo(at)postgresql(dot)org)
> > >
> >
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>