Tom Lane wrote:
van Elsacker Frans <[EMAIL PROTECTED]> writes:
All my tables (more than 100) have a field datumi of type date default
today, as this example:
CREATE TABLE tabel (
datumi date DEFAULT 'today',
);
This does not work anymore in PG 7.4. You need something lik
Hi all,
I got the error message reported in the subject and
I could not find anything about it anywhere.
I cannot get any explain plan for this
query.
I'm working on PosgreSQL 7.4-1, the latest cygwin
distribution I can find.
The query generating the error is:
select *from info where p
Olivier Hubaut wrote:
> I think this won't get the same result he expects. As I know, the
> CURRENT_DATE will always give the current day, not the day you
> inserted the row.
Your knowledge is incorrect.
---(end of broadcast)---
TIP 8: explain anal
Hi All,
I am trying to install pgaccess on a redhat 7.2 linux server with
postgres7.4. Everything seems to be alright but when I go to run pgaccess I
get an error message saying
Application initialization failed: no display name and no $DISPLAY
environment v
ariable
Error in startup script: in
Alessandro Depase wrote:
> The query generating the error is:
This is useless unless we know table schema, what data is in the tables,
and what software version you use.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Olivier Hubaut <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> This does not work anymore in PG 7.4. You need something like
>> datumi date DEFAULT CURRENT_DATE,
> I think the now()::date seems to be a better way to translate the
> 'today' value.
There is no real difference.
"Alessandro Depase" <[EMAIL PROTECTED]> writes:
> I got the error message reported in the subject and I could not find anythi=
> ng about it anywhere.
It's a bug, but we can't do much about it unless you provide a
reproducible example. In addition to the query itself, schemas
for the tables invol
On 16/12/2003 13:29 vijaykumar M wrote:
Hi All,
I am trying to install pgaccess on a redhat 7.2 linux server with
postgres7.4. Everything seems to be alright but when I go to run
pgaccess I get an error message saying
Application initialization failed: no display name and no $DISPLAY
environme
On Tuesday 16 December 2003 13:29, vijaykumar M wrote:
> Hi All,
> I am trying to install pgaccess on a redhat 7.2 linux server with
> postgres7.4. Everything seems to be alright but when I go to run pgaccess
> I get an error message saying
>
> Application initialization failed: no display name an
Peter Eisentraut wrote:
> > The query generating the error is:
>
> This is useless unless we know table schema, what data is in the tables,
> and what software version you use.
I can just give you (at the end of this answer) the DDL for the fields I
reported in the query, but they are enough becau
On Tuesday 16 December 2003 15:34, Alessandro Depase wrote:
>
People smarter than me are looking at this, but I can give you some quick
feedback.
> Version? In my previous message I told that I'm using 7.4-1 on cygwin
> distribution. What other info do you need? How can I get them?
Are you sure i
The version declared by the cygwin setup is 7.4-1 (I don't know if the '-1'
is the same that your '.1' or, for example, a progressive in the cygwin
PostgreSQL build sequence).
A 'select version()' answers with this information:
PostgreSQL 7.4 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.3.1 (cyg
12 matches
Mail list logo
