Hi,
Previously I wanted to ensure that I am inserting something unique into a
table, the answer was to create a unique index on the relevant columns.
But what if I don't want to get an error which would force a rollback? Say
I want to insert something if it doesn't already exist, but update it
At 09:02 PM 21-04-2000 -0200, Manuel Lemos wrote:
>It's a trade-off. If you want to take the most of a database non-standard
>extensions, don't use database abstraction packages at all. If you want
>flexibility in such way that your applications will be more portable,
>database abstraction packa
Does PostGreSQL-6.5.2 have a record limit?
Ive read a few posts that say older versions (6.3.x) had a limit of 8k..
and they said it would change soon.. does this limit still exist?
Thanks.
I'm a little confused, what is the proper and reccomended procedure for
upgrading from 6.3.x to 6.5.x? I recently did an upgrade install of
Mandrake 7 on a Redhat 5.2 box and I would like to get my old data into the
6.5.x PostgreSQL that comes with Mandrake.
I searched the archives a bit and tri
Hi,
I need some custom rounding function (say 1 or two decimal points),
what would be the simplest way to make one?
- Robert
P.S. I tried to create one in C like
#include
#include "postgres.h"
double tst5(double x) {
return x; // ... whatever neede
Hello!
How can i recreate system indexes in PostgreSQL 6.5.x? I understand
there is a REINDEX command for v7 but how is it possible to do the same
thing in v6.5 (there is on 6.5.2 and one 6.5.3 running). The problem is
that such indexes as
pg_attribute_attrelid_index
pg_attribute_relid_attnam_i
>
> > It feels like there should be some *really* obvious answer to this
> > question, and I'll find myself whacking my forehead in self-abasement
> > and out of sheer relief to have found the answer to a problem that
> > should not have bothered me in the first place since the answer is too
> >
