On Thu, Apr 2, 2009 at 11:55 PM, Gordon Shannon wrote:
>
> What I'm trying to do doesn't seem like it should be that difficult or
> unusual, but I can't seem to find the right combination of commands to make
> it happen. I want to have a log file that captures everything from an
> interactive psq
That does the trick, awesome!
I do think it would be great if psql had a "stderr" capture in addition to
stdout.
Thanks
hubert depesz lubaczewski-2 wrote:
>
> On Thu, Apr 02, 2009 at 10:55:10PM -0700, Gordon Shannon wrote:
>> Has anyone solved this issue before?
>
> have you seen program "sc
On Thu, Apr 02, 2009 at 10:55:10PM -0700, Gordon Shannon wrote:
> Has anyone solved this issue before?
have you seen program "script"?
usage:
just run script
you will get shell. now run your command you want to capture everything
from - it will work as usual.
after you finish - exit the "script-
What I'm trying to do doesn't seem like it should be that difficult or
unusual, but I can't seem to find the right combination of commands to make
it happen. I want to have a log file that captures everything from an
interactive psql session. Running 8.3.7 with bash shell on Linux.
If I use \
On Fri, Apr 3, 2009 at 2:35 AM, Ricardo Fuentes wrote:
> Hello, i want to subscribe to this lists
>
Hi Ricardo,
Here is the link to subscribe.
http://www.postgresql.org/community/lists/
Regards,
Itishree
On Thu, Apr 2, 2009 at 7:05 PM, Sam Mason wrote:
> On Thu, Apr 02, 2009 at 09:48:33PM +0200, Ivan Sergio Borgonovo wrote:
>> I didn't find any elegant example of cursor use in PHP... OK PHP is
>> not the most elegant language around... but still any good exapmle
>> someone could point me at?
>
> I
On Thu, Apr 2, 2009 at 2:48 PM, rafalak wrote:
> Hello i have big table
> 80mln records, ~6GB data, 2columns (int, int)
>
> if query
> select count(col1) from tab where col2=1234;
> return low records (1-10) time is good 30-40ms
> but when records is >1000 time is >12s
>
>
> How to increse perform
Patrick Desjardins wrote:
> Humm, they want to close the AntiVirus for 1 night not anymore. Do you think
> that if we take out the database directory of the scan that it will solve
> the problem or it really need to have no antivirus on the server? They
> really want to keep it...
It depends on th
On Fri, Apr 3, 2009 at 2:18 AM, rafalak wrote:
> Hello i have big table
> 80mln records, ~6GB data, 2columns (int, int)
>
> if query
> select count(col1) from tab where col2=1234;
> return low records (1-10) time is good 30-40ms
> but when records is >1000 time is >12s
>
>
> How to increse perfor
On Thu, Apr 02, 2009 at 09:48:33PM +0200, Ivan Sergio Borgonovo wrote:
> I didn't find any elegant example of cursor use in PHP... OK PHP is
> not the most elegant language around... but still any good exapmle
> someone could point me at?
I don't program PHP; but my guess would be something like:
On Thu, Apr 02, 2009 at 12:06:01PM -0700, David E. Wheeler wrote:
> On Apr 2, 2009, at 11:24 AM, Sam Mason wrote:
> >Yes, I'd be tempted to pick one and go with it. It's seems a
> >completely arbitrary choice one way or the other but the current
> >behaviour is certainly wrong.
> >
> >I'd go with
Kev writes:
> For some reason, which I couldn't see spelled out very well in the
> docs for GRANT ROLE and SET ROLE, indirect membership in the group
> "user" doesn't give one its privileges unless you SET ROLE "user"
> first, even if all roles involved have INHERIT set.
Really? Works for me:
r
Suppose I have some group roles, say "student" and "employee", to
which I want to grant another group role, "user". I then want to give
privileges to an updateable view "my_preferences" to "user" so that
they'll be given to any login role that's a member of "student" or
"employee".
Seems sensible
Humm, they want to close the AntiVirus for 1 night not anymore. Do you think
that if we take out the database directory of the scan that it will solve
the problem or it really need to have no antivirus on the server? They
really want to keep it...
On Wed, Apr 1, 2009 at 1:06 PM, Scott Marlowe wrot
Hello i have big table
80mln records, ~6GB data, 2columns (int, int)
if query
select count(col1) from tab where col2=1234;
return low records (1-10) time is good 30-40ms
but when records is >1000 time is >12s
How to increse performace ?
my postgresql.conf
shared_buffers = 810MB
temp_buffers =
Hello, i want to subscribe to this lists
Thank you very much to all people!!!
I reached the goal using lynx to dowload the rpms and then
the "An Almost Idiots's Guide To PostgreSQL YUM" from Postgres OnLine
Journal
Domenico
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ht
On Thu, Apr 2, 2009 at 12:51 PM, dfx wrote:
> dear Sirs,
>
> is there on the web a simple guide (for "idiots") to install postgresql on
> CentOS 5.2 using only a ssh connection? (no web browser, no graphical
> capability). My first problem is to download using ftp instead a web
> browser.
>
> The
On Thu, Apr 2, 2009 at 2:50 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Thu, Apr 2, 2009 at 2:18 PM, Tom Lane wrote:
>>> If there's a camp that actually *wants* a NULL result for this case,
>>> I missed the reasoning.
>
>> So that we don't break existing apps because of an issue that is
>> t
On Thu, 2 Apr 2009 17:27:55 +0100
Sam Mason wrote:
> On Thu, Apr 02, 2009 at 11:20:02AM +0200, Ivan Sergio Borgonovo
> wrote:
> > This is the work-flow I've in mind:
> >
> > 1a) take out *all* data from a table in chunks (M record for each
> > file, one big file?) (\copy??, from inside a scriptin
dfx wrote:
dear Sirs,
is there on the web a simple guide (for "idiots") to install postgresql
on CentOS 5.2 using only a ssh connection? (no web browser, no graphical
capability). My first problem is to download using ftp instead a web
browser.
Try something like "yum install lynx" first -
2009/4/3 dfx :
> dear Sirs,
> The default installation (#>yum install opstresql)suggest the version 8.1
> but I would like to install the latest 8.3, so I suppose that I have to
> change some file containing yum directive per postgresql.
30 seconds on the postgres website ... ran into this ;}
h
On Apr 2, 2009, at 11:24 AM, Sam Mason wrote:
Yes, I'd be tempted to pick one and go with it. It's seems a
completely
arbitrary choice one way or the other but the current behaviour is
certainly wrong.
I'd go with returning a zero element array because it would do
the "right thing" more ofte
dear Sirs,
is there on the web a simple guide (for "idiots") to install postgresql
on CentOS 5.2 using only a ssh connection? (no web browser, no graphical
capability). My first problem is to download using ftp instead a web
browser.
The default installation (#>yum install opstresql)suggest
Robert Haas writes:
> On Thu, Apr 2, 2009 at 2:18 PM, Tom Lane wrote:
>> If there's a camp that actually *wants* a NULL result for this case,
>> I missed the reasoning.
> So that we don't break existing apps because of an issue that is
> trivial to work around.
We would only be breaking them if
On Thu, Apr 2, 2009 at 2:18 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Thu, Apr 2, 2009 at 2:04 PM, Tom Lane wrote:
>>> Right at the moment, if we stick with the historical definition
>>> of the function, *both* camps have to write out their choice of
>>> the above. Seems like this is the
On Thu, Apr 02, 2009 at 02:04:41PM -0400, Tom Lane wrote:
> A correct fix
> outside-the-function would look more like
>
> case when str = '' then '{}'::text[] else string_to_array(str, ',') end
>
> which should correctly yield NULL for NULL input and an empty array
> for empty input. Similarly,
Robert Haas writes:
> On Thu, Apr 2, 2009 at 2:04 PM, Tom Lane wrote:
>> Right at the moment, if we stick with the historical definition
>> of the function, *both* camps have to write out their choice of
>> the above. Seems like this is the worst of all possible worlds.
>> We should probably pic
On Thu, Apr 2, 2009 at 2:04 PM, Tom Lane wrote:
> Right at the moment, if we stick with the historical definition
> of the function, *both* camps have to write out their choice of
> the above. Seems like this is the worst of all possible worlds.
> We should probably pick one or the other.
ISTM t
"David E. Wheeler" writes:
>> Or we could stick to the current behavior and say "use COALESCE() to
>> resolve the ambiguity, if you need to".
> Steve has a point that leaving it as-is leaves it as impossible to
> tell the difference between string_to_array(NULL, ',') and
> string_to_array('',
On Thu, Apr 2, 2009 at 11:34 AM, Patrick Desjardins
wrote:
> Humm, they want to close the AntiVirus for 1 night not anymore. Do you think
> that if we take out the database directory of the scan that it will solve
> the problem or it really need to have no antivirus on the server? They
> really wa
On Thu, Apr 2, 2009 at 12:10 PM, David E. Wheeler wrote:
> On Apr 1, 2009, at 12:19 PM, Robert Haas wrote:
>
>>> my @ints = map { $_ || 0 } split ',', $string;
>>>
>>> This ensures that I get the proper number of records in the example of
>>> something like '1,2,,4'.
>>
>> I can't see that there's
On Thu, Apr 2, 2009 at 12:17 PM, David E. Wheeler wrote:
> On Apr 1, 2009, at 2:22 PM, Tom Lane wrote:
>
>> Another way to state the point is that we can offer people a choice of
>> two limitations: string_to_array doesn't work for zero-length lists,
>> or string_to_array doesn't work for empty st
On Thu, Apr 02, 2009 at 09:29:04AM -0700, Steve Crawford wrote:
> Leif B. Kristensen wrote:
> >Somehow this reminds me of the old "division by zero" problem.
> >
> >IMO, the proper way to handle this kind of anomaly would be to test if
> >the length of the string is non-zero before submitting it t
> In ORACLE I can get that information from V$SESSION_LONGOPS view which will
> give the approx TIME_REMAINING to complete running queries. Is there a
> similar way in postgres?
As far as I know, PostgreSQL has no such facility, and the database
server has no idea how long a given query will ta
Tom Lane wrote:
Steve Clark writes:
I am getting the following error after upgrading from 7.4.6 to 8.3.6
and can't figure out what is wrong. Any help would be greatly appreciated.
2009-04-02 10:45:10 EDT:srm2api:ERROR: column "event_ref_log_no" is of type
integer but expression is of type tex
Leif B. Kristensen wrote:
On Thursday 2. April 2009, Steve Crawford wrote:
Currently string_to_array(null, ',') yields a null result -
indistinguishable from string_to_array('',','). Wrapping in coalesce
does not help distinguish true null input from empty-string input. I'm
not sure at the mo
On Thu, Apr 02, 2009 at 11:20:02AM +0200, Ivan Sergio Borgonovo wrote:
> This is the work-flow I've in mind:
>
> 1a) take out *all* data from a table in chunks (M record for each
> file, one big file?) (\copy??, from inside a scripting language?)
What about using cursors here?
> 2a) process each
On Apr 1, 2009, at 2:22 PM, Tom Lane wrote:
Another way to state the point is that we can offer people a choice of
two limitations: string_to_array doesn't work for zero-length lists,
or string_to_array doesn't work for empty strings (except most of the
time, it does). The former is sounding le
On Apr 1, 2009, at 12:19 PM, Robert Haas wrote:
my @ints = map { $_ || 0 } split ',', $string;
This ensures that I get the proper number of records in the example
of something like '1,2,,4'.
I can't see that there's any way to do this in SQL regardless of how
we define this operation.
It'
On Thu, Apr 02, 2009 at 12:52:40PM +0200, Angelo Nicolosi wrote:
> I wanted to write some C-Function
Where is this code going to live? if it's going to be "inside" PG as a
function you can call from SQL you want something called SPI:
http://www.postgresql.org/docs/current/static/spi.html
If it
On Apr 2, 11:06 am, linnewbie wrote:
> On Apr 2, 10:01 am, andreas.kretsch...@schollglas.com ("A.
>
>
>
> Kretschmer") wrote:
> > In response to linnewbie :
>
> > > I am using tcl ( ncgi and tclobdc ) so it is more like the excerpts
> > > below:
>
> > > ie I input:
>
> > > Hello World
>
> > > xyz
Steve Clark writes:
> I am getting the following error after upgrading from 7.4.6 to 8.3.6
> and can't figure out what is wrong. Any help would be greatly appreciated.
> 2009-04-02 10:45:10 EDT:srm2api:ERROR: column "event_ref_log_no" is of type
> integer but expression is of type text at charac
--- On Thu, 4/2/09, Leif B. Kristensen wrote:
> From: Leif B. Kristensen
> Subject: Re: [GENERAL] How to find the query completeion time?
> To: pgsql-general@postgresql.org
> Date: Thursday, April 2, 2009, 10:53 AM
> On Thursday 2. April 2009, SHARMILA
> JOTHIRAJAH wrote:
> >Hi,
> >Is there a
Hello list,
I am getting the following error after upgrading from 7.4.6 to 8.3.6
and can't figure out what is wrong. Any help would be greatly appreciated.
from our program:
sqlcode=-400 errmsg='column "event_ref_log_no" is of type integer but
expression is of type text' in line 4138.
from pg_
On Apr 2, 10:01 am, andreas.kretsch...@schollglas.com ("A.
Kretschmer") wrote:
> In response to linnewbie :
>
>
>
> > I am using tcl ( ncgi and tclobdc ) so it is more like the excerpts
> > below:
>
> > ie I input:
>
> > Hello World
>
> > xyz
> > .
>
> > into the text area field, save:
>
On Thursday 2. April 2009, SHARMILA JOTHIRAJAH wrote:
>Hi,
>Is there a way in Postgres to find when a particular query will
> finish?
>
>For example, for a query like this
>SELECT * FROM TABLE1
>Can we find out from any of the catalog tables(or any other way) when
> this query is likely to complet
Hi,
Is there a way in Postgres to find when a particular query will finish?
For example, for a query like this
SELECT * FROM TABLE1
Can we find out from any of the catalog tables(or any other way) when this
query is likely to complete?
Thanks
--
Sent via pgsql-general mailing list
On Thu, Apr 2, 2009 at 1:23 AM, Craig Ringer
wrote:
>
> You might want to add this as a comment on the interactive version of the
> online documentation, too, so it's not lost when revising the docs for 8.4 /
> 8.5 .
Done, sir. Thanks!
Aleksey
--
Aleksey Tsalolikhin
UNIX System Administrator
hi,
i'm not a tcl user but it looks like an array representation. try to
remove braces [] from page_content.
regards.
thomas
linnewbie schrieb:
into the text area field, save:
set page_content [ ncgi::value textarea_field_name]
database connect dbh $datasource $dbuser $dbpassword
set s
In response to linnewbie :
> I am using tcl ( ncgi and tclobdc ) so it is more like the excerpts
> below:
>
> ie I input:
>
> Hello World
>
> xyz
> .
>
> into the text area field, save:
>
> set page_content [ ncgi::value textarea_field_name]
>
> database connect dbh $datasource $d
On Apr 2, 8:59 am, l...@solumslekt.org ("Leif B. Kristensen") wrote:
> On Thursday 2. April 2009, linnewbie wrote:
>
> >Hi All,
>
> >I'm fairly new to postgres and I'm having this peculiar problem.
>
> >I'm storing raw html in a text field and I want users who know HTML to
> >update the content in
PostgreSQL does not add braces to text. It sounds like a problem with the code
you have that inserts and retreives data out of PostgreSQL
Let's try a test case:
BEGIN;
CREATE TEMP TABLE test_table (
foo text
);
INSERT INTO test_table (foo) VALUES('foo');
SELECT foo FROM test_table;
ROLLBACK
(CC'ed to the list)
On Thursday 2. April 2009, linnewbie wrote:
> I am using tcl ( ncgi and tclobdc ) so it is more like the excerpts
> below:
>
>ie I input:
>
>Hello World
>
>xyz
>
>into the text area field, save:
>
>set page_content [ ncgi::value textarea_field_name]
>
>database connect dbh
Duco Fijma wrote:
> Please allow me to rephrase a question I asked on this list some time
> ago. Could somebody shine some light on what exactly influences the
> value of the %r parameter in the restore_command (as used in
> recovery.conf)? I'm using this in a hot-standby-configuration in
On Thursday 2. April 2009, linnewbie wrote:
>Hi All,
>
>I'm fairly new to postgres and I'm having this peculiar problem.
>
>I'm storing raw html in a text field and I want users who know HTML to
>update the content in a textarea field.
>
>The problem is postgres is adding braces to the begining and
Hi All,
I'm fairly new to postgres and I'm having this peculiar problem.
I'm storing raw html in a text field and I want users who know HTML to
update the content in a textarea field.
The problem is postgres is adding braces to the begining and ending of
the content. On creation and every time
Hi to all,
I'm new on this list and also on using postgre.
I wanted to write some C-Function but, also if I read all the documentation
about it on the Manuals directory on the postgre web page, i still have some
problems.
I already made some simple works just to try how was working and all went
Hi Duco,
sorry that I can't help you. But I want to say, that I have experienced
this last week too. In my case there was a power outage before and after
restart this happened, so ...
... but would be nice to have a comment from an expert.
Regards,
Bernhard
--
Sent via pgsql-general mailing
Hi All,
I'm fairly new to postgres and I'm having this peculiar problem.
I'm storing raw html in a text field and I want users who know HTML to
update the content in a textarea field.
The problem is postgres is adding braces to the begining and ending of
the content. On creation and every time
This is the work-flow I've in mind:
1a) take out *all* data from a table in chunks (M record for each
file, one big file?) (\copy??, from inside a scripting language?)
2a) process each file with awk to produce N files very similar each
other (substantially turn them into very simple xml)
3a) gzip
Aleksey Tsalolikhin wrote:
Hi. We're trying to implement two-phase commit and did not find a
complete working example in the manual. We found examples of the
separate pieces, but not the sequence in which to put them together.
[snip]
If there is somebody on this list involved with editing t
durumdara wrote:
Which way is supports by PGSQL trigger?
One way you did NOT mention, but you need to look into: use LISTEN and
NOTIFY. Whether or not this is suitable depends on how your application
is accessing PostgreSQL, as IIRC some database access APIs (eg: ODBC) do
not support LISTEN
Hi!
Windows Server, PGSQL.
When a new records arrived to the database, I want process them in the
background.
I have a processor service.
This is periodically (5-10 minutes) checking the "message" table, and if
there is some message, it is process them.
This periodic processing is good, but
64 matches
Mail list logo