Re: [pgadmin-support] first time
Title: Message If you have a datasouce field, then you need to upgrade to the latest version from http://www.pgadmin.org. Versions or pgAdmin with the datasource field haven't been supported for some time. Regards, Dave. -Original Message-From: Camila Rocha [mailto:[EMAIL PROTECTED]] Sent: 08 April 2002 04:46To: [EMAIL PROTECTED]Subject: [pgadmin-support] first time Hi! I'm a student from brazil... i want to know what should i write in the fields datasource, user and password. sorry for the bad english and the stupid question! thanx!
[pgadmin-support] error 380
After upgrading from last CVS, I have error in pgAdmin:frmMain:svServer Number 380 'Valeur de propriété non valide' from time to time (connection, queries, ...) but all seems working well Regards, ___ Jacques Massé Tel. 33 (0)5 57 89 08 11 - Fax 33 (0)5 57 89 08 01 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [pgadmin-support] error 380
> -Original Message- > From: Masse Jacques [mailto:[EMAIL PROTECTED]] > Sent: 08 April 2002 10:44 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] error 380 > > > After upgrading from last CVS, I have > > error in pgAdmin:frmMain:svServer > Number 380 > 'Valeur de propriété non valide' > > from time to time (connection, queries, ...) > > but all seems working well Hi, Please try the latest builds in /binaries. Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[pgadmin-support] ODBC Connection to PostgreSQL 7.1 via pgAdmin and M$ Access 2000, updating fails
Hey folks, I have tried to update fields in a table with timestamps via pgAdmin 1.2.0 but it fails. In the mailing list I could figure out that this is a 'bizarre feature' bugging Dave a long time - http://www.mail-archive.com/pgadmin-support@postgresql.org/msg00309.html So now I was looking for an alternative for updating fields on a M$ Windows System: I used Access 2000 via the ODBC Driver delivered with pgAdmin 1.2.0. But here I get errors that say that there is somebody else writing into that table - this database is running in the internet and another application is watching on a view related to that table. Finally I altered the name of the table but I still got this error message. Is somebody out there who could give my a workaround, a way to solve that problem. My aims is just to write via a GUI into PostgreSQL 7.1 from a Windows System via ODBC. Regards, Hans -- Hans Plum Geographic Info Sys Department of Geography, University of Bonn Meckenheimer Allee 166 53115 Bonn Germany fon +49 +228 73-3829 fax +49 +228 73-9658 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-support] first time
Thanks, but it didn't work... I created the driver, with this parameters: i tried localhost as a server too. It's a local machine, with no connections. But, when i tried to open pgAdmin, this error message appeared: what can i do - Original Message - From: Daniel Chang To: Camila Rocha Sent: Monday, April 08, 2002 3:37 AM Subject: RE: [pgadmin-support] first time Camila, When you created an ODBC connection to a database (in our case to a Postgresql database) you told it a few things: 1. The name of the host (this is the name of the machine where Postgresql server is running) 2. The port number (this is the number of the port where Postgresql is listening for requests. The default value is 5432) 3. Database Name. Here you write the name of the database you wish to connect to. If you have several databases and you will be using this ODBC connection to connect to any of them, then it is better that you leave this field blank. 4. User and Password: This is the user id that has privileges to access the database.and its respective password. You can leave this two fields in blank or you can enter the information. The ODBC connection that you created above was saved with a name. This name is known as the DATASOURCE. For example if you saved the ODBC connection above with the name "postgres" then every time your are asked for the datasource you will have to write "postgres". Once you created an ODBC connection, you tell pgAdmin the information it needs: DATASOURCE is the name of the ODBC connection that you created above. If in the above connection you entered a user name and password then you do not have to entered here in pgAdmin. If you did not entered a user id and password in the ODBC connection then you will have to enter them here. NOTE: Remember that to be able to create an ODBC connection to Postgresql you have to install an ODBC driver for Postgresql. To create the ODBC connection you will go to the ODBC administrator in the control pannel. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Camila RochaSent: Sunday, April 07, 2002 11:46 PMTo: [EMAIL PROTECTED]Subject: [pgadmin-support] first time Hi! I'm a student from brazil... i want to know what should i write in the fields datasource, user and password. sorry for the bad english and the stupid question! thanx!
Re: [pgadmin-support] ODBC Connection to PostgreSQL 7.1 via pgAdm
> -Original Message- > From: Hans Plum [mailto:[EMAIL PROTECTED]] > Sent: 08 April 2002 19:43 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [pgadmin-support] ODBC Connection to PostgreSQL 7.1 > via pgAdmin and M$ Access 2000 , updating fails > > > Hey folks, > > I have tried to update fields in a table with timestamps via pgAdmin > 1.2.0 but it fails. In the mailing list I could figure out > that this is > a 'bizarre feature' bugging Dave a long time - > http://www.mail-archive.com/pgadmin-support@postgresql.org/msg00309.html :-) Hi Hans, I have done some work on this now - specifically, if a primary key can be found, that is used in preference building a huge great big WHERE clause to add onto DELETE/UPDATE queries. Please try out the latest dev code - you can download a tarball (with instructions) from: http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/binaries/ Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[pgadmin-support] migration tool
Hello, I tried to use the migration plug-in to migrate from Oracle to Postgres, but I failed to connect to the Oracle database. This db is on a server, so normally I use an IP address to connect to it. In the migration tool, I set the db type to 'SQL server database'. But then there are only a 'Server Name' and a 'Database Name' fields. How can I connect to my remote server? I tried Server Name = [EMAIL PROTECTED] but that didn't work. What did I miss? Miguel Juteau ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] first time
Le Lundi 8 Avril 2002 20:39, Camila Rocha a écrit : > Thanks, but it didn't work... I created the driver, with this parameters: > i tried localhost as a server too. It's a local machine, with no > connections. > But, when i tried to open pgAdmin, this error message appeared: > what can i do 1) General Windows setup: http://www.ejip.net/faq/postgresql_win_setup_faq.jsp. 2) Is socket connection enabled on PostgreSQL? Have a look at /var/lib/pgsql/data/ files. 3) Log in template1 database. Cheers, Jean-Michel ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] migration tool
> -Original Message- > From: Miguel Juteau [mailto:[EMAIL PROTECTED]] > Sent: 09 April 2002 06:20 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] migration tool > > > > Hello, > I tried to use the migration plug-in to migrate from Oracle > to Postgres, but I failed to connect to the Oracle database. > This db is on a server, so normally I use an IP address to > connect to it. In the migration tool, I set the db type to > 'SQL server database'. But then there are only a 'Server > Name' and a 'Database Name' fields. How can I connect to my > remote server? I tried Server Name = > [EMAIL PROTECTED] but that didn't work. What did I miss? The SQL Server option is for Microsoft SQL Server. If you setup an ODBC datasource (using the ODBC driver manager in Control Panel) to point to your database, you can then use the ODBC migration option. Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
