Re: [pgadmin-support] wrong handling of character params in debugger

2009-04-22 Thread Dave Page
On Wed, Apr 22, 2009 at 7:24 PM, Wolfgang Pasche wrote: > Hi, > I am running PostgreSQL 8.7.3 on Windows Vista (binary MSI distribution) > and have the following problem with the included pgAdmin Version (1.8.4) > as well as with the actual Beta release (1.9.0-Dev, Feb 27 2009, > rev:7617:7618): >

[pgadmin-support] wrong handling of character params in debugger

2009-04-22 Thread Wolfgang Pasche
Hi, I am running PostgreSQL 8.7.3 on Windows Vista (binary MSI distribution) and have the following problem with the included pgAdmin Version (1.8.4) as well as with the actual Beta release (1.9.0-Dev, Feb 27 2009, rev:7617:7618): If I enter the debugger for a function with character parameters, th

Re: [pgadmin-support] CREATE DATABASE wrong SYNTAX

2009-04-22 Thread Dave Page
On Wed, Apr 22, 2009 at 5:10 PM, Jan-Peter Seifert wrote: > Hello, > > when you create a new database with pgAdmin III 1.10 beta 2 specifying a > locale different from the server pgAdmin sends a wrong CREATE DATABASE syntax > to the server - COLLATE instead of LC_COLLATE and CYTPE instead of LC_

Re: [pgadmin-support] pgAgent absent from win32 beta distributions?

2009-04-22 Thread Kevin Field
On Apr 22, 11:34 am, Kevin Field wrote: > On Apr 22, 11:17 am, dp...@pgadmin.org (Dave Page) wrote: > > > On Wed, Apr 22, 2009 at 3:41 PM, Kevin Field > > wrote: > > > On Apr 21, 4:00 pm, dp...@pgadmin.org (Dave Page) wrote: > > >> No, the Windows event log. > > > > Aha: "Couldn't create the pr

[pgadmin-support] CREATE DATABASE wrong SYNTAX

2009-04-22 Thread Jan-Peter Seifert
Hello, when you create a new database with pgAdmin III 1.10 beta 2 specifying a locale different from the server pgAdmin sends a wrong CREATE DATABASE syntax to the server - COLLATE instead of LC_COLLATE and CYTPE instead of LC_CTYPE. http://www.postgresql.org/docs/8.4/static/sql-createdatabase

Re: [pgadmin-support] pgAgent absent from win32 beta distributions?

2009-04-22 Thread Kevin Field
On Apr 22, 11:17 am, dp...@pgadmin.org (Dave Page) wrote: > On Wed, Apr 22, 2009 at 3:41 PM, Kevin Field > wrote: > > On Apr 21, 4:00 pm, dp...@pgadmin.org (Dave Page) wrote: > >> No, the Windows event log. > > > Aha: "Couldn't create the primary connection (attempt 10): > > fe_sendauth: no pass

Re: [pgadmin-support] pgAgent absent from win32 beta distributions?

2009-04-22 Thread Dave Page
On Wed, Apr 22, 2009 at 3:41 PM, Kevin Field wrote: > On Apr 21, 4:00 pm, dp...@pgadmin.org (Dave Page) wrote: >> No, the Windows event log. > > Aha:  "Couldn't create the primary connection (attempt 10): > fe_sendauth: no password supplied" and nine other attempts, then > finally, "Stopping pgAge

Re: [pgadmin-support] pgAgent absent from win32 beta distributions?

2009-04-22 Thread Kevin Field
On Apr 21, 4:00 pm, dp...@pgadmin.org (Dave Page) wrote: > No, the Windows event log. Aha: "Couldn't create the primary connection (attempt 10): fe_sendauth: no password supplied" and nine other attempts, then finally, "Stopping pgAgent: Couldn't establish the primary connection with the database

[pgadmin-support] Restore

2009-04-22 Thread akosh kobash
I am using MAC OS X, when i backup the database using pgadmin3, which extension should i put at the end of the output file. The file does not have any extension. How do i restore the database using the same tool pgadmin3 using the same file. Regards Akosh

Re: [pgadmin-support] Backup

2009-04-22 Thread Ashesh Vashi
Hi Akosh, Follow these steps: * Go to File->Options. * This will open a Option dialog. * Set the correct PG bin path. Hope, this will help you. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: http://www.enterprisedb.com

Re: [pgadmin-support] Backup

2009-04-22 Thread Hiren Mistry
Hello, You can use for backup pg_dump -Cdi instead of pg_dump -Cd Regards, Hiren Mistry akosh kobash wrote: I am not able to backup my database this is the situation i have pg_dump: server version: 8.3.5; pg_dump version: 8.3.1 any help? -- Sent via pgadmin-support mailing list (pgadmin

Re: [pgadmin-support] Backup

2009-04-22 Thread akosh kobash
The pgadmin3 does not have that option, or is it me who is not checking properly? Am a rookie in this application On Wed, Apr 22, 2009 at 12:45 PM, Hiren Mistry < hiren.mis...@mobilefundas.com> wrote: > Hello, > > You can use for backup pg_dump -Cdi instead of pg_dump -Cd > > Regards, > Hiren Mi

[pgadmin-support] Backup

2009-04-22 Thread akosh kobash
I am not able to backup my database this is the situation i have pg_dump: server version: 8.3.5; pg_dump version: 8.3.1 any help?