hmmm. someone on this list has an overactive spam filter. leaving full
headers and stuff so the list admins can decide what to do about it, if
anything.
btw, if the user at the bouncing domain happens to see this its very
VERY rude to bounce spam based on the 'from' address as 90% of -re
sunpeng wrote:
it's in source codes,actually i'm writting codes in postgresql source
codes,just to verify some of my ideas. C language is used.
you would pass the SQL statements to do what you want to the various
libpq library functions...
something like...
PGconn *conn;
PGresult *re
it's in source codes,actually i'm writting codes in postgresql source
codes,just to verify some of my ideas. C language is used.
2010/5/17 Guy Rouillier
> On 5/17/2010 10:31 AM, sunpeng wrote:
>
>> hi,when i do experiment on postgresql 8.4,i need to create a table and
>> insert some tuples,which
On 5/17/2010 10:31 AM, sunpeng wrote:
hi,when i do experiment on postgresql 8.4,i need to create a table and
insert some tuples,which function should i invoke?
for example,i want to create a table with "create table test (uid
int,catcode int)" and insert tuples with "insert into test values(1,1)"
On 17 May 2010 16:00, Richard Broersma wrote:
>
> Is this announcement premature? I don't see where to download 8.4.4.
>
> -- Forwarded message --
> From: Google Alerts
> Date: Mon, May 17, 2010 at 5:18 AM
> Subject: Google Alert - postgresql 8.4
> To: richard.broer...@gmail.com
Le 17/05/2010 07:52, Yan Cheng CHEOK a écrit :
> The pgadmin result seems different with my machine. My friend and I are using
> Windows machine. Are you using Linux machine?
>
My tests this morning were on a Linux machine. I tried tonight with a
Windows PC. Here are the results for three "creat
Le 17/05/2010 14:28, Thom Brown a écrit :
> On 13 May 2010 18:28, Guillaume Lelarge wrote:
>
>> Le 13/05/2010 19:24, Thom Brown a écrit :
>>> On 13 May 2010 17:49, Guillaume Lelarge wrote:
>>>
Le 13/05/2010 14:12, Thom Brown a écrit :
> On 5 March 2009 12:08, Thom Brown wrote:
>> [
PostgreSQL New RPM Sets
2010-05-17
Versions: 8.4.4 8.3.11 8.2.17, 8.1.21, 8.0.25, 7.4.29
-
-
akp geek writes:
> I would like to know if there is a way to restrict
> individual users not to change the work_mem parameter for their session?
No.
> Reason I am asking is if there is 2GB RAM available, if one of the user want
> to set the work_mem to 2GB because query is runnin
dear all -
I would like to know if there is a way to restrict
individual users not to change the work_mem parameter for their session?
Reason I am asking is if there is 2GB RAM available, if one of the user want
to set the work_mem to 2GB because query is running slow. it might cau
On 17 May 2010 17:08, Leif Biberg Kristensen wrote:
> On Monday 17. May 2010 17.13.05 Thom Brown wrote:
>> >
>> > Is this announcement premature? I don't see where to download 8.4.4.
>> >
>> > -- Forwarded message --
>> > From: Google Alerts
>> > Date: Mon, May 17, 2010 at 5:18 A
On Monday 17. May 2010 17.13.05 Thom Brown wrote:
> >
> > Is this announcement premature? I don't see where to download 8.4.4.
> >
> > -- Forwarded message --
> > From: Google Alerts
> > Date: Mon, May 17, 2010 at 5:18 AM
> > Subject: Google Alert - postgresql 8.4
> > To: richard.
Just a reminder -- We've got a few spaces left for lightning talks.
Submit your idea today!
See below for details.
-selena
On Sat, May 8, 2010 at 6:46 AM, Selena Deckelmann wrote:
> Hi!
>
> We're having Lightning Talks again at PgCon - scheduled for 5:30pm on
> May 20th in Ottawa!
>
> Do you ha
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Tom Lane
...
>
> "Ken Winter" writes:
> > The documentation at
> > http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems
> to
> > say that the spe
On 5/17/2010 12:52 AM, Yan Cheng CHEOK wrote:
> The pgadmin result seems different with my machine. My friend and I are using
> Windows machine. Are you using Linux machine?
>
> Thanks and Regards
> Yan Cheng CHEOK
>
>
> **snip**
I use both windows and Linux using pgadmin, and on occasion use
>
> Is this announcement premature? I don't see where to download 8.4.4.
>
> -- Forwarded message --
> From: Google Alerts
> Date: Mon, May 17, 2010 at 5:18 AM
> Subject: Google Alert - postgresql 8.4
> To: richard.broer...@gmail.com
>
>
> Google News Alert for: postgresql 8.4
>
>
Is this announcement premature? I don't see where to download 8.4.4.
-- Forwarded message --
From: Google Alerts
Date: Mon, May 17, 2010 at 5:18 AM
Subject: Google Alert - postgresql 8.4
To: richard.broer...@gmail.com
Google News Alert for: *postgresql 8.4*
*PostgreSQL* develo
On 17 May 2010 15:53, sunpeng wrote:
> Thanks for your quickly reply.
> Maybe i haven't expressed clearly.My purpose is in the postgresql source
> codes which function invoke should i use to create table and insert tuples.
> for example are there any function just like _createTable(char
> *tableN
On 17 May 2010 15:31, sunpeng wrote:
> hi,when i do experiment on postgresql 8.4,i need to create a table and
> insert some tuples,which function should i invoke?
> for example,i want to create a table with "create table test (uid
> int,catcode int)" and insert tuples with "insert into test value
hi,when i do experiment on postgresql 8.4,i need to create a table and
insert some tuples,which function should i invoke?
for example,i want to create a table with "create table test (uid
int,catcode int)" and insert tuples with "insert into test values(1,1)".
thanks millions!
peng
seil...@so-net.net.tw writes:
> I need to know the match columns of referencing and referenced keys.
The query you show definitely won't match them up correctly, since that
=ANY test is not order-sensitive. What you need to do is generate the
integers from 1 to array_length(conkey) and then join
On 05/14/2010 08:49 PM, Igor Neyman wrote:
>
>
>> -Original Message-
>> From: Catalin BOIE [mailto:cboie-pg...@66.com]
>> Sent: Friday, May 14, 2010 5:43 AM
>> To: pgsql-general@postgresql.org
>> Subject: Re: PANIC: corrupted item pointer: 32766
>>
>> Some more info.
>>
>> The PANIC hap
On 05/14/2010 07:16 PM, Emanuel Calvo Franco wrote:
>> The PANIC happens several times per minute, so, is really bad for me.
>>
>> I tried to narrow down based on a field (timestamp) and I found some bad
>> "points", but I cannot delete them (same PANIC message appear).
>>
>> Do you have any idea h
Ken Winter wrote:
The documentation at
http://www.postgresql.org/docs/8.3/static/datatype-datetime.html
seems to say that the special value ‘infinity’ (“later than all
other time stamps”) should work for an date-time column, and the
type “date” is listed as among the date-time
On 13 May 2010 18:28, Guillaume Lelarge wrote:
> Le 13/05/2010 19:24, Thom Brown a écrit :
> > On 13 May 2010 17:49, Guillaume Lelarge wrote:
> >
> >> Le 13/05/2010 14:12, Thom Brown a écrit :
> >>> On 5 March 2009 12:08, Thom Brown wrote:
> [...]
> >>> I'm bringing this thread back to lif
Hi!
I need to know the match columns of referencing and referenced keys.
CREATE TABLE referenced (c1 TEXT,c2 TEXT, PRIMARY KEY(c1,c2));
CREATE TABLE referencing (c1 TEXT,c2 TEXT,c3 TEXT, PRIMARY KEY(c1,c2,c3),
CONSTRAINT fk FOREIGN KEY (c1,c2) REFERENCES referenced (c1,c2));
The following SQL
On Mon, May 17, 2010 at 12:02 AM, Scott Marlowe wrote:
> On Sun, May 16, 2010 at 7:21 PM, Yan Cheng CHEOK wrote:
>> Recently, I try to introduce my friend to use PostgreSQL.
>>
>> However, he first impression is that. PostgreSQL is much slower compared to
>> MySQL. He realize he has to wait for
Scott Marlowe, 17.05.2010 10:58:
Why on earth would anybody compare database performance using a command that
is usually executed only once in the lifetime of a database?
It's like saying "The car from manufacturer A is slower than the one from
manufacturer B, because it takes 1 second longer to
On Mon, May 17, 2010 at 2:35 AM, Thomas Kellerer wrote:
> Yan Cheng CHEOK, 17.05.2010 03:21:
>>
>> Recently, I try to introduce my friend to use PostgreSQL.
>>
>> However, he first impression is that. PostgreSQL is much slower
>> compared to MySQL. He realize he has to wait for 7 seconds, to creat
Yan Cheng CHEOK, 17.05.2010 03:21:
Recently, I try to introduce my friend to use PostgreSQL.
However, he first impression is that. PostgreSQL is much slower
compared to MySQL. He realize he has to wait for 7 seconds, to create
a tmp database.
Why on earth would anybody compare database perfor
Here's a more useful test.
write a simple script that creates a 100 or so dbs. Run it against
each database, and while it's running, pull the power plug. Plug back
in, see if your database comes back up uncorrupted.
If pgsql is on proper db hardware (i.e. it obeys fsync, has battery
backed cach
31 matches
Mail list logo
