Hi,
I'd recommend coping directly to child tables (partitions). It's much
faster.
Regards,
foo
Scott Marlowe wrote:
I believe triggers can do it.
On Sun, Aug 9, 2009 at 11:15 PM, cjm1010cjm1...@naver.com wrote:
hi~
I want to insert DATA by using the COPY making PARTITON TABLE. By the
thanks for reply
I am using rules with libpq instead of triggers now.
When INSERT was used, it was possible to insert it in CHILD TABLE well.
However, if COPY is used, it is possible to insert it only in PARENT TABLE.
Can triggers be used with libpq?
And, if trigger is used, can it straighten
Dear All,
I am using postgres 7.3 version on RHEL 4.0.
My database has been restored.
All tables all working fine i.e select , update but on a particular table
its showing error
ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to
AF/50F15ABC
I have searched other
On Mon, Aug 10, 2009 at 11:04:24AM +1200, Brent Wood wrote:
Hi...
I have a view across 3 tables, total some 5m rows.
I can extract parts of the view, entire rows, with a where clause
(eg: select * from view where cell_id=10;)
If I try to select the entire view (eg: select * from
Is there a Python driver that uses the same protocol form
of addBatch in Java?
I'll answer my own question: the method to be used should be
cursor.executemany()
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
In response to Kobus Wolvaardt kobusw...@gmail.com:
2009/8/9 Scott Marlowe scott.marl...@gmail.com
On Sun, Aug 9, 2009 at 4:06 AM, Kobus Wolvaardtkobusw...@gmail.com
wrote:
Hi,
We have software deployed on our network that need postgres, we have
server
that hosts the server
Hello everyone, I have a question regarding foreign keys and
information_schema. Given the following valid schema:
CREATE TABLE Cat
(
IdCat serial NOT NULL,
CONSTRAINT PK_Cat PRIMARY KEY (IdCat)
);
CREATE TABLE Art
(
IdArt serial NOT NULL,
IdCat integer NOT NULL,
CONSTRAINT PK_Art
Jonathan Tapicer tapi...@gmail.com writes:
I was a able to do it using the pg_catalog tables, but I haven't found
a way to do it using information_schema since it relies on foreign
keys names being unique in the same catalog. Is this a known
limitation?
Actually, the information_schema
Actually, the information_schema supposes that constraint names are
unique within a *schema*, not within a *catalog* (a/k/a database).
Don't know if that distinction can help you or not. You are correct
that Postgres is less rigid. We do not consider that to be a deficiency
on the Postgres
Hello all
Thank you very much for your responses! I realised that the restores were
not working as the databases were not being...backed up!...oops! After I did
the reinstallation of the OS I forgot to give permissions in postgresql for
the user doing the backup in ubuntu! I have fixed this.
I
We have two machines that run a C application that interfaces with a Postgres
database. They are our development and production machines. The version is
PostgreSQL 8.3.7 on i686-redhat-linux-gnu, complied by GCC gcc (GCC)
4.1.2.20071124 (Red Hat 4.1.2-42) .
On the development machine, I
Hi
I used PQstatus(conn) function to check connection status, but I found that
it still returns CONNECTION_OK even after postgres is restarted. Does
anyone know if there is another command that I can use to check connection
status?
What other solution is available to check whether a connection
I've got some GIS tables that I want to use across several projects and
currently I've got each project in a separate database. So say I've got
two databases, one for the Spacely Sprookets project and one for the
Cogswell Cogs contract, but I want to access my WorldMap tables in my
GIS
Rodrick Hales wrote:
We have two machines that run a C application that interfaces with a
Postgres database. They are our development and production machines.
The version is PostgreSQL 8.3.7 on i686-redhat-linux-gnu, complied by
GCC gcc (GCC) 4.1.2.20071124 (Red Hat 4.1.2-42) .
On the
On Mon, Aug 10, 2009 at 10:48:10AM -0600, Bill Thoen wrote:
I've got some GIS tables that I want to use across several projects
and currently I've got each project in a separate database. So say
I've got two databases, one for the Spacely Sprookets project and
one for the Cogswell Cogs
Juan Backson juanback...@gmail.com writes:
I used PQstatus(conn) function to check connection status, but I found that
it still returns CONNECTION_OK even after postgres is restarted. Does
anyone know if there is another command that I can use to check connection
status?
PQstatus isn't
On Tue, Aug 11, 2009 at 12:41:47AM +0800, Juan Backson wrote:
I used PQstatus(conn) function to check connection status, but I found that
it still returns CONNECTION_OK even after postgres is restarted. Does
anyone know if there is another command that I can use to check connection
status?
On Mon, Aug 10, 2009 at 9:46 AM, Bill Moranwmo...@potentialtech.com wrote:
We have servers using about 200 connections on average ... it climbs up
to 300+ during busy use. I've seen it peak as high as 450, and we've seen
no performance issues.
This is a quad core with 4G of RAM. Of course
On Mon, Aug 10, 2009 at 12:58 AM, cjm1010cjm1...@naver.com wrote:
thanks for reply
I am using rules with libpq instead of triggers now.
When INSERT was used, it was possible to insert it in CHILD TABLE well.
However, if COPY is used, it is possible to insert it only in PARENT TABLE.
Can
On 8/10/09 12:08 PM, Sam Mason s...@samason.me.uk wrote:
On Tue, Aug 11, 2009 at 12:41:47AM +0800, Juan Backson wrote:
I used PQstatus(conn) function to check connection status, but I found that
it still returns CONNECTION_OK even after postgres is restarted. Does
anyone know if there is
these are straight dll calls as outlined in Using Run-Time Dynamic Linking
(Windows)
that's why they look funny. it is impossible to link VC++ .lib files with
mingw(gcc) .a libraries.
yeah, I just found the PQntuples bug myself too, and got the program finished.
thank you for the tips on
On Mon, Aug 10, 2009 at 4:03 PM, Jim Michaelsjmich...@yahoo.com wrote:
these are straight dll calls as outlined in Using Run-Time Dynamic Linking
(Windows)
that's why they look funny. it is impossible to link VC++ .lib files with
mingw(gcc) .a libraries.
that is not why they look
On Mon, 10 Aug 2009 13:49:02 -0400
Vick Khera vi...@khera.org wrote:
On Mon, Aug 10, 2009 at 9:46 AM, Bill Moranwmo...@potentialtech.com wrote:
We have servers using about 200 connections on average ... it climbs up
to 300+ during busy use. I've seen it peak as high as 450, and we've seen
On Mon, Aug 10, 2009 at 7:49 PM, Vick Kheravi...@khera.org wrote:
On Mon, Aug 10, 2009 at 9:46 AM, Bill Moranwmo...@potentialtech.com wrote:
We have servers using about 200 connections on average ... it climbs up
to 300+ during busy use. I've seen it peak as high as 450, and we've seen
no
On Mon, Aug 10, 2009 at 3:16 PM, Allan Kamaukamaual...@gmail.com wrote:
On Mon, Aug 10, 2009 at 7:49 PM, Vick Kheravi...@khera.org wrote:
On Mon, Aug 10, 2009 at 9:46 AM, Bill Moranwmo...@potentialtech.com wrote:
We have servers using about 200 connections on average ... it climbs up
to 300+
Bill Thoen wrote:
I've got some GIS tables that I want to use across several projects and
currently I've got each project in a separate database. So say I've got
two databases, one for the Spacely Sprookets project and one for the
Cogswell Cogs contract, but I want to access my WorldMap tables
Hi,
Thanks for all the answers.
I think I need to first look into the windows connection issue (where some
memory pool gets used up and then new connections cannot be made). If that
does not help, upping the ram by a bit might help (at least buy some time).
And looking into tuning the options
I didn't remember seeing anywhere in the docs that you were supposed to check
for pqr==NULL, I wish they would document that in PQexec.
It's right there in the first sentence of the discussion.
There is no mention of return values!
???
--
Scott Ribe
scott_r...@killerbytes.com
Just a thought, but would it not be possible to add a trigger written in
python that makes a connection to another database and does what it needs
to? I have not done this, but if it is possible it should solve your problem
and one that I have. It should allow updates and selects.
I am sure the
On Tue, Aug 11, 2009 at 2:51 AM, John R Pierce pie...@hogranch.com wrote:
Rodrick Hales wrote:
We have two machines that run a C application that interfaces with a
Postgres database. They are our development and production machines. The
version is PostgreSQL 8.3.7 on i686-redhat-linux-gnu,
While doing
# VACUUM VERBOSE ANALYZE d_trr_dfh;
INFO: vacuuming xmms.d_trr_dfh
ERROR: xlog flush request 21F/9F57DF88 is not satisfied --- flushed only to
21F/924CE76C
CONTEXT: writing block 2919652 of relation 17461/17462/17668
I see this in the logs
user= CONTEXT: writing block
Ow Mun Heng ow.mun.h...@wdc.com writes:
As background, this is a new box mirrored from a separate box via rsync.
I've basically copied/rsync the entire postgresql server and data files over
to create a mirror copy. After which, I've tried to do the vacuum and gotten
into the above trouble.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Ow Mun Heng ow.mun.h...@wdc.com writes:
As background, this is a new box mirrored from a separate box via rsync.
I've basically copied/rsync the entire postgresql server and data files
over
to create a mirror copy. After
Hi Tim,
Thank you for your suggestion.
In my application, it is a multi-thread and each thread will need to query 5
select statements.
Right now, I am having my own pool of 500 PgConn inside the code. For each
connection that I obtain from the connection pool, I am using direct socket
into
34 matches
Mail list logo