Обсуждение: update
Hi, Does pgadmin support update/change of tables and columns? Cagil Seker.
Yes, pretty much everything that is supported by PostgreSQL is supported by pgAdmin. Regards, Dave. > -----Original Message----- > From: Çagil Seker [mailto:cagils@biznet.com.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
I think I have a problem with the security tab. I cannot change any security setting. I cannot create any schema. I cannotchange/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@vale-housing.co.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@biznet.com.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 >
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@biznet.com.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@vale-housing.co.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@biznet.com.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@postgresql.org) >
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 tablesand columns inside the public schema of my DB. But I cannot edit them. The properties tab allows me to edit only thename and comment for the columns for example, the other options are all disabled (gray shaded). Regards, Cagil. > -----Original Message----- > From: Dave Page [mailto:dpage@vale-housing.co.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@biznet.com.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@vale-housing.co.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@biznet.com.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@postgresql.org) > > >
Yes, that is because PostgreSQL doesn't allow you to change these options. PostgreSQL 7.3 (released last Wednesday) willallow you use of Schemas, and you can also edit column defaults and null/not null. You can also now drop columns whichyou couldn't do in 7.2.x. Regards, Dave. > -----Original Message----- > From: Çagil Seker [mailto:cagils@biznet.com.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@vale-housing.co.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@biznet.com.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@vale-housing.co.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@biznet.com.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@postgresql.org) > > > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org) >