July 25, 2008 12:11am pdt

1. adrpo 24,265
2. ivanovn 24,020
3. earthman2 21,510
4. drazen_n... 11,400
5. gheist 10,260
6. fridom 6,000
7. lesouef 5,900
8. TomasHelgi 5,625
9. grant300 5,300
10. angelIII 5,000
11. rokov 4,500
12. tusharkan... 3,900
13. sanjooz 3,800
14. ee_rlee 3,750
15. mark_wills 3,600

1. earthman2 428,643
2. ivanovn 91,657
3. gheist 84,279
4. m1tk4 62,462
5. adrpo 43,659
6. rjkimble 31,347
7. grant300 28,122
8. ravenpl 20,699
9. GGuzdziol 16,660
10. fridom 15,000
11. drazen_n... 11,400
12. TomasHelgi 11,125
13. angelIII 9,000
14. Ghitza 7,600
15. ldbkutty 6,730

05.13.2008 at 07:01PM PDT, ID: 23400050 | Points: 500

	[x] Attachment Details

Postgres - alter table add column - and it doesn't exist after

Zone: PostgreSQL Database

Tags: postgres alter table add column - column does not exist

Hi Experts,

Looks like a bug in Postgres - I just installed 8.3.1-1, hoping it was fixed... I added a column in PGAdmin III - I do a query (select * from mytable limit 1) and I get a row which shows my column exists in psql command line. Then I try to update this new column and I get the error that it does not exist. What to do???

Many thanks,
Mike

Start your free trial to view this solution

Question Stats

Zone: Database

Question Asked By: thready

Question Asked On: 05.13.2008

Participating Experts: 1

Points: 500

Translate:

Loading Advertisement...

20080236-EE-VQP-29 / EE_QW_EXPERT_20070906