> Greetings,
> there seems to be a slight bug in the parsing of the
> nextval function, tested under 6.4.2.
> It affects also the SERIAL type.
>
> Symptom :
>
> CREATE SEQUENCE "AA";
> -- Correct, quoted identifier is allowed;
> SELECT NEXTVAL('AA');
> --Produces Error
> --aa.nextval: sequence d
I live in an area with a lot of early French explorer influence therefore
may french names. I'm building a database for a website/directory of
businesses, organizations, attractions, etc. for the locals and visitors.
I'd like to handle miss-spellings or rather phonetic spellings for those
that ha
We have problems with aggregates in some views. It is a know problem on
the TODO list.
> I got an error when accessing a view. The view looks like this:
>
> CREATE TABLE ar_contacts(
> contact_seq int,
> update_date date,
> period date,
> paid
At 11:59 +0200 on 15/3/99, Silvio Emanuel Barbosa de Macedo wrote:
> If there is an insert between my INSERT and SELECT, won't the counter be
> increased ? The only way I can understand this is the transaction locks
> inserts... so, in fact there could not exist another insert...
The counter is
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
Silvio Emanuel Barbosa de Macedo wrote:
> If there is an insert between my INSERT and SELECT, won't the counter be
> increased ? The only way I can understand this is the transaction locks
> inserts... so, in fact there could not exist another insert...
It should be a counter attached to your ses
on using fti function at fulltextindex contrib packages Iam problem.
System:
OSF1 V3.2C
Postmaster:
postgresql-6.4.2
start ./bin/postmaster -i -B 256 -d 3
Debug outpout:
bash$ FindExec: found "/home/serv_data/SQL/./bin/p
At 2:57 +0200 on 15/3/99, Silvio Emanuel Barbosa de Macedo wrote:
> 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
I'm in a bind. I have a Unix TAR backup of the "data" directory from
a PG 6.1 database, but have lost the binaries. I need to get access
to the data.
The new 6.4 binaries will not work with the older data format, so I
need a copy of the 6.1 binaries (preferably the complete 6.1 PG
archive) t
