Thank you for your answer.
Still, one doubt.
On Mon, 15 Mar 1999, Herouth Maoz wrote:
> INSERT...
> SELECT currval( 'seq_name' );
>...
> It will also give you the
>correct number even if between the INSERT and the SELECT, another process
>or another connection also made an i
Hi!
When I insert data into a table with a sequence associated to a column
(and the required trigger), how can I know the value the sequence has
just generated ? (think in parallel accesses)
Would this approach be the answer ?
begin work
insert...
select max...
commit
,,,
Hello,
>found a link to PgAdmin once but did not get the chance to download it.
In the help about it reads: www.mindzone.demon.co.uk
>most recent version they can send me? Also if anyone knows of some
>Postgress~ friendly admin apps for Windows let me know.
I use pgaccess on a X-window wi
Hi!
I'm designing a database and I'm having some trouble selecting
which optimizations should I implement (in Postgres and maybe Oracle)
Can someone please give an opinion on the following ?:
As an example of my doubt:
Imagine two tables representing a trivial h
Hi!
In the source tree of Postgresql you'll find:
postgresql-6.4.2/contrib/fulltextindex
and you'll read README:
-
The included software is an attempt to add some sort of Full Text Indexing
support to PostgreSQL. I mean by this that we can ask question
Hi!
I'm still dealing with "QueryBuffer exceeded, core dump..".
I've tried using
psql -e < xx.sql
psql -f xx.sql
as Bob Dusek suggested...
or inside psql with \i xx.sql.
I've broken the sql script in two... after a few lines of the second part,
the same error... should I download again and re
Hi there, portuguese fellow!
You can use pgaccess. It comes with pgsql source. If you use the
postgresql binaries, I advise you to use sources and compile and install
it [postgresql] - it's a really easy process... and you'll get version
6.4.2.
Any way, if you insist in binaries, I think that a
On Fri, 15 Jan 1999, Bob Dusek wrote:
>Sorry,
>> One way to execute .sql scripts in your database is this:
>> psql -e dbname < script.sql
>> good luck,
>> Bob
Ohh... sorry... I forgot to thank you! Thank you... :)
Silvio Emanuel Nunes Barbosa de Macedo
mailto:[EMAIL PROTECTED]
On Fri, 15 Jan 1999, Bob Dusek wrote:
>Sorry,
>I should have been more clear:
>> One way to execute .sql scripts in your database is this:
>> psql -e dbname < script.sql
>That should be done from the command line.
Yes... I imagined
Anyway, Query Buffer being full I CAN understand..., but
c
Hi!
I was using psql to insert data into the database.
I have *.sql files with the necessary scripts, eg:
insert into descritor values (4992,'MARCHAS DE LISBOA','te','cl');
After many inserts... I've got this message:
query buffer max length of 2 exceeded
query line ignored
and then, a fe
Hi!
Where can I find the required patch to upgrade 6.4.1 to 6.4.2 ?
I am reluctant to download 5.x Mb each time a minor update is released.
(6.4, 6.4.1, an now 6.4.2 = 17Mb!)
Please note that I've already check psql-patches mailing list archives...
Is /pub/patches supposed to be almost empty
11 matches
Mail list logo