Обсуждение: Comment 1966 added to page ddl-alter.html of version 7.4
Author: Alex French <alexfrench@gmail.com> ---- Note that pg does not support changing the type of a column. Instead, use something like the code below to change, say, avarchar(32) into varchar(64) (assuming the collumn is called abc): BEGIN; ALTER TABLE mytable ADD COLUMN abc_new varchar(64); UPDATE mytable SET abc_new = abc; ALTER TABLE mytable RENAME abc TO abc_old; ALTER TABLE mytable RENAME abc_new TO abc; COMMIT; If you're chaning the type of the column radically, you need to do more fancy type casting, but that's the theory. ---- Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/ddl-alter.html Reject: http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1966 Edit: http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1966 Delete: http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1966
Are we going to continue to see all interactive document comments posted to the www list? --------------------------------------------------------------------------- nobody wrote: > Author: Alex French <alexfrench@gmail.com> > ---- > Note that pg does not support changing the type of a column. Instead, use something like the code below to change, say,a varchar(32) into varchar(64) (assuming the collumn is called abc): > > BEGIN; > ALTER TABLE mytable ADD COLUMN abc_new varchar(64); > UPDATE mytable SET abc_new = abc; > ALTER TABLE mytable RENAME abc TO abc_old; > ALTER TABLE mytable RENAME abc_new TO abc; > COMMIT; > > If you're chaning the type of the column radically, you need to do more fancy type casting, but that's the theory. > ---- > Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/ddl-alter.html > Reject: http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1966 > Edit: http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1966 > Delete: http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1966 > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
On Wed, 5 Jan 2005, Bruce Momjian wrote: > > Are we going to continue to see all interactive document comments posted > to the www list? > I'd like to see them in separate phorum "PostgreSQL documentation discussions", or just redirect them to separate mailing list. > --------------------------------------------------------------------------- > > nobody wrote: >> Author: Alex French <alexfrench@gmail.com> >> ---- >> Note that pg does not support changing the type of a column. Instead, use something like the code below to change, say,a varchar(32) into varchar(64) (assuming the collumn is called abc): >> >> BEGIN; >> ALTER TABLE mytable ADD COLUMN abc_new varchar(64); >> UPDATE mytable SET abc_new = abc; >> ALTER TABLE mytable RENAME abc TO abc_old; >> ALTER TABLE mytable RENAME abc_new TO abc; >> COMMIT; >> >> If you're chaning the type of the column radically, you need to do more fancy type casting, but that's the theory. >> ---- >> Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/ddl-alter.html >> Reject: http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1966 >> Edit: http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1966 >> Delete: http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1966 >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 4: Don't 'kill -9' the postmaster >> > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
Oleg Bartunov wrote: > On Wed, 5 Jan 2005, Bruce Momjian wrote: > > > > > Are we going to continue to see all interactive document comments posted > > to the www list? > > > > I'd like to see them in separate phorum "PostgreSQL documentation discussions", > or just redirect them to separate mailing list. Ageed. They would make more sense going to the docs list or a separate list. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
On Wednesday 05 January 2005 15:13, Bruce Momjian wrote:
> Oleg Bartunov wrote:
> > On Wed, 5 Jan 2005, Bruce Momjian wrote:
> > > Are we going to continue to see all interactive document comments
> > > posted to the www list?
> >
> > I'd like to see them in separate phorum "PostgreSQL documentation
> > discussions", or just redirect them to separate mailing list.
>
> Ageed. They would make more sense going to the docs list or a separate
> list.
Previous discussion's led to people on the docs list not wanting to see them,
and all the people who moderate them being on www so we left them here
thinking folks could set up mail filters to junk them if they wanted.
It does seem a number of people are complaining, so if you want to reopen the
issue I suppose we could. Ideally it could wait till after 8.0 is released?
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Robert Treat wrote: > On Wednesday 05 January 2005 15:13, Bruce Momjian wrote: > > Oleg Bartunov wrote: > > > On Wed, 5 Jan 2005, Bruce Momjian wrote: > > > > Are we going to continue to see all interactive document comments > > > > posted to the www list? > > > > > > I'd like to see them in separate phorum "PostgreSQL documentation > > > discussions", or just redirect them to separate mailing list. > > > > Ageed. They would make more sense going to the docs list or a separate > > list. > > Previous discussion's led to people on the docs list not wanting to see them, > and all the people who moderate them being on www so we left them here > thinking folks could set up mail filters to junk them if they wanted. > > It does seem a number of people are complaining, so if you want to reopen the > issue I suppose we could. Ideally it could wait till after 8.0 is released? What filter should I use, nobody@? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
On Wed, 5 Jan 2005, Bruce Momjian wrote: > Robert Treat wrote: >> On Wednesday 05 January 2005 15:13, Bruce Momjian wrote: >>> Oleg Bartunov wrote: >>>> On Wed, 5 Jan 2005, Bruce Momjian wrote: >>>>> Are we going to continue to see all interactive document comments >>>>> posted to the www list? >>>> >>>> I'd like to see them in separate phorum "PostgreSQL documentation >>>> discussions", or just redirect them to separate mailing list. >>> >>> Ageed. They would make more sense going to the docs list or a separate >>> list. >> >> Previous discussion's led to people on the docs list not wanting to see them, >> and all the people who moderate them being on www so we left them here >> thinking folks could set up mail filters to junk them if they wanted. >> >> It does seem a number of people are complaining, so if you want to reopen the >> issue I suppose we could. Ideally it could wait till after 8.0 is released? > > What filter should I use, nobody@? We could setup a seperate list for "administrative traffic" like the comments, news items, etc ... ? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
nobody wrote: > Author: Alex French <alexfrench@gmail.com> > ---- > Note that pg does not support changing the type of a column. Instead, use something like the code below to change, say,a varchar(32) into varchar(64) (assuming the collumn is called abc): Hi all, PG 8 allows for changing the column type doesn't it, as one of the "important new features"? Regards and best wishes, Justin Clift <snip> -- "One who sees the invisible can do the impossible." + Frank Gaines
Marc G. Fournier wrote: <snip> > We could setup a seperate list for "administrative traffic" like the > comments, news items, etc ... ? Sounds appropriate pgsql-slavestothewww ? ;) Regards and best wishes, Justin Clift -- "One who sees the invisible can do the impossible." + Frank Gaines
Bruce Momjian wrote: > Are we going to continue to see all interactive document comments posted > to the www list? As a person that does the approving/rejecting/etc of these comments, having an email about them is really useful and welcome. But, since it seems like it's annoying most others, then maybe we should have a mailing list setup for them? Regards and best wishes, Justin Clift -- "One who sees the invisible can do the impossible." + Frank Gaines
On Thu, 6 Jan 2005, Justin Clift wrote: > Marc G. Fournier wrote: > <snip> >> We could setup a seperate list for "administrative traffic" like the >> comments, news items, etc ... ? > > Sounds appropriate > > pgsql-slavestothewww ? ;) I was thinking more on the lines of pgsql-www-admin ... but the above would work too ;) ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Marc, > We could setup a seperate list for "administrative traffic" like the > comments, news items, etc ... ? Speaking of which, what happened to sysadmins@postgresql.org? Did we get that set up? -- __Aglio Database Solutions_______________ Josh Berkus Consultant josh@agliodbs.com www.agliodbs.com Ph: 415-752-2500 Fax: 415-752-2387 2166 Hayes Suite 200 San Francisco, CA
On Thu, 6 Jan 2005, Josh Berkus wrote: > Marc, > >> We could setup a seperate list for "administrative traffic" like the >> comments, news items, etc ... ? > > Speaking of which, what happened to sysadmins@postgresql.org? Did we get > that set up? Must have missed that request ... I know there was talk about it, but it seemed that there wasn't a decision on under which domain it should be ... who should be the owner for it? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Marc, > Must have missed that request ... I know there was talk about it, but it > seemed that there wasn't a decision on under which domain it should be ... > who should be the owner for it? I can own it. I'll set up a list under one of my domains, and if I get the sub and unsub messages, then I can make sure that the "emergency" list matches the live list. --Josh -- __Aglio Database Solutions_______________ Josh Berkus Consultant josh@agliodbs.com www.agliodbs.com Ph: 415-752-2500 Fax: 415-752-2387 2166 Hayes Suite 200 San Francisco, CA