Michael Glaesemann <[EMAIL PROTECTED]> writes:
> On Dec 14, 2005, at 2:49 , Tom Lane wrote:
>> There is a built-in function to_timestamp() equivalent to this in 8.1,
>> though it doesn't seem to have made it into the documentation :-(
> It's in 9.8. Data Type Formatting Functions
Yeah, I found it
David Rysdam <[EMAIL PROTECTED]> writes:
> Just finished building and installing on *Sun* (also
> "--without-readline", not that I think that could be the issue): Works
> fine. So it's something to do with the SGI build in particular.
More likely it's something to do with weird behavior of the
On Dec 14, 2005, at 11:38 , Rick Gigger wrote:
What actually fixes it is to run it a while and made sure there is
a bunch of data there (even if it is deleted and not visible to
anything) and run vacuum analyze. Then recreate the stored
procedure. Then run the stored procedure.
What ha
I have a table that I populate with a stored procedure. When the
stored procedure runs it deletes the table and rebuilds the whole
thing from scratch. Initially it performs terribly but when I play
around with it for a while (I will describe this in a moment) it runs
very, very fast.
If
This might be easier to use this SQL:
UPDATE message_table SET status = 'A' WHERE mid IN (1,2,3);
The following might work for Cocoon (never used it):
UPDATE message_table SET status = 'A' WHERE
mid IN ();
Aaron
On 12/13/05, Daniel Hertz <[EMAIL PROTECTED]> wrote:
Given a set of checkb
Well, go ahead...
On Tuesday 13 December 2005 10:41 am, Huub Fleuren saith:
> i would like to make a post
>
> --
> --
> Geodan IT b.v.
> Buitenhaven 27-A
> 5211 TP 's-Hertogenbosch (NL)
> -
> Tel: +31 (0)73 - 692 5151
> Fax:
David Rysdam <[EMAIL PROTECTED]> writes:
> Just finished building and installing on *Sun* (also
> "--without-readline", not that I think that could be the issue): Works
> fine. So it's something to do with the SGI build in particular.
IRIX buggy, film at 11. :)
-Doug
-
i would like to make a post
--
--
Geodan IT b.v.
Buitenhaven 27-A
5211 TP 's-Hertogenbosch (NL)
-
Tel: +31 (0)73 - 692 5151
Fax: +31 (0)73 - 692 5150
Mobiel:
-
Postadres / mailing address
All,
i'm trying to convert time stamps to "seconds since epoch" and back. My
original timestamps are given with a time zone (UTC), and i have a
conversion function to "ctime" which works pretty well:
CREATE OR REPLACE FUNCTION to_ctime (timestamptz) RETURNS integer AS $$
SELECT date_p
Hi,
I just downloaded the 8.1.1 rpms for FC4 from postgresql.org.
It appears that removing the existing rpms will require also
removing a number of dependencies. (That what Synaptics asserts...)
Is it possible to use a "rpm -Uvh *" to overwrite the existing
8.1.0 rpms from postgresql.org? and n
Version of Postgresql: 8.0.4
I have created a function:
-- Function: avg_max_speed_hr(timestamp, timestamp)
-- DROP FUNCTION avg_max_speed_hr("timestamp", "timestamp");
CREATE OR REPLACE FUNCTION avg_max_speed_hr("timestamp", "timestamp")
RETURNS SETOF t_avgmaxspeedhr AS
$BODY$
SELECT date_tr
Richard Huxton wrote:
John Taber wrote:
I am having trouble connecting php(5.1.1) and postgresql(8.1) running on
Ubuntu Breezy. Both run fine separately. I created a user (tempuser) and
a database (tempdb). If I run psql -l it shows the database "tempdb"
with the username "tempuser". But I ge
kbforge.com is pleased to announce the first public release of "kbforge",
a new free desktop search application specifically designed for software
developers.
What differentiates kbforge from other desktop search programs, is its
ability to assist the user in categorising the information before it
Given a set of checkbox values that are submitted through an html form,
how do you loop through the submitted values to update more than one row
in a table?
Imagine a table called 'message_table':
mid | message | status
+-+---
1 | Text1 | H
2 | Text2 | H
3 | Text
On Dec 14, 2005, at 2:49 , Tom Lane wrote:
There is a built-in function to_timestamp() equivalent to this in 8.1,
though it doesn't seem to have made it into the documentation :-(
It's in 9.8. Data Type Formatting Functions
http://www.postgresql.org/docs/current/interactive/functions-
format
Just finished building and installing on *Sun* (also
"--without-readline", not that I think that could be the issue): Works
fine. So it's something to do with the SGI build in particular.
David Rysdam wrote:
I have a working 8.1 server running on Linux and I can connect to it
from other Linu
Peter L. Berghold wrote:
The question I have is with a trigger on delete are the NEW and OLD
system variables valid? Which one is valid?
OLD for deletes. NEW for inserts. Both for updates.
HTH
--
Richard Huxton
Archonet Ltd
---(end of broadcast)
John Taber wrote:
I am having trouble connecting php(5.1.1) and postgresql(8.1) running on
Ubuntu Breezy. Both run fine separately. I created a user (tempuser) and
a database (tempdb). If I run psql -l it shows the database "tempdb"
with the username "tempuser". But I get the following error us
>
> The question I have is with a trigger on delete are the NEW and OLD
> system variables valid? Which one is valid?
>
>
OLD
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 4: Have you searched our list archi
On Tue, Dec 13, 2005 at 01:24:36PM +0200, Sim Zacks wrote:
> Where can I change the statistic targets?
See the readme for pg_autovacuum. As I mentioned, -V is one of the
parameters you want to track.
> These details for each table are written at the beginning, when I start it.
>
> [2005-12-13 12
I am having trouble connecting php(5.1.1) and postgresql(8.1) running on
Ubuntu Breezy. Both run fine separately. I created a user (tempuser) and
a database (tempdb). If I run psql -l it shows the database "tempdb"
with the username "tempuser". But I get the following error using
pg_connect:
Wa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi folks,
I hope this question isn't a stupid one, but I'm fairly much a newbie to
SQL in general and Postgres in particular.
I have a table (abbreviated for clarity sake) that contains:
create table change_record (
change_record_id inte
I have a working 8.1 server running on Linux and I can connect to it
from other Linux clients. I built postgresql 8.1 on an SGI (using
--without-readline but otherwise stock) and it compiled OK and installed
fine. But when I try to connect to the Linux server I get "could not
send startup pac
On Tue, Dec 13, 2005 at 12:34:19PM -0700, Michael Fuhr wrote:
> > *Display* of timestamptz values at arbitrary time zones is
> > already possible using the "at time zone" syntax.
>
> But the result is a timestamp without time zone and thus doesn't
> display the target time zone. In other words,
On Tue, Dec 13, 2005 at 08:21:20PM +0100, Karsten Hilbert wrote:
> On Tue, Dec 13, 2005 at 10:28:42AM -0700, Michael Fuhr wrote:
> > As far as I know there isn't a way to defeat this. However, the
> > developers' TODO file does have the following item:
> >
> > Allow TIMESTAMP WITH TIME ZONE t
On Tue, Dec 13, 2005 at 10:28:42AM -0700, Michael Fuhr wrote:
> According to the Date/Time Types documentation,
>
> All timezone-aware dates and times are stored internally in UTC.
> They are converted to local time in the zone specified by the
> timezone configuration parameter befor
Vivek Khera <[EMAIL PROTECTED]> writes:
> On Dec 13, 2005, at 2:49 AM, [EMAIL PROTECTED] wrote:
>
> > What is the performance difference between U320 15kRPM and U320 10kRPM ?
> > Does your RAID crontoller has some memory (e.g. 128 MB or 256 MB )
> > and something like memory backup write cache
> Andrus wrote:
>> I want to create editable grid (client application) for large Postgres
>> table:
>>
>> At startup this grid show first screenful of records and allows to edit
>> them.
>> When user presses page down key, this grid should read next screenful of
>> records and allow to edit them et
Martin Pitt <[EMAIL PROTECTED]> writes:
> I fully agree. (BTW, I doubt that double operations on m68k would be
> any faster than integer ones...)
Debatable at best --- most later 68k machines had hardware FPUs, but
none of them had any 64-bit-int instructions...
regards, t
"John Sidney-Woollett" <[EMAIL PROTECTED]> writes:
> Is it possible to grab memory outsize of a processes space?
Not unless there's a kernel bug involved.
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to inc
Alex Mayrhofer <[EMAIL PROTECTED]> writes:
> i'm trying to convert time stamps to "seconds since epoch" and back.
> test=# SELECT (TIMESTAMP WITH TIME ZONE 'epoch'
> + 0 * INTERVAL '1 second') AT TIME ZONE 'UTC';
You're overthinking the problem. It should be just
SELECT
On Tue, 13 Dec 2005, Stephen Frost wrote:
> * Stephan Szabo ([EMAIL PROTECTED]) wrote:
>
> > In and of itself it's a good option. However, choosing that option means
> > that Debian is saying that compatibility of data files with default
> > compiled PostgreSQL is not one of its primary concerns
Wes <[EMAIL PROTECTED]> writes:
> Any ideas on how I might I reconfigure to mitigate the issue? Separating
> the most offending indexes to separate drives probably isn't an option.
What are you using for vacuum_mem? A larger value should reduce the
number of times we have to scan the indexes of
On Tue, 2005-12-13 at 09:13, Tom Lane wrote:
> John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> *What* is consuming memory, exactly --- which processes?
>
> > Sorry but I don't know how to determine that.
>
> Try "ps auxw", or some other incantation if you prefer, so long
On Tue, Dec 13, 2005 at 05:31:49PM +0100, Alex Mayrhofer wrote:
> i'm trying to convert time stamps to "seconds since epoch" and back. My
> original timestamps are given with a time zone (UTC), and i have a
> conversion function to "ctime" which works pretty well:
>
> CREATE OR REPLACE FUNCTION
Hi Stephen!
Stephen Frost [2005-12-13 11:06 -0500]:
> Honestly, in the end I think the default should be changed. It could
> fall-back to double with a warning (if it doesn't already) if the
> compiler doesn't support 64bit integers.
> [...]
> I don't think the Debian default should be changed th
Andrus wrote:
I want to create editable grid (client application) for large Postgres
table:
At startup this grid show first screenful of records and allows to edit
them.
When user presses page down key, this grid should read next screenful of
records and allow to edit them etc.
PgADMIN tries to
I want to create editable grid (client application) for large Postgres
table:
At startup this grid show first screenful of records and allows to edit
them.
When user presses page down key, this grid should read next screenful of
records and allow to edit them etc.
PgADMIN tries to read the whole t
Tom Lane said:
> John Sidney-Woollett <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>>> *What* is consuming memory, exactly --- which processes?
>
>> Sorry but I don't know how to determine that.
>
> Try "ps auxw", or some other incantation if you prefer, so long as it
> includes some statistics a
Hi,
i'm trying to convert time stamps to "seconds since epoch" and back. My
original timestamps are given with a time zone (UTC), and i have a
conversion function to "ctime" which works pretty well:
CREATE OR REPLACE FUNCTION to_ctime (timestamptz) RETURNS integer AS $$
SELECT date_pa
On Tuesday 13 December 2005 11:20 am, John Sidney-Woollett saith:
> Not sure if there is a numeric formatting option that allows what you want.
>
> But how about?
>
> substr(to_char(1029, '9,999'),2)
That's so simple, I'm embarrased ;o)
Thanks for the help...
>
> John
>
> Terry Lee Tucker said:
On 12/12/05 5:26 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
>> The problem was determined to be due to the fact that indexes are vacuumed
>> in index order, not in disk storage order. I don't see anything about this
>> in the "What's new" for 8.1. Has anything been done to resolve this?
>
> No.
Not sure if there is a numeric formatting option that allows what you want.
But how about?
substr(to_char(1029, '9,999'),2)
John
Terry Lee Tucker said:
> Greetings List:
>
> I am using to_char to format numeric data into a string that is ultimately
> displayed in an XmText widget. Much of the
Greetings List:
I am using to_char to format numeric data into a string that is ultimately
displayed in an XmText widget. Much of the numeric data is always going to be
positive. In some of the windows that display this data, space is at a
premium. Basically, I need to display something like 1,
* Stephan Szabo ([EMAIL PROTECTED]) wrote:
> On Tue, 13 Dec 2005, Anand Kumria wrote:
> > On Mon, Dec 12, 2005 at 09:41:47AM +0100, Richard van den Berg wrote:
> > > Tom Lane wrote:
> > > > You've got that 100% backwards: you should be complaining to Debian that
> > > > it's not their business to e
Thank you for your answer.
Instead of launching a VACUUM FULL ANALYZE on the "big" table, I will
try to use the "ALTER TABLE SET STATISTICS" command.
I will done this in a second time, during the optimization of the
benchmark.
Best regards,
Alexandra DANTE
Tom Lane a écrit :
DANTE ALEX
On Tue, 13 Dec 2005, Anand Kumria wrote:
> On Mon, Dec 12, 2005 at 09:41:47AM +0100, Richard van den Berg wrote:
> > Tom Lane wrote:
> > > You've got that 100% backwards: you should be complaining to Debian that
> > > it's not their business to editorialize on the default setting.
>
> Actually it
John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> *What* is consuming memory, exactly --- which processes?
> Sorry but I don't know how to determine that.
Try "ps auxw", or some other incantation if you prefer, so long as it
includes some statistics about process memory use.
On Dec 13, 2005, at 3:50 AM, Benjamin Arai wrote:
What kind of performance boost do you get from using raid 10? I am
trying
to do a little cost analysis.
For small amounts of data you probably wont notice anything. Once
you get into the 10's of GB you'll notice improvement when you have
On Dec 13, 2005, at 2:49 AM, [EMAIL PROTECTED] wrote:
What is the performance difference between U320 15kRPM and U320
10kRPM ?
Does your RAID crontoller has some memory (e.g. 128 MB or 256 MB )
and something like memory backup write cache (like HP DL 380 server) ?
Do you use Intel or Opteron
UPDATE
geom_summen a
SET
a.var228= a.var228 + (SELECT b.var228 FROM geom_ns_wrf b
WHERE b.gid=a.gid);
Use Coalesce if you want to substitute zero for null, otherwise the
column will be updated to null, if any of the values that was summed
was null.
On 12/1
/Hi,
I want to update a column (integer). The value that should be set is the
sum of the column I want to update and an integer column from another
table with similiar information an the same primary key "gid".
It should work this way:
Table1+ Table2 =
Is there any way (maybe via the odbc driver) to get MSAccess to
translate the money data type to Currency with linked tables?
I have converted our database from Access to Postgresql, but we are
still using the access front end. The difference between an Access
number type and an access currenc
Dear All,
I use '$libdir/lo' for manage my Large Object for PostgreSQL 8.0.4 . Now I try to up my PostgreSQL to new version as 8.1.1 but I think I got some error about lo (Large Object).
lo (Large Object) function that normally shown in function list now disappear. I'm sure that I already ch
Where can I change the statistic targets?
These details for each table are written at the beginning, when I start it.
[2005-12-13 12:38:45 IST] INFO: table name:
sales."public"."productdetails"
[2005-12-13 12:38:45 IST] INFO: relid: 9451256; relisshared: 0
[2005-12-13 12:38:45 I
On Mon, Dec 12, 2005 at 09:36:27PM -0600, Jim C. Nasby wrote:
> On Mon, Dec 12, 2005 at 02:38:57PM +0200, Marko Kreen wrote:
> >
> > I needed to re-set all permissions on a database as the database
> > access philosophy changed. But as it had a lot of tables, I was
> > losing overview very quick.
Tom Lane wrote:
Rich Doughty <[EMAIL PROTECTED]> writes:
I have a view vw_tokens defined as
...
I cannot however perform a meaningful join against this view.
...
PG forms the full output of the view.
You seem to be wishing that PG would push the INNER JOIN down inside the
nested LEFT JOINs.
On Tue, Dec 13, 2005 at 10:43:14AM +0200, Sim Zacks wrote:
> This is a sampling of the debug output.
>
> [2005-12-13 09:43:47 IST] DEBUG: 33 All DBs checked in: 278300 usec,
> will sleep for 300 secs.
> [2005-12-13 09:48:47 IST] DEBUG: 34 All DBs checked in: 171112 usec,
> will sleep for 300
What kind of performance boost do you get from using raid 10? I am trying
to do a little cost analysis.
Benjamin Arai
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.benjaminarai.com
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> [EMAIL PRO
This is a sampling of the debug output.
[2005-12-13 09:43:47 IST] DEBUG: 33 All DBs checked in: 278300 usec,
will sleep for 300 secs.
[2005-12-13 09:48:47 IST] DEBUG: 34 All DBs checked in: 171112 usec,
will sleep for 300 secs.
[2005-12-13 09:53:47 IST] DEBUG: updating the database list
On Mon, Dec 12, 2005 at 08:31:52PM -0800, Joshua D. Drake wrote:
> >
> >>It sure is. Gentoo with kernel version 2.6.12, built for x86_64.
> >>Looks like we have a contender for the common factor. :)
> >>
> >
> >Please tell me you're *not* running a production database on Gentoo.
> >
> >
>
On Mon, Dec 12, 2005 at 09:41:47AM +0100, Richard van den Berg wrote:
> Tom Lane wrote:
> > You've got that 100% backwards: you should be complaining to Debian that
> > it's not their business to editorialize on the default setting.
Actually it *is* the business of Debian maintainers to determine
On Mon, Dec 12, 2005 at 11:09:01PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Mon, Dec 12, 2005 at 06:26:37PM -0500, Tom Lane wrote:
> >> No. Avoiding that would require a new approach to
> >> vacuum-vs-ordinary-indexscan interlocking, so it won't happen until
> >>
Sorry but I don't know how to determine that.
We stopped and started postgres yesterday so the server is behaving well
at the moment.
top shows
top - 07:51:48 up 34 days, 6 min, 1 user, load average: 0.00, 0.02, 0.00
Tasks: 85 total, 1 running, 84 sleeping, 0 stopped, 0 zombie
Cpu(s): 0
64 matches
Mail list logo
