Danny O'Brien typed this on 03/09/2004 07:45 AM:
>
> My next test was an attempt to manually enter values into the database
> (called "ourdb" for the sake of this test):
>
> ourdb=# INSERT INTO usr (id, fname, lname, login, password, admin_flag,
> client_id) VALUES (4, 'Fred', 'Friendly', 'Fred', 'xxxxx', 'A', 1)
> ourdb-#
>
Typically, you would end your INSERT statement with a ';'
In your example, you do not, otherwise the db would give you back some
sort of response.
> The database did not accept the new information. Why not? More
> questions....
>
-Robby
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
rrussell@commandprompt.com | Telephone: (503) 222.2783