Harry Hochheiser <[EMAIL PROTECTED]> writes:
> Running Postgres 7.4 on Panther, there seems to be a problem with
> setting a timestamp column to have a default of 'now':
There was an intentional change of behavior --- see the release notes.
The supported way to do this is to use CURRENT_TIMESTAMP
Garrett Dangerfield <[EMAIL PROTECTED]> writes:
> I am trying to load a data file into a table using the copy command.
> When I do it on a small subset of the data (gotten using the Linux head command) it
> all works fine, but when I run it on the full dataset, I get the following error:
> ERROR:
On Thu, Feb 12, 2004 at 12:46:27 -0600,
Javier Carlos <[EMAIL PROTECTED]> wrote:
>
> bd_temporal=> SELECT * FROM tbl_temp WHERE var < 0.20;
> var
> --
> 0.1
> 0.11
> (2 rows)
> bd_temporal=> SELECT * FROM tbl_tem
"Javier Carlos" <[EMAIL PROTECTED]> writes:
>When I make a select and in the WHERE section I use the = (EQUAL)
> operator whith a column of real datatype the results of the query is 0
> rows even if there exist rows that match the condition.
This isn't a bug, it's a natural consequence of the
POSTGRESQL BUG REPORT TEMPLATE
Your name : Javier Carlos Rivera
Your email address : fjc
Running Postgres 7.4 on Panther, there seems to be a problem with
setting a timestamp column to have a default of 'now':
createdb test
create table bar (date timestamp DEFAULT 'now');
insert into bar DEFAULT VALUES;
insert into bar DEFAULT VALUES;
insert into bar DEFAULT VALUES;
insert into bar
Not sure if this is a bug or not, but it seems like one.
I am trying to load a data file into a table using the copy command.
When I do it on a small subset of the data (gotten using the Linux head command) it
all works fine, but when I run it on the full dataset, I get the following error:
ERRO
On Mon, Feb 09, 2004 at 03:56:16PM -0400, PostgreSQL Bugs List wrote:
> that refers to a column in one of my tables called "auto". The program
> compiles successfully on 7.3.
I just committed a fix so 'auto' works as it should. Hopefully I've
added all symbols that were missing. So if you find a
