Re: [BUGS] Are CSV logs supported in the PgAdmin log viewer?

2011-01-04 Thread Dave Page
On Tue, Jan 4, 2011 at 7:29 PM, Robert Walker wrote: > Are CSV log files handled by current versions of PgAdmin? I'd like to switch > to always using CSV files rather than stderr so that the logs are easily > analyzed by development tools. No, they're not. Though it should warn you of that, rathe

Re: [BUGS] BUG #5559: Full SSL verification fails when hostaddr provided

2011-01-04 Thread Christopher Head
On Tue, 4 Jan 2011 19:42:38 -0500 Robert Haas wrote: > Me, too. I reread the original discussion of this topic and I'm still > a little fuzzy on it, but the issue that was under discussion seems to > be what information we pass to external auth libraries like GSSAPI or > Kerberos, given that we

Re: [BUGS] Full Text index is not using during OR operation for multiple table join

2011-01-04 Thread Robert Haas
On Mon, Nov 29, 2010 at 5:27 AM, AI Rumman wrote: > Full Text index is not using during OR operation for multiple table join: Hmm. If you have a condition of the form OR then the system is going to have to join those tables before evaluating that condition. It can't scan A and throw awa

Re: [BUGS] BUG #5798: Some weird error with pl/pgsql procedure

2011-01-04 Thread Robert Haas
On Wed, Dec 22, 2010 at 4:53 PM, Maxim Boguk wrote: > About stack backtrace I not sure how to get it (and even worse the > database is heavily loaded production DB so I not sure creating core > dump would be good idea). > Still I would like to receive any help with creating a stack backtrace. Wel

Re: [BUGS] Are CSV logs supported in the PgAdmin log viewer?

2011-01-04 Thread Robert Haas
On Tue, Jan 4, 2011 at 2:29 PM, Robert Walker wrote: > Are CSV log files handled by current versions of PgAdmin? I'd like to switch > to always using CSV files rather than stderr so that the logs are easily > analyzed by development tools. This doesn't seem like a bug report, although the report

Re: [BUGS] BUG #5559: Full SSL verification fails when hostaddr provided

2011-01-04 Thread Robert Haas
On Sun, Dec 19, 2010 at 5:13 PM, Christopher Head wrote: > On Wed, 14 Jul 2010 18:35:55 -0400 > Tom Lane wrote: > >> Bruce Momjian writes: >> > Do the docs need any more updating? >> >> No doubt, but it's a bit premature to consider that while we're still >> arguing whether the code needs to cha

Re: [BUGS] unable to export database from postgres

2011-01-04 Thread Robert Haas
On Fri, Dec 31, 2010 at 5:25 AM, d.yadagiri wrote: > I have a database in that i have 2 schema's >  1.myschema >  2.public  (it does not contains data) > > All my database tables, views and functions are in adempiere schema > > When i Export the database it gives 0 bytes dump.sql.gz file > > the d

[BUGS] Are CSV logs supported in the PgAdmin log viewer?

2011-01-04 Thread Robert Walker
I'm using PgAdmin 1.12.2 with PostgreSQL 9.0.2 on Windows XP Pro 32bit. When I edit postgresql.conf and set log_destination to 'csvlog' and restart the server, Postgres then writes its logs to CSV files and leaves blank .log files in the same directory. When I open PgAdmin and go to "server status"

Re: [BUGS] to_timestamp returns the incorrect result for the DST fall over time.

2011-01-04 Thread Tom Lane
Gouse writes: > I find that the to_timestamp giving the incorrect result for the DST time > period. On what grounds do you claim it's incorrect? > select to_timestamp('2010-03-28 01:00:03 243','-MM-DD HH24:MI:SS.MS') > results '2010-03-28 02:00:03.243 + 01' , I am not sure if this is correc

[BUGS] to_timestamp returns the incorrect result for the DST fall over time.

2011-01-04 Thread Gouse
Hi I find that the to_timestamp giving the incorrect result for the DST time period. select to_timestamp('2010-03-28 01:00:03 243','-MM-DD HH24:MI:SS.MS') results '2010-03-28 02:00:03.243 + 01' , I am not sure if this is correct. select to_timestamp('2010-03-28 02:00:03 243','-MM-DD

Re: [BUGS] BUG #5809: bigserial duplicate value

2011-01-04 Thread Joshua Tolley
On Mon, Jan 03, 2011 at 11:04:17AM -0800, Jeff Davis wrote: > On Sun, 2011-01-02 at 11:40 +, mahmoud elzaiady wrote: > > i ask ,bigserial must not duplicate the value ? > > how solve this problem > > This is probably due to the sequence being reset somehow. Have you > dumped/reloaded recently?

[BUGS] BUG #5812: ecpg problem with array of varchar when using dimension name with length > 12

2011-01-04 Thread Jean-Baptiste Veslin
The following bug has been logged online: Bug reference: 5812 Logged by: Jean-Baptiste Veslin Email address: jean-baptiste.ves...@meteo.fr PostgreSQL version: 9.0.1 Operating system: linux CentOS 5.4 Description:ecpg problem with array of varchar when using dimension