[GENERAL] 8Ko limitation

2000-07-20 Thread Xavier ZIMMERMANN
Hi, I am thinking about using postgreSQL to manage large geographic databases connected to a GIS. I would really appreciate if someone could give me some answers to those 3 questions : what about performances with postgreSQL and large databases, the object size limitation (8192 bytes) is

[GENERAL] Return PGresult

2000-07-20 Thread anuj
Hi, PGresult is a structure. I want to return PGresult pointer.(Code is given below.) Is this possible ? if yes , please give me the solution. Thanks in Advance. Anuj === /* tempdb=>create table tbltemp (id int4, name varchar(30)); */ #include #include main() { int

Re: [GENERAL] unique constraint - bug?

2000-07-20 Thread Oliver Elphick
Tom Lane wrote: >Merrill Oveson <[EMAIL PROTECTED]> writes: >> It appears as though the null value inserted for column b causes an >> abrogation of the unique constaint. > >Two nulls are never considered equal, therefore the unique constraint >does not trigger. > >This is correct b

[GENERAL] Re: [HACKERS] 8Ko limitation

2000-07-20 Thread Karel Zak
>what about performances with postgreSQL and large databases, >the object size limitation (8192 bytes) is really not acceptable for this Now you can change this limit in config.h, the possible range is 8Kb - 32Kb. In new 7.1 version will this limit dead forever (see TOAST project).

Re: [GENERAL] Re: [HACKERS] 8Ko limitation

2000-07-20 Thread Stephane Bortzmeyer
On Thursday 20 July 2000, at 10 h 0, the keyboard of Karel Zak <[EMAIL PROTECTED]> wrote: > And what is a "large database"? 1, 5 .. 10Gb? If yes, (IMHO) the PostgreSQL > is good choice. Even on Linux? I'm studying a database project where the raw data is 10 to 20 Gb (it will be in several t

Re: [GENERAL] Re: [HACKERS] 8Ko limitation

2000-07-20 Thread Jules Bean
On Thu, Jul 20, 2000 at 10:35:41AM +0200, Stephane Bortzmeyer wrote: > On Thursday 20 July 2000, at 10 h 0, the keyboard of Karel Zak > <[EMAIL PROTECTED]> wrote: > > > And what is a "large database"? 1, 5 .. 10Gb? If yes, (IMHO) the PostgreSQL > > is good choice. > > Even on Linux? I'm stud

Re: [GENERAL] Re: [HACKERS] 8Ko limitation

2000-07-20 Thread Karel Zak
On Thu, 20 Jul 2000, Stephane Bortzmeyer wrote: > On Thursday 20 July 2000, at 10 h 0, the keyboard of Karel Zak > <[EMAIL PROTECTED]> wrote: > > > And what is a "large database"? 1, 5 .. 10Gb? If yes, (IMHO) the PostgreSQL > > is good choice. > > Even on Linux? I'm studying a database pro

Re: [GENERAL] Return PGresult

2000-07-20 Thread Dave Smith
anuj wrote: > > Hi, > PGresult is a structure. > I want to return PGresult pointer.(Code is given below.) > Is this possible ? if yes , please give me the solution. > Thanks in Advance. > Anuj > === > /* tempdb=>create table tbltemp (id int4, name varchar(30)); */ > #inclu

[GENERAL] Migrating from 7.0RC1 to 7.0.2 and initdb

2000-07-20 Thread Guillaume Perréal
Hello. A few days ago, I tried to migrate from v7.0RC1 to 7.0.2. Since major version number doesn't change, I just stopped postmaster, installed the new RPM (I work under Redhat 6.1) and started the new postmaster. I got an error such as 'System catalog version changed, you should use initdb'. We

RE: [GENERAL] Return PGresult

2000-07-20 Thread anuj
Thanks,I'm trying PGresult pointer to pointer. And Why don't PGresult pointer variable reqiure memory allocation (malloc()? Like /* resu = (PGresult *)(malloc(sizeof(PGresult)); */ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dave Smith Sent: Thursday