On 04/15/2016 11:35 PM, vinothcanwin wrote:
Partition tables are empty in backup while using pg_dump to take backup, but
those tables having data in database. Below is the command i am using to
take backup.
./pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f /tmp/dump.sql
db_mydb
Not
Partition tables are empty in backup while using pg_dump to take backup, but
those tables having data in database. Below is the command i am using to
take backup.
./pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f /tmp/dump.sql
db_mydb
--
View this message in context:
http://postgr
On 12/21/11 10:24 AM, Xiaoning Xu wrote:
Since the serial primary key of my partition table is the FK of some other
tables, I need to get the
id after each insertion.
My solution now is to select the max id from the parent table.
I am wondering if there is any other alternatives to solve this p
Hello,
I have a problem concerning the partition table.
When I store a record into one of the partition and use "RETURNING table_id" or
"RETURNING *",
I expect the same result when calling fetchall or fetchone function as not
using partition.
However, it simply returns nothing.
Since the ser
olumn with taken
value - then the same value use later in other tables as fk...
Kind Regards,
Misa
Sent from my Windows Phone From: Xiaoning Xu
Sent: 21 December 2011 22:31
To: pgsql-general@postgresql.org
Subject: [GENERAL] [partition table] python fetchall or fetchone
function can not get the
Hello,
I have a problem concerning the partition table.
When I store a record into one of the partition and use "RETURNING table_id" or
"RETURNING *",
I expect the same result when calling fetchall or fetchone function as not
using partition.
However, it simply returns nothing.
Since the seria
Hello,
I have a problem concerning the partition table.
When I store a record into one of the partition and use "RETURNING table_id" or
"RETURNING *",
I expect the same result when calling fetchall or fetchone function as not
using partition.
However, it simply returns nothing.
Since the seria
diffuser, de le distribuer ou de le reproduire.
- Original Message -
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>
Cc:
Sent: Saturday, March 03, 2007 3:26 PM
Subject: Re: [GENERAL] Partition Table
> Martin Gainty wrot
Martin Gainty wrote:
> Good Afternoon All-
> I come from the other DBMS from California where extremely large datasets
> could be partitioned into separate and distinct partition tables
> Lets say for example I have Property Table which contains a tera worth of
> data and to gain performnce in
Good Afternoon All-
I come from the other DBMS from California where extremely large datasets
could be partitioned into separate and distinct partition tables
Lets say for example I have Property Table which contains a tera worth of data
and to gain performnce in the indexing I *could* partitio
10 matches
Mail list logo
