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 по дате отправления: