TAN 47: El CapiTAN (Page 39)

Forum guidelines BT super discount
Other Resources My Cup of Joe » TAN 47: El CapiTAN Rss Feed  
Moderators: k9car363, the bear, DerekL, alicefoeller Reply
CLOSED
 
 
of 91
 
 
2008-09-18 3:31 PM
in reply to: #1682721

User image

Champion
11989
500050001000500100100100100252525
Philly 'burbs
Subject: RE: TAN 47: El CapiTAN

Buddhabuddha - 2008-09-18 3:58 PM

 I had wilt issues too...

 

Did you go see a urologist?



2008-09-18 3:32 PM
in reply to: #1682820

User image

Extreme Veteran
928
50010010010010025
Chesapeake, VA
Subject: RE: TAN 47: El CapiTAN
mrbbrad - 2008-09-18 4:31 PM

Buddhabuddha - 2008-09-18 3:58 PM

 I had wilt issues too...

 

Did you go see a urologist?



Thanks for reminding me, I need to schedule that VAS...
2008-09-18 3:32 PM
in reply to: #1682820

User image

Expert
1069
10002525
Wauwatosa
Subject: RE: TAN 47: El CapiTAN
mrbbrad - 2008-09-18 3:31 PM

Buddhabuddha - 2008-09-18 3:58 PM

 I had wilt issues too...

 

Did you go see a urologist?


yeah, she said, "stop hangin out in TAN you'll catch sumtin"
apparently she was right
2008-09-18 3:33 PM
in reply to: #1679113

User image

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: TAN 47: El CapiTAN
Does anyone know a lot about databases?  I need help.
2008-09-18 3:34 PM
in reply to: #1682829

Subject: ...
This user's post has been ignored.
2008-09-18 3:35 PM
in reply to: #1682829

Champion
11989
500050001000500100100100100252525
Philly 'burbs
Subject: RE: TAN 47: El CapiTAN

Artemis - 2008-09-18 4:33 PM Does anyone know a lot about databases?  I need help.

 

Sure!

2008-09-18 3:36 PM
in reply to: #1682829

Extreme Veteran
928
50010010010010025
Chesapeake, VA
Subject: RE: TAN 47: El CapiTAN
Artemis - 2008-09-18 4:33 PM

Does anyone know a lot about databases?  I need help.


eeek. not a DBA, but I do work alot with talking to and from a DB'z.. whats the question?
2008-09-18 3:38 PM
in reply to: #1682829

Champion
9060
5000200020002525
Charlottesville, Virginia
Subject: RE: TAN 47: El CapiTAN

Artemis - 2008-09-18 4:33 PM Does anyone know a lot about databases?  I need help.

yep, lotsa stuff.

2008-09-18 3:40 PM
in reply to: #1679113

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: TAN 47: El CapiTAN

Using PostgreSQL.  Column definition is numeric(4,0), so I can't add anything greater than 9,999. 

But, I need to add in values greater than that.  Is there a way to modify the column defintion to numeric(5,0) without dropping and readding the column?  There's too much data in this table to do that.

2008-09-18 3:43 PM
in reply to: #1682844

Subject: ...
This user's post has been ignored.
2008-09-18 3:45 PM
in reply to: #1682851

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: TAN 47: El CapiTAN
Rynamite - 2008-09-18 4:43 PM
Artemis - 2008-09-18 4:40 PM

Using PostgreSQL.  Column definition is numeric(4,0), so I can't add anything greater than 9,999. 

But, I need to add in values greater than that.  Is there a way to modify the column defintion to numeric(5,0) without dropping and readding the column?  There's too much data in this table to do that.

Ah, just as I suspected....

 

 

I have no idea.

None of the useful stuff got covered in my DB class either.  Just theory.



2008-09-18 3:49 PM
in reply to: #1682814

Sensei
Sin City
Subject: RE: TAN 47: El CapiTAN

Buddhabuddha - 2008-09-18 1:29 PM
Aikidoman - 2008-09-18 3:17 PM I think I lost my Ipod shuffle yesterday...  Cry
those darn things need homing devices

I think I might have left it on top of a gym locker while searching through my bag and walked away without it.

It grew legs and took off to find a new home, I'm afraid....

To be honest, I forgot how much I paid for it so I thought it was $150 down the drain.  but I just looked at the Ipod store, $69 bucks....  Not as bad as I thought to get a replacement...  That's only about 5 drinks on the strip.  Still sucks though...



Edited by Aikidoman 2008-09-18 3:49 PM
2008-09-18 3:49 PM
in reply to: #1682853

Subject: ...
This user's post has been ignored.
2008-09-18 3:52 PM
in reply to: #1682853

Champion
9060
5000200020002525
Charlottesville, Virginia
Subject: RE: TAN 47: El CapiTAN
Artemis - 2008-09-18 4:45 PM
Rynamite - 2008-09-18 4:43 PM
Artemis - 2008-09-18 4:40 PM

Using PostgreSQL.  Column definition is numeric(4,0), so I can't add anything greater than 9,999. 

