| From: | claud yu <claud(at)tera(dot)cs(dot)tku(dot)edu(dot)tw> |
|---|---|
| To: | pgsql-bugs(at)postgreSQL(dot)org |
| Subject: | 7.0 bug ?? |
| Date: | 2000-05-01 00:49:42 |
| Message-ID: | 390CD4A6331.1B23CLAUD@tera.cs.tku.edu.tw |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
-----------------------------------------------
freechange-# \d accountloginrec
Table "accountloginrec"
Attribute | Type | Modifier
----------------------+-------------+----------
regaccounttype | smallint | not null
regloginname | char(20) | not null
reglgoinpassword | varchar(20) | not null
regaccounthint | varchar(32) |
regaccounteffectdate | date |
regaccountexpireeate | date |
eshopcode | integer | not null
companycode | integer |
freechange-#
freechange=# select eshopcode from accountloginrec;
eshopcode
-----------
10
11
11
12
13
14
(6 rows)
freechange=# insert into accountloginrec values (1,'test','test','test',NOW(),NOW()+30,Max(eshopcode)+1,null);
ERROR: Attribute 'eshopcode' not found
-----------------------------------------------
The same syntax at 6.5.3 is OK !!
It happen at 7.0rc1 and 7.0rc2
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-05-01 01:31:04 | Re: 7.0 bug ?? |
| Previous Message | root | 2000-04-29 18:13:01 | Postgresql 7.0 bug |