Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Bugs > pg_dump error w...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 3721 of 3896
Post > Topic >>

pg_dump error when dumping mixed-case name tables

by vlpri@[EMAIL PROTECTED] ("Prischepa Vladimir") Apr 21, 2008 at 05:15 PM

This is a multi-part message in MIME format.

------=_NextPart_000_0003_01C8A3D3.49037750
Content-Type: text/plain;
	charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

Hello!

I dump only one table which has mixed case name. But it doesn't work.
It results in the following error:

pg_dump.exe -h localhost -p 5433 -U postgres -i  -F p -t '"T10441"' -v =
-f "test.sql" test
pg_dump: No matching tables were found
pg_dump: *** aborted because of error


Is that a bug or am I doing anything wrong?

Thank you in advance.

Best Regards,=20
Vladimir Prischepa.
------=_NextPart_000_0003_01C8A3D3.49037750
Content-Type: text/html;
	charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dkoi8-r">
<META content=3D"MSHTML 6.00.2900.3199" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I dump only one table which has mixed =
case name.=20
But it doesn't work.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>It results in the following =
error:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>pg_dump.exe -h localhost -p 5433 -U =
postgres=20
-i&nbsp; -F p -t '"T10441"' -v -f "test.sql" test<BR>pg_dump: No =
matching tables=20
were found<BR>pg_dump: *** aborted because of error</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Is that a bug or am&nbsp;I doing =
anything=20
wrong?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thank you in advance.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Best Regards, </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Vladimir =
Prischepa.</FONT></DIV></BODY></HTML>

------=_NextPart_000_0003_01C8A3D3.49037750--




 2 Posts in Topic:
pg_dump error when dumping mixed-case name tables
vlpri@[EMAIL PROTECTED]   2008-04-21 17:15:23 
Re: pg_dump error when dumping mixed-case name tables
tgl@[EMAIL PROTECTED] (T  2008-04-21 10:03:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 4 14:38:15 CDT 2008.