Re: [GENERAL] Npgsql Exception

2010-08-22 Thread Mike Christensen
Sorry, when I had emailed the NHibernate DL the exception was in the subject line. I forgot to copy the subject this time. The exception is: ERROR: 42704: unrecognized configuration parameter "ssl_renegotiation_limit" On Sun, Aug 22, 2010 at 8:54 PM, Mike Christensen wrote: > Hi all, this is

Re: [GENERAL] append_array causes rapid growth according to pg_total_relation_size

2010-08-22 Thread Randall Smith
More information including a workaround. VACUUM ANALYZE is not freeing space after an array_append, but it does after replacing a specific element in the array. So if I do this: update array_big1 set chunk_ids = array_append(chunk_ids, '1') where id = 0; update array_big1 set chunk_ids[1] = chun

[GENERAL] Npgsql Exception

2010-08-22 Thread Mike Christensen
Hi all, this is really a NHibernate issue I believe, but I emailed their DL and all I got was crickets.. Lots and lots of crickets.. I get this error every time I start my app. It also appears in my SQL log files. I'm running Postgres 8.3.x. The exception occurs on this line of code: ISession

Re: [GENERAL] Warm Standby Weirdness

2010-08-22 Thread Tom Lane
Yaroslav Tykhiy writes: > On Thu, Aug 19, 2010 at 11:22:15PM -0400, Tom Lane wrote: >> This is just an educated guess, but I'm going to bet on 32-bit vs 64-bit. >> Are you trying to copy the DB to a machine with different word size? >> Won't work. > Just in case, if anyone ever _really_ needs to

Re: [GENERAL] Warm Standby Weirdness

2010-08-22 Thread Yaroslav Tykhiy
On Thu, Aug 19, 2010 at 11:22:15PM -0400, Tom Lane wrote: > Sam Nelson writes: > > Here's the output from pg_controldata: > > > $ pg_controldata `pwd` > > WARNING: Calculated CRC checksum does not match value stored in file. > > Either the file is corrupt, or it has a different layout than this p

Re: [GENERAL] Warm Standby and resetting the primary as a standby

2010-08-22 Thread Yaroslav Tykhiy
On Sat, Aug 21, 2010 at 12:45:44PM -0400, Bruce Momjian wrote: > Derrick Rice wrote: > > I've been reading up on the documentation for WAL shipping and warm standby > > configuration. One concern that I have (a common one, I'm sure) is that it > > seems that after bringing a standby server up as pr

Re: [GENERAL] nntp not working

2010-08-22 Thread Arturo Pérez
On Aug 22, 2010, at 11:45 AM, Tom Lane wrote: > =?iso-8859-1?Q?Arturo_P=E9rez?= writes: >> I've switched my NNTP to use the GMane system. Is that the only official >> NNTP interface now? > > I've not paid attention to netnews in a very long time, but the last I > heard, the postgresql newsgro

Re: [GENERAL] getting list of columns from a query

2010-08-22 Thread Pavel Stehule
Hello 2010/8/22 c k : > Hi all, > As I am using MS Access for a long time, many tools like ms access provides > a way to get the list of columns from a query. (using filed list in combo > boxes in ms access). But is it possible to get such list of columns from a > query where it is not known to th

Re: [GENERAL] getting list of columns from a query

2010-08-22 Thread Octavio Alvarez
On Sun, 22 Aug 2010 10:27:52 -0700, c k wrote: Hi all, As I am using MS Access for a long time, many tools like ms access provides a way to get the list of columns from a query. (using filed list in combo boxes in ms access). But is it possible to get such list of columns from a query wh

[GENERAL] getting list of columns from a query

2010-08-22 Thread c k
Hi all, As I am using MS Access for a long time, many tools like ms access provides a way to get the list of columns from a query. (using filed list in combo boxes in ms access). But is it possible to get such list of columns from a query where it is not known to the user, that which columns are de

Re: [GENERAL] nntp not working

2010-08-22 Thread Marc G. Fournier
This should be fixed as of yesterday ... On Sun, 22 Aug 2010, Tom Lane wrote: =?iso-8859-1?Q?Arturo_P=E9rez?= writes: Oh, no that's not it. Someone with access to postgresql.org was running an Mail-to-NNTP gateway so that the mailing lists could also be viewed through an NNTP client. My Us

Re: [GENERAL] nntp not working

2010-08-22 Thread Tom Lane
=?iso-8859-1?Q?Arturo_P=E9rez?= writes: > Oh, no that's not it. Someone with access to postgresql.org was running an > Mail-to-NNTP gateway so that the mailing lists could also be viewed through > an NNTP client. My Usenet connection was directly to news.us.postgresql.org. Well, the "someone" w

Re: [GENERAL] nntp not working

2010-08-22 Thread Tom Lane
=?iso-8859-1?Q?Arturo_P=E9rez?= writes: > I've switched my NNTP to use the GMane system. Is that the only official > NNTP interface now? I've not paid attention to netnews in a very long time, but the last I heard, the postgresql newsgroups had never passed an official group creation vote. If

Re: [GENERAL] nntp not working

2010-08-22 Thread Arturo Pérez
On Aug 21, 2010, at 8:10 PM, Christopher Browne wrote: > 2010/8/18 Arturo Pérez : >> Is anyone else having problems accessing the mailing lists through NNTP? > > Yeah, I see the occasional message coming through, but it looks like > the gateway between mail and NNTP isn't working. > -- > http:/