[list re-added]
> In the eventlog I found quite often the following (therefore
> I assume it has to do with those many postgres.exe's). Does
> this give an indication where to look for the problem/solution?
Yes, it definitly does.
> gegevens zijn deel van de gebeurtenis: LOG: unexpected EOF
"Satya Prakash Tripathi" <[EMAIL PROTECTED]> writes:
> postgres server crashes on running "select count(*) from table;" from psql
> client
I don't think so ;-). Perhaps you have a corrupted copy of the postgres
executables?
> test_db=# select count(*) from test_tbl;
> WARNING: terminating conn
You'd better use plain text messages in newsgroups.
And you should use English.
Here is the document
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html.
You can try with the lines in "Example 20-1. Example pg_hba.conf entries".
(Your pg_hba.conf is not correct.)
Steps:
1.
The following bug has been logged online:
Bug reference: 2461
Logged by: Stephen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Windows Server 2003
Description:pg_dump ftell mismatch error
Details:
HI,
I'm using pgadmin to backup my da
The following bug has been logged online:
Bug reference: 2463
Logged by: Satya Prakash Tripathi
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Linux
Description:postgres server crashes on "select count(*) from table;"
Details:
postgres
""Greg Sabino Mullane"" <[EMAIL PROTECTED]>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> | UPDATE
> | orderby SET orderby = orderby +10
> | WHERE groupid = 1;
> | -> FAILS because of UNIQUE INDEX
>
> One workaround is to do it in two steps, assuming that
> orderby is > 0 for all rows
The following bug has been logged online:
Bug reference: 2462
Logged by: Stephen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Windows Server 2003
Description:pg_dump ftell mismatch error (cont'd)
Details:
This is a continuation of bug
> Hi
>
> Newbie when it comes down to postgre.
>
> OS: Windows XP SP2 Pro Dutch
>
> When I run a DMS (Xinco) that uses postgre (I only use
> postgre for this), a service is started. Xinco uses a
> separate limited Xinco User account.
>
> After starting the service I see several postgre.exe s
This is the statement which having problem: select count(distinct empno) as counter1 from pay_master_history where empno in (select empno from pay_batch_basic_history whereorganizationid like '015003%')
and processyear = '2006' and processmonth = '05' and processbatc
