problem s Postgres 7.0.3-2
Robert Vojta
vojta na ipex.cz
Čtvrtek Únor 22 19:15:24 CET 2001
Zdravim,
do dneska fungovala databaze bez problemu, tj. PostgreSQL 7.0.3-2 a
najednou se cela sesypala ;((
1) Select bez where kde to vsechno najde tak jak ma
netacc=> SELECT line,flag,value FROM lines ORDER BY line;
line | flag | value
...
absolon | ROUTER | 212.071.138.003
...
2) Select bez where, kde to najde to co ma taky
netacc=> SELECT * FROM lines;
...
absolon | ROUTER | 212.071.138.003
...
3) Posledni select
netacc=> select * from lines where line='absolonll';
line | flag | value | stamp
------+------+-------+-------
(0 rows)
4) Tabulka vypada takto
netacc=> \d lines
Table "lines"
Attribute | Type | Modifier
-----------+--------------+------------------------
line | varchar(64) | not null
flag | varchar(10) | not null
value | varchar(255) | not null default ''
stamp | timestamp | not null default 'now'
Indices: lines_line,
lines_line_flag
Nemate nekdo ideu proc se v poslednim selectu (tj. bod 3) nic neukazuje?
Uz to bezi pres mesic a dneska se to sesype ;((
S pozdravem,
Robert Vojta
--
_
|-| __ Robert Vojta <vojta na ipex.cz> -= Oo.oO =-
|=| [Ll] IPEX, s.r.o.
"^" ====`o
----- End forwarded message -----
S pozdravem,
Robert Vojta
--
_
|-| __ Robert Vojta <vojta na ipex.cz> -= Oo.oO =-
|=| [Ll] IPEX, s.r.o.
"^" ====`o
Další informace o konferenci Databases