madhu_d wrote
> Hi,
>
> I am writing a C program to access a PostgreSQL database, where
>
> I add a column if it doesn't exists in the table
>
> or, update the column, if the column already exits.
>
> Please suggest how to work with the conditional statements.
>
> Thanks!
>
> N.B. I wrote the
On 7/6/2014 9:06 AM, Tom Lane wrote:
David Wall writes:
There's one row in pg_largeobject_metadata per large object. The rows in
pg_largeobject represent 2KB "pages" of large objects (so it looks like
your large objects are averaging only 8KB-10KB apiece). The "metadata"
table was added in 9
Hi,
I am writing a C program to access a PostgreSQL database, where
I add a column if it doesn't exists in the table
or, update the column, if the column already exits.
Please suggest how to work with the conditional statements.
Thanks!
N.B. I wrote the following:
res = PQexec(conn, "IF COL_
David Wall writes:
>>> There are only 32 table, no functions, but mostly large objects. Not
>>> sure how to know about the LOs, but a quick check from the table sizes I
>>> estimate at only 2GB, so 16GB could be LOs. There are 7,528,803 entries
>>> in pg_catalog.pg_largeobject.
>> Hmm ... how ma
On 07/06/2014 05:44 AM, Ravi Kiran wrote:
hi,
I am using helios Eclipse for debugging my code in postgresql.
My aim is to know how postgresql uses join algorithms during the join
query, so I started to debug*nodenestloop.c* which is in the Executor
folder.
I gave break points in that file, But
hi,
I am using helios Eclipse for debugging my code in postgresql.
My aim is to know how postgresql uses join algorithms during the join
query, so I started to debug*nodenestloop.c* which is in the Executor
folder.
I gave break points in that file, But whenever I try to debug that file,
the cont
