[BUGS] BUG #6028: age() function output contracts "months", but not any other units.
The following bug has been logged online: Bug reference: 6028 Logged by: Martin A. Brooks Email address: mar...@antibodymx.net PostgreSQL version: 9.0.4 Operating system: Debian/GNU Linux 6 Description:age() function output contracts "months", but not any other units. Details: Hi postgres=# select age(now(),'1973-12-20'::timestamp); age - 37 years 4 mons 28 days 15:33:49.041831 (1 row) Note "mons" and not "months". And if "mons", why not "yrs" and "dys"? Regards Martin A. Brooks http://antibodyMX.net/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #6027: OLE DB Provider not available
The following bug has been logged online: Bug reference: 6027 Logged by: dhaval Email address: d_dha...@rediffmail.com PostgreSQL version: 9.0 Operating system: windows-7 , 64-bit Description:OLE DB Provider not available Details: Hello, I have downloaded Postgres-Sql - ver 9.0 on my laptop. It has windows 7 and is 64-bit. I wanted to use this for some application development in Visual basic-6. But I am unable to make a connection through my vb-6 applicaton. Can some 1 help me with this issue. Thanks in advance. Regards, Dhaval -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS]
PostgreSQL version: 8.3.1 Operating system: windows xp Description: postgres stops working after restart Details: I installed 8.3.1 fine and the service starts and works fine. However, after I restart the computer and opens up pgAdmin3.exe and try to start the service again i get error message: "Failed to start server pgsql-8.3:Errcode=1069. Check event log for details." The log folder doesn't show any error problems. When I run the psql.exe on the command line i get: "psql: could not connect to server: Connection refused (0x274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432? " I checked using netstat -an and 5432 is not even listed being in use/listening. I also tried changing the port in pgadmin to something else like 5050 but same problem -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #6029: packaged installer fails to configure ldap
The following bug has been logged online: Bug reference: 6029 Logged by: mark Email address: m...@remidata.com PostgreSQL version: 9.0.2 Operating system: RHEL 6.0 x86_64 Description:packaged installer fails to configure ldap Details: The source code installation can be configured to work with LDAP, but the one-click installer cannot by default. The one-click installer fails to detect openldap and does not attempt to configure or link with openldap. We first noticed pg_hba.conf disallowed specifying ldap authentication. We verified openldap and openldap-devel are installed and up-to-date. We then verified using "pg_configure --configure" and "ldd postgres" that the PGHOME was not built with ldap support. For some reason the one-click installer did not detect openldap was installed and so did not include it in the configure options. I have tested this on RHEL 5.5 and RHEL 6.0, both x86_64. On all servers we installed openldap and openldap-devel for x86_64 prior to installing postgres. On the RHEL 6.0 server we additionally have ldap installed via Centify. We can use ldapsearch to connect to the ldap server and query it, so we know our RHEL servers are functional in that respect. To make the one-click installer make use of the openldap software we had to install the i686 edition of it (yum install openldap.i686). This "trick" is not required when installing via source code. We wiped and rebuilt the servers multiple times to verify this behavior. To install postgresql 9.0 from source we first installed openldap and openldap-devel (both were x86_64 only - we made sure the i686 was not installed), and then we ran "./configure --with-ldap" followed by make && make install. The postgres executable appears to support ldap (verified using "pg_configure --configure" which shows the --with-ldap option, and "ldd postgres" which shows /usr/lib64/libldap-2.3.so.0). Server Specs: -- 1. The RHEL 5.5 server is a vm with 4 cores and 8 GB RAM running kernel 2.6.18-194.el5 #1 SMP x86_64 GNU/Linux. 2. The RHEL 6.0 server is a HP DL580G7 with 32 cores and 256 GB RAM running kernel 2.6.32-71.el6.x86_64 #1 SMP GNU/Linux. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] Query Tools
En Pgadmin III el Query Tools no esta funcionando. Se bloquea. Que hay que hacer para poder habilitarlo. Eduardo Velasquez M
Re: [BUGS] Query Tools
2011/5/17 Eduardo Velasquez M : > > En Pgadmin III el Query Tools no esta funcionando. Se bloquea. Que hay que > hacer para poder habilitarlo. > > Este no es un bug de postgres sino un problema en pgAdmin III, sería preferible que envies la consulta a la lista de correo de soporte de pgAdmin (pgadmin-supp...@postgresql.org) sin embargo esa lista es en inglés (así como esta forma reportar bugs deberías llenarla en íngles)... si se te complica el inglés podrías intentar enviar un reporte a la lista de postgres en español (pgsql-es-ay...@postgresql.org) y podríamos tratar de ayudarte. Siempre que proveas la suficiente información para determinar el problema, lo cual obviamente no has hecho. This is not a postgres' bug but an issue with pgAdmin III, it could be better if you send this inquiry to the pgadmin's support mailing list (pgadmin-supp...@postgresql.org) however that list is an english list (like this form ti report bugs should be filled in english)... if you're not comfortable with english then you could send the report to spanish postgres mailing list (pgsql-es-ay...@postgresql.org) and we will try to help you. But you need to provide enough information to determine what the problem is, which you obviously haven't do it. -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación de PostgreSQL -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
