Paul Cunningham wrote:
I use a bash script (similar to following example) to update tables.
psql -v passed_in_var=\'some_value\' -f script_name
Is it possible to pass a value back from psql to the bash script?
You can pass the textual output of psql back with backticks:
echo `psql ...`
--
Hi,
Im a convert from Firebird so I consider
myself a newbie to Postgresql. We have a requirement to host 400 600 companies
data inside a single database for connection pooling and scalability reasons as
well as our business logic requirements. We have therefore been very busy
adding a
I've been looking at the possibility of having a planned CR in the source
code and I don't see a case where it would happen.
I tried this function, as an example:
create or replace function crtest() returns int as
$$
x=plpy.execute(select * from pg_proc where prosrc like '%\r%')
Title: RE: [GENERAL] Convert Cursor to array
ok, i think that i will try to use pl/perl or pl/python
but i don't know which one is better for my problem
maybe you can help me.
thanks
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de Richard Huxton
Now that I think about it, FTP programs currently do this when they transfer
ASCII files.
If you have a planned CR in your program and FTP from mac to windows the CR
becomes a CRLF and if you FTP from mac to unix the CR changes to an LF.
Sim Zacks [EMAIL PROTECTED] wrote in message
news:[EMAIL
FERREIRA William (COFRAMI) wrote:
ok, i think that i will try to use pl/perl or pl/python
but i don't know which one is better for my problem
Whichever you know better is the best solution.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
On Mon, Mar 14, 2005 at 06:04:01PM -0500, Chris Browne wrote:
[EMAIL PROTECTED] (Mark Rae) writes:
Clients 1 2 3 4 6 812163264
128
--
mysql-4.1.1 1.00 1.41 1.34
I'm working with mod_python and pygresql (although I get virtualy the
same error with psycopg too)
Anyone know what the following error actualy means:
Exception pg.InternalError: 'Connection already closed' in ignored
Does it mean the obvious: Some code tries to access a connection
object that
The following is how I understand it, but please let's delay further
discussion until someone tests the program under Windows.
On Mon, 14 Mar 2005, Michael Fuhr wrote:
Hmmm...I think that would be inconsistent with previous reports.
For example, in the following message, the poster said that
Hello,
I've dumped the content of MS-Access 2002
SP3tables on a PC with Windows XP Pro in French localization.Then I
COPY these files, on the same PC hosting an PostgreSQL 8.0.1 database.I've
problems with the accents !? Why ?
What kind of encoding must I use to create the PG
database
On Tue, Mar 15, 2005 at 12:57:52 +0800,
Qingqing Zhou [EMAIL PROTECTED] wrote:
Yu Jie [EMAIL PROTECTED] writes:
Hi all,
If I want to restrict the maximum size of one
table to 5MB, restrict the maximum size of database
file to 100MB, how can I do that restriction?
Is
Le mardi 15 mars 2005 à 12:26 +, Mark Rae a écrit :
Clients 1 2 3 4 6 812163264
128
--
mysql-4.1.1 1.00 1.41 1.34 1.16 0.93 1.03 1.01 1.00 0.94 0.86
Secrtariat wrote:
Hello,
I've dumped the content of MS-Access 2002 SP3 tables on a PC with
Windows XP Pro in French localization.
Then I COPY these files, on the same PC hosting an PostgreSQL 8.0.1
database.
I've problems with the accents !? Why ?
Luc, what encoding did you set for your
hello
on windows 2000 (chinese)
during postgres8.0.0-rc1.msi installation,
it fails in 'Service configuration':
Internal account lookup failure
sylvain
smime.p7s
Description: S/MIME Cryptographic Signature
sferriol wrote:
hello
on windows 2000 (chinese)
during postgres8.0.0-rc1.msi installation,
it fails in 'Service configuration':
Internal account lookup failure
Is there a reason for not using version 8.0.1? Maybe this one will
install without problem.
sylvain
Miroslav
begin:vcard
I have situation where I have one box with linux native 64 bit distribution
(Gentoo on AMD) running pg 8.x and other box running a 32 bit distro
running version of pg 8.x
Is it posssible to take a filesystem level backup (copyiing all in
$PGDATA directory) from 64 bit system and use it as
Le mardi 15 mars 2005 à 13:52 +0100, Secrétariat a écrit :
I've dumped the content of MS-Access 2002 SP3 tables on a PC with
Windows XP Pro in French localization.
Then I COPY these files, on the same PC hosting an PostgreSQL 8.0.1
database.
I've problems with the accents !? Why ?
What kind
On Tue, Mar 15, 2005 at 08:09:47AM +0200, Sim Zacks wrote:
I don't think that this type of solution should be discussed as an official
patch.
If it was, I would recommend solving the problem in source code when the
function is passed to the translator. That way each platform could fix the
On Tue, Mar 15, 2005 at 02:29:51PM +0100, NTPT wrote:
I have situation where I have one box with linux native 64 bit
distribution (Gentoo on AMD) running pg 8.x and other box running a 32 bit
distro running version of pg 8.x
Is it posssible to take a filesystem level backup (copyiing all
Title: RE: [GENERAL] Convert Cursor to array
hi
i need
to know the execution time of a part of my pl/pgsql code
so, i
tried to use CURRENT_TIME :
t_time_d TIME;t_time_f TIME;t_diff TIME;
select CURRENT_TIME into
t_time_d;
//the traitment
select
CURRENT_TIME into
Hi Gnari,
I'll do some more test tonight to figure out if it's a tomcat problem
and I'll get back to you with this info.
Thanks!
/David
maybe some difference in the environments that the two
tomcats run in? are their locales the same ?
gnari
---(end of
Hello all
I am trying to grant privs to a user on all tables. I think I understood
there was no command to do that :// so I wrote the following:
create or replace function granting() RETURNS integer AS '
declare
v_schema varchar;
v_user varchar;
begin
v_user := user
On Mar 15, 2005, at 23:21, FERREIRA William (COFRAMI) wrote:
i need to know the execution time of a part of my pl/pgsql code
so, i tried to use CURRENT_TIME :
snip /
my function is recursive and the problem is that i always get the same
result for each iteration
t_time_d is set at the first
Sim Zacks [EMAIL PROTECTED] writes:
I've been looking at the possibility of having a planned CR in the source
code and I don't see a case where it would happen.
Does python actually disallow newlines in string literals? That is
x = 'foo
bar'
Whether you think this is good style is
Hi Fred,
On Mar 15, 2005, at 9:35 AM, Fred Blaise wrote:
I am trying to grant privs to a user on all tables. I think I
understood
there was no command to do that :// so I wrote the following:
You can find some code to do this here:
http://pgedit.com/node/view/20
I then login to psql, and do a
Martijn van Oosterhout kleptog@svana.org writes:
On Tue, Mar 15, 2005 at 02:29:51PM +0100, NTPT wrote:
Is it posssible to take a filesystem level backup (copyiing all in=20
$PGDATA directory) from 64 bit system and use it as $PGDATA in the native=
32 bit system with the same version of
On Tue, 2005-03-15 at 09:58 -0500, John DeSoi wrote:
Hi Fred,
On Mar 15, 2005, at 9:35 AM, Fred Blaise wrote:
I am trying to grant privs to a user on all tables. I think I
understood
there was no command to do that :// so I wrote the following:
You can find some code to do this
On Tue, Mar 15, 2005 at 09:46:54AM -0500, Tom Lane wrote:
Sim Zacks [EMAIL PROTECTED] writes:
I've been looking at the possibility of having a planned CR in the source
code and I don't see a case where it would happen.
Does python actually disallow newlines in string literals? That is
On Mar 15, 2005, at 10:19 AM, Fred Blaise wrote:
Just to make sure... Once the function is created, you would call it as
'execute function()' from psql, correct?
Try: select function();
As a top level SQL command, EXECUTE is for executing prepared
statements:
Fred Blaise [EMAIL PROTECTED] writes:
On Tue, 2005-03-15 at 09:58 -0500, John DeSoi wrote:
raise log ''t is %'', t;
Yes, that's what I thought... but oddly nothing gets written.
Fred, your original example made it look like you were writing
(one double quote mark) where what you need to
On Tue, 2005-03-15 at 07:33 -0600, David wrote:
[about the line-termination problem in plpython]
I'd like to insert one note here. While I'm not particularly familiar
with either perl or python, when I encountered the referred-to thread
regarding Windows/Unix newline incompatibilities in
Hi,
On the PostgreSQL 6.5 server I use this shell script (see below) for the
backup all of the database in several files, one file per database.
With version 7.3 of PostgreSQL (and the following) the data are not
recorded any more in a repertory with the name of the database, but with
the OID
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
[EMAIL PROTECTED] wrote:
Hi,
On the PostgreSQL 6.5 server I use this shell script (see below) for the
backup all of the database in several files, one file per database.
With version 7.3 of PostgreSQL (and the following) the data are not
Lonni J Friedman wrote:
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
[EMAIL PROTECTED] wrote:
Hi,
On the PostgreSQL 6.5 server I use this shell script (see below) for the
backup all of the database in several files, one file per database.
[...]
Maybe i'm just not following you, but why
On Friday 11 March 2005 18:49, Jerry Sievers wrote:
Hello.
The PG mailing lists web page contains artifacts of a jobs list but no
such list appeared in the dropdown of available lists.
I am referring to;
http://www.postgresql.org/community/lists/subscribe
This has been fixed now, thanks
On Tue, Mar 15, 2005 at 05:01:39PM +0100, Frederic Massot wrote:
Lonni J Friedman wrote:
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
[EMAIL PROTECTED] wrote:
Hi,
On the PostgreSQL 6.5 server I use this shell script (see below) for the
backup all of the database in several files,
On Tue, 15 Mar 2005 17:01:39 +0100, Frederic Massot
[EMAIL PROTECTED] wrote:
Lonni J Friedman wrote:
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
[EMAIL PROTECTED] wrote:
Hi,
On the PostgreSQL 6.5 server I use this shell script (see below) for the
backup all of the database in
On Tue, 15 Mar 2005, Tom Lane wrote:
Sim Zacks [EMAIL PROTECTED] writes:
I've been looking at the possibility of having a planned CR in the source
code and I don't see a case where it would happen.
Does python actually disallow newlines in string literals? That is
x = 'foo
bar'
Whether
Title: Problems building postgresql 8.0.1 on OS X
10.3.8
Hi,
I get the following error message when trying to build
postgresql:
checking for C compiler default output... configure: error: C
compiler cannot create executables
I have installed XCode which has the gcc compiler. I use the
On Tue, 15 Mar 2005 12:15:39 -0400, Alvaro Herrera
[EMAIL PROTECTED] wrote:
On Tue, Mar 15, 2005 at 05:01:39PM +0100, Frederic Massot wrote:
Lonni J Friedman wrote:
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
[EMAIL PROTECTED] wrote:
Hi,
On the PostgreSQL 6.5 server I use
Alvaro Herrera wrote:
On Tue, Mar 15, 2005 at 05:01:39PM +0100, Frederic Massot wrote:
[...]
You can obtain the list of databases for scripting with
psql -tlA | cut -d\| -f1
Great !!! :o)
Thank you.
--
==
| FREDERIC MASSOT |
|
On Tue, 2005-03-15 at 07:29, NTPT wrote:
I have situation where I have one box with linux native 64 bit distribution
(Gentoo on AMD) running pg 8.x and other box running a 32 bit distro
running version of pg 8.x
Is it posssible to take a filesystem level backup (copyiing all in
$PGDATA
On Tue, 2005-03-15 at 02:14, Paul Newman wrote:
Hi,
Im a convert from Firebird so I consider myself a newbie to
Postgresql. We have a requirement to host 400 600 companies data
inside a single database for connection pooling and scalability
reasons as well as our business logic
On Tue, Mar 15, 2005 at 01:40:23PM +0100, Marco Colombo wrote:
On Mon, 14 Mar 2005, Michael Fuhr wrote:
Hmmm...I think that would be inconsistent with previous reports.
For example, in the following message, the poster said that everything
(PostgreSQL, pgAdmin) was running on Windows 2003:
On Tue, 15 Mar 2005, Michael Fuhr wrote:
[...]
That somebody was me.
Ok, sorry.
I'll postpone commenting on the rest until we find out how the
example programs run on Windows. If nobody follows up here then
maybe I'll wander over to comp.lang.python.
Yeah, there's no point in discussing until we
Hi all,
I'm running the same database on two systems:
A) Debian PostgreSQL 7.4.7
B) SuSE PostgreSQL 7.3.4
Both machines have approx. 1GHz and 1GB RAM.
The amount of data is almost equal (+- 10%). But I'm facing
huge performance differences. For instance, a simple sequential
scan results in the
While I have accomplished what I needed with the pgedit script given by
John, I am still curious as to why mine is not working...
Here is the latest version:
/* */
create or replace function fred_on_all() RETURNS integer AS '
declare
v_schema varchar;
v_user varchar;
v_t
Andreas Hartmann wrote:
Hi all,
I'm running the same database on two systems:
A) Debian PostgreSQL 7.4.7
B) SuSE PostgreSQL 7.3.4
Both machines have approx. 1GHz and 1GB RAM.
The amount of data is almost equal (+- 10%). But I'm facing
huge performance differences. For instance, a simple
On Tue, 2005-03-15 at 11:10, Andreas Hartmann wrote:
Hi all,
I'm running the same database on two systems:
A) Debian PostgreSQL 7.4.7
B) SuSE PostgreSQL 7.3.4
Both machines have approx. 1GHz and 1GB RAM.
The amount of data is almost equal (+- 10%). But I'm facing
huge performance
On Tue, Mar 15, 2005 at 06:03:01PM +0100, Marco Colombo wrote:
On Tue, 15 Mar 2005, Michael Fuhr wrote:
I'll postpone commenting on the rest until we find out how the
example programs run on Windows. If nobody follows up here then
maybe I'll wander over to comp.lang.python.
Yeah, there's
On Tue, 2005-03-15 at 18:18 +0100, Fred Blaise wrote:
While I have accomplished what I needed with the pgedit script given by
John, I am still curious as to why mine is not working...
Here is the latest version:
/* */
create or replace function fred_on_all() RETURNS integer AS '
declare
Hi,
I am trying to install postgresql-8.0.1 on a machine running XP
Professional.
On the web site I went to the download area, then to V8.0.1 and then
to win32. I downloaded postgresql.8.0.1.zip . I unzip that and executed
postgresql-8.0.msi . When I hit the Start button, I get the following:
On Tue, Mar 15, 2005 at 07:32:43AM -0500, Alex Turner wrote:
I'm working with mod_python and pygresql (although I get virtualy the
same error with psycopg too)
What's the exact error you get with psycopg?
Anyone know what the following error actualy means:
Exception pg.InternalError:
On Tue, 2005-03-15 at 18:10 +0100, Andreas Hartmann wrote:
explain analyze select * from veranstaltung_original order by semester;
Sort (cost=3054.08..3067.74 rows=5467 width=223) (actual
time=2568.10..2573.02 rows=5467 loops=1)
Sort Key: semester
- Seq Scan on
On Tue, 2005-03-15 at 12:18, Ragnar Hafsta wrote:
On Tue, 2005-03-15 at 18:10 +0100, Andreas Hartmann wrote:
explain analyze select * from veranstaltung_original order by semester;
Sort (cost=3054.08..3067.74 rows=5467 width=223) (actual
time=2568.10..2573.02 rows=5467 loops=1)
[EMAIL PROTECTED] (Magnus Hagander) writes:
I suppose my first (lazy) question is, is there a Python 2.4
compatible plpython.dll available anywhere? Alternatively, is
there a way I can build one for myself? I'm happy enough
doing my own build (I have mingw and msys available), but I'd
On Tue, Mar 15, 2005 at 07:05:22PM +, Paul Moore wrote:
As per my earlier posting, I actually found that building postgresql
wasn't at all hard. Once I'd built with Python 2.4 support, I had a
compatible plpython.dll I could just copy in.
Pardon the interruption, but do you have a
On Mar 15, 2005, at 1:14 PM, Glenn Sullivan wrote:
I am trying to install postgresql-8.0.1 on a machine running XP
Professional.
On the web site I went to the download area, then to V8.0.1 and then
to win32. I downloaded postgresql.8.0.1.zip . I unzip that and
executed
postgresql-8.0.msi .
On Tue, 2005-03-15 at 14:07 +0100, tony wrote:
by the time 3 clients are running, postgres is getting through the
queries 1.90/1.34=1.42 times faster
That is very interesting!!!
I have several webapps on my server each one opens several queries to
the database from _each_ JSP - often
On Mon, 2005-03-14 at 21:14, Net Virtual Mailing Lists wrote:
On Mon, 2005-03-14 at 06:11, Net Virtual Mailing Lists wrote:
Hello,
I am sorry to bring this up again Does anyone have any idea what
might be going on here?... I'm very worried about this situation.. ;-(
It looks
On Mon, 2005-03-14 at 12:43 +, Richard Huxton wrote:
Take 30 minutes to read through the article below. It covers the basics
of how to manage your configuration settings.
http://www.powerpostgresql.com/PerfList
That's an informative article. I was hoping, however, that it would have
On Tue, Mar 15, 2005 at 03:41:37PM +, Ragnar Hafstað wrote:
actually, perl scripts with \r\n line endings will run just fine in
unix/linux.
Indeed, and PL/Perl doesn't care. I just tested several PLs with
PostgreSQL 8.0.1 on Solaris 9 and here are the results:
PL/pgSQL CRLF ok
PL/Perl
Also, a 32-bit machine can only hold so much RAM. If I'm correct, there
are ways to address more memory than that on a 32 bit machine, but I
wonder at what cost? In other words, is it a good idea to address more
than 4GB on a 32 bit machine? If not, is it a reasonable choice to
invest in 64
[EMAIL PROTECTED] (Michael Fuhr) writes:
We (the thread participants) could use somebody with a Windows
server to do some testing.
Glad to help... This is with postgresql 8.0.1, Python 2.4.
Specifically, we're wondering if Python on Windows requires embedded
Python code to have CRLF
Hi,
When running the installer on XP, I get to the Service Configuration
panel.
When I enter the password and click OK, I get:
Failed to open local computer policy.
Unable to determine user account rights(5).
If I click OK to that, the install continues until it fails complaining
On Tue, Mar 15, 2005 at 12:51:03PM -0800, Jeff Davis wrote:
Be careful assuming that. DB benchmarks are hard to do in a general
sense. His results probably indicate a general trend, but you should
test your application yourself to get a real result. His pattern of SQL
queries might be very
Mark Rae wrote:
On Tue, Mar 15, 2005 at 12:51:03PM -0800, Jeff Davis wrote:
Be careful assuming that. DB benchmarks are hard to do in a general
sense. His results probably indicate a general trend, but you should
test your application yourself to get a real result. His pattern of SQL
On Tue, Mar 15, 2005 at 06:46:50PM -0500, Bruce Momjian wrote:
Mark Rae wrote:
Also, while on the subject of scaling. I had the opportunity
to try postgres on a 16CPU Altix and couldn't get it to scale
more than about 4x, whereas Oracle got up to about 12x faster
We have had some major
Mark Rae wrote:
On Tue, Mar 15, 2005 at 06:46:50PM -0500, Bruce Momjian wrote:
Mark Rae wrote:
Also, while on the subject of scaling. I had the opportunity
to try postgres on a 16CPU Altix and couldn't get it to scale
more than about 4x, whereas Oracle got up to about 12x faster
On Tue, Mar 15, 2005 at 06:03:01PM +0100, Marco Colombo wrote:
On Tue, 15 Mar 2005, Michael Fuhr wrote:
I'll postpone commenting on the rest until we find out how the
example programs run on Windows. If nobody follows up here then
maybe I'll wander over to comp.lang.python.
Yeah, there's
On Tue, Mar 15, 2005 at 10:46:09PM +, Paul Moore wrote:
The long and short of it is that I believe you just use \n to delimit
lines on Windows, just like anywhere else.
Many thanks -- your test results contain the info we've been seeking.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
On Tue, Mar 15, 2005 at 07:00:25PM -0500, Bruce Momjian wrote:
Oh, you have to try CVS HEAD or a nightly snapshot. Tom made a major
change that allows scaling in SMP environments.
Ok, I'll give it a try in the next couple of days when there is
some free time available on the machine.
Mark Rae wrote:
On Tue, Mar 15, 2005 at 12:51:03PM -0800, Jeff Davis wrote:
Be careful assuming that. DB benchmarks are hard to do in a general
sense. His results probably indicate a general trend, but you should
test your application yourself to get a real result. His pattern of SQL
queries might
beyarecords.com [EMAIL PROTECTED] writes:
I get the following error message when trying to build postgresql:
checking for C compiler default output... configure: error: C
compiler cannot create executables
Hm, it works for me and for other people on OS X. Look into the
config.log file for
I'm running apache 2.0.52 on pentium III 866 using RedHat EL3 - kernel
2.4.21-27.0.2.EL I'm using mod_python 3.1.3 and the
postgresql-python-8.0.1-1PGDG RPM.
Unfortunately the error is not readibly reproducable. Sometimes it
happens, and sometimes it doesn't. Normaly if I reload the page it
75 matches
Mail list logo
