On Tuesday, March 27, 2012 08:20:23 PM Akshay Joshi wrote:
> In my case I won't allow anyone to insert/modify the rows of sample_one
> table. I have already inserted some rows in sample_one table where I
> want one constraint is number of array elements of sample_one.param_names
> and sample.pa
On Tue, Mar 27, 2012 at 7:40 PM, Tom Lane wrote:
> "Albe Laurenz" writes:
> > pg_dump does not resolve dependencies, it avoids problems by adding
> > constraints after inserting the data.
>
> > It seems that this is not done for CHECK constraints, however - they are
> > added when the table is d
"Albe Laurenz" writes:
> pg_dump does not resolve dependencies, it avoids problems by adding
> constraints after inserting the data.
> It seems that this is not done for CHECK constraints, however - they are
> added when the table is defined.
> I think that this is a bug.
It is not a bug; it is
Akshay Joshi wrote:
> I am facing issue while restoring the database. I have taken the
backup of my database using pg_dump
> and then create new database and try to restore it using pg_restore. I
am using PostgreSQL 9.0.
> I have created one small test case to reproduce the issue, attached is
the s
On 27 March 2012 15:12, Akshay Joshi wrote:
> On Tue, Mar 27, 2012 at 6:15 PM, Alban Hertroys wrote:
>>
>> On 27 March 2012 11:33, Akshay Joshi
>> wrote:
> pg_restore: restoring data for table "sample"
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db
On Tue, Mar 27, 2012 at 6:15 PM, Alban Hertroys wrote:
> On 27 March 2012 11:33, Akshay Joshi
> wrote:
> > Hi
> >
> > I am facing issue while restoring the database. I have taken the backup
> of
> > my database using pg_dump and then create new database and try to
> restore it
> > using pg_resto
On 27 March 2012 11:33, Akshay Joshi wrote:
> Hi
>
> I am facing issue while restoring the database. I have taken the backup of
> my database using pg_dump and then create new database and try to restore it
> using pg_restore. I am using PostgreSQL 9.0.
What is the error?
It looks like you are t
