In article <[EMAIL PROTECTED]>,
Allan Kamau <[EMAIL PROTECTED]> writes:
> Hi all,
> I am looking for a way of selecting records from a
> table comprising of pairing fields having unique
> semantics, where the pair of values of lets say 'left'
> and 'right' and another pair having values of 'right'
In article <[EMAIL PROTECTED]>,
"Klay Martens" <[EMAIL PROTECTED]> writes:
> I have had a postgresql server up and running smoothly for 1.5 years now -
> no problems at all..but:
> I now need to be able to administer the server remotely, as well as allow
> remote logins from a WAN.
Did you set
In article <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> writes:
> Arnau <[EMAIL PROTECTED]> writes:
>> template1=# create database test with encoding='LATIN9';
>> ERROR: encoding LATIN9 does not match server's locale en_US
>> DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
In article <[EMAIL PROTECTED]>,
Edgars <[EMAIL PROTECTED]> writes:
> Jaime,
> thanks for the response!
> yes, i have tried this VACUMM, it gives some effect but only for some
> time (2hours or so). Maybe you know why it is happening so?
PostgreSQL can't run for long without a proper VACUUM poli
In article <[EMAIL PROTECTED]>,
Chris Browne <[EMAIL PROTECTED]> writes:
> A usual reason why I would want to dump everything except for a few
> tables is that those few tables are particularly enormous and
> particularly useless (at least, for the purposes of my dump).
> In that case, the LAST t
In article <[EMAIL PROTECTED]>,
"Frank Smith" <[EMAIL PROTECTED]> writes:
> Hi
> ID:7
> I am running PostgreSQL 7.2.2 on Red Hat 9 and I am suffering a growing
> performance problem. The problem shows through a slowing of queries and
> an increase in the system CPU usage. Queries that took le
In article <20090204165933.gb32...@alvh.no-ip.org>,
Alvaro Herrera writes:
> Marc Mamin wrote:
>> There are 2 features that would be helpfull in my case:
>>
>> - define vacuum properties on table groups rather than on given tables:
>>
>> For example, I don't want to vacuum daily tables which ca
In article <8f750b7c0902250259w6065515as350aca3b5d7d8...@mail.gmail.com>,
Tony Liao writes:
> hi all,
> I have a table table_A (id serial,prefix varchar),for example.
> now I want to get the id of "johnsmith"'s prefix match table_A.prefix,so
> I do select id from table_A where 'johnsm
In article <2499.1238420...@sss.pgh.pa.us>,
Tom Lane writes:
> In particular, a constraint like "sel=123" is *not* going to lead the
> planner to draw any conclusions about the value of "mod(sel,6)".
> Now, if you'd written "WHERE mod(sel,6)=3", I think it would draw
> the right conclusions.
Yes
> I agree with Scott, if your application generate IN condition, could create
> CASE too, looks like this
> SELECT id, product_id FROM your_table
> WHERE product_id IN (6, 3, 4, 10, 7)
> ORDER BY
> CASE
> WHEN product_id = 6 THEN 1
> WHEN product_id = 3 THEN 2
>
In article ,
Scott Marlowe writes:
> Do you mean when the table was modified (i.e. alter table add column)
> or when the data in the table was changed? If it's when the table was
> changed, the easiest way is to store that in the comment for the table
> whenever you alter it.
Highly interesting
In article <201110311014.45633.ach...@matrix.gatewaynet.com>,
Achilleas Mantzios writes:
> Στις Sunday 30 October 2011 12:34:38 ο/η Akash Kodibail έγραψε:
>> Hi,
>>
>> I am using postgresql 8.4.0
>>
>> Select version() gives:
>>
>> PostgreSQL 8.4.0 on x86_64-unknown-linux-gnu, compiled by GCC
12 matches
Mail list logo