Thanks Jeff
I'm going through a learning curve. I don't need to add possible
instability.
Thanks again.
Bob
- Original Message -
From: "Jeff Davis" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Wednesday, November 29, 2006 4:41 PM
Subject: Re: [GEN
On Wed, 2006-11-29 at 15:31 -0800, Bob Pawley wrote:
> I may as well bite the bullet.
>
If you're going to migrate to 8.1, you might consider migrating to 8.2
since it's almost released. That depends on your timeline though; 8.1 is
a safer bet if you need stability now.
> Is this the syntax to u
2006/11/29, Guy Rouillier <[EMAIL PROTECTED]>:
John DeSoi wrote:
> There are supposedly some native Mono toolkits for
> the Mac, but I have yet to see any Mac application that uses it.
I'm aware there is substantial anti-Java bias here, but the Standard
Widget Toolkit (SWT) uses native widgets o
I may as well bite the bullet.
Is this the syntax to use ???
CREATE OR REPLACE FUNCTION p_id.loopnumber()
RETURNS "trigger" AS $$
Update p_id.loop_sequence
Set function_ = library.devices.designation
From p_id.loops
where p_id.loop_sequence.monitor = p_id.devices.devices_id
and p_id.devices.dev
On Wed, Nov 29, 2006 at 04:55:49PM -0500, Tom Lane wrote:
> "Matt Miller" <[EMAIL PROTECTED]> writes:
> > I thought I saw a thread (here or on -hackers, or somewhere) where
> > someone created a C program or something to automatically convert
> > Oracle's DECODE expression into an ANSI CASE express
On Wednesday 29 November 2006 02:42 pm, Bob Pawley wrote:
> I have just upgraded from v8.0 to 8.1.
>
> In the new version I keep getting errors due to the absence of 'from' -on
> triggers that showed no error in the old version.
>
> Was insisting on the use of from a planned part of the upgrade?
>
On Wed, 2006-11-29 at 14:42 -0800, Bob Pawley wrote:
> I have just upgraded from v8.0 to 8.1.
>
> In the new version I keep getting errors due to the absence of 'from'
> -on triggers that showed no error in the old version.
>
> Was insisting on the use of from a planned part of the upgrade?
>
I have just upgraded from v8.0 to 8.1.
In the new version I keep getting errors due to the absence of 'from' -on
triggers that showed no error in the old version.
Was insisting on the use of from a planned part of the upgrade?
Bob Pawley
Chris Browne schrieb:
> There are other options out there that could conceivably change the
> price of compression, such as:
>
> http://www.lzop.org/
> http://www.quicklz.com/
>
> Of course, those are not as well known compression systems, and so are
> not as well trusted. Maybe worth looking i
Tom Lane wrote:
> -- repeat up to the most number of decode items you need to support
Does PG's function overloading make varargs difficult?
--
Guy Rouillier
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desi
[EMAIL PROTECTED] (Vivek Khera) writes:
> On Nov 28, 2006, at 11:11 AM, Andrus wrote:
>
>> 1. My database size seems to be appox 1 GB and download speed is
>> approx 600
>> kb/s. Your solution requires 4.5 hours download time
>> since 1 GB of data must be downloaded.
>
> If you're running pg_dump
"Matt Miller" <[EMAIL PROTECTED]> writes:
> I thought I saw a thread (here or on -hackers, or somewhere) where
> someone created a C program or something to automatically convert
> Oracle's DECODE expression into an ANSI CASE expression.
You could just use a compatibility function:
create functio
John DeSoi wrote:
> There are supposedly some native Mono toolkits for
> the Mac, but I have yet to see any Mac application that uses it.
I'm aware there is substantial anti-Java bias here, but the Standard
Widget Toolkit (SWT) uses native widgets on all platforms. I've never
had occasion to use
>>> On Wed, Nov 29, 2006 at 1:32 PM, in message
<[EMAIL PROTECTED]>, "Kevin Grittner"
<[EMAIL PROTECTED]> wrote:
On Wed, Nov 29, 2006 at 1:09 PM, in message
> <[EMAIL PROTECTED]>,
> Richard Huxton wrote:
>
>> Another option I can think of: Spot the case where all values in
the
>> coales
Joshua D. Drake wrote on 29.11.2006 17:30:
I forgot that NetBeans was open source now...
Now? It has been open source way before Eclipse even dawned ;)
Thomas
---(end of broadcast)---
TIP 4: Have you searched our list archives?
ht
I thought I saw a thread (here or on -hackers, or somewhere) where
someone created a C program or something to automatically convert
Oracle's DECODE expression into an ANSI CASE expression. Now I'm not
finding that thread. Is there such a beast?
---(end of broadcast)-
Andrus wrote:
You seem dead set on making your life harder than it needs to be. If you
really don't want to have the ssh port open then set the backup to run
from a cron-job on the main server and have it scp the result over to the
backup server. That way only the backup server needs ssh open.
pgAdmin III is only for PgSQL. I plan on a multidb one. Thats my idea
from the beginning. Atleast, support Mysql and PgSQL and and then
support other DB as time progresses.
On 11/29/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
On Wed, 2006-11-29 at 13:00 -0600, Tony Caduto wrote:
> Ritesh Nadh
On Wed, 2006-11-29 at 14:16, Vivek Khera wrote:
> On Nov 29, 2006, at 2:39 PM, Scott Marlowe wrote:
>
> >> Sounds good. According to LSI, the drive will take 8 hrs to rebuild a
> >> 146GB disc (at a 30% rebuild rate), so doing this in the middle of
> >> the
> >> day is not ideal.
> >
> > The reb
http://www.postgresql.org/files/documentation/books/aw_pgsql/node210.html
just a simple command to copy data to and from tables/files.
Mark Jensen
- Original Message
From: Andrus <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Wednesday,
On Nov 29, 2006, at 2:39 PM, Scott Marlowe wrote:
Sounds good. According to LSI, the drive will take 8 hrs to rebuild a
146GB disc (at a 30% rebuild rate), so doing this in the middle of
the
day is not ideal.
The rebuild time also tends to depend on how full the array is. If
you're only u
On Wed, Nov 29, 2006 at 01:45:09PM -0600, Kevin Grittner wrote:
> > And do what? The only information you have is that all the inputs
> > are of unknown type.
>
> I know this is naive, but, what is the type information of the bare
> null? Could that be used?
A null can be of any type, string,
Kevin Grittner wrote:
On Wed, Nov 29, 2006 at 1:38 PM, in message
<[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
Richard Huxton wrote:
It's the coalesce that has the problem, not the insert. The
coalesce is
deciding that it's working
>> Not sure but using a binary cursor might improve things.
>
> Why not use COPY protocol?
I did full text search in Postgres 8.1 help file for "COPY protocol" but
havent found any matches.
Which is COPY protocol and how to use it ?
Andrus.
---(end of broadcast)-
> You seem dead set on making your life harder than it needs to be. If you
> really don't want to have the ssh port open then set the backup to run
> from a cron-job on the main server and have it scp the result over to the
> backup server. That way only the backup server needs ssh open.
By bac
>>> On Wed, Nov 29, 2006 at 1:38 PM, in message
<[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
>> Richard Huxton wrote:
>>> It's the coalesce that has the problem, not the insert. The
coalesce is
>>> deciding that it's working on text, a
thanks Richard. I've talking to Ron Mayer about this as well offline. I think
the main problem is dedupping users, and not being able to aggregate visits in
the fact table. that's where most of the query time takes place. but the
business guys just won't accept using visits, but not actual u
On Wed, 2006-11-29 at 13:21, Steve Poe wrote:
> Yep, I've done it a few times. A few tips:
>
> backup your database with pg_dump. confirm you can restore on
> a test
> machine.
>
> Thanks. We do nightly dump and restore to a second server for
> testing/
On Wed, 2006-11-29 at 13:00 -0600, Tony Caduto wrote:
> Ritesh Nadhani wrote:
> > Thanks to all for their suggestions and ideas. I believe that there is
> > indeed a scope for such a tool.
> >
> > My semester ends on 15th December and I get a one month break between
> > next semester. I will write
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> Richard Huxton wrote:
>> It's the coalesce that has the problem, not the insert. The coalesce is
>> deciding that it's working on text, and so returns text.
> It seems like maybe it would be worth overloading the coalesce method
> to handle this p
>>> On Wed, Nov 29, 2006 at 1:09 PM, in message
<[EMAIL PROTECTED]>,
Richard Huxton wrote:
> Kevin Grittner wrote:
>> Tom Lane <[EMAIL PROTECTED]> wrote:
>> We never do assume that a text literal is a valid date. I won't
bore
>> you with all the details unless you ask for them, but we're runni
2006/11/29, Joshua D. Drake <[EMAIL PROTECTED]>:
On Wed, 2006-11-29 at 17:31 +, Tomi N/A wrote:
> 2006/11/29, Joshua D. Drake <[EMAIL PROTECTED]>:
> > On Wed, 2006-11-29 at 10:17 -0600, Tony Caduto wrote:
> > > Joshua D. Drake wrote:
> > > > The closest I think you would find is Eclipse or ma
Mark Jensen wrote:
So i've been given the task of designing a data warehouse in
either Postgresql or Mysql for our clickstream data for our sites. I
started with Mysql but the joins in Mysql are just way too slow
compared to Postgresql when playing with star schemas.
Mark - it's not my usual a
Yep, I've done it a few times. A few tips:
backup your database with pg_dump. confirm you can restore on a test
machine.
Thanks. We do nightly dump and restore to a second server for
testing/backup purposes.
The data is entact. Are you recommending a dump before we begin the drive
rebuild?
Kevin Grittner wrote:
Tom Lane <[EMAIL PROTECTED]> wrote:
We never do assume that a text literal is a valid date. I won't bore
you with all the details unless you ask for them, but we're running on
Java and generating literals based on the object type passed to a low
level method. A null has n
Ritesh Nadhani wrote:
Thanks to all for their suggestions and ideas. I believe that there is
indeed a scope for such a tool.
My semester ends on 15th December and I get a one month break between
next semester. I will write a simple app in wxWidgets (that is what I
am comfortable with right now)
>>> On Wed, Nov 29, 2006 at 12:15 PM, in message
<[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
>> [ "coalesce(null, null)" yields type TEXT ]
>
> Well, it has to yield *something*. You'd get the same result from
> "coalesce('2006- 11- 29'
On Nov 29, 2006, at 11:56 AM, Steve Poe wrote:
I've never had to replace a disc in an array with Postgresql
running on it. LSI says I can replace the disc and do a rebuild
while everything is running. I am of course concerned about data
integrity/corruption.
This is the whole entire co
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> [ "coalesce(null, null)" yields type TEXT ]
Well, it has to yield *something*. You'd get the same result from
"coalesce('2006-11-29', '2006-11-30')" ... you might think this looks
like dates, but it's just some untyped literals and the parser chooses
Thanks to all for their suggestions and ideas. I believe that there is
indeed a scope for such a tool.
My semester ends on 15th December and I get a one month break between
next semester. I will write a simple app in wxWidgets (that is what I
am comfortable with right now) to show what I am tryin
On Wed, 2006-11-29 at 16:47 +0100, Michal Taborsky - Internet Mall
wrote:
> Hello.
>
> We started using, in one of our applications, the LOCK ... NOWAIT
> functionality. It works as it's supposed to, but there is one, albeit
> tiny, annoyance about it.
>
> When the LOCK cannot be immediately obta
On Wed, 2006-11-29 at 17:31 +, Tomi N/A wrote:
> 2006/11/29, Joshua D. Drake <[EMAIL PROTECTED]>:
> > On Wed, 2006-11-29 at 10:17 -0600, Tony Caduto wrote:
> > > Joshua D. Drake wrote:
> > > > The closest I think you would find is Eclipse or maybe KDevelop.
> > > >
> > > Actually NetBeans 5.5 i
2006/11/29, Joshua D. Drake <[EMAIL PROTECTED]>:
On Wed, 2006-11-29 at 10:17 -0600, Tony Caduto wrote:
> Joshua D. Drake wrote:
> > The closest I think you would find is Eclipse or maybe KDevelop.
> >
> Actually NetBeans 5.5 is the closest thing I have seen for Java that is
> even close to visual
On Wed, 2006-11-29 at 08:56 -0800, Steve Poe wrote:
> I need some input from the Postgresql community.
>
> Our animal hospital runs Postgresql 7.4 on a 6-disc RAID10. The
> database logs are on a separate RAID1.
>
> We're using an LSI MegaRAID 320-2X controller. The controller reports
> one 146G
Here is sample code demonstrating the issue:
test=# create table test_coalesce(f1 int not null, f2 date);
CREATE TABLE
test=# insert into test_coalesce values (1, null);
INSERT 0 1
test=# insert into test_coalesce values (2, coalesce(null, null));
ERROR: column "f2" is of type date but expressio
On Wed, 2006-11-29 at 10:56, Steve Poe wrote:
> I need some input from the Postgresql community.
>
> Our animal hospital runs Postgresql 7.4 on a 6-disc RAID10. The
> database logs are on a separate RAID1.
>
> We're using an LSI MegaRAID 320-2X controller. The controller reports
> one 146GB SCSI
I need some input from the Postgresql community.
Our animal hospital runs Postgresql 7.4 on a 6-disc RAID10. The database
logs are on a separate RAID1.
We're using an LSI MegaRAID 320-2X controller. The controller reports one
146GB SCSI disc has failed in the RAID10 performance is in "DEGRADED"
On Wed, 29 Nov 2006 18:38:22 +0530, "Merlin Moncure" <[EMAIL PROTECTED]> wrote:
> On 11/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> Hello friends,
>> I have a view defined as:-
>>
>> CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS
> name from users, vivek_test wh
On 11/29/06, Bernd Helmle <[EMAIL PROTECTED]> wrote:
> no, queries using * are expanded when the plan is created. for views,
> the plan is created when you create the view (also the original query
> string to create the view is not stored). however, you could however
> create a function that re
On Wed, 2006-11-29 at 08:42 -0800, Richard Troy wrote:
> On Wed, 29 Nov 2006, Ritesh Nadhani wrote:
> >
> > Hello
> >
> > I have been working with wxWidgets and I didnt face a problem. What
> > specific thing were broken in wxWidgets for Windows?
> >
> > Ritesh
>
> PLEASE take this offline - it's
Well, to be fair, I was using fairly low-level functionality. If you
look at the screenshot from my app, I am just using the raw window class
and handling all of the dragging etc. manually. In addition, my foreign
key drawing is handled by directly painting on the background, and my
own click
On Wed, 29 Nov 2006, Ritesh Nadhani wrote:
>
> Hello
>
> I have been working with wxWidgets and I didnt face a problem. What
> specific thing were broken in wxWidgets for Windows?
>
> Ritesh
PLEASE take this offline - it's not even close to Postgres related.
Richard
--
Richard Troy, Chief Scie
On Wed, 2006-11-29 at 10:17 -0600, Tony Caduto wrote:
> Joshua D. Drake wrote:
> > The closest I think you would find is Eclipse or maybe KDevelop.
> >
> >
> >
> Actually NetBeans 5.5 is the closest thing I have seen for Java that is
> even close to visual studio or Delphi.
I forgot that NetB
Hello
I have been working with wxWidgets and I didnt face a problem. What
specific thing were broken in wxWidgets for Windows?
Ritesh
On 11/29/06, John McCawley <[EMAIL PROTECTED]> wrote:
I have been struggling with this problem for a few years. I have
written a basic relational database desi
> I am in the impression that SQL join takes more time for
> execution as well as space because database internally builds Cartesian
> product and then evaluates for condition.
No, that's a conceptual description, but the actual process is more
optimized, often far more so if you have the appropri
Joshua D. Drake wrote:
The closest I think you would find is Eclipse or maybe KDevelop.
Actually NetBeans 5.5 is the closest thing I have seen for Java that is
even close to visual studio or Delphi.
The visual web add on package they have for 5.5 is actually pretty
amazing, it's a tech p
On Wed, 2006-11-29 at 08:29 +0100, Marcus Engene wrote:
> John DeSoi skrev:
>
> > There are highly productive IDEs for the Mac with all the goodies you
> > mention. But few are cross-platform.
> >
> > Your statement about Windows desktop market share is correct, but it is
> > not the relevant p
"surabhi.ahuja" <[EMAIL PROTECTED]> writes:
> I was using Postgres 8.0.0
> I have upgraded it to Postgres 8.1.5
> I have seen that the delete performance has degraded considerably.
Did you remember to re-ANALYZE your tables after transferring your database?
If so, what does EXPLAIN ANALYZE show fo
Hello.
We started using, in one of our applications, the LOCK ... NOWAIT
functionality. It works as it's supposed to, but there is one, albeit
tiny, annoyance about it.
When the LOCK cannot be immediately obtained, this statement logs an
ERROR message. But in this case, I think it is not appropr
Can anybody please tell me whether there are any disadvantage of SQL
joins in terms of space and time and how postgres has implemented SQL
joins? I am in the impression that SQL join takes more time for
execution as well as space because database internally builds Cartesian
product and then eva
On 11/28/06, Tom Lane <[EMAIL PROTECTED]> wrote:
This is at variance with what Merlin reported --- so I'm asking again
just what platform he's on. He might want to strace cp to see whether
it's doing an unlink or not in his scenario.
this is centos 32 bit.
[EMAIL PROTECTED] esilo]# uname -a
Li
I have been struggling with this problem for a few years. I have
written a basic relational database design tool:
http://www.hardgeus.com/pgdesigner/
I have completely rewritten this program 3 times. I initially
implemented it in Fltk, but ran into a bunch of limitations in the API.
I rewr
Marc Evans wrote:
Hello -
A company that I am working with is looking for a pgsql system
administrator.
Couple of points Marc
1. Don't reply to a message to start a new thread - it can end up with
your message being displayed in the wrong place.
2. There's a pgsql-jobs list that you will p
On 11/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello friends,
I have a view defined as:-
CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS name from
users, vivek_test where vivek_test.username=users.username;
Now, when I add a new column in vivek_test, I cant see
Hello -
A company that I am working with is looking for a pgsql system
administrator. The host OSes are FreeBSD 6 and RedHat Enterprise Linux,
currently. Postgresql is currently version 8.1. Tasks would include
devising a world-wide replication and backup strategy, system performance
tuning,
Hi there,
I've got a rather large PL/pgSQL function which returns a varchar
(though it could be text, char or blob, I'm not fussy) containing JSON
information (where JSON is Javascript Object Notation). The middle
tier of the app does pretty much sweet FA except pass this straight
back to the cli
Hello friends,
I have a view defined as:-
CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS name from
users, vivek_test where vivek_test.username=users.username;
Now, when I add a new column in vivek_test, I cant see the new column in the
view. Currently we have to drop the
Hello friends,
I have a view defined as:-
CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS name from
users, vivek_test where vivek_test.username=users.username;
Now, when I add a new column in vivek_test, I cant see the new column in the
view. Currently we have to drop the
I was using Postgres 8.0.0
I have upgraded it to Postgres 8.1.5
I have seen that the delete performance has degraded considerably.
Nothing else has changed.
Please help
thanks
regards
Surabhi
Albert wrote:
Hi, I'm wondering if there is a method to call pg_dump from an external
application without changing the security level in pg_hba.conf from
trust to md5. I'd like to pass my password not in clear but using a
secure cryptographic method like md5.
You want the ".pgpass" file - it's
Hi, I'm wondering if there is a method to call pg_dump from an external
application without changing the security level in pg_hba.conf from
trust to md5. I'd like to pass my password not in clear but using a
secure cryptographic method like md5.
Any suggestion? Thanks!
--
Version 1.8 of VTD-XML is now released. The new features are:
·XMLModifier is a easy to use class that takes advantage of the
incremental update capability offered by VTD-XML
·XPath built-in functions are now almost complete
·This release added encoding support for iso-8
I am using Redhat Linux 4
Now the problem is solved.I installed Postgres 8.1.5
from source code previously it was installed using rpm
on slave machine.
but then i am having one problem :
I am left with following details
I am having two machine
1)Master machine :
Redhat linux
PostgreSQL 8.1.5 -- i
73 matches
Mail list logo
