Skip site navigation (1) Skip section navigation (2)

Re: BUG #3377: pg_dump: No matching tables were found

From: Christian Gonzalez <christian(dot)gonzalez(at)sigis(dot)com(dot)ve>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3377: pg_dump: No matching tables were found
Date: 2007-06-08 19:34:03
Message-ID: 1181331243.4478.1.camel@it01lnx.sigis.local (view raw or flat)
Thread:
Lists: pgsql-bugs
I Think that your problem is:  test.mytable() <> test.mytable, why your
table name include --> ()

On Fri, 2007-06-08 at 16:59 +0000, Kevin Neufeld wrote:
> The following bug has been logged online:
> 
> Bug reference:      3377
> Logged by:          Kevin Neufeld
> Email address:      kneufeld(at)refractions(dot)net
> PostgreSQL version: 8.2.4
> Operating system:   Linux Fedora Core 3
> Description:        pg_dump: No matching tables were found
> Details: 
> 
> pg_dump does not seem to use -n to qualify a table dump.
> 
> $ psql -U postgres -c "create schema test" postgres
> CREATE SCHEMA
> 
> $ psql -U postgres -c "create table test.mytable()" postgres
> CREATE TABLE
> 
> $ pg_dump -U postgres -t mytable postgres | less
> pg_dump: No matching tables were found
> 
> $ pg_dump -U postgres -n test -t mytable postgres | less
> pg_dump: No matching tables were found
> 
> $ psql -U postgres -c "alter user postgres set search_path to test, public"
> postgres
> ALTER ROLE
> 
> $ pg_dump -U postgres -n test -t mytable postgres | less
> --
> -- PostgreSQL database dump
> --
> 
> SET client_encoding = 'UTF8';
> SET ...
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 


-- 
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que est limpio.


In response to

pgsql-bugs by date

Next:From: Kenneth ChristensenDate: 2007-06-10 09:48:45
Subject: BUG #3378: UTF-8 upper() and lower() don't work
Previous:From: Alvaro HerreraDate: 2007-06-08 18:13:04
Subject: Re: BUG #3377: pg_dump: No matching tables were found

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group