simple update closes connection. why? - Mailing list pgsql-novice

From joseph speigle
Subject simple update closes connection. why?
Date
Msg-id 20040201014226.GA11863@www.sirfsup.com
Whole thread Raw
Responses Re: simple update closes connection. why?
Re: simple update closes connection. why?
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: "[" is a nuisance...
Next
From: joseph speigle
Date:
Subject: Re: simple update closes connection. why?