Обсуждение: op error no question, but no error warning
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
On Wed, 12 Mar 2003, Theodore Petrosky wrote: > 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. That ; is inside a single quoted string, it's not an end of statement character, it's taken as a literal ;. The prompt should change to something like test-db'# to let you know that you're inside a literal.