simple update closes connection. why?
| От | joseph speigle | 
|---|---|
| Тема | simple update closes connection. why? | 
| Дата | |
| Msg-id | 20040201014226.GA11863@www.sirfsup.com обсуждение исходный текст | 
| Ответы | Re: simple update closes connection.  why? Re: simple update closes connection. why? | 
| Список | pgsql-novice | 
hi,
this simple update closes the connection.  I use the database to dynamically update titles and directory on my web
pages.  
I show table structure first then the command then, uh, the closed connection.
calling=# \d calling;
                Table "public.calling"
   Column    |          Type          | Modifiers
-------------+------------------------+-----------
 filename    | character varying(40)  |
 description | character varying(180) |
 uname       | character varying(30)  |
Indexes: unique_filename unique btree (filename),
         unique_filename_idx btree (filename)
calling=# select * from calling limit 5;
    filename     |             description             | uname
-----------------+-------------------------------------+-------
 c_java_python   |                                     |
 conf            | old conf directory                  |
 mod_perl_webapp | main weba pplication, now a symlink |
 python          |                                     |
 ssh+ssl         |                                     |
(5 rows)
calling=# update calling set uname='pencilhead';
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!# \q
[pencilhead@www postgres]$ psql -d calling
Password:
Welcome to psql 7.3.1, the PostgreSQL interactive terminal.
Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit
calling=# select count(*) from calling;
 count
-------
  1683
(1 row)
calling=# \dp calling
       Access privileges for database "calling"
 Schema | Table |        Access privileges
--------+-------+---------------------------------
 public | calling   | {=,pencilhead=arwdRxt}
(1 row)
joe speigle
		
	В списке pgsql-novice по дате отправления: