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,
I’m 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%'")
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
E
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:[EMAI
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)---
T
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
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 everyt
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 ?
What kind of encoding must I use to create the PG
database unde
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 restrict
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
Secrétariat 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 PostgreS
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
fn;quoted-printa
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
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" (copyii
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 t_time_f;t_
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 broadcast)
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 :
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 iteration
"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
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 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 postgresql ?
>
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
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? T
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:
http://www.postgresql.org/docs/8.0/i
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 t
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 o
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 a
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 can
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,
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 databas
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 al
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
following
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 P
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
>
On Tue, 2005-03-15 at 02:14, Paul Newman wrote:
> Hi,
>
> Iâm 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 requ
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
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 h
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 fo
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 va
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 sequentia
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 perfo
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, t
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 '
> decl
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 veranstal
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 lo
[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
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 Postg
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 . Whe
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 -
>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 situa
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 h
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
[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
ab
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 so
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 fa
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
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.
-Ma
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
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
goe
75 matches
Mail list logo
