On Mon, 8 Dec 2008, Scott Marlowe wrote:
Are you familiar with this bug:
https://bugs.launchpad.net/debian/+source/linux/+bug/245779
It's the reason my latest db servers are running Centos 5.2, sadly.
By the time I'd found the suggested workaround of setting a boot
option of NO_HZ=y I was alrea
On Tue, 9 Dec 2008, Klint Gore wrote:
How did you fix it? (so its filed in the archive)
klint,
I removed the 'stale' .pid file, then manually started the postmaster (su
postgres -c 'postgres -D /var/lib/pgsql/data &') rather than using the
Slackware startup script (/etc/rc.d/rc.postgresql)
Rich Shepard wrote:
On Mon, 8 Dec 2008, Rich Shepard wrote:
> I had this happen several years ago, but do not recall what fixed the bad
> PID file and socket. The thread had been saved here, but I must have
> inadvertenly deleted it.
Figured out how to fix the problem, but still cannot get
On Mon, 8 Dec 2008, Rich Shepard wrote:
I had this happen several years ago, but do not recall what fixed the bad
PID file and socket. The thread had been saved here, but I must have
inadvertenly deleted it.
Figured out how to fix the problem, but still cannot get SQL-Ledger to
load. Time t
I am trying to get the following program to compile the following program
with Embedded SQL Processor:
#include
main()
{
printf( "I am alive\n" );
#if 0
EXEC SQL CONNECT TO DEFAULT;
#endif
printf( "status is %d\n", sqlca.sqlcode );
}
I am doing this as
Tonny Sapri wrote:
Iwant quit this milis. could you help me? I forget my milis password.
go to this web site http://www.postgresql.org/mailpref/pgsql-general
click "Sign In" at the top left.
find the section that says "Lost Password".
put your email address in there and click the "Mail My
Iwant quit this milis. could you help me? I forget my milis password.
Selalu bisa chat di profil jaringan, blog, atau situs web pribadi! Yahoo!
memungkinkan Anda selalu bisa chat melalui Pingbox. Coba!
http://id.messenger.yahoo.com/pingbox/
--
Sent via pgsql-general mailing list (pg
On Mon, Dec 8, 2008 at 8:16 PM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> 中和刘 wrote:
>> I have just installed postgresql 8.3 on my debian sid, and have set
>> the password of both system user postgres and database user to the
>> same password, but when i connect to it using pgadmin3(from the loca
> >
> > When we get windowing functions, a lot of this pain will go away :)
> >
>
> Yes! Hope it won't be too long now. The patch seems to behave like it
> should
> now :)
> Hopefully we'll see it commited for 8.4.
>
> Though this does not look too much cleaner at least it's standard SQL:
>
> A
Madison Kelly Wrote:
> David Fetter wrote:
> > On Mon, Dec 08, 2008 at 11:16:29PM -, David Rowley wrote:
> >>> -Original Message-
> >>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> >>> [EMAIL PROTECTED] On Behalf Of Madison Kelly
> >>> Sent: 08 December 2008 22:19
> >>> To: pgsql-ge
> -Original Message-
> From: David Fetter [mailto:[EMAIL PROTECTED]
> Sent: 09 December 2008 00:55
> To: David Rowley
> Cc: 'Madison Kelly'; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] SELECT DISTINCT ... ORDER BY problem
>
> On Mon, Dec 08, 2008 at 11:16:29PM -, David Rowley
David Fetter wrote:
On Mon, Dec 08, 2008 at 11:16:29PM -, David Rowley wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Madison Kelly
Sent: 08 December 2008 22:19
To: pgsql-general@postgresql.org
Subject: [GENERAL] SELECT DISTINC
On Mon, 8 Dec 2008, Alvaro Herrera wrote:
Wow. Is this Gentoo by chance?
Alvaro,
Nope. It's Slackware-12.1, and not being at all gentle.
I had this happen several years ago, but do not recall what fixed the bad
PID file and socket. The thread had been saved here, but I must have
inadver
On Mon, Dec 08, 2008 at 11:16:29PM -, David Rowley wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:pgsql-general-
> > [EMAIL PROTECTED] On Behalf Of Madison Kelly
> > Sent: 08 December 2008 22:19
> > To: pgsql-general@postgresql.org
> > Subject: [GENERAL] SELECT DISTIN
David Rowley wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Madison Kelly
Sent: 08 December 2008 22:19
To: pgsql-general@postgresql.org
Subject: [GENERAL] SELECT DISTINCT ... ORDER BY problem
Hi all,
I've got a table that I am
Rich Shepard wrote:
> On Mon, 8 Dec 2008, Rich Shepard wrote:
>
>> I upgraded the distribution on my system and am now having problems
>> opening a local application. /var/log/apache/error.log shows:
>
> More insight. When I stop the postmaster I see this:
>
> [EMAIL PROTECTED] ~]# /etc/rc.d/rc.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Madison Kelly
> Sent: 08 December 2008 22:19
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] SELECT DISTINCT ... ORDER BY problem
>
> Hi all,
>
>I've got a table that I am tr
Hi all,
I've got a table that I am trying to SELECT DISTINCT on one column
and ORDER BY on a second column, but am getting the error:
SELECT DISTINCT ON expressions must match initial ORDER BY expressions
I can't add the second column to the DISTINCT clause because every
row is unique. L
Hello Guys,
The following is my sample program
result R(T.exec("select * from emp"));
string L;
stringstream S;
vector v;
int z,i;
z = R.size();
for (i = 0;i> L;
v.push_back(L);
}
There is a table emp with single column,while I am working on this module I
encountere
On Mon, 8 Dec 2008, Rich Shepard wrote:
I upgraded the distribution on my system and am now having problems
opening a local application. /var/log/apache/error.log shows:
More insight. When I stop the postmaster I see this:
[EMAIL PROTECTED] ~]# /etc/rc.d/rc.postgresql stop
Shutting down P
I upgraded the distribution on my system and am now having problems
opening a local application. /var/log/apache/error.log shows:
Error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.
Erik Jones <[EMAIL PROTECTED]> writes:
> I've just run up against a problem with ALTER LANGUAGE ... OWNER
> TO ... wherein the change of ownership does not propagate to a
> language's handler and validator functions preventing you from
> dropping the role if it created a language. I'm assumi
Greetings,
I've just run up against a problem with ALTER LANGUAGE ... OWNER
TO ... wherein the change of ownership does not propagate to a
language's handler and validator functions preventing you from
dropping the role if it created a language. I'm assuming a valid
workaround is manuall
On Mon, Dec 8, 2008 at 10:47 AM, Liraz Siri <[EMAIL PROTECTED]> wrote:
>> This sounds great. If I wind up with a big machine to test it on I'll
>> tell you how it goes.
>
> Thanks, though you don't necessarily have to wait for a "big machine" if
> you just want to give the appliance a go. A little
Thanks all
On 12/7/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Josh Harrison" <[EMAIL PROTECTED]> writes:
>> How can I give the ALTER permission
>
> You can't grant ALTER permission --- that's only allowed to the table
> owner. However, you could make thw table be owned by a group role and
> grant
> This sounds great. If I wind up with a big machine to test it on I'll
> tell you how it goes.
Thanks, though you don't necessarily have to wait for a "big machine" if
you just want to give the appliance a go. A little machine or even a
virtual machine should do.
> Are you familiar with this bu
"Richard Broersma" <[EMAIL PROTECTED]> writes:
> Does this mean the PostgreSQL supports row-wise updates? When did this
> happen?
Only sort of ...
http://archives.postgresql.org/pgsql-committers/2006-09/msg00021.php
I didn't want this applied
http://archives.postgresql.org/pgsql-patches/2006-07
On Sat, Dec 6, 2008 at 7:36 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
>> itidb=> update joblist set (full_name, email_address, recruiter,
>> itidb(> subscribed, verified, created_at, updated_at) =
>> itidb-> ('[name hidden]', '[email address hidden]', false, true
>> itidb(> true, current_t
On Mon, Dec 8, 2008 at 7:06 AM, Liraz Siri <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I am one of the developers for TurnKey Linux, a new opensource project
> that develops a family of lightweight installable live CDs optimized for
> various server-type tasks including LAMP, Ruby on Rails, Djang
On Mon, Dec 8, 2008 at 3:28 AM, Sebastian Böhm <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a table with a lot of columns (text and integer).
>
> It currently has 3Mio Rows.
>
> Updating a column in all rows (integer) takes endless (days).
I'm afraid you may not understand how postgresql's MVCC imp
2008/12/8 Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>
> try rewriting it to something like:
>
> update users set price = p.price from prices p where p.type =
> 'normal_price' and p.currency = users.currency;
also avoid "fake" updates:
update users set price = p.price from prices p where p.type =
'n
Hi everyone,
I am one of the developers for TurnKey Linux, a new opensource project
that develops a family of lightweight installable live CDs optimized for
various server-type tasks including LAMP, Ruby on Rails, Django, Joomla,
Drupal, MediaWiki, and others:
http://www.turnkeylinux.org/applianc
try rewriting it to something like:
update users set price = p.price from prices p where p.type =
'normal_price' and p.currency = users.currency;
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-g
On Sun, Dec 07, 2008 at 02:36:56PM -0500, Jaime Casanova wrote:
> Hi,
>
> any one has doing this... is there a good tutorial o directions for it?
The answer to this is highly dependent on the system you're using.
What is it?
A
--
Andrew Sullivan
[EMAIL PROTECTED]
--
Sent via pgsql-general m
Hi,
I have a table with a lot of columns (text and integer).
It currently has 3Mio Rows.
Updating a column in all rows (integer) takes endless (days).
The column I update is not indexed.
How can I tune postgres to do this much more quickly?
VMstat looks like this:
r b swpd free buff
On Tue, Dec 02, 2008 at 05:35:35PM +0530,
ravi kiran <[EMAIL PROTECTED]> wrote
a message of 19 lines which said:
> I am using the psqlodbc driver to connect to postgresql... But this
> is not supporting all the languages that UTF should support..
An important thing: the Unicode character set,
> From: Tom Lane <[EMAIL PROTECTED]>
>
> You've provided no evidence that this is a bad plan.
>
Looks like I didn't take the time to understand properly what the explains were
showing.
> In particular, the plan you seem to think would be better
> would involve
> an estimated 153 iterations of
WireSpot wrote:
> This mechanism is still not perfect. Technically it is still possible
> for race conditions to appear. Apparently (in PHP at least) pg_connect
> does persistent connections by default.
Nope - pg_pconnect() does that. Multiple calls to pg_connect() within
the same script will give
中和刘 wrote:
> I have just installed postgresql 8.3 on my debian sid, and have set
> the password of both system user postgres and database user to the
> same password, but when i connect to it using pgadmin3(from the local
> machine), i got the error:
> here is the log messages
> --
39 matches
Mail list logo
