[pgadmin-support] problem on view data
Hi, Using: pgAdmin II V1.4.12 When view data of table pg_index, it will close down pgAdmin automatically. Thank you very much ! Jack ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] ADO syntax
Hi All, Can anybody help? I have setup PostgreSQL 7.1 on a RedHat 7.2 machine. I finally managed the configuration and have an ADO connection to a Database imported from MS Sql server. If I retrieve a record set with "SELECT DISTINCT lastname AS alpha FROM customers" I can manipulate the records and without the DISTINCT can add new. If I want only the first letter form each of the customers names I tried using "SELECT DISTINCT SUBSTR(lastname FROM 1 FOR 1) AS alpha FROM customers" the database returns 'parse error at or near FROM'. As the first string works the error has to be with the syntax of SUBSTR. Does anybody know how to format the string so that the database will accept the function. Presumably I will have the same problem trying to use any of the functions. Martin ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] problem on view data
> -Original Message- > From: jack [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2003 01:11 > To: pgadmin > Subject: [pgadmin-support] problem on view data > > > Hi, > > Using: pgAdmin II V1.4.12 > When view data of table pg_index, it will close down pgAdmin > automatically. Thank you very much ! Yes, unfortunately this appears to be a problem in Microsoft's ADO which has trouble wit some array types. The pg_trigger table will do it as well iirc. Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[pgadmin-support] Pgadmin- connection error
I installed, PostGreSql 7.3 for win, on Win XP and PgAdmin , but nothing is working. The Pgadmin is giving me this error: Cannot connect to the server; could not connect to the remote socket. Number: -2147467259 All I am trying to do is connect to the database in my local computer. I have also changed the Tcpip_socket = true in the .conf file. Please let me know how to resolve this problem. Thanks, Suranjana ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
