Hi all.
I am a french student working in a computer
science lab in France. (http://www.lisi.ensma.fr)
Actually we use postgresql with Cygwin
interface.
We use PostgreSQL 7.3.2.
We want to increaze namedatalen 64 to 128 or
256.
So ...
1- I open the file postgre_ext.h. (and
save)
2- Run /.c
Given:
orig_sav=# \d realtycompany_contacts
Table "public.realtycompany_contacts"
Column | Type | Modifiers
--++---
realtycompany_id | bigint | not null
contact_id | bigint | not null
and
orig_sav=# \d users
Table "public.use
Hello,
I saw this 'bug' reported in the Firebird SourceForge website for the
Firebird 1.0 server. They confirmed it as a bug! I tried it in PostgreSQL
7.2 (I know its an old release but I do not have a newer version installed,
and in any case I am only using the server for reserach purposes).
Postg
"Jerome Chochon" <[EMAIL PROTECTED]> writes:
> 1- I open the file postgre_ext.h. (and save)
> 2- Run /.configure
> 3- Run make and make install
Try a "make distclean" before you configure. I think you've got object
files that aren't getting rebuilt.
regards, tom lane
---
On Thu, 1 Jul 2004, Ilir Gashi wrote:
> I saw this 'bug' reported in the Firebird SourceForge website for the
> Firebird 1.0 server. They confirmed it as a bug! I tried it in PostgreSQL
> 7.2 (I know its an old release but I do not have a newer version installed,
> and in any case I am only using
Aha. Well, you learn something new every day. Yes, the behavior is
indeed like "contact_id is not null", which was true for all rows in
users, which explains why I lost all my data in realtycompany_contacts.
Thank goodness for backups. Many thanks!
James
On Jul 1, 2004, at 3:35 PM, Stephan Szabo
On Thu, 1 Jul 2004, James Robinson wrote:
> Why in the world does this statement parse and run:
>
> orig_sav=# delete from realtycompany_contacts where contact_id in
> (select contact_id from users);
> DELETE 1634
>
> Since users has *no* column contact_id ? One would expect the statement
> to fa
Title: problem installing on aix 4.3.3
Hello,
i've got your mail through postgres site.
As i've seen you've managed to compile successfully on aix.
I'm actually trying to (aix 4.3.3, xlc v5.0) and get some errors :
- readline library (installed ok, but not seen correctly by configure. i've put
Stephan Szabo <[EMAIL PROTECTED]> writes:
> Technically speaking, I believe the queries are simply invalid without the
> presence of casts from the spec's standpoint.
Right. The reason PG doesn't error is that we have an implicit cast
from integer to text. I've opined before that we should mark
Hello,
I saw this 'bug' reported in the Firebird SourceForge website for the
Firebird 1.0 server. They confirmed it as a bug! I tried it in PostgreSQL
7.2 (I know its an old release but I do not have a newer version installed,
and in any case I am only using the server for reserach purposes).
P
Title: VACUUM analyze verbose is skipping tables
Hello.
We are having a big database with a lot of tables. We are running daily vacuum analyze vith the vacuumdb script.
The problem is that the script is skipping skipping some tables that really should have been vacuumed.
Does anybody know
I was trying to get postgresql to run / build on a windows system.
Following the instructions to get Mingw32 and MSys as directed on the site -
http://momjian.postgresql.org/main/writings/pgsql/project/win32.html
These are the steps I followed.
I downloaded MINGW32 and MSys and installed then
POSTGRESQL BUG REPORT TEMPLATE
Your name : Roberto João Lopes Garcia
Your email address : [EM
On Thu, Jul 01, 2004 at 16:42:29 -0300,
Roberto João Lopes Garcia <[EMAIL PROTECTED]> wrote:
>
> When I use string concatenator || and there are fields of type date whith NULL values
> the result is an enpty string. Please see example:
This isn't a bug. If either operand of || is NULL, then the
"Lending, Rune" <[EMAIL PROTECTED]> writes:
> The problem is that the script is skipping skipping some tables that really
> should have been vacuumed.
AFAIR vacuum will only skip tables if (a) you don't own them and (b)
you're not superuser.
The vacuumdb script really should always be run as a P
On Thu, 1 Jul 2004, Roberto [iso-8859-1] João Lopes Garcia wrote:
> When I use string concatenator || and there are fields of type date whith NULL values
> the result is an enpty string. Please see example:
The result is NULL. This is the correct result.
"If either S1 or S2 is the null value,
3 and '003 ' are not the samething!!!
Do not forget that F1 and F2 are paded with spaces also.
Maybe you want to use varchar instead.
Ilir Gashi wrote:
Hello,
I saw this 'bug' reported in the Firebird SourceForge website for the
Firebird 1.0 server. They confirmed it as a bug! I tried it in
Postg
> Following the instructions to get Mingw32 and MSys as
> directed on the site -
> http://momjian.postgresql.org/main/writings/pgsql/project/win32.html
>
> These are the steps I followed.
>
> I downloaded MINGW32 and MSys and installed then.
> Then downloaded postgresql-7.4.3.tar.gz from the ft
18 matches
Mail list logo
