List z dnia: Sat, 17 Jun 2000, :
> > I usually prefer the following trick for preventing long locking
> > times. On every
> > table I define a timestamp field which is updated every time the record is
> > written to the database. If a user edits a record (without
> > locking) and commit his chan
Hi,
I am dealing with an already built database from which there is no
documentation available on how it was designed. I can list indices, tables,
and sequences from the DB using the '\d' command. But how can I list
functions, triggers, and other implementations?
Thank in advance for your reply.
> "Philip Poles" <[EMAIL PROTECTED]> writes:
>> I'm having some trouble using a hash index on an INT8 field in
>> postgres7.0(release):
> Looks like we don't have a hash function defined for int8 :-(.
> This is going to have to stay broken until 7.1, given our rule
> against changing system catal
On Sun, 18 Jun 2000, Vipin Samtani wrote:
> How can I auto-increment numeric primary keys? So on a table called
> "Test1" with fields "ID" and "Name" when I do an INSERT, I only type
>
> INSERT INTO Test1 values ('Bob');
>
> instead of
>
> INSERT INTO Test1 values (1, 'Bob');
>
> Is this impl
Vipin Samtani wrote:
>
> How can I auto-increment numeric primary keys? So on a table called
> "Test1" with fields "ID" and "Name" when I do an INSERT, I only type
>
> INSERT INTO Test1 values ('Bob');
>
> instead of
>
> INSERT INTO Test1 values (1, 'Bob');
>
> Is this implemented in PostgreS
How can I auto-increment numeric primary keys? So on a table called
"Test1" with fields "ID" and "Name" when I do an INSERT, I only type
INSERT INTO Test1 values ('Bob');
instead of
INSERT INTO Test1 values (1, 'Bob');
Is this implemented in PostgreSQL 7?
-Vipin
On Sun, 18 Jun 2000, Peter Eisentraut wrote:
> Using RPMs is also popular, if applicable.
Thanks for the plug :-).
Seriously, that is exactly why the RPM's are split as they are -- you _can_
install just the main package and get a working psql and libpq (with all docs)
installation to connect to
Precedence: bulk
Hello Gunther,
On 18-Jun-00 00:41:24, you wrote:
>the Universal Postal Union [http://www.upu.int] keeps some record
>about internationally used address formats. However, what they have is
>also not a standard, but more of an inventory of national peculiarities
>[http://www.up
Rick Delaney writes:
> Is there a source distribution to install just psql?
No (at least not officially). If you want to use psql you probably have a
server somewhere, and there's no reason why you couldn't reuse that source
tree.
> What I'm looking for is a quick and easy way to install psql a