Csaba Nagy wrote:
> On Tue, 2007-07-24 at 19:06, Stephan Szabo wrote:
>>> Unfortunately I don't think this will work. Multiple backends will happily
>>> pick up the same ctid in their selects and then try to delete the same
>>> records.
>> I'm pretty sure he said that the batch processing (and the
Jonas Henriksen wrote:
>>> explain analyze SELECT max(date_time) FROM data_values;
> Goes fast and returns:
In prior postgres versions, the planner could not take advantage of
indexes with max() (nor min()) calculations. A workaround to this was
(given an appropriate index) a query like:
select
Tom Lane wrote:
> chrisj <[EMAIL PROTECTED]> writes:
>> This helped a lot, but ideally I want a tab field delimiter and -F '\t' does
>> not seem to work, any ideas??
>
> I don't think there's any provision for backslash-notation in that
> switch; you'd need to type an actual tab character there.
Lutz Broedel wrote:
> Dear list,
>
> I am trying to verify the password given by a user against the system
> catalog. Since I need the password hash later on, I can not just use the
> authentication mechanism for verification, but need to do this in SQL
> statements.
> Unfortunately, even if I set
Erick Papadakis wrote:
Right now, if I wish to contribute to the documentation, how do I make
it relevant? Look at MySQL docs, or PHP manual. I can leave comments
in a context-relevant manner -- e.g., check at the bottom of page:
http://sg.php.net/manual/en/ref.pgsql.php.
Have you seen the "int
Jonathan Hedstrom wrote:
Scott Marlowe wrote:
On Tue, 2007-01-09 at 13:38, Jonathan Hedstrom wrote:
We recently upgraded from 8.1.4 to 8.2.0 on Fedora Core 6, and are now
seeing a few rather ominous-looking messages.
[ SNIP ]
Also, schedule some maintenance window for your server to run
Jonathan Hedstrom wrote:
Tom Lane wrote:
Scott Marlowe <[EMAIL PROTECTED]> writes:
Also, schedule some maintenance window for your server to run memtest86
and possibly something to check for bad blocks on your drives.
+1 ... I have not seen any instance of "invalid page header" that co