But, I need to add in values greater than that.  Is there a way to modify the column defintion to numeric(5,0) without dropping and readding the column?  There's too much data in this table to do that.

Ah, just as I suspected....

 

 

I have no idea.

None of the useful stuff got covered in my DB class either.  Just theory.

I believe

ALTER TABLE table_name
 MODIFY column_name column_type;

i.e.

ALTER TABLE supplier
 MODIFY supplier_name   varchar2(100)     not null;

I believe since you are making the column bigger not smaller it shouldn't be a problem.  Different databases handle it better than others.  (I am a bit rusty though)

2008-09-18 3:52 PM
in reply to: #1682866

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: TAN 47: El CapiTAN
Rynamite - 2008-09-18 4:49 PM
Artemis - 2008-09-18 4:45 PM
Rynamite - 2008-09-18 4:43 PM
Artemis - 2008-09-18 4:40 PM

Using PostgreSQL.  Column definition is numeric(4,0), so I can't add anything greater than 9,999. 

But, I need to add in values greater than that.  Is there a way to modify the column defintion to numeric(5,0) without dropping and readding the column?  There's too much data in this table to do that.

Ah, just as I suspected....

 

 

I have no idea.

None of the useful stuff got covered in my DB class either.  Just theory.

Maybe highlight the column, right click, and edit?

Right!  And then I just copy and paste all my data in there!

2008-09-18 3:53 PM
in reply to: #1679113

Champion
9060
5000200020002525
Charlottesville, Virginia
Subject: RE: TAN 47: El CapiTAN
do you have a test DB you can check before trying this with live data?

2008-09-18 3:54 PM
in reply to: #1682877

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: TAN 47: El CapiTAN
dalessit - 2008-09-18 4:52 PM
Artemis - 2008-09-18 4:45 PM
Rynamite - 2008-09-18 4:43 PM
Artemis - 2008-09-18 4:40 PM

Using PostgreSQL.  Column definition is numeric(4,0), so I can't add anything greater than 9,999. 

But, I need to add in values greater than that.  Is there a way to modify the column defintion to numeric(5,0) without dropping and readding the column?  There's too much data in this table to do that.

Ah, just as I suspected....

 

 

I have no idea.

None of the useful stuff got covered in my DB class either.  Just theory.

I believe

ALTER TABLE table_name
 MODIFY column_name column_type;

i.e.

ALTER TABLE supplier
 MODIFY supplier_name   varchar2(100)     not null;

I believe since you are making the column bigger not smaller it shouldn't be a problem.  Different databases handle it better than others.  (I am a bit rusty though)

Thanks!!!  I'll have to boot up the development server and try that out tomorrow.  Trying it on the production server is a way to get to get kicked out of school without a degree...

2008-09-18 3:55 PM
in reply to: #1682886

Champion
9060
5000200020002525
Charlottesville, Virginia
Subject: RE: TAN 47: El CapiTAN
no worries, if you don't need it until tomorrow I will try it out on my MySQL DB tonight and check it.
2008-09-18 3:55 PM
in reply to: #1679113

Extreme Veteran
928
50010010010010025
Chesapeake, VA
Subject: RE: TAN 47: El CapiTAN
you can use the Alter table command to do that and not drop any data.
2008-09-18 3:55 PM
in reply to: #1682882

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: TAN 47: El CapiTAN

dalessit - 2008-09-18 4:53 PM do you have a test DB you can check before trying this with live data?

Yes!  I keep a development server around for things like this.  I'll dump the DB as it stands now so I can restore it if things go horribly wrong.

Which reminds me that I need to burn a CD of the current iteration of the production server.

2008-09-18 3:56 PM
in reply to: #1682888

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: TAN 47: El CapiTAN

dalessit - 2008-09-18 4:55 PM no worries, if you don't need it until tomorrow I will try it out on my MySQL DB tonight and check it.

If you want.  Either way, I still have to try it on ours before my adviser is going to sign off on it.



2008-09-18 3:59 PM
in reply to: #1679113

Champion
5868
50005001001001002525
Urbandale, IA
Subject: RE: TAN 47: El CapiTAN
Homeward - see you all tomorrow, except Ryan and Kido - have fun stormin the castle boys.
2008-09-18 4:02 PM
in reply to: #1679113

Champion
34263
500050005000500050005000200020001001002525
Chicago
Subject: RE: TAN 47: El CapiTAN
What a day. I'm tired now. But must run 7 and lift tonight.
2008-09-18 4:16 PM
in reply to: #1679113

Science Nerd
28760
50005000500050005000200010005001001002525
Redwood City, California
Subject: RE: TAN 47: El CapiTAN

I am tired, too.  Today has been frustrating.

Now I have to eat and get ready for a knitting class tonight.

2008-09-18 4:16 PM
in reply to: #1679113

Expert
1069
10002525
Wauwatosa
Subject: RE: TAN 47: El CapiTAN
mmmm afternoon snacks are good
New Thread
CLOSED
Other Resources My Cup of Joe » TAN 47: El CapiTAN Rss Feed  
 
 
of 91