>>> On Fri, Jul 18, 2008 at 2:35 PM, in message
<[EMAIL PROTECTED]>,
Sanjay Rajdev <[EMAIL PROTECTED]> wrote:
> Thanks for the thought, I think that this can be the problem, as
earlier
> there was no indexing on the column, but 2 days back we added index
on 5 of
> columns in the table and "so
Tom,
Thanks for the thought, I think that this can be the problem, as earlier there
was no indexing on the column, but 2 days back we added index on 5 of columns
in the table and "somedate" is one of them. This problem have been noticed
after the index's were added.
I can't test this out as t
Resend attempt -- previous attempt rejected for size. I have NOT
attached the PostgreSQL log (110kB) to this attempt.
--
We had an odd problem the other night which appears to be a rare but
serious bug in PostgreSQL 8.2.4. I don't see anything in the release
notes to indicate that thi
- What was the previous database version?
8.1
- Can you provide DDL for the table?
No, company policies does not allow that.
- What is the exact data type of the field `somedate' ?
datatype is "date"
Regards,
Sanjay Rajdev
- Original Message -
From: "Craig Ringer" <[EMAIL PRO
"Sanjay Rajdev" <[EMAIL PROTECTED]> writes:
> Here is what is happening, I have a datatype "date" column in my database
> called "somedate" there are 277 rows in the database which have "somedate" =
> "2008-07-18".
> When I execute the below query
> "select * from myTable where somedate = '2008-0
Sanjay Rajdev wrote:
If I execute
"select * from myTable where somedate between '2008-07-18' and
'2008-07-18'"
I get all 277 rows.
I'm not able to help you out directly (just another user) but answering
the following questions might help others:
- What was the previous database version?
- C
On Fri, Jul 18, 2008 at 1:07 PM, Bhaskar Sirohi
<[EMAIL PROTECTED]> wrote:
> Hi Dave,
>
> There is no directory as pg_log, there is pg_clog and also there are no
> entries in event viewer related to postgres.
OK, - if you turn on auditing of privilege use for that user (I forget
how, it's been a l
The following bug has been logged online:
Bug reference: 4317
Logged by: Sanjay Rajdev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: Window Server 2003
Description:problem with comparision of datatype date
Details:
I installed a new Po
Hi Dave,
There is no directory as pg_log, there is pg_clog and also there are no
entries in event viewer related to postgres.
On Fri, Jul 18, 2008 at 5:10 PM, Dave Page <[EMAIL PROTECTED]> wrote:
> Please keep messages on-list.
>
> On Fri, Jul 18, 2008 at 12:23 PM, Bhaskar Sirohi
> <[EMAIL PROTE
Please keep messages on-list.
On Fri, Jul 18, 2008 at 12:23 PM, Bhaskar Sirohi
<[EMAIL PROTECTED]> wrote:
> Hi Dave,
>
> Attached is the pg_logs. I could not figure out anything from them.
That's a transaction log from pg_xlog, not pg_log. What is in the
pg_log directory? Are there any PostgreSQL
The following bug has been logged online:
Bug reference: 4316
Logged by: blueos
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3
Operating system: Linux
Description:13 seconds to complete SELECT * FROM
pg_catalog.pg_attribute
Details:
On a server with 5 d
The following bug has been logged online:
Bug reference: 4315
Logged by: jspxnet
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3.1
Operating system: winxp/2003
Description:message encoding is error,not show chinese
Details:
eg:select v;
postgresql use U
12 matches
Mail list logo
