Am Montag, den 05.09.2005, 03:00 +0300 schrieb Sterpu Victor:
Can I do something like this?
SELECT sum(name) FROM table;
Where name is a text field.
I know 'sum' doesn't work, but is there another solution?
'||' is not good because it will take just 2 arguments.
Yes you can write an
# [EMAIL PROTECTED] / 2005-09-05 09:39:47 +0200:
I working now for a wile with postgres (7.4), and I have the impression
that is one of the slowest dbms with which I've aver worked. Can please
somebody explain to me, why this is the case?
Because the default configuration (is | seems to
Hi List
Does anyone have any comments, HOWTOs and experience running multiple
Postgres servers with a shared disk (SAN) in a Hot standby configuration?
Can someone please point me in the direction of any docs on this subject?
Thanks in Advance
--
Peter Nixon
http://www.peternixon.net/
PGP
Reading up on ECPG, I figured it would be nice to be able to use that in
stored procedures. I couldn't find anything about such in the
documentation though.
So, a few questions:
Is it possible?
If so, is it feasable? Is the performance comparable to using libpq
calls directly, for example.
[Peter Nixon wrote] :
Hi List
Does anyone have any comments, HOWTOs and experience running multiple
Postgres servers with a shared disk (SAN) in a Hot standby configuration?
Can someone please point me in the direction of any docs on this subject?
Thanks in Advance
For server
Am Montag, 5. September 2005 11:42 schrieb Alban Hertroys:
Reading up on ECPG, I figured it would be nice to be able to use that in
stored procedures.
The purpose of ECPG is to provide a smooth interface for hooking in SQL calls
into C programs. If you want to have that kind of smoothness for
Peter Eisentraut wrote:
Am Montag, 5. September 2005 11:42 schrieb Alban Hertroys:
Reading up on ECPG, I figured it would be nice to be able to use that in
stored procedures.
The purpose of ECPG is to provide a smooth interface for hooking in SQL calls
into C programs. If you want to have
Am Montag, 5. September 2005 13:37 schrieb Alban Hertroys:
If it's not possible to use ECPG for this, too bad. Then we'll have to
try with libpq (I doubt my boss would give us time to create a free
implementation of a PL/ECPG or something along the lines). I'd just like
to know...
If you are
Peter Eisentraut wrote:
If you are using libpq for writing stored procedures, you're doing something
wrong. libpq is for client-side access.
It seems the documentation doesn't tell what library to link, so I
guessed wrong. Searching the FAQs or my mailbox doesn't help much
either... Which
Am Montag, 5. September 2005 14:39 schrieb Alban Hertroys:
It seems the documentation doesn't tell what library to link, so I
guessed wrong. Searching the FAQs or my mailbox doesn't help much
either... Which lib are we supposed to use for SPI?
None. Your code will be compiled into a shared
Have you set your stats appropriately?
I've been wondering about how high to set these - is there any
performance downside to pumping up the statistics count on a table? I
presume ANALYZE will take longer, and the planner might take a tiny bit
longer, but otherwise, it can't hurt, correct?
Hello.
I will install a database on a remote server. There
is pg_hba.config file that should be adjusted to protect from unauthorized
access. It requires IP adresses.
Now, I would like to be able to connect to the
server from my personal computer, in order to do some maintenance job on the
am 05.09.2005, um 15:49:23 +0200 mailte Zlatko Mati? folgendes:
How can I connect to remote server from a remote personal computer
without its own IP adress ?
You can connect to the remote server via ssh. Then you are a local user.
SSH is a highly secure protocol, i suggest, use ssh with
On Mon, Sep 05, 2005 at 03:49:23PM +0200, Zlatko Mati? wrote:
Hello.
I will install a database on a remote server. There is pg_hba.config file
that should be adjusted to protect from unauthorized access. It requires IP
adresses.
Now, I would like to be able to connect to the server from
Is it possible to pass a table name and/or schema name to a plpgsql
function?
How can I use them in the code? Which Types to use for each of the
parameters?
E.g.
create or replace function MyTest (mySchema WhichType?, myTable
WhichType?) returns integer as '
declare result integer;
Begin
[EMAIL PROTECTED] (John D. Burger) writes:
Have you set your stats appropriately?
I've been wondering about how high to set these - is there any
performance downside to pumping up the statistics count on a table?
I presume ANALYZE will take longer, and the planner might take a
tiny bit
am 05.09.2005, um 14:26:31 -0300 mailte Sidnei de Souza folgendes:
Is it possible to pass a table name and/or schema name to a plpgsql
function?
Yes.
How can I use them in the code? Which Types to use for each of the
parameters?
varchar.
E.g.
create or replace function MyTest
I'm trying to setup a database for 1 concurrent users for a test.
I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
It is running SuSE 9.3
I have changed SHMMAX SHMALL
echo 536870912 /proc/sys/kernel/shmmax
echo 536870912 /proc/sys/kernel/shmall
and max_connections =
Calculated the values should be
SEMMNI = 1 / 16
SEMMNS = (1 / 16) * 17 plus room for other applications How much
should that be ?
And where can I change those values on a 2.6 kernel ?
I will try to answer myself with another question.
Can it be that it should be changed in
Does PostgreSQL provide a way to step-debug into plpgSQL stored procedures?
If yes, how do you do debug the stored procedures? Can it be done via
any interface: jdbc, odbc, .net, etc.?
If no, is there any plans to provide debugging support of plpgSQL stored
procedures?
I do request, if you
Poul Møller Hansen wrote:
I'm trying to setup a database for 1 concurrent users for a test.
I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
It is running SuSE 9.3
I think you're being horribly optimistic if you actually want 1
concurrent connections, with users
I think you're being horribly optimistic if you actually want 1
concurrent connections, with users all doing things. Even if you only
allow 1MB for each connection that's 10GB of RAM you'd want. Plus a big
chunk more to actually cache your database files and do work in. Then,
if you had
Daniel Morgan wrote:
Does PostgreSQL provide a way to step-debug into plpgSQL stored procedures?
Afraid not. One of the commercial versions of PG offered it as a feature
IIRC, but I could be wrong, and if so it was some time ago.
If yes, how do you do debug the stored procedures? Can it be
Richard Huxton wrote:
Daniel Morgan wrote:
Does PostgreSQL provide a way to step-debug into plpgSQL stored
procedures?
It is a shame. PostgreSQL is really rocking these days. Especially
with 8.0 on Windows. I was really impressed how far it has come since
the 6.x days running on
FYI, it appears that you cannot start the postmaster when your current
working directory is not accessible by the postgres user:
shell-init: could not get current directory: getcwd: cannot access parent
directories: Permission denied
LOG: 0: could not identify current directory: Permission
Hello everybody,
I've just wondered if there are any way to
implement an INSERT IGNORE in PostgreSQL, I know, I could catch an exception in
PL/pgSQL and just handle it in the right way, but I would need to write a SP for
the task. I've been lookin into the documentation and I found no
On Mon, 05 Sep 2005 21:59:33 +0100, Richard Huxton dev@archonet.com wrote:
Daniel Morgan wrote:
Does PostgreSQL provide a way to step-debug into plpgSQL stored procedures?
Afraid not. One of the commercial versions of PG offered it as a feature
IIRC, but I could be wrong, and if so it was
On Mon, 5 Sep 2005, [UTF-8] Poul Mц╦ller Hansen wrote:
I'm trying to setup a database for 1 concurrent users for a test.
I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
It is running SuSE 9.3
I have changed SHMMAX SHMALL
echo 536870912 /proc/sys/kernel/shmmax
Keary Suska [EMAIL PROTECTED] writes:
FYI, it appears that you cannot start the postmaster when your current
working directory is not accessible by the postgres user:
Is there a good reason that this case should work? I don't think it's
very easy to fix given that we have to resolve the actual
Sergey E. Koposov [EMAIL PROTECTED] writes:
But I really doubt that it it possible/reasonable to have 1
simultaneous connections.
You're going to need a heck of a beefy machine to do it, anyway.
I would expect that after fixing the semaphore configuration problem,
the next thing that'll
Hi,
I'm currently using PostgreSQL 8.0.3 and would like to have a load-
balancing and failover solution over LAN.
From reading the mailing list, it seems that pgpool and slony1
combination has been recommended for LAN replication. But seems that
pgcluster is still actively maintained?
Poul Jensen wrote:
you want to create 1 million tables, all with one of
2 schemas?
I started out with a schema for each file, thinking I could utilize
the schema
structure in queries, but I don't see how. Schemas are useful for
grouping
tables according to users/owners. Other than
I don't think any such behavior exists in PostgreSQL, and based on a reading of the behavior in MySQL, I can't imagine it ever existing considering the preference of PostgreSQL developers for correct (and sane) behavior. INSERT IGNORE seems like a foot-cannon... --Thomas F. O'ConnellCo-Founder,
On Mon, Sep 05, 2005 at 10:35:49PM -0500, Thomas F. O'Connell wrote:
I don't think any such behavior exists in PostgreSQL, and based on a
reading of the behavior in MySQL, I can't imagine it ever existing
considering the preference of PostgreSQL developers for correct (and
sane)
On Sep 5, 2005, at 10:51 PM, Alvaro Herrera wrote:
On Mon, Sep 05, 2005 at 10:35:49PM -0500, Thomas F. O'Connell wrote:
I don't think any such behavior exists in PostgreSQL, and based on a
reading of the behavior in MySQL, I can't imagine it ever existing
considering the preference of
35 matches
Mail list logo