Are you sure your working directory is what you think it is? You may want to specify a full path for the output, and see if that works. I suspect your working directory is not set correctly.On May 12, 2006, at 3:11 AM, Thanh Thao Nguyen wrote:Can you help me? To back up database, I use pg_dum
Thank you
With UNION ALL the SQL work correct for my case...
Dario.
Tom Lane escreveu:
Dario Basso Cardoso <[EMAIL PROTECTED]> writes:
I receive two (2) rows if i union with other table i receive one (1) row!!!
You do know that UNION is defined to eliminate duplicate output rows?
(
"Sidney Li" <[EMAIL PROTECTED]> writes:
> when backing up with "pg_dump -o -Ft database_name" then
> later restoring with pg_restore, the indices and constraints/triggers are
> not restored.
Seems pretty unlikely. More details, or better a test case, would help.
I think you've probably misdiagnos
The following bug has been logged online:
Bug reference: 2431
Logged by: bhavani
Email address: [EMAIL PROTECTED]
PostgreSQL version: postgresql 8.10
Operating system: windowsxp
Description:Error:SELECT query has no destination for result data
Details:
CREATE OR REP
Can you help me? To back up database, I use pg_dump command as normal in command prompt 1. C:\Program Files\PostgreSQL\8.1\bin\pg_dump -h 192.168.77.117 -p 5432 -U quangvu -C BENET2 > a.sql or 2. C:\Program Files\PostgreSQL\8.1\bin\pg_dump -h 192.168.77.117 -p 5432 -U quangvu -C -f
The following bug has been logged online:
Bug reference: 2434
Logged by: Jacques Gollion
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Windows 2000 SP4 Fr
Description:Using pg_dump in a .bat : Cannot avoid asking for user
Name and Passwo
The following bug has been logged online:
Bug reference: 2433
Logged by: Jacques Gollion
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Windows 2000 SP4 Fr
Description:Using pg_dump in a .bat : Cannot avoid asking for user
Name and Passwo
The following bug has been logged online:
Bug reference: 2435
Logged by: Sidney Li
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Linux
Description:pg_dump/pg_restore with tar format misses indices and
constraints
Details:
when backing
On Thu, 2006-05-11 at 20:14 -0400, Tom Lane wrote:
> Casey Duncan <[EMAIL PROTECTED]> writes:
> > On May 11, 2006, at 4:42 AM, Simon Riggs wrote:
> >> As your database is defined, this SQL statement will return
> >> approximately 4 trillion rows, by my calculation. As you say, it
> >> returns no
