On Wed, Mar 02, 2005 at 09:21:44AM +0200, Sim Zacks wrote:
PostGreSQL 8.0beta1
That's pretty old. Have you tried 8.0.1?
I have a function that uses a cursor and it is giving me the error: cursor
crsr already in use when the parameters I pass in come from another table.
The function works
I haven't tried 8.0.1 yet. I am planning on making the upgrade soon, but
since I haven't seen this issue discussed I did not think it had been fixed
just because I am using an older version. I did search the Internet and
found one person who had the same issue and found a workaround that won't
You might want to take a look at
http://www.daffodildb.com/replicator.html
It claims to be able to replicate between different databases, including
Sql server and postgres. If you try it pleases share your experience
with us, I haven't seen yet a review involving replication between
different DB
Sim Zacks wrote:
create or replace function testcursor(thistestid int) returns varchar as
$$
declare
crs Cursor for select comments from test a join test2 b on
a.testid=b.testid where a.TestID=thistestid;
thiscomment varchar;
totalstr varchar;
begin
open crs;
fetch crs into thiscomment;
If I add close crs; before the function returns, I get this:
SELECT name, testcursor(testid) FROM test;
name | testcursor
--+
Bob | -Comment 1-Comment 2-Comment 3
Mark | -Comment 1
Tom |
(3 rows)
You got it.
I was closing the cursor at
Always close your cursors.
Thanks.
In my real example I had multiple return points and did not close the cursor
before each one.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining
On Wed, Mar 02, 2005 at 11:15:52AM +0200, Sim Zacks wrote:
select name,testcursor(testid) from test; --doesn't work
select name,testcursor(testid) from test where testid=1; -- works (as does
testid=2 or 3)
If I add close crs; before the function returns, I get this:
SELECT name,
If the number is negative there needs to be room for the minus sign...
On Tue, Mar 01, 2005 at 09:25:02AM -, Ben Trewern wrote:
From the docs:
FM suppresses leading zeroes and trailing blanks that would otherwise be
added to make the output of a pattern be fixed-width
It works now
hi all,
running amd64 fedora core 3 w/ default postgresql
7.4.7-3. did asu - , su postgres and createdb mydb as
explained in the postgresql tutorial. installed the
latest pgadmin3 and am trying to connect to this
database. as i wasn't sure what the FC3 default
password was for postgres, i changed
Did you start the postmaster using '-i' to allow tcp/ip connections?
Sean
On Mar 2, 2005, at 6:15 AM, Jonathan Schreiter wrote:
hi all,
running amd64 fedora core 3 w/ default postgresql
7.4.7-3. did asu - , su postgres and createdb mydb as
explained in the postgresql tutorial. installed the
latest
On Wed, 2 Mar 2005, Jonathan Schreiter wrote:
hi all,
running amd64 fedora core 3 w/ default postgresql
7.4.7-3. did asu - , su postgres and createdb mydb as
explained in the postgresql tutorial. installed the
latest pgadmin3 and am trying to connect to this
database. as i wasn't sure what the FC3
Did you set up the pg_hba.conf file with the proper security rights?
Jonathan Schreiter [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
hi all,
running amd64 fedora core 3 w/ default postgresql
7.4.7-3. did asu - , su postgres and createdb mydb as
explained in the postgresql
On Tue, 2005-03-01 at 09:44 +1300, Envbop wrote:
Hi
I've just inherited a PostgreSQL database, for which I do not have any
details of, like database name or the users.
This used to be a library database which was managed via a web page written
in php.
Its running on a Linux box.
The front
I manage a Debian/Linux machine which runs PostgreSQL 7.4.7.
All the user accounts, including mine, are in a LDAP database. Thanks
to NSS (Name Service Switch) all applications have access to the LDAP
accounts (getpwuid(3) and getpwnam(3) use LDAP). But not PostgreSQL.
When I connect locally
Hello..
I've got this error and I don't know how to fix
it.
Since it's an production database , I can't drop
recreate it..
Here are some infos below..
[EMAIL PROTECTED] gateway]# psql -U postgres -h
127.0.0.1 template1Welcome to psql 7.4.5, the PostgreSQL interactive
terminal.
Type:
Hi,
I tried to test plperl and got the following error with the very first
example from chapter 37:
CREATE OR REPLACE FUNCTION perlmax(integer,integer)
RETURNS integer AS $$
if ($_[0] $_[1]) { return $_[0]; } return $_[1];
$$ LANGUAGE plperl;
--
error from Perl function: trusted Perl functions
On 2/28/05 6:53 PM, Tom Lane [EMAIL PROTECTED] wrote:
Again, VACUUM VERBOSE info would be informative (it's sufficient to look
at your larger tables for this).
It took 5.2 hours again tonight to do the vacuum. I don't see anything out
of the ordinary - no explanation for the non-linear
Hemapriya wrote:
Hi,
Does postgres support any system functions that
decode/decrypt the user passwords stored in pg_shadow
system catalog.
Is there a way to retrieve the passwords, if
forgotten.
No. They are MD5 and are designed to be unencryptable.
--
Bruce Momjian
Hi,
Does postgres support any system functions that
decode/decrypt the user passwords stored in pg_shadow
system catalog.
Is there a way to retrieve the passwords, if
forgotten.
Thanks in Advance.
Priya
__
Celebrate Yahoo!'s
Envbop [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi
I've just inherited a PostgreSQL database, for which I do not have any
details of, like database name or the users.
This used to be a library database which was managed via a web page
written
in php.
Its running on a
That particular error message is typically associated with a missing
pg_hba.conf entry that tells the postgreSQL server which remote machines to
allow connections FROM
# If you want to allow non-local connections, you need to add more
# host records. Also, remember TCP/IP connections are
I have an aggregate function setup (attached) that I'm calling over a
massive amount of data and am running into:
ERROR: cannot have more than 2^32-1 commands in a transaction
CONTEXT: PL/pgSQL function float8_jitter_add line 16 at if
error. Since I'm able to do count() and
On Wed, Mar 02, 2005 at 12:23:45PM -0500, Todd Kover wrote:
I have an aggregate function setup (attached) that I'm calling over a
massive amount of data and am running into:
ERROR: cannot have more than 2^32-1 commands in a transaction
CONTEXT: PL/pgSQL function
Got it. Thanks!
Scott
On Mar 1, 2005, at 10:52 PM, Ragnar HafstaĆ° wrote:
On Tue, 2005-03-01 at 16:51 -0800, Scott Frankel wrote:
Sweet! And not so sweet.
The natural join worked beautifully with my test schema; but it failed
to yield any rows with my real-world schema. I think I've tracked
On 3/2/05 12:16 PM, Tom Lane [EMAIL PROTECTED] wrote:
Would you post the complete VACUUM VERBOSE log? The CPU/elapsed time lines
would help us identify where the time is going.
I'll send it to you directly - its rather long.
DETAIL: Allocated FSM size: 1000 relations + 100 pages = 5920
Wes [EMAIL PROTECTED] writes:
It took 5.2 hours again tonight to do the vacuum. I don't see anything out
of the ordinary - no explanation for the non-linear increases in vacuum
time.
Would you post the complete VACUUM VERBOSE log? The CPU/elapsed time lines
would help us identify where the
On 3/2/05 12:16 PM, Tom Lane [EMAIL PROTECTED] wrote:
Would you post the complete VACUUM VERBOSE log? The CPU/elapsed time lines
would help us identify where the time is going.
Mailed.
I do see stats like:
CPU 518.88s/25.17u sec elapsed 10825.33 sec.
CPU 884.96s/64.35u sec elapsed 13793.13
pgadmin3 does not seem to want to connect to the server using UNIX
sockets, it only does it through TCP.
Set up the Postgres server to use TCP (as well as UNIX sockets) - i.e. -
starting postmaster with the -i option, sorting it pg_hba.conf etc.
Eddy
Jonathan Schreiter wrote:
hi all,
running
Alexandru Coseru wrote:
Hello..
snip content=Error Details/
Any ideeas ?
Fraid so and it is not good.
I am no expert in the inner-inner workings of Postgres, but my guess is
that your catalogue is, or has been, corrupt.
If this is the case it is unrecoverable. It is a matter of rescuing
Stephane Bortzmeyer [EMAIL PROTECTED] writes:
It is of course very inconvenient to duplicate my LDAP database into
pg_ident.conf. Is there a better way?
Perhaps you can find a PAM plugin that talks to LDAP, and configure
Postgres to use that.
regards, tom lane
Alexandru Coseru [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] gateway]# psql -U postgres -h 127.0.0.1 template1
Welcome to psql 7.4.5, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash
On Tue, 1 Mar 2005, Tom Lane wrote:
Tatsuo Ishii [EMAIL PROTECTED] writes:
So it seems Ioannis' number was not taken immediately after a CREATE
INDEX operation?
I would guess not, but it's up to him to say. If it is a number derived
after some period of normal operation, then his
Ioannis Theoharis [EMAIL PROTECTED] writes:
Where can i find a documentation with technical analysis for all (if
possible) of components of postgres?
Read the source code.
regards, tom lane
---(end of broadcast)---
TIP 7:
On Wed, 2 Mar 2005, Tatsuo Ishii wrote:
An other question:
Is there any way to prevent duplicates on btree index attribute,
PERMITTING them on table?
I can't think of any usefull usage for such an index. Can you explain
why you need it?
I have a relation like this: (att0
One can, however, simply delete the forgotten password
and create another for temporary usage until the user
in question can create a new one. (At least one could
in 7.4, I have not tried it in 8.0.)
Jeff
--- Bruce Momjian pgman@candle.pha.pa.us wrote:
From: Bruce Momjian
On Wed, Mar 02, 2005 at 10:08:58PM +0200, Ioannis Theoharis wrote:
I have a relation like this: (att0 varchar(1000), att1 int4)
i create a b-tree index on att1 ()
i cluster my raltion according to index
now i have a query
select*
form tc20
where att1=9
Brian Maguire wrote:
Is anyone currently using pgpool with production high volume use? I
am interested in your success and challenges.
There isn't much special about high volume use. Just make sure you
configure the pool size appropriately for your application and
configure a corresponding
Watching the system as vacuum is running, I can see that we are encountering
the kswapd/kscand problem in the 2.4.20 kernel. This could very well
account for the non-linear increase in vacuum time.
This problem is fixed in the 2.6 kernel, but we can't upgrade because DELL
is dragging their feet
Wes [EMAIL PROTECTED] writes:
Watching the system as vacuum is running, I can see that we are encountering
the kswapd/kscand problem in the 2.4.20 kernel. This could very well
account for the non-linear increase in vacuum time.
Hmm. Looking at the vacuum verbose output you sent me, it's
On Wed, Mar 02, 2005 at 11:30:58PM +0200, Ioannis Theoharis wrote:
On Wed, 2 Mar 2005, Martijn van Oosterhout wrote:
What makes you think that? Clustering is nice, but postgresql needs to
get the right answer and that the table in clustered is not something
postgresql can rely on.
If
Jonathan Schreiter wrote:
i can't seem to connect to the new database using
pgadmin3. i have the correct IP address of the local
computer, default port 5432, mydb as the initaldb,
postgres as the username, and my new password as the
password. i keep getting the error
Error connecting to
Wes Palmer [EMAIL PROTECTED] writes:
Any chance of change that
behavior to scan in physical storage order?
It wouldn't be easy --- there are some locking considerations that say
btbulkdelete needs to scan the index in the same order that an ordinary
scan would do. See the nbtree README for
Dear All,
I facing problem in my log rotation for postgres, it
is not rotation properly. I am using syslog-ng package
for loging.
My logs for postgres looks like this,
-rw-r--r--1 root root 10M Feb 28
23:24 postgres.log.20
-rw-r--r--1 root root0 Feb 28
43 matches
Mail list logo