Ben Kim <[EMAIL PROTECTED]> wrote:
>
>
> Dear admins,
>
> I have a table whose primary key is a record_id with serial type.
>
> I would like to know, when I insert a new row, what was the value of the
> record_id that I just inserted. Since this is a multi user application, I
> cannot simply s
[EMAIL PROTECTED] (Josh Berkus) wrote:
>> Well, as I said, that's why I was asking - I'm willing to give it a go
>> if nobody can prove me wrong. :)
>
> Why not? If you have time?
True enough.
>> I thought you knew - OCFS, OCFS-Tools and OCFSv2 have not only been
>> open- source for quite a whi
I'm running several 7.3.4 database servers and would like to turn on all of
the statistic collectors to help with tuning. However, I don't have an idea
of what sort of performance impact doing this would have.
Does anyone have any rough numbers or documentation links that discuss the
performance
On Fri, 9 Apr 2004, Ben Kim wrote:
>
> Dear admins,
>
> I have a table whose primary key is a record_id with serial type.
>
> I would like to know, when I insert a new row, what was the value of the
> record_id that I just inserted. Since this is a multi user application, I
> cannot simply sel
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> The next way is to individually link thinks like indexes onto other
> volumes. The procedure is basically, create the index, figure out which
> file in $PGDATA/base/oidofyourdbhere is the index, shut down postgresql,
> copy to file elsewhere, softli
Grega,
> Well, as I said, that's why I was asking - I'm willing to give it a go
> if nobody can prove me wrong. :)
Why not? If you have time?
> I thought you knew - OCFS, OCFS-Tools and OCFSv2 have not only been open-
> source for quite a while now - they're released under the GPL.
Keen! Wo
On Thu, 8 Apr 2004, hal wrote:
> What is the best/simplest way to split:
> a database
> multiple databases
> a table
> multiple tables
> across more than one disk drive?
>
> I know that this has come up before but I can't find
> any info. A pointer to a HOWTO or other inf
Dear admins,
I have a table whose primary key is a record_id with serial type.
I would like to know, when I insert a new row, what was the value of the
record_id that I just inserted. Since this is a multi user application, I
cannot simply select max of the record_id or currval of the sequence.
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> When I restore a backup into a 7.4.2 database from a backup made on
> 7.2.1 database, using the clean option, I get the following error.
>
> pg_restore: [archiver (db)] could not execute query: ERROR: sequence
> "vm_emailjob_jobid_seq" does not
"Coby Beck" <[EMAIL PROTECTED]> writes:
> I get the following error trying to update a view:
> Thanks for the reply, Tom. Upgrading is on the TODO list for sure. In the
> meantime, is there not a way to change the default?
Not without recompiling. IIRC it's a #define in
backend/rewriter/rewrit
Title: Message
I have table defined
as follows:
create table
vm_emailjob(
JobId
serial
not null,
MessageId
varchar(128) not
null,
Recipients
bytea
not null,
SendTime
11 matches
Mail list logo
