On Thu, Dec 23, 2004 at 01:22:42PM -0800, Mike wrote:
> My question is- is there anyway, since a call to sp_host('10.0.0.1') will
> always
> return the same value (the primary key/sequence value from the ip_addresses
> table), to cache/index that value somehow, so anytime I ever call that same
> f
Klint Gore wrote:
Can anyone do something about the duplicate messages from the list?
It seems to be delivering twice from svr1.postgresql.org to
commandprompt.com (the timestamps on the received headers are the same
up until that point). Delivering to hosting.commandprompt.com doesnt
seem to dupl
* Lonni J Friedman <[EMAIL PROTECTED]> [1217 18:17]:
> I dunno, can ruby by used in windows? I haven't touched a windows box
> in about 10 years.
Yup, see :
http://rubyforge.org/projects/rubyinstaller/
--
'Interesting. No, wait, the other thing - Tedious.'
-- Bender
Rasputin
On Thu, Dec 23, 2004 at 11:23:30PM +0100, Együd Csaba (Freemail) wrote:
Együd,
> Sorry for misspelling your name. It is almost midnight here...
Ah, never mind! I don't really care that much about it ...
> So Dear Alvaro, [is it ok? :)]
Well, not completely, because it's really Álvaro, though
Bambero <[EMAIL PROTECTED]> writes:
> I don't know what fields are in the table so:
>
> select fieldname as 1, fieldname2 as 2
>
> is useless.
slo=> create table x (foo text,bar text,baz text);
CREATE TABLE
slo=> select * from (select * from x) as x ("1","2","3");
1 | 2 | 3
---+---+---
(0 ro
Sorry for misspelling your name. It is almost midnight here...
So Dear Alvaro, [is it ok? :)]
This table is updated (not inserted... just updated) by another server in
every minutes. The procedure creates a few (configurable number of) empty
minutes in advance as a placeholder for the coming measu
Hello Group,
I've run into a bit of a problem, I have a varchar(6) field that I now need to
have as a varchar(12).
I am relatively new to postgres and am unsure how best to do this. What I
would like to do is alter the meta-data directly. Change the value of
atttypmod in pg_attribute directly.
On Thu, Dec 23, 2004 at 09:48:56PM +0100, Együd Csaba (Freemail) wrote:
Hi,
> Dear Alvarao,
Wow, now that's a strange misspelling. I've seen several but this one
is new to me :-D
> would you please so kind explaining me your opinion in details.
What do you want that table for? If you are usi
On Tue, Dec 21, 2004 at 12:51:05PM -0500, Ernest Kim wrote:
> I'm trying to use the tiki-wiki software. It has several indexes
> which store the web page's data as an index criteria. The problem
> comes up when a web page is a large web page. It can't store the page
> in the index.
That's a
Hello,
I've written several functions using the SPI_ interface, some of them are to
simply ease inserting into a few tables-
ie- I wrote a function sp_host('10.0.0.1'); which returns the id of the
given
ip address from a ip_addresses table if it exists, otherwise, it inserts it,
and
returns that
Dear Alvarao,
would you please so kind explaining me your opinion in details.
thanks,
-- Csaba
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alvaro Herrera
Sent: Thursday, December 23, 2004 3:58 PM
To: Együd Csaba (Freemail)
Cc: pgsql-general@postgresq
On Thu, Dec 23, 2004 at 11:56:26AM -0800, Mark wrote:
> Is it possible to lock row(s) when updating a table, so another call
> for update( from different session) will be rejected and to be on
> hold until lock get released ?
The UPDATE statement automatically acquires locks, but if you need
more
On Thu, 2004-12-23 at 13:56, Mark wrote:
> Hi,
> Is it possible to lock row(s) when updating a table, so another call
> for update( from different session) will be rejected and to be on
> hold until lock get released ?
Generally the update itself will lock the table from other updates until
your t
Hi,
Is it possible to lock row(s) when updating a table, so another call
for update( from different session) will be rejected and to be on
hold until lock get released ?
Thanks,
Mark.
__
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
On Thu, Dec 23, 2004 at 06:37:14PM +, Bambero wrote:
> Is there any easy way to select all fields from table (*) but the result
> should looks like this:
>
> 1|2|3
> +-+--
> asas| asd | dasd
> ada | ads | dasa
>
> Column name should be a number of column.
Why do you n
I dunno, can ruby by used in windows? I haven't touched a windows box
in about 10 years.
On Thu, 23 Dec 2004 11:50:08 -0600, Jason Tesser <[EMAIL PROTECTED]> wrote:
> maybe We don't mind the command line but my college at work doesn't like to
> bring in other technologies where not needed and h
maybe We don't mind the command line but my college at work doesn't like to
bring in other technologies where not needed and he feels like this woulr be
doing that. it is ruby so if we need to modify it we need to learn ruby. I
dont mind so much I was just looking to see if anyone else had som
Hello
Is there any easy way to select all fields from table (*) but the result
should looks like this:
1|2|3
+-+--
asas| asd | dasd
ada | ads | dasa
Column name should be a number of column.
I don't know what fields are in the table so:
select fieldname as 1, fieldname2 as 2
pqa does exactly what your original question requested. Sounds like
what you really want is a GUI for pqa.
On Thu, 23 Dec 2004 10:09:51 -0600, Jason Tesser <[EMAIL PROTECTED]> wrote:
> Does anyone else know of any other tool that can do what I am talking about.
> I can get this one to work but
I pipe my postgresql output to apaches log rotator, and use perl or php
or even shell commands (cut, sort, uniq, etc...) to munge the data for
pretty viewing. I'll see what I've got laying around, but right now I'm
working on three or four other projects at work, and monitoring won't be
an issue f
Does anyone else know of any other tool that can do what I am talking about. I
can get this one to work but I would like to see a tool that is a little more
robust. maybe even a gui client or something?
-Original Message-
From: Lonni J Friedman [mailto:[EMAIL PROTECTED]
Sent: Thu 12/23
On Thu, Dec 23, 2004 at 10:51:46AM +0100, Együd Csaba (Freemail) wrote:
Hi,
> I've got it. Not the date handling is slow but the string handling.
> Eliminating the huge string buffer and running all the inserts row by row,
> the overall running time is 12 sec.
> So as a conclusion never use larg
Checkout pqa
On Thu, 23 Dec 2004 08:14:41 -0600, Jason Tesser <[EMAIL PROTECTED]> wrote:
> But that will just st in a huge tet sticks all data in text filess. I need a
> tool that will take that data and give me meaningful reports. I want to be
> able to get reports on queries ove rthe last 2
But that will just st in a huge tet sticks all data in text filess. I need a
tool that will take that data and give me meaningful reports. I want to be
able to get reports on queries ove rthe last 2 weeks. Which ones were slow
etc.. I dont want to have to read through 2 weeks worth of logs :-)
Sure, in postgresql.conf uncomment log_min_duration_statement and set
it to whatever value you want to log. This, of course, assumes that
you're already logging for the DB.
On Thu, 23 Dec 2004 07:27:22 -0600, Jason Tesser <[EMAIL PROTECTED]> wrote:
> I am looking for a tool in postgres to monito
I am looking for a tool in postgres to monitor present and past activity. Foe
example in SQLServer there is a tool that reports on all queries run in the
past say 2 weeks and tells you how long they took etc.. I know I can use
explain in postgres but I want to be able to track my queries in a
Hi,
I've got it. Not the date handling is slow but the string handling.
Eliminating the huge string buffer and running all the inserts row by row,
the overall running time is 12 sec.
So as a conclusion never use large strings in plpgsql functions.
Bye,
-- Csaba
-Original Message-
From:
On Thu, Dec 23, 2004 at 12:41:29PM +0530, Nageshwar Rao wrote:
> How to the insert into bytea data type column?
See the "Binary Data Types" section of the "Data Types" chapter in
the PostgreSQL documentation -- it shows the format for BYTEA data.
Your interface to PostgreSQL might have a functio
28 matches
Mail list logo
