Re: [pgadmin-support] switching postgres from windows to linux

2003-12-29 Thread Együd Csaba
Hi Vidhya, if I can understand it clearly you are using postgres under Cygwin on a win2k server and you would like to move it to a Linux box.   To establish a connection between a Linux based postgres server and a Windows application you have to use the PsqlODBC driver. (http://gborg.postg

[pgadmin-support] switching postgres from windows to linux

2003-12-29 Thread vidhya baskaran
Hi,   We installed postgres 7.3.3 in windows 2000 server and using ASP applications.   But, due to overload postgres crashes very often.   So, we decided to switch the databases to Linux box.   We have to access the PG databases in windows from Linux.   Tell me how to the drivers required and ho

Re: [pgadmin-support] PgAdmin 3 startup

2003-12-29 Thread Andreas Pflug
Michael Shapiro wrote: I have downloaded the latest snapshot of pgadmin3 (pgadmin3-20031228-Win32.zip) and connected to a database. PgAmin takes 150 seconds to complete its startup. 2003-12-29 15:16:26 QUERY : Scalar query (delphi:5432): SELECT COUNT(*) FROM (SELECT tgargs from pg_trigger tr

Re: [pgadmin-support] pgadmin bug

2003-12-29 Thread Andreas Pflug
George T. Gibson wrote: Small bug... When you go to add a group, under properties the label says username and user id instead of groupname and group id. It appears that the sql is correct though. Which version? AFAIR this is fixed. Regards, Andreas ---(end of broadca

[pgadmin-support] pgadmin bug

2003-12-29 Thread George T. Gibson
Small bug... When you go to add a group, under properties the label says username and user id instead of groupname and group id. It appears that the sql is correct though. -- George Gibson J.B. Stamping, Inc. 7413 Associate Ave. Cleveland, OH 44144 216.631.0013 216.631.1327 fax [EMAIL PROTECTE

[pgadmin-support] PgAdmin 3 startup

2003-12-29 Thread Michael Shapiro
I have downloaded the latest snapshot of pgadmin3 (pgadmin3-20031228-Win32.zip) and connected to a database. PgAmin takes 150 seconds to complete its startup. (I have reported this problem previously, but just wanted to let you know that it remains with this snapshot) --- Michael 2003-12-29 15

Re: [pgadmin-support] Error Message: ERROR: syntax error at or near ""

2003-12-29 Thread Tyler Mitchell
I've got this kind of error before using the psql command line and it was related to the client program having a different version than the database server. Perhaps pgadmin 3 would work? Or perhaps there is an upgrade for the database driver. My goal would be to get as much of your setup to

Re: [pgadmin-support] Error Message: ERROR: syntax error at or near ""

2003-12-29 Thread Michiel Lange
Mind the single quote / double quote differencies... PostgreSQL sometimes requires you to use single quotes. If I'm not mistaken: single quotes are for litteral reading. eg. case sensitivity... hope it helps a bit, Michiel L. De informatie opgeno

[pgadmin-support] Error Message: ERROR: syntax error at or near ""

2003-12-29 Thread mario_3
-- System Information --Platform: Windows MEVersion: 4.90Build: 3000 -- Application Information --Name: pgAdmin IIVersion: 1.6.0Descripton: Name: pgSchemaVersion: 1.6.0Descripton: PostgreSQL Schema Objects v1.6.0-- Database Information --Version: 7.3.4Descripton: PostgreSQL 7.3.4 on i686-pc-cygwin,

[pgadmin-support]

2003-12-29 Thread Rajesh Sharma
Dear all, I have succesfully installed postgresql 7.4 and I am able to do everything i.e creating databases, tables etc from psql. Having default 'postgres' as the database user. But when I start pgadmin3 and get connected to the server with initial database to be my database, it gets connected but