[EMAIL PROTECTED] wrote:
Thank you.
You stated that the SELECT currval('orderid_id_seq') statement is a
separate query and must be treated as such.
This gives me cause for concern. My intention is to obtain the
orderid of the order inserted at that moment, but if I am to use a
separate qu
Hi,
when vacuuming a big table with some indexes I experienced a locking of
VACUUM.
As I understood the theory the normal VACUUM should never lock something
or influence queries made to the table.
When running VACUUM it was vacuuming first the indexes, after that it
was vacuuming the table
emails divididos por categorias emails divididos por categorias programas para
spam:
http://www.segmails.vze.com
ou
http://www.vendemails.cjb.net
ou
http://geocities.yahoo.com.br/webneggocios/listagemnova.htm
e-mails e-mail free marketing programas para spam listas de e-mails por
profissão
em
On Thu, Aug 18, 2005 at 11:01:27PM -0400, Bruce Momjian wrote:
> Enzo D'addario wrote:
> > 2.What happens with any DB inserts, updates, deletes etc that occur
> > between the SELECT pg_start_backup() and the end of the tar?
> > They would be already logged in the WAL files and already applied in t
Enzo D'addario wrote:
> Hi All,
>
> I have a couple of questions regarding On-line backup and point-in-time
> recovery (PITR) in the postgres documentation:
>
> 1.How is it that we can create a tar file of the PG Data directory
> whilst postgres is running?
Whe pg_xlog archived files contain inf
Hi All,
I have a couple of questions regarding On-line backup and point-in-time
recovery (PITR) in the postgres documentation:
1.How is it that we can create a tar file of the PG Data directory
whilst postgres is running?
2.What happens with any DB inserts, updates, deletes etc that occur
betwee
While this is strictly related to the administration of a rdbms, I don't actully know if it is a matter of the rdbms software to control the connection timeout. (This is something that major rdbms providers, oracle, ms, give as a solution, but I am not sure if that is a good habit, asuming that in
Have been reading the manual and searching for connection timeout
information, but
I don't think what I have found answers my questions. Most of what I found
so far
is C library functions in Chapter 27 on version 8.0 manual (am not a C
programmer).
I saw connection timeout discussed a little bit w
Just in the past month or so (no code changes, server changes that I
know of, etc, for the last six months), I've started getting errors like:
org.postgresql.util.PSQLException: Unknown Response Type 8
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:192)
at org.
Did you check file ownership and permissions?
Greetings.
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de Magnus Hagander
Enviado el: lunes, 15 de agosto de 2005 16:07
Para: Dirk Kalp; pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] Server Won't Start On a Copy
> On Wed, 2005-08-17 at 08:14 -0700, [EMAIL PROTECTED] wrote:
> >
> > Could you tell us what is the best way to grant a user who can select
> > all data from all tables, if I don't like to write a script which
> > Andrew memtioned earlier.
You may be interested in the acl admin plpgsql scripts t
11 matches
Mail list logo
