Wow seems like this post took on a life of it's own. All I wanted to do
was to be able to use a table that someone else has all ready created.
Seems like somewhere someone mentioned a DBA ( which I'm assuming to be
Database Administrator ) well as far as I know we don't have one
though I wish we
Hello, I have the same problem.
I've checked plpython.dll dependencies with depends tool and all is correct.
I tried to install plperl with no success.
What can I do?
Magnus Hagander-2 wrote:
On Tue, Feb 20, 2007 at 05:15:38PM -0500, Rhys Stewart wrote:
resurrection
Ok so i am having
On 2008-03-31 21:16, mark wrote:
is the query I am running , and it takes over 10 seconds to complete
this query...
update users set number_recieved=number_recieved+1 where
uid=738889333;
Every time or only sometimes?
If it is sometimes then I think this query is waiting for a checkpoint.
On Tue, Apr 1, 2008 at 1:22 AM, Tom Lane [EMAIL PROTECTED] wrote:
Please do --- I have a lot of other stuff on my plate.
Please see the attached patch. One change I made is to hold the SHARE lock
on the page while ANALYZE is reading tuples from it. I thought it would
be a right thing to do
On Mon, Mar 31, 2008 at 11:18 PM, Tomasz Ostrowski [EMAIL PROTECTED]
wrote:
On 2008-03-31 21:16, mark wrote:
is the query I am running , and it takes over 10 seconds to complete
this query...
update users set number_recieved=number_recieved+1 where
uid=738889333;
Every time or only
On Tue, 2008-04-01 at 13:07 +0530, Pavan Deolasee wrote:
Please see the attached patch. One change I made is to hold the SHARE lock
on the page while ANALYZE is reading tuples from it. I thought it would
be a right thing to do instead of repeatedly acquiring/releasing the lock.
ANALYZE is a
On Tue, Apr 1, 2008 at 12:44 AM, mark [EMAIL PROTECTED] wrote:
On Mon, Mar 31, 2008 at 11:18 PM, Tomasz Ostrowski [EMAIL PROTECTED]
wrote:
On 2008-03-31 21:16, mark wrote:
is the query I am running , and it takes over 10 seconds to complete
this query...
update users set
How about if i do this inside a procedure:
SELECT setval('sequence',(SELECT max(id) FROM table)) INTO variable;
insert into table values(variable, ..., ...); ?
Will this be transactional? Cause, they say that setval is a command
that its transactional. Using this way i
don´t will need to use a
hh ok
greatest()/least()
2008/4/1, josep porres [EMAIL PROTECTED]:
I cannot find predefined functions to find minimum and maximum of at least
two values.
Aren't there any?
select min(3,6)
3
select max(3,6)
6
Josep Porres
I made a similar question but maybe it was not that clear.
I've a large table (items) linked with other tables (attributes).
Some product ends into a basket.
create table items(
item_id serial primary key,
attributes...
);
create table item_attributes(
item_id int references items
On Mon, Mar 31, 2008 at 05:20:56AM -0600, Pettis, Barry wrote:
I wish I could say that I knew with certainty what schemas are or 2PC
is. Would be nice if I had exposure to other databases as well. I'm
sure that I'd have the same questions about MSft's SQL server.
Schemas are a subdivision
On 2008-04-01 09:44, mark wrote:
I already am running 8.3.1 [ i mentioned in subject].
Missed that, sorry.
I'd first try to set the following on a write-busy 8.3 server to smooth
checkpoint spikes:
checkpoint_segments = 16
checkpoint_timeout = 20min
On Tue, 1 Apr 2008 12:01:21 +0200
Albe Laurenz [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
I've a bunch of functions that operates on the basket (a smaller
list of products with their attributes).
So many functions ends up in repeating over and over a select
similar to:
Ivan Sergio Borgonovo wrote:
I've a bunch of functions that operates on the basket (a smaller list
of products with their attributes).
So many functions ends up in repeating over and over a select similar
to:
select [list of columns] from baskets b
join basket_items bi on
I cannot find predefined functions to find minimum and maximum of at least
two values.
Aren't there any?
select min(3,6)
3
select max(3,6)
6
Josep Porres
Hi,
Is there a way to create new attributes for a login role, like an email
attribute?
I have to keep a few informations on all the users that connect to the
PG server, and their attributes list looks like an elegant place to
store these informations. But I cannot find a way to add new
Ivan Sergio Borgonovo wrote:
I've a bunch of functions that operates on the basket (a smaller
list of products with their attributes).
So many functions ends up in repeating over and over a select
similar to:
select [list of columns] from baskets b
join basket_items bi on
On Tue, Apr 1, 2008 at 1:48 AM, Tomasz Ostrowski [EMAIL PROTECTED]
wrote:
On 2008-04-01 09:44, mark wrote:
I already am running 8.3.1 [ i mentioned in subject].
But I have no experience on anything with more than 1GB of RAM...
Should I reduce shared_buffers to less than 1GB? If that is
Please do --- I have a lot of other stuff on my plate.
Please see the attached patch. One change I made is to hold the SHARE lock
on the page while ANALYZE is reading tuples from it. I thought it would
be a right thing to do instead of repeatedly acquiring/releasing the lock.
I have
On Tue, 1 Apr 2008 14:00:39 +0200
Albe Laurenz [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
It doesn't look as I can do the same stuff with array and
tables/records.
Many times I use joint or aggregates on the basket.
Sorry, my example was unclear.
I was the first not to be
Tomasz Ostrowski [EMAIL PROTECTED] writes:
I'd also set
log_checkpoints=on
to get an idea how it behaves.
Yeah, that's really the *first* thing to do. You need to determine
whether the episodes of slowness are correlated with checkpoints
or not; there's no point fooling with the
Ivan Sergio Borgonovo wrote:
[wants to cache query results in a temporary table for use in
several functions]
yes... but it is not just a matter of caching the data but rather
being able to exploit them with SQL.
Oh, I see, you want to select/join with the cached data.
Then neither arrays nor
Is there a way to create new attributes for a login role, like an email
attribute?
I have to keep a few informations on all the users that connect to the
PG server, and their attributes list looks like an elegant place to
store these informations. But I cannot find a way to add new
On Mon, Mar 31, 2008 at 2:10 PM, Tom Lane [EMAIL PROTECTED] wrote:
Morris Goldstein [EMAIL PROTECTED] writes:
Suppose I have a database with $PGDATA on /dev/sda, and a tablespace
directory on /dev/sdb. Will Postgres start successfully if /dev/sda is
mounted and /dev/sdb is not? If not, why
Simon Riggs [EMAIL PROTECTED] writes:
On Tue, 2008-04-01 at 10:22 -0400, Tom Lane wrote:
In the fourth, if we actually believed this was a problem we'd
need to redesign VACUUM too, as it does the same thing.
VACUUM waits until nobody else has the buffer pinned, so lock contention
is much
On Tue, 1 Apr 2008 16:08:45 +0200
Albe Laurenz [EMAIL PROTECTED] wrote:
[snip]
Since you are looking for a sample, maybe something like that can
get you started:
CREATE SEQUENCE temp_names;
[snip]
I was thinking something in the line of it.
I wasn't that sure of the course to follow.
Just
Simon Riggs [EMAIL PROTECTED] writes:
On Tue, 2008-04-01 at 13:07 +0530, Pavan Deolasee wrote:
Please see the attached patch. One change I made is to hold the SHARE lock
on the page while ANALYZE is reading tuples from it. I thought it would
be a right thing to do instead of repeatedly
On Monday 31 March 2008 4:20 am, Pettis, Barry wrote:
Wow seems like this post took on a life of it's own. All I wanted to do
was to be able to use a table that someone else has all ready created.
Seems like somewhere someone mentioned a DBA ( which I'm assuming to be
Database Administrator )
On Tue, 2008-04-01 at 10:22 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On Tue, 2008-04-01 at 13:07 +0530, Pavan Deolasee wrote:
Please see the attached patch. One change I made is to hold the SHARE lock
on the page while ANALYZE is reading tuples from it. I thought it
My bad.
1. I work at a Manufacturing plant.
2. We identify different process steps using numbers along with a short
and long description
3. For a part we manufacture the system identifies SOME properties of
said part. Things like nuper of process steps, part name, part family,
and other
On Tue, Apr 01, 2008 at 09:12:54AM -0600, Pettis, Barry wrote:
I guess the biggest problem is trying to describe something in terms
that all can understand. On a forum like this most CONTRIBUTORS those
who answer questions speak a language that the typical novice poster
doesn't use or
I have a client who is running this query(just brings back info about
the databases on the server):
select
pgd.datname as database,
pdesc.description,
pgr.rolname as owner,
pgt.spcname as tablespace,
pg_size_pretty(pg_database_size(pgd.oid)) as dbsize,
pg_encoding_to_char(encoding) as encoding,
Ivan Sergio Borgonovo [EMAIL PROTECTED] writes:
I can't really appreciate the difference... or better... I think the
difference may be that I can't take for granted the function will be
cached if I delegate the choice to the optimiser.
You can take for granted that it won't be, because there
On Tue, Apr 01, 2008 at 06:06:35PM +0200, Ivan Sergio Borgonovo wrote:
Would you please be so kind to rephrase:
http://www.postgresql.org/docs/8.1/interactive/xfunc-volatility.html
snip
I can't understand how it can call a function a single time and avoid
to cache the result.
Is it
On Tue, 01 Apr 2008 11:22:20 -0400
Tom Lane [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo [EMAIL PROTECTED] writes:
I can't really appreciate the difference... or better... I think
the difference may be that I can't take for granted the function
will be cached if I delegate the choice to
Tom Lane wrote:
This must be coming from calculate_database_size(). Is
$PGDATA/pg_tblspc actually missing? If the guy has no custom
tablespaces, I can believe that nothing except pg_database_size()
or pg_tablespace_size() would try to touch that subdirectory, so
he might not otherwise notice
-- Original message --
From: Pettis, Barry [EMAIL PROTECTED]
My bad.
1. I work at a Manufacturing plant.
2. We identify different process steps using numbers along with a short
and long description
3. For a part we manufacture the system identifies
Tony Caduto [EMAIL PROTECTED] writes:
The exact error is(as reported from PG Admin III):
ERROR: could not open tablespace directory pg_tblspc: No such file or
directory
This must be coming from calculate_database_size(). Is
$PGDATA/pg_tblspc actually missing? If the guy has no custom
Tony Caduto wrote:
Tom Lane wrote:
This must be coming from calculate_database_size(). Is
$PGDATA/pg_tblspc actually missing? If the guy has no custom
tablespaces, I can believe that nothing except pg_database_size()
or pg_tablespace_size() would try to touch that subdirectory, so
he might
Magnus Hagander wrote:
Tony Caduto wrote:
I will follow up with the client and have him check if that directory
is missing.
I think he may have used the Postbooks win32 installer to install his
server, so it might be that their installer is messed up and not
creating the directory properly or
On Tue, 1 Apr 2008 18:32:25 +0200
Martijn van Oosterhout [EMAIL PROTECTED] wrote:
On Tue, Apr 01, 2008 at 06:06:35PM +0200, Ivan Sergio Borgonovo
wrote:
Would you please be so kind to rephrase:
http://www.postgresql.org/docs/8.1/interactive/xfunc-volatility.html
snip
I can't
Hello,
I am sure this won't be the first e-mail about this issue, however we
are upgrading production-like environment. Please help.
For reproducing I've used two debian servers, same locales (en_US.UTF-8,
en_US ISO-8859-1, hu_HU.UTF-8, hu_HU ISO-8859-2), Debian testing.
Hello,
Using PostgreSQL 8.2, I have atable one of whose columns reference a
column in othertable. I see serialization failures as a result of
*inserts* to atable in the context of:
'SELECT 1 FROM ONLY othertable x WHERE otherid = $1 FOR SHARE OF
x ' in 'INSERT INTO atable (otherid, col2,
Mage [EMAIL PROTECTED] writes:
We would like to upgrade from 8.1 to 8.3. We have UTF-8 and LATIN2
databases. Any idea?
If you were running with a non-C database locale, that was always
broken in 8.1, and you are very fortunate not to have stumbled across
any of the failure cases.
You can
Tony Caduto [EMAIL PROTECTED] writes:
I just used the postbooks installer and it did not create the pg_tblspc
directory, so the issue appears to be caused by a messed up Postbooks
win32 installer. Check out this screenshot:
http://www.milwaukeesoft.com/postbooks_datadir.png
Bizarre. I
Tom Lane wrote:
Mage [EMAIL PROTECTED] writes:
We would like to upgrade from 8.1 to 8.3. We have UTF-8 and LATIN2
databases. Any idea?
If you were running with a non-C database locale, that was always
broken in 8.1, and you are very fortunate not to have stumbled across
any of the
Tom Lane wrote:
Bizarre. I hope you'll tell them to fix that.
Agreed :-)
I bet they just took a snapshot of a install dir that had the postmaster
stopped and used that in their setup. It probably does not do a initdb
during the setup. Why it's missing that directory is a mystery :-)
Hi,
I am a bit stuck finding out how to log autovacuum activity in PostgreSQL 8.2.
In the olden times I used to pipe the pg_autovacuum daemon's output to a file.
Now pg_autovacuum has become part of the core, I wonder if there's some other
possibility of monitoring its activity?
I've got the
On Tue, 2008-04-01 at 21:02 +0200, Markus Wollny wrote:
I am a bit stuck finding out how to log autovacuum activity in
PostgreSQL 8.2. In the olden times I used to pipe the pg_autovacuum
daemon's output to a file. Now pg_autovacuum has become part of the
core, I wonder if there's some other
Tom Lane [EMAIL PROTECTED] writes:
Simon Riggs [EMAIL PROTECTED] writes:
On Tue, 2008-04-01 at 13:07 +0530, Pavan Deolasee wrote:
Please see the attached patch. One change I made is to hold the SHARE lock
on the page while ANALYZE is reading tuples from it. I thought it would
be a right
select schemaname,relname,last_autovacuum,last_autoanalyze from
pg_stat_user_tables;
...should get you what you're after.
On Tue, 1 Apr 2008, Markus Wollny wrote:
Hi,
I am a bit stuck finding out how to log autovacuum activity in PostgreSQL 8.2.
In the olden times I used to pipe the
Mage [EMAIL PROTECTED] writes:
What is the proper use of create database encoding = 'yyy' in
postgresql 8.3?
If you're not using C locale, it has no use whatsoever.
If I understand You, I should avoid it totally, and
convert every affected database dumps to UTF-8, load them and use
Hi,
I am looking around for an ETL tool to transfer data from one Postgres
database to another periodically.
I was wondering if anyone has used Talend's Open Studio or any other
ETL tools and wouldn't mind sharing their thoughts.
Thanks,
Irina
--
Sent via pgsql-general mailing list
Irina Connelly wrote:
Hi,
I am looking around for an ETL tool to transfer data from one Postgres
database to another periodically.
I was wondering if anyone has used Talend's Open Studio or any other
ETL tools and wouldn't mind sharing their thoughts.
Thanks,
Irina
I've been using
Hi,
Le Tuesday 01 April 2008 22:00:11 Irina Connelly, vous avez écrit :
I am looking around for an ETL tool to transfer data from one Postgres
database to another periodically.
You could simply rely on COPY for this, as data coming out of PG could be
trusted to be able to get in the other
Much the same as this person here:
http://archives.postgresql.org/pgsql-general/2008-02/msg00689.php
I am running Postgres 8.2.3 and am seeing the following error messages in my
logs:
LOG: SSL SYSCALL error: Connection reset by peer
LOG: could not receive data from client: Connection reset by
Pettis, Barry wrote:
So yes I use multiple databases. ( 4 of which are )
1. Lists all pats I manufacture ( includes general summary
information
like cycle time, number of process', number of critical process',
number
of metals used, etc... )
2. Lists all process steps at my
On Tue, Apr 1, 2008 at 7:27 AM, Tom Lane [EMAIL PROTECTED] wrote:
Tomasz Ostrowski [EMAIL PROTECTED] writes:
I'd also set
log_checkpoints=on
to get an idea how it behaves.
Yeah, that's really the *first* thing to do. You need to determine
I set this on,
log_checkpoints = on
and
Hi
ERROR: cannot have more than 2^32-1 commands in a transaction
SQL state: 54000
Iam getting the above error when iam running my program. If iam not
wrong this error ocuurs when there are too many statements executing
in one single transaction.
But this error is occuring in a function that iam
Jeff Wigal (Referee Assistant) [EMAIL PROTECTED] writes:
I am running Postgres 8.2.3 and am seeing the following error messages in my
logs:
LOG: SSL SYSCALL error: Connection reset by peer
LOG: could not receive data from client: Connection reset by peer
LOG: unexpected EOF on client
sam [EMAIL PROTECTED] writes:
ERROR: cannot have more than 2^32-1 commands in a transaction
But this error is occuring in a function that iam least expecting it
to occur in.
If you haven't marked the function as read-only (IMMUTABLE or STABLE)
then each statement in it counts as a command.
mark [EMAIL PROTECTED] writes:
I set this on,
log_checkpoints = on
and started postgres using this command
pg_ctl -D /mnt/work/database -l /mnt/work/logs/pgsql.log start
nothing is getting logged in the logfile. should I turn on some other
settings?
You're probably looking in the wrong
That's possible. They are communicating with the server using MS Access,
which is connecting to the server through the Postgres ODBC driver.
On Tue, Apr 1, 2008 at 5:12 PM, Tom Lane [EMAIL PROTECTED] wrote:
Jeff Wigal (Referee Assistant) [EMAIL PROTECTED] writes:
I am running Postgres 8.2.3
Hi List;
Does Postgres allow updates based on the context of a sub-query,
something like the sample below ?
1) Insert data (real_tab.keyID and real_tab.data_desc) into a temp
table (temp_tab)
2) update real_tab
set real_tab.data_desc = temp_tab.data_desc
join real_tab on
Does Postgres allow updates based on the context of a sub-query,
something like the sample below ?
Yes,
Update real_tab
set real_tab.data_desc = temp_tab.data_desc
From temp_tab
Where real_tab.keyID = temp_tab.keyID
(don't repeat your updated table in the from list unless you
Mean to
How I can make dblink to participate in transaction so that remote changes made
by dblink can only be committed if only local transaction succeds.
Here is my current scenario:
I am using two databases A B. In Database A, I have trigger procedure
written for a Table . In this
I would like to increment one field, depending of the value of the
other. here´s an example:
id variable
1 1
2 1
1 2
2 2
can i do that with the following commands?
SELECT setval('sequence',(SELECT max(id) FROM table)) INTO variable;
insert into table values(variable,
Just to clarify few things in the above posting.
My Main DB Client is java (using hibernate) which has Main Transaction
Manager.
This one controls the overall transaction
Work flow is as follows:
1)java program updates a table in Database A
2) As a result Trigger procedure defined for
On Tue, 1 Apr 2008, mark wrote:
current settings all default
#checkpoint_segments = 3
#checkpoint_timeout = 5min
#checkpoint_completion_target = 0.5
#checkpoint_warning = 30s
this is what I have on pg_stat_bgwriter ; how much should I increase
checkpoint_segment checkpoint_completion_target
On Tue, Apr 1, 2008 at 7:42 PM, Morris Goldstein
[EMAIL PROTECTED] wrote:
But that makes me wonder: what about this sequence of events:
- Postgres running normally on /dev/sda and /dev/sdb.
- Update to table in /dev/sdb tablespace is committed but still exists in
WAL.
- Postgres crashes
On Tue, Apr 1, 2008 at 7:56 PM, carty mc [EMAIL PROTECTED] wrote:
In this case the updates that were made using dblink_exec are not getting
rolled back in Database B.
And they won't be. dblink isn't transactional in that way. Your best
bet is to put all the data into one database and use
x asasaxax wrote:
How about if i do this inside a procedure:
SELECT setval('sequence',(SELECT max(id) FROM table)) INTO variable;
insert into table values(variable, ..., ...); ?
Will this be transactional? Cause, they say that setval is a command
that its transactional. Using this way i
x asasaxax wrote:
I would like to increment one field, depending of the value of the
other. here´s an example:
Didn't you just ask this question with practically the same wording a
few days ago?
What was wrong with the answers then? What has changed? What's the
*difference* this time?
73 matches
Mail list logo