I got installed on my windows box and my debian box. But is there a way
to install 8.2 on centos 4 using yum? I am fairly ignorant about yum but
am trying to figure this out.
---(end of broadcast)---
TIP 4: Have you searched our list archives
Oops! [EMAIL PROTECTED] (Cornelia Boenigk) was seen spray-painting on a wall:
> Hi all
>
> If I have a running transaction in database1 and try to vacuum
> database2 but the dead tuples in database2 cannot be removed.
>
> INFO: vacuuming "public.dummy1"
> INFO: "dummy1": found 0 removable, 14
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/06/06 16:34, Wei Weng wrote:
> On Tue, 2006-12-05 at 15:56 -0500, Wei Weng wrote:
[snip]
> I think I have discovered the reason for why the query runs so slow. The
> original query has an ORDER BY Field1 clause that I forgot to put in my
> email.
On Wed, 2006-12-06 at 15:00 -0500, Chris Browne wrote:
> Let me add another question to this; this might possibly be worthy of
> a TODO for 8.3 or so...
>
> What if I wanted to:
> ALTER TABLE distributors ADD PRIMARY KEY CONCURRENTLY (dist_id);
> ?
>
> We have a number of cases where there is
I have a signifigant number of tables that each have a name_date
naming scheme. I want to write a function that takes a start and end
date as arguments, and optionally a name, and returns a view of all
tables joined together by the name of the supplied name, er - if
supplied. is there a better way
Cornelia Boenigk <[EMAIL PROTECTED]> wrote:
>
> Hi Bill
>
> > I don't believe that's the reason. AFAIK, activity in one database
> > will never block activity in another.
>
> This way I read the documentation.
psql -U pgsql db2
Welcome to psql 8.2.0, the PostgreSQL interactive terminal.
Type
Hi,
On Thursday 07 December 2006 8:20 am, [EMAIL PROTECTED] wrote:
> I got installed on my windows box and my debian box. But is there a way
> to install 8.2 on centos 4 using yum? I am fairly ignorant about yum but
> am trying to figure this out.
There's no public repository for CentOS4 holdin
I got installed on my windows box and my debian box. But is there a way
to install 8.2 on centos 4 using yum? I am fairly ignorant about yum but
am trying to figure this out.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi
as soon as I committed the open transaction the hangig vacuum full
completed and the table was vacuumed:
regards
Conni
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi Bill
> I don't believe that's the reason. AFAIK, activity in one database
> will never block activity in another.
This way I read the documentation.
> I would suspect that you haven't vacuumed this database in a long time,
I created both databases one hour ago for just testing this behavio
--- Jeff > You can create a table called order_item with columns that exist for
all
> items (the shared columns). Create a table called merchandise with
> columns that exist only for merchandise and not other items (without any
> of the shared columns).
>
> When you insert new merchandise, put t
Cornelia Boenigk <[EMAIL PROTECTED]> wrote:
>
> Hi all
>
> If I have a running transaction in database1 and try to vacuum database2
> but the dead tuples in database2 cannot be removed.
>
> INFO: vacuuming "public.dummy1"
> INFO: "dummy1": found 0 removable, 14 nonremovable row versions in
Hi all
If I have a running transaction in database1 and try to vacuum database2
but the dead tuples in database2 cannot be removed.
INFO: vacuuming "public.dummy1"
INFO: "dummy1": found 0 removable, 14 nonremovable row versions in
1341 pages
DETAIL: 135000 dead row versions cannot be
On Wed, 2006-12-06 at 13:58 -0700, Keary Suska wrote:
> My thoughts then turned to table inheritance, but I am not sure whether this
> addresses the issue or introduce new problems. My thought was that I could
> have an "order_item" table with the columns/data shared by all line items,
> and then h
"Nathan Boley" <[EMAIL PROTECTED]> writes:
> Merge Join (cost=883182.60..1024622.03 rows=6873573 width=89)
> Merge Cond: ("outer".pkeycolumn1 = "inner".pkey)
> -> Sort (cost=93387.50..94711.01 rows=529404 width=18)
> Sort Key: table2.pkey
> -> Seq Scan on table2 (cost=0.00..
On Dec 6, 2006, at 2:34 PM, Wei Weng wrote:
On Tue, 2006-12-05 at 15:56 -0500, Wei Weng wrote:
I have a table that has roughly 200,000 entries and many columns.
The query is very simple:
SELECT Field1, Field2, Field3... FieldN FROM TargetTable;
TargetTable has an index that is Field1.
I t
On Wed, 2006-12-06 at 14:48, Curtis Braly wrote:
> I recently installed this database to use with Sam Broadcaster for my
> internet radio station. When I log into Sam Broadcaster is should
> automatically connect to my database. It is giving me an error
> message stating that it unable to connect
On mið, 2006-12-06 at 17:34 -0500, Wei Weng wrote:
> On Tue, 2006-12-05 at 15:56 -0500, Wei Weng wrote:
> > I have a table that has roughly 200,000 entries and many columns.
>...
> I think I have discovered the reason for why the query runs so slow. The
> original query has an ORDER BY Field1 claus
On Wed, Dec 06, 2006 at 10:45:08AM -0500, Schwenker, Stephen wrote:
> ... I know it's not
> the best solution but I couldn't get an answer fast enough because every
> time I send an email to the list, I get a message saying it was stalled
> and I have to wait for it to be approved by the moderator
I recently installed this database to use with Sam Broadcaster for my
internet radio station. When I log into Sam Broadcaster is should
automatically connect to my database. It is giving me an error
message stating that it unable to connect to server. I am not a big
computer guy, so I am very c
On Dec 7, 2006, at 0:26 , Tom Lane wrote:
Michael Glaesemann <[EMAIL PROTECTED]> writes:
I'm trying to shift the first element off of an array, but I'm just
not getting it. I'm not necessarily interested in saving the rest of
the array. i just want to get the first element, which in this case
On Tue, 2006-12-05 at 15:56 -0500, Wei Weng wrote:
> I have a table that has roughly 200,000 entries and many columns.
>
> The query is very simple:
>
> SELECT Field1, Field2, Field3... FieldN FROM TargetTable;
>
> TargetTable has an index that is Field1.
>
I think I have discovered the reason
Keary Suska wrote:
I have a problem I am trying to address and am looking to see if table
inheritance may be the solution.
My problem is this: I have a POS system using basic POS principles--i.e., I
have an "invoice" table, with a one-to-many related "line items" table. Now,
each line item may s
> I don't list my email in newsgroups because they're primary resources
> for spammers.
A lot of users will create a Junk email address specifically for this and other
lists.
Please realize that any user who's emails get bounced because of false email
addresses, exceeded
disks quotas, or aut
On Wed, Dec 06, 2006 at 12:16:35PM -0800, wheel wrote:
re Bruce Momjian
> Wow, what an unfriendly dude!
Well, he's one of the very guys who make all this
(PostgreSQL, that is) happen for us.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
2006/12/6, Markus Schiltknecht <[EMAIL PROTECTED]>:
Hi,
Tomi N/A wrote:
>> > When the subselect returns a lot of results, pgsql really takes it's
>> time.
>
> 8.1.something
PostgreSQL 8.2 improved a lot for IN clauses with lots of values. I
think it now performs as good as an equal join query.
I have a problem I am trying to address and am looking to see if table
inheritance may be the solution.
My problem is this: I have a POS system using basic POS principles--i.e., I
have an "invoice" table, with a one-to-many related "line items" table. Now,
each line item may specify one of certain
On Wed, 2006-12-06 at 01:17, swati desai wrote:
> i am trying to connect php to postgresql but im getting warning FATAL:
> IDENT authentication failed... for user and pg_connect("dbname=swati
> user=xyz password=abc");
>
> and hence cant work
> plz tell me wat is d problem
Your pg_hba.conf file
On Wed, 2006-12-06 at 14:16, wheel wrote:
> In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> says...
> > [ The author's email address is clearly bogus, so I can't privately send
> > him email.]
> >
> > You seems to be trying to get help by supplying the least amount of
> > information possible
km wrote:
Hi all,
i could not do variable substitution in plpgsql procedure.
The variable names are taken as it is but not substituted in the SQL query.
what could be the problem ?
FOR result IN "SELECT x,y,z FROM mydata WHERE x = a AND y < b AND z > c" LOOP
RETURN NEXT result;
What exactly are the restrictions of a serial column? It's just standard
integer value with a default value that calls the nextval function.
The deletion process produces gaps and/or voids. The only way to resurect
the gapless sequence, starting at 1, is to drop and re-create the table or
ser
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> [ The author's email address is clearly bogus, so I can't privately send
> him email.]
>
> You seems to be trying to get help by supplying the least amount of
> information possible, and not even fully typing out words. Such
> approache
Hi,
the problem is that i can insert, or I think that it is insert (it didn't
show any error), well. But when I try to read the large object in the db,
it didn't read nothing. The last var parameter of SQLbindCol,
StrLen_or_IndPtr, ever return 0.
I don't know where the error is. Any Idea to fix
i am trying to connect php to postgresql but im getting warning FATAL: IDENT
authentication failed... for user and pg_connect("dbname=swati user=xyz
password=abc");
and hence cant work
plz tell me wat is d problem
Thank you everybody,
I decided to modify the export process to vacuum right after the export
and that has done the trick to clean up the filesystem. I know it's not
the best solution but I couldn't get an answer fast enough because every
time I send an email to the list, I get a message saying it
Howdy,
I'm trying to create a schema in which there will be simple a view for
each table that will have the same columns and can be acted on in the
same way as the underlying table
An example of one table and its view would be:
CREATE TABLE test (id int, text_field varchar(100));
CREATE VIEW _te
Hi,
I just created a new column on a relatively large table (~ 2 mil rows over
400 mb in tablesize) and am trying to populate it from another much smaller
table by using an update query .
The purpose of the query to set a bool flag if the user for the action on
table1 is the last user, as determi
Hi all,
i could not do variable substitution in plpgsql procedure.
The variable names are taken as it is but not substituted in the SQL query.
what could be the problem ?
code looks like this:
--
CREATE OR REPLACE FUNCTION test(a te
[EMAIL PROTECTED] (Bill Moran) writes:
> In response to Alvaro Herrera <[EMAIL PROTECTED]>:
>
>> Bill Moran wrote:
>> > In response to Josh Berkus <[EMAIL PROTECTED]>:
>> >
>> > > -- Online index builds
>> >
>> > I'm particularly curious about this feature. Does this mean that
>> > PostgreSQL 8.
On 03/12/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Michael Guyver" <[EMAIL PROTECTED]> writes:
> ... Running the array_append version is faster by at least one order of
> magnitude in these examples.
Really? I see only about a 50% advantage (155 msec vs 105 msec) in both
8.1 and 8.2. What PG ve
Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> I have a query that if I do "explain" shows an other plan than if I do
> "explain analyze" with that same query (immediately after the explain).
Really? What PG version is this? Can you provide a self-contained
test case?
> Does it have to do some
> I didn't notice this kind of sensitivity with MSSQL, but again, I
> can't easily reproduce what I've been doing.
Funny, although it was better at the IN type of query, so the difference was
not as great, MSSQL also typically did better with the query expressed as a
join--older versions, I haven'
I am receiving an error message about a missing "From Clause" in an insert
statement.
I've tried a number of variations of adding a from clause with no success.
Could someone help with the following statement??
Insert Into p_id.loop_sequence (monitor) values(p_id.loops.monitor) ;
Bob Pawley
Hi,
Whats the difference between a module and a bundle as i can see while
downloading DBI from
CPAN website.
What exactly needs to be downloaded . I'm kind of not sure about it.
Thanks,
Jas
On 12/4/06, Albe Laurenz <[EMAIL PROTECTED]> wrote:
> Trying to connect to it throught perl code.
> Just
Casey Duncan wrote:
On Dec 5, 2006, at 11:04 PM, Joost Kraaijeveld wrote:
Does PostgreSQL lock the entire row in a table if I update only 1
column?
Know that updating 1 column is actually updating the whole row. So if
one transaction updates column A of a row, it will block another
concurre
On Dec 5, 2006, at 11:04 PM, Joost Kraaijeveld wrote:
Does PostgreSQL lock the entire row in a table if I update only 1
column?
Know that updating 1 column is actually updating the whole row. So if
one transaction updates column A of a row, it will block another
concurrent transaction that
Hi,
On Wed, 2006-12-06 at 16:55 +0200, Devrim GUNDUZ wrote:
> > Is the srpm for compat-postgresql downloadable somewhere?
>
> I don't plan to upload them somewhere, because:
After thinking a bit (and talking with Alvaro and Magnus), I decided to
put them to main FTP site.
They are under binar
On Wed, 2006-12-06 at 10:15, Vivek Khera wrote:
> On Dec 5, 2006, at 4:09 PM, Scott Marlowe wrote:
>
> > I recently tossed 8.1 on my workstation which runs a little reporting
> > application here. I pointed the app from 7.4 to 8.1 and got a visit
> > within about an hour from a user, asking if I'
I have a query that if I do "explain" shows an other plan than if I do
"explain analyze" with that same query (immediately after the explain).
Is that possible, and if so, why? Does it have to do something with
vacuum?
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nij
Hi,
On Wed, 2006-12-06 at 16:32 +0100, Bernhard Weisshuhn wrote:
> I don't get it.
Per offlist discussion with Bernhard (thanks again for your patience and
detailed testing), we now have the correct RPM. It is tagged as
fc6.x86_64 and will hit the main FTP site shortly.
It seems a weird tarri
On Dec 5, 2006, at 5:07 PM, Josh Berkus wrote:
Ragnar,
Now that this has been announced, should not
http://www.postgresql.org/docs/current/ and co be
redirected to http://www.postgresql.org/docs/8.1/
instead of http://www.postgresql.org/docs/8.2/
in particular, the press release's link to the
On Dec 5, 2006, at 4:09 PM, Scott Marlowe wrote:
I recently tossed 8.1 on my workstation which runs a little reporting
application here. I pointed the app from 7.4 to 8.1 and got a visit
within about an hour from a user, asking if I'd done anything to my
database. Worrying that I'd made some
Download the contrib module .tgz from PGFoundry and check out the
readme. Syntax is explained therein. It's a multi-step process, it
appears.
I don't especially care for the term 'full disjunction' to describe this
operation, but it seems to be an understood relational operation.
--
Brandon Aik
Devrim GUNDUZ schrieb:
> Hi,
>
> On Wed, 2006-12-06 at 15:39 +0100, Bernhard Weisshuhn wrote:
>> error: unpacking of archive failed on file
>> /usr/lib64/libpq.so.4;4576d3af: cpio: MD5 sum mismatch
>
> Please download the RPM from another mirror, or re-download it. I could
> not duplicate that er
On Tue, Dec 05, 2006 at 17:31:53 +0530,
deepak pal <[EMAIL PROTECTED]> wrote:
> hi can we make a field auto incrementing field using Time Stamp data type
You can use a column default that uses current_timestamp for its expression.
If you also want to handle updates or override cases where people
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> I'm trying to shift the first element off of an array, but I'm just
> not getting it. I'm not necessarily interested in saving the rest of
> the array. i just want to get the first element, which in this case
> is another array.
No, it isn't.
Hi,
On Wed, 2006-12-06 at 15:39 +0100, Bernhard Weisshuhn wrote:
> error: unpacking of archive failed on file
> /usr/lib64/libpq.so.4;4576d3af: cpio: MD5 sum mismatch
Please download the RPM from another mirror, or re-download it. I could
not duplicate that error.
> Is the srpm for compat-postgr
I'm trying to shift the first element off of an array, but I'm just
not getting it. I'm not necessarily interested in saving the rest of
the array. i just want to get the first element, which in this case
is another array.
# select * from arrays;
this_array_id |this_arra
Devrim GUNDUZ schrieb:
> Hi,
>
> On Wed, 2006-12-06 at 13:14 +0100, Albe Laurenz wrote:
>> I have notified the packager and hope that the problem will be fixed
>> soon.
>
> After thinking about it a bit, I thought it is the only solution to
> prepare different RPMs per platform :-(
>
> Per this
Hi,
On Wednesday 06 December 2006 9:20 pm, Devrim GUNDUZ wrote:
> Hi,
>
> On Wed, 2006-12-06 at 13:14 +0100, Albe Laurenz wrote:
> > I have notified the packager and hope that the problem will be fixed
> > soon.
>
> After thinking about it a bit, I thought it is the only solution to
> prepare diff
On Wed, Dec 06, 2006 at 08:26:45AM -0500, Dave Cramer wrote:
> >>Unless you specifically ask for it postgresql doesn't lock any
> >>rows when you update data.
> >>
> >Thats not right. UPDATE will force a RowExclusiveLock to rows
> >matching the WHERE clause, or all if no one is specified.
>
>
Hi,
Dave Cramer wrote:
Apparently I've completely misunderstood MVCC then
Probably not. You are both somewhat right.
Jens Schipkowski wrote:
>> Thats not right. UPDATE will force a RowExclusiveLock to rows
>> matching the WHERE clause, or all if no one is specified.
That almost right, Ro
On 6-Dec-06, at 8:20 AM, Jens Schipkowski wrote:
On Wed, 06 Dec 2006 13:29:37 +0100, Dave Cramer <[EMAIL PROTECTED]>
wrote:
Unless you specifically ask for it postgresql doesn't lock any
rows when you update data.
Thats not right. UPDATE will force a RowExclusiveLock to rows
matching t
Hi,
On Wed, 2006-12-06 at 13:14 +0100, Albe Laurenz wrote:
> I have notified the packager and hope that the problem will be fixed
> soon.
After thinking about it a bit, I thought it is the only solution to
prepare different RPMs per platform :-(
Per this, I built new packages for RHEL4 for both
On Wed, 06 Dec 2006 13:29:37 +0100, Dave Cramer <[EMAIL PROTECTED]> wrote:
Unless you specifically ask for it postgresql doesn't lock any rows when
you update data.
Thats not right. UPDATE will force a RowExclusiveLock to rows matching the
WHERE clause, or all if no one is specified.
@Joost
> I'm trying to install PostgreSQL 8.2.0 ony my development box using
rpm on
> CentOS 4.4. Currently I'm stuck at installing compat-postgresql-libs
with
> the following error:
>
> libc.so.6(GLIBC_2.4) is needed by compat-postgresql-libs-4-1PGDG.i386
> libcrypto.so.6 is needed by compat-postgres
Unless you specifically ask for it postgresql doesn't lock any rows
when you update data.
Dave
On 6-Dec-06, at 2:04 AM, Joost Kraaijeveld wrote:
Does PostgreSQL lock the entire row in a table if I update only 1
column?
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nij
Hi,
On Wednesday 06 December 2006 5:26 pm, Devrim GUNDUZ wrote:
> Hi,
>
> On Wed, 2006-12-06 at 16:43 +0800, Leonard Soetedjo wrote:
> > I'm trying to install PostgreSQL 8.2.0 ony my development box using rpm
> > on CentOS 4.4. Currently I'm stuck at installing compat-postgresql-libs
> > with the
Wei Weng wrote:
I have a table that has roughly 200,000 entries and many columns.
The query is very simple:
SELECT Field1, Field2, Field3... FieldN FROM TargetTable;
TargetTable has an index that is Field1.
The thing is on this machine with 1Gig Ram, the above query still takes
about 20 secon
Hi,
On Wed, 2006-12-06 at 16:43 +0800, Leonard Soetedjo wrote:
> I'm trying to install PostgreSQL 8.2.0 ony my development box using rpm on
> CentOS 4.4. Currently I'm stuck at installing compat-postgresql-libs with
> the following error:
>
> libc.so.6(GLIBC_2.4) is needed by compat-postgresql
I ran into an interesting issue trying to pass an array to a plpythonu function
(Postgresql 8.03).
When I googled the issue I found a number of people asking similar questions and they haven't found
an answer. The problem is that there is no type mapped from a postgresql array to a python list.
> I get the following error installing the binary RPMS for RedHat es 4:
>
> [EMAIL PROTECTED] postgres]# rpm -Uvh compat-postgresql-libs-4-1PGDG.i386.rpm
> error: Failed dependencies:
> libc.so.6(GLIBC_2.4) is needed by
compat-postgresql-libs-4-1PGDG.i386
> libcrypto.so.6 is needed
Hi,
I'm trying to install PostgreSQL 8.2.0 ony my development box using rpm on
CentOS 4.4. Currently I'm stuck at installing compat-postgresql-libs with
the following error:
libc.so.6(GLIBC_2.4) is needed by compat-postgresql-libs-4-1PGDG.i386
libcrypto.so.6 is needed by compat-postgresql-libs
73 matches
Mail list logo
