On Fri, May 06, 2005 at 02:35:16PM +0200, Dirk Bade wrote:
>
> YES, you were right: the 7.1-binaries were still existent in /usr/bin - I
> wonder how this postmaster could coperate with V8.0.1 !?
If the files (binaries, libraries, headers, etc.) for each version
are installed in different places
I don't see this as half baked error checking, but rather, as error
reporting during a "half baked conversion". I prefer to know when the
converter encounters something it doesn't understand, rather than having
it silently enter nulls into the db.
It was the original error reporting that helped m
The following bug has been logged online:
Bug reference: 1652
Logged by: Villiam Manera
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.01
Operating system: linux
Description:pg_restore failed
Details:
from pgAdminIII i've created a backup
and then I've try
The following bug has been logged online:
Bug reference: 1653
Logged by: Guilherme
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Linux
Description:Bug in date
Details:
Dear Postgres Support,
I think found a bug in postgres, see the sql:
The following bug has been logged online:
Bug reference: 1651
Logged by: Peter van der Meer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.7-6
Operating system: Debian Linux (Unstable)
Description:static date field is not recognized automatically when
group
"Peter van der Meer" <[EMAIL PROTECTED]> writes:
> This query doesn't work:
> INSERT INTO testthis(id, somedate) SELECT 2 as id, '2005-02-02' as
> somedate GROUP BY id, somedate;
> Executing it reports:
> ERROR: column "somedate" is of type date but expression is of type text
The GROUP BY forc
"Guilherme" <[EMAIL PROTECTED]> writes:
> BILHETAGEM=# select sum(tm_arquivo) from bilhete where
> cd_caixa_postal_principal=1304 AND
> BILHETAGEM-# dt_transacao >= to_date('0104200500', 'ddmmHH24MISS')
> AND
> BILHETAGEM-# dt_transacao <= to_date('01042005235959', 'ddmmHH24MISS');
to_
Guilherme Silva <[EMAIL PROTECTED]> writes:
> Negative, i know what the to_date do.
I don't think you do, because you are feeding it input that it will
ignore --- the hh/mm/ss fields are just being thrown away.
regression=# select to_date('0104200500', 'ddmmHH24MISS');
to_date
-
It is really hard to currently alter
table schema.
Particularly the order of the table
schema.
to move a column position is very
hard. worse if your table as references (and which proper tables don't
?)
I would really like postgres to
model the alter syntax of mysql, which is reall
I understand you, sorry my english is too bad, ignore the last email.
I will try use to_timestamp.
Thanks.
Guilherme Silva
Programador - Planejamento
E-mail: [EMAIL PROTECTED]
Tel/Fax: +55 48 2106-5698
ICQ: #119540871
http://www.nexxera.com
NEXXERA Tecnologia e Serviços S.A.
"Seu ambiente eletrônic
Negative, i know what the to_date do.
See the "dt_transacao _/*<=*/_ to_date("
The <= make the first sql equal to second
Second: "dt_transacao _/*<*/_ to_date('0204200500')"
Guilherme Silva
Programador - Planejamento
E-mail: [EMAIL PROTECTED]
Tel/Fax: +55 48 2106-5698
ICQ: #119540871
http://www
Any more information on this?
---
Cade Cairns wrote:
> I will post a patch in a few days. I am extremely busy and don't have
> adequate time. I apologize for not having posted more in the first
> place.
>
> On 27-Mar-05,
>
> It is really hard to currently alter table schema.
>
> Particularly the order of the table schema.
>
> to move a column position is very hard. worse if your table as
references (and which proper
> tables don't ?)
Doesn't that in itself promote bad progra
Would someone be kind enough to advise this person to update his
antispam software, so that it doesn't include all of australia as
spammers?
Kind Regards,
John Hansen
_
From: System Administrator
Sent: Saturday, May 07, 2
I would really like postgres to model the alter syntax of mysql, which
is really easy to modify table schema especially to include the AFTER
col_name part.
A) why does the order of the columns in a particular table matter at all?
B) is this any sort of SQL standard?
---(e
15 matches
Mail list logo
