op error no question, but no error warning

From: Theodore Petrosky <tedpet5(at)yahoo(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: op error no question, but no error warning
Date: 2003-03-12 14:09:42
Message-ID: 20030312140942.36024.qmail@web41015.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

This isn't all my problem...

I was going through tutorials, and I typed in the
example for inheritance. I had a typo that did not
throw an error and I think it should.

i created the tables from the cities, capitals example
and then tried to insert.

test-db=# insert into capitals (name, population,
state) values ('Trenton', '543565, 'New Jersey');

my typo is the extra single quote before the number. I
received no error message, but of course there was no
insert. I would have assumed that the trailing ';'
would have terminated the insert and if there is an
error, it should have said so.

i am on mac osx 10.2.4 with PostgreSQL 7.3.2 on
powerpc-apple-darwin6.4, compiled by GCC gcc (GCC) 3.1
20020420 (prerelease)

Ted

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2003-03-12 14:48:39 Re: RI Bug In Inherited Table
Previous Message cn cn 2003-03-12 12:27:06 RI Bug In Inherited Table