On 01/14/2016 12:59 AM, Karsten Hilbert wrote:
On Wed, Jan 13, 2016 at 12:10:15PM -0800, Adrian Klaver wrote:
On 01/13/2016 11:38 AM, Karsten Hilbert wrote:
create table parent (
not_null_in_parent integer not null
);
create table child() inherits (pa
On Wed, Jan 13, 2016 at 03:32:12PM -0500, Tom Lane wrote:
> Karsten Hilbert writes:
> > create table parent (
> > not_null_in_parent integer not null
> > );
>
> > create table child() inherits (parent);
> > alter table child
> > alter column not_null_in_p
On Wed, Jan 13, 2016 at 12:10:15PM -0800, Adrian Klaver wrote:
> On 01/13/2016 11:38 AM, Karsten Hilbert wrote:
> > create table parent (
> > not_null_in_parent integer not null
> > );
> >
> > create table child() inherits (parent);
> > alter table child
> >
Karsten Hilbert writes:
> Please consider the following:
> create table parent (
> not_null_in_parent integer not null
> );
> create table child() inherits (parent);
> alter table child
> alter column not_null_in_parent
>
On 01/13/2016 11:38 AM, Karsten Hilbert wrote:
Please consider the following:
- Debian
- server is PG 9.4.5
- client (psql/pg_dump/libpq5) is 9.5
create table parent (
not_null_in_parent integer not null
);
create table child() inherits (parent);
Please consider the following:
- Debian
- server is PG 9.4.5
- client (psql/pg_dump/libpq5) is 9.5
create table parent (
not_null_in_parent integer not null
);
create table child() inherits (parent);
alter table child
alter column n
- Mensaje original -
Fecha: Fri, 05 Oct 2012 17:30:15 -0400
De: "Tom Lane"
Para: "Leonardo M. Ramé"
Asunto: Re: [GENERAL] pg_dump problem
Copia: "PostgreSql-general"
Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= writes: > I'm trying
to migrate a Postg
Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= writes:
> I'm trying to migrate a PostgreSql 8.3 database from a Windows 2003
> server to a PostgreSql 8.4 Linux x86_64 server running Ubuntu Server
> 12.04.
> When running pg_dump from the Linux server, I get:
> postgres@ubuntupostgresql:~$ pg_dump -h 192.1
I'm trying to migrate a PostgreSql 8.3 database from a Windows 2003
server to a PostgreSql 8.4 Linux x86_64 server running Ubuntu Server
12.04.
When running pg_dump from the Linux server, I get:
postgres@ubuntupostgresql:~$ pg_dump -h 192.168.10.105 -U postgres ris
pg_dump: SQL command failed
pg_
Sorry, I forgot to say I am using version 8.2.6.
I already removed option -n and left only -s (sincer there are no
other user schemas in the db) and I get the same error.
However when I removed the -c option it worked fine!
And also when using a formatted dump it works ok (even with -c option)
pg
"=?ISO-8859-1?Q?Laura_Del_Ca=F1o?=" <[EMAIL PROTECTED]> writes:
> I am issuing the following command:
> pg_dump -c -o -s -n distributed -f backups/schema.sql syslog
> which apparently works fine. It is only when I tried to restore it in
> a fresh created database using:
> psql syslog < backups/sche
On Thursday 28 August 2008 4:32:56 am Laura Del Caño wrote:
> Hi,
> I am having a problem with pg_dump and I could not find any reference
> in the archive mailing lists.
> I am issuing the following command:
>
> pg_dump -c -o -s -n distributed -f backups/schema.sql syslog
>
> which apparently works
Hi,
I am having a problem with pg_dump and I could not find any reference
in the archive mailing lists.
I am issuing the following command:
pg_dump -c -o -s -n distributed -f backups/schema.sql syslog
which apparently works fine. It is only when I tried to restore it in
a fresh created database u
0 PM
Subject: Re: [GENERAL] pg_dump problem
SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> writes:
> looks like the OIDs are there
Yeah, that makes it look more like the pg_class row went missing
than that there was an intentional drop of the view.
Does "VACUUM VERBOSE pg_class&qu
No...I dont have slony installed. Its not a replica
sharmila
- Original Message
From: Andrew Sullivan <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Thursday, November 15, 2007 1:03:48 PM
Subject: Re: [GENERAL] pg_dump problem
On Wed, Nov 14, 2007 at 10:32:54AM
On Wed, Nov 14, 2007 at 10:32:54AM -0800, SHARMILA JOTHIRAJAH wrote:
> Hi
> I try to use pg_dump to dump my database.
> pg_dump smrs
> and it gives me an error
> pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite entry OID
> 670741 not found
Is there any possibility you have Slon
- Original Message
From: Tom Lane <[EMAIL PROTECTED]>
To: SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]>
Cc: pgsql-general@postgresql.org
Sent: Wednesday, November 14, 2007 3:33:20 PM
Subject: Re: [GENERAL] pg_dump problem
SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> writes:
> lo
Re: [GENERAL] pg_dump problem
SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> writes:
> pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite
entry OID 670741 not found
> What causes this problem?
Corrupt system tables, looks like :-( What PG version is this?
I would suggest chec
SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> writes:
> looks like the OIDs are there
Yeah, that makes it look more like the pg_class row went missing
than that there was an intentional drop of the view.
Does "VACUUM VERBOSE pg_class" report anything interesting?
It's possible also that reindexing
nesday, November 14, 2007 1:41:56 PM
Subject: Re: [GENERAL] pg_dump problem
On Wed, 2007-11-14 at 10:32 -0800, SHARMILA JOTHIRAJAH wrote:
> Hi
> I try to use pg_dump to dump my database.
> pg_dump smrs
> and it gives me an error
> pg_dump: failed sanity check, parent table OID
SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> writes:
> pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite entry OID
> 670741 not found
> What causes this problem?
Corrupt system tables, looks like :-( What PG version is this?
I would suggest checking to see if either of those OIDs
On Wed, 2007-11-14 at 10:32 -0800, SHARMILA JOTHIRAJAH wrote:
> Hi
> I try to use pg_dump to dump my database.
> pg_dump smrs
> and it gives me an error
> pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite
> entry OID 670741 not found
>
check out the --oids option in the manuals
Hi
I try to use pg_dump to dump my database.
pg_dump smrs
and it gives me an error
pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite entry OID
670741 not found
What causes this problem?
Thanks
sharmila
_
Hi,
First, thank you, things now do seem to be working correctly.
Hmm, do you rely on "DROP SCHEMA foo CASCADE" to make the contained
objects go away? We have seen a few reports suggesting that that
sometimes misses some contained objects. The mechanism for this has
not been identified for
David Brain <[EMAIL PROTECTED]> writes:
> This is PG version 8.2.3.
> The select returns:
> temptrans,1515546,1515548,16398,0,1515547,0,133873,2.0234e
> +06,1515549,0,f,f,r,24,0,0,0,0,0,f,f,f,f,195484336,,
> What other catalogs would be worth looking in to? By the way the
> table name here d
Hi,
This is PG version 8.2.3.
The select returns:
temptrans,1515546,1515548,16398,0,1515547,0,133873,2.0234e
+06,1515549,0,f,f,r,24,0,0,0,0,0,f,f,f,f,195484336,,
What other catalogs would be worth looking in to? By the way the
table name here does sort of make sense as to something that m
David Brain <[EMAIL PROTECTED]> writes:
> I am getting the error mentioned in the subject ('pg_dump: schema
> with OID 1515546 does not exist') when I try to back up one database
> out of a cluster of half a dozen or so on our server.
Well, for starters, troll through the system catalogs in th
Hi,
I am getting the error mentioned in the subject ('pg_dump: schema
with OID 1515546 does not exist') when I try to back up one database
out of a cluster of half a dozen or so on our server. This is a
production DB and the database in question _seems_ to be working OK,
other than the i
I cannot do a /usr/bin/pgdump with my new Postgres 7.4. When I try,
here is what I get:
---
[ ~]$ /usr/bin/pg_dump dcf_20050404 >&
/home/japsey/DCF_RAID_01/source/sql/backup/bu/dcf_200
Title: pg_dump problem
I am trying to get pg_dump to work. I suspect that I am doing something wrong - Here's my command, and the resulting message.
"postgres" owns the database and the tables; all tables were created under "postgres".
"postgres" has no password.
The database is named "d
I keep the same message when trying to dump any database. I haven't a clue;
consequently, I'd appreciate any help that you could provide.
postgres@ibook:/usr/local/pgsql/bin > ./pg_dump -o discuss -f /tmp/ibook_discuss_db
getDatabase(): SELECT failed. Explanation from backend: 'ERROR: More th
On Thu, Jul 27, 2000 at 12:11:53PM -0400, Antoine Reid wrote:
> > In 7.x versions, this appears to be fixed using the '-f' switch:
> >
> > mymachine:~$ pg_dump -u [database] -f [somefile]
>
> That is absolutely correct, although we might want to have the 'Username:'
> and 'Password:' prompt
32 matches
Mail list logo
