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