| From: | ricardorsj(at)uol(dot)com(dot)br |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Query doesn't work anymore on 7.2 |
| Date: | 2002-02-26 12:01:03 |
| Message-ID: | 200202261201.JAA10996@walters.uol.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello there. I've just upgraded to pgsql 7.2 on netbsd and one of my programs stopped working because of a parser error:
carteirinhas=# \d registros
Table "registros"
Column | Type | Modifiers
-----------+------------------------+-----------
matricula | integer |
resp | character varying(50) |
tipo | character(1) |
nome | character varying(50) |
data | date |
hora | time without time zone |
baixa | boolean |
carteirinhas=# insert into registros values (1234,'Teste','A','Teste',date('now'),time('now'),false);
ERROR: parser: parse error at or near "'"
Although it's clear that this program was done in 10 minutes, it was working on 7.1.3. Has something changed or it seems to be a bug in 7.2's parser?
[]'s
Ricardo.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Janning Vygen | 2002-02-26 12:02:05 | Sql basic Query |
| Previous Message | Martijn van Oosterhout | 2002-02-26 08:17:04 | Re: transaction abortion |