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
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 by
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.
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
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
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
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
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
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
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 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
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 different
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, I built
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 |
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
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. What
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
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 error.
I
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
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
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
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
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
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'd done
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,
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.
Apparently
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
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
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
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't
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 something
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 version
[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.2 can perform a REINDEX
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
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
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
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
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
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
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
approaches
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
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;
I
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, and not
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 isn't
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
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.
Thats
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
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
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
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
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
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 for
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
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
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.
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 clause
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 to
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
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..15037.04
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 have
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
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
1341 pages
--- 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 the
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
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
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,
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 holding
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:
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
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 isn't a
-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.
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
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
73 matches
Mail list logo