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
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
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
>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).
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
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
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
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
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
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
10 matches
Mail list logo