Perfect - that appears to be exactly what I was looking for.
Cheers
Reg Me Please wrote:
Il Wednesday 14 November 2007 05:50:36 Willem Buitendyk ha scritto:
Will Postgresql ever implement an ignore on error feature when bulk
loading data? Currently it is my understanding that any record
On Mon, Nov 12, 2007 at 03:11:50PM -0800, Sarah Dougherty wrote:
To recap with an example, the query below works fine, but how do I add a
series to it?
generate_series will not help with this.
try the sequence approach, or this:
On Wed, Nov 14, 2007 at 06:56:06PM +1300, Martin Langhoff wrote:
Hmmm. We'll have to test and see if we have any in Moodle.
All that has happened is that the *implicit* casting is gone. They will
now simply produce errors, the fix being to explicity cast it to the
type you wanted, rather than
Hello all,
I'd like to know if the autovacuum feature also deals with automatically
reindexing my indexes.
I know Pg8 know comes with a more eficient management of indexes, but I
also read in the manuals that it's still good practice to routine
reindex de most critical (in terms of speed)
Joao Miguel Ferreira wrote:
Hello all,
I'd like to know if the autovacuum feature also deals with automatically
reindexing my indexes.
It doesn't.
I know Pg8 know comes with a more eficient management of indexes, but I
also read in the manuals that it's still good practice to routine
I have found some errors in my perl script that was slowing everything
down. I too am now seeing similar speed between postgresql and mysql.
Sorry for the confusion.
Dave
-Original Message-
From: Merlin Moncure [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 13, 2007 8:44 PM
To:
Hi:
I have a situation where I will be inserting thousands of records into a
table but leaving 2 of it's columns null. Later on, I will be updating
most of those records and putting real values in place of those 2
nulls. As for the ones that do not get updated, I want to leave them
null.
hubert depesz lubaczewski [EMAIL PROTECTED] writes:
On Mon, Nov 12, 2007 at 03:11:50PM -0800, Sarah Dougherty wrote:
To recap with an example, the query below works fine, but how do I add a
series to it?
generate_series will not help with this.
try the sequence approach, or this:
hubert depesz lubaczewski [EMAIL PROTECTED] writes:
On Wed, Nov 14, 2007 at 10:26:52AM -0500, Tom Lane wrote:
That's a fairly ugly/messy way of doing it. If you're going to need a C
function anyway, why not just do it directly? As in the attachment.
actually you dont have to do it in c.
On Wed, Nov 14, 2007 at 10:26:52AM -0500, Tom Lane wrote:
That's a fairly ugly/messy way of doing it. If you're going to need a C
function anyway, why not just do it directly? As in the attachment.
actually you dont have to do it in c.
alec pointed (in comments) that there already is
On 11/14/07, Tom Lane [EMAIL PROTECTED] wrote:
hubert depesz lubaczewski [EMAIL PROTECTED] writes:
On Mon, Nov 12, 2007 at 03:11:50PM -0800, Sarah Dougherty wrote:
To recap with an example, the query below works fine, but how do I add a
series to it?
generate_series will not help with
On Nov 14, 2007 9:28 AM, Gauthier, Dave [EMAIL PROTECTED] wrote:
Hi:
I have a situation where I will be inserting thousands of records into a
table but leaving 2 of it's columns null. Later on, I will be updating most
of those records and putting real values in place of those 2 nulls. As
On Wed, Nov 14, 2007 at 10:28:30AM -0500, Gauthier, Dave wrote:
null. My concern has to do with record fragmentation at the time of
update because there's no room to expand them to accept the non-null
data. (BTW, the columns are floating point).
You have a mistaken idea about how this
On 11/14/07, Tom Lane [EMAIL PROTECTED] wrote:
Jan de Visser [EMAIL PROTECTED] writes:
Any reason why this couldn't appear in the core of some future
version?
You didn't read to the end of my post ;-). If a rownum() function
like this didn't have any gotchas, I'd be in favor of putting it
Jan de Visser [EMAIL PROTECTED] writes:
Any reason why this couldn't appear in the core of some future
version?
You didn't read to the end of my post ;-). If a rownum() function
like this didn't have any gotchas, I'd be in favor of putting it in,
but I don't really want to set the behavior in
In this usage scenario, doesn't the new HOT (heap only tuples) feature
of PG8.3 help, in terms of the DB requiring less VACUUM maintenance?
I am similarly performing a huge number of inserts, followed by a huge
number of updates to fill in a few null fields. The data is indexed by
insert time.
On Nov 14, 2007, at 10:44 AM, Mike Charnoky wrote:
In this usage scenario, doesn't the new HOT (heap only tuples) feature
of PG8.3 help, in terms of the DB requiring less VACUUM maintenance?
I am similarly performing a huge number of inserts, followed by a huge
number of updates to fill in a
On Wed, Nov 14, 2007 at 11:31:11AM -0500, Gauthier, Dave wrote:
Thanks for the advanced warning about problems with vaccuum !
Note this isn't a _problem_ with vacuum, exactly, it's just the set of
compromises that PostgreSQL has settled on. There are other ways of
cleaning up the system
On Wed, Nov 14, 2007 at 11:44:55AM -0500, Mike Charnoky wrote:
In this usage scenario, doesn't the new HOT (heap only tuples) feature
of PG8.3 help, in terms of the DB requiring less VACUUM maintenance?
It should, yes. We'll probably know more once 8.3 is in the field. For new
work, though, I
OK, I didn't know Postgres did it this way. I was hoping it would retain
the old rec and update in place (if the updated values could fit). I
guess not.
I can rewrite the DB loading algorithm to get those values in advance,
load into program memory, and reference at the time of the initial load.
Hi,
Does anyone know if there is a debugger function that will return the
line numbers that are executable?
Also, is the debugger code available at pgfoundry the GUI client that
EnterpriseDB has done or is the module that needs to be installed on the
server?
As I understand it the debugger
Tom Lane wrote:
Tony Caduto [EMAIL PROTECTED] writes:
As I understand it the debugger functions are included by default in
8.3,
That's incorrect.
regards, tom lane
Ok, thanks for the info.
Back in Sept the debugger was advertised as a feature of 8.3, so
I am on 8.2 production and it will be difficult to upgrade to 8.3. Is
it possible to backport the %r fix from 8.3 to 8.2?
Regards
Dhaval
On Nov 13, 2007 11:26 PM, Simon Riggs [EMAIL PROTECTED] wrote:
On Tue, 2007-11-13 at 00:07 -0500, Greg Smith wrote:
On Mon, 12 Nov 2007, Mason Hale wrote:
Erik Jones wrote:
On Nov 14, 2007, at 10:44 AM, Mike Charnoky wrote:
In this usage scenario, doesn't the new HOT (heap only tuples) feature
of PG8.3 help, in terms of the DB requiring less VACUUM maintenance?
I am similarly performing a huge number of inserts, followed by a huge
number of
Tony Caduto [EMAIL PROTECTED] writes:
As I understand it the debugger functions are included by default in
8.3,
That's incorrect.
regards, tom lane
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 12:46:07 -0500
brian [EMAIL PROTECTED] wrote:
Tony Caduto wrote:
Back in Sept the debugger was advertised as a feature of 8.3, so if
it's not included how is it a feature?
Advocacy of PostgreSQL includes more than just
Tony Caduto wrote:
Back in Sept the debugger was advertised as a feature of 8.3, so if it's
not included how is it a feature?
Is it going to be included as a contrib module or something else? I am
talking about the server side stuff not the EDB GUI client.
I don't know what you're
Hi
I try to use pg_dump to dump my database.
pg_dump smrs
and it gives me an error
pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite entry OID
670741 not found
What causes this problem?
Thanks
sharmila
On Wed, 2007-11-14 at 10:32 -0800, SHARMILA JOTHIRAJAH wrote:
Hi
I try to use pg_dump to dump my database.
pg_dump smrs
and it gives me an error
pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite
entry OID 670741 not found
check out the --oids option in the manuals (man
Joshua D. Drake wrote:
So the debugger is a feature of 8.3. It just isn't included in core.
Is it going to be included as a contrib module or something else?
It is a pgfoundry project which is part of PostgreSQL. A quick co
of /trunk shows that it is not in contrib.
Which is probably an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 12:49:37 -0600
Tony Caduto [EMAIL PROTECTED] wrote:
Here ya go:
http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375
Now you know what I am talking about :-)
I see nothing incorrect in that article.
Joshua D. Drake wrote:
Which is probably an error IMHO. If anything makes sense as part of
/contrib it's a procedural-language debugger module.
Take it up with those who didn't submit it for inclusion :)
Fair enough.
--
Richard Huxton
Archonet Ltd
---(end of
brian wrote:
I don't know what you're referring to when you say it was advertised
as a feature but it's not a part of the PG release. You can get it here:
Here ya go:
http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375
From the article:
After nine months of work,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 18:40:26 +
Richard Huxton [EMAIL PROTECTED] wrote:
Joshua D. Drake wrote:
So the debugger is a feature of 8.3. It just isn't included in core.
Is it going to be included as a contrib module or something else?
It
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 12:49:37 -0600
Tony Caduto [EMAIL PROTECTED] wrote:
Here ya go:
http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375
Now you know what I am talking about :-)
I see nothing
Richard Huxton [EMAIL PROTECTED] writes:
Joshua D. Drake wrote:
It is a pgfoundry project which is part of PostgreSQL. A quick co
of /trunk shows that it is not in contrib.
Which is probably an error IMHO. If anything makes sense as part of
/contrib it's a procedural-language debugger
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 12:49:37 -0600
Tony Caduto [EMAIL PROTECTED] wrote:
Here ya go:
http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375
I see nothing incorrect in that article.
Sincerely,
Hi,
Thanks...But I still get the same error
pg_dump --oids smrs
pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite entry OID
670741 not found
sharmila
- Original Message
From: Joao Miguel Ferreira [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Wednesday,
SHARMILA JOTHIRAJAH [EMAIL PROTECTED] writes:
pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite entry OID
670741 not found
What causes this problem?
Corrupt system tables, looks like :-( What PG version is this?
I would suggest checking to see if either of those OIDs
Richard Huxton wrote:
So you're saying the finished plpgsql debugger will be available from
www.postgresql.org ?
After nine months of work, the new features in 8.3 will be available
at www.postgreSQL.org. They will include:
* A finished PL/pgSQL debugger
There is no mention of
--- Original Message ---
From: Richard Huxton [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]
Sent: 14/11/07, 19:01:04
Subject: Re: [GENERAL] PLpgsql debugger question
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007
Since we converted to PG8, we've been experiencing segfaults when the
psql client exits. It doesn't have any real effect on things... or it
hasn't until now.
RHEL4 i686 - PostgresQL 8.2.4 (non-redhat)
-bash-3.00$ psql -n
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.
Type:
Hello,
Magnus Hagander wrote:
Willem Buitendyk wrote:
Is there any plan to port Postgresql to windows x64? I can currently
run Postgresql as 32 bit inside Vista 64 - would I see better
performance if Postgresql was running under 64 bit. My biggest concern
is memory - at 32 bit is not
SHARMILA JOTHIRAJAH [EMAIL PROTECTED] writes:
looks like the OIDs are there
Yeah, that makes it look more like the pg_class row went missing
than that there was an intentional drop of the view.
Does VACUUM VERBOSE pg_class report anything interesting?
It's possible also that reindexing
Quick question, are there any native functions in PostGreSQL 8.1.4 that will
strip HTML tags, escape chars, etc?
thanx:)
---(end of broadcast)---
TIP 6: explain analyze is your friend
Tony Caduto wrote:
brian wrote:
I don't know what you're referring to when you say it was advertised
as a feature but it's not a part of the PG release. You can get it here:
Here ya go:
http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375
From the article:
After
be used for disk cache, since that's managed
by the kernel.
//Magnus
__ NOD32 2658 (20071114) Information __
This message was checked by NOD32 antivirus system.
http://www.eset.com
---(end of broadcast)---
TIP 9: In versions below
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 15:44:39 -0500
brian [EMAIL PROTECTED] wrote:
I should have pointed out that I wasn't questioning whether or not
there was an article that stated this. I was simply pointing out that
the debugger was *not* included in the
On Nov 14, 2007 2:40 PM, madhtr [EMAIL PROTECTED] wrote:
Quick question, are there any native functions in PostGreSQL 8.1.4 that will
strip HTML tags, escape chars, etc?
I can't think of a lot of native functions, but it's sure easy enough
to roll your own with things like the regex
Dhaval Shah wrote:
I am on 8.2 production and it will be difficult to upgrade to 8.3. Is
it possible to backport the %r fix from 8.3 to 8.2?
You need to troll through the CVS archives to find that patch and try to
apply it to 8.2. This feature will not be backpatched because we don't
backpatch
Is there any plan to port Postgresql to windows x64? I can currently
run Postgresql as 32 bit inside Vista 64 - would I see better
performance if Postgresql was running under 64 bit. My biggest concern
is memory - at 32 bit is not Postgresql limited to 4GB in windows?
Thanks,
Willem
Tony Caduto [EMAIL PROTECTED] writes:
Who said anything was incorrect? It's just a bit misleading (the Info
Week Article).
Three out of the four features mentioned in your quote are not part of
core Postgres, so the author was obviously taking a very wide view of
what Postgres is. Or was just
No problem.
One more question, is there a way to find out, without going through a
test install, and from release notes etc. for 8.3 if the database
needs migration from 8.2 to 8.3 or not.
Regards
Dhaval
On Nov 14, 2007 10:44 AM, Bruce Momjian [EMAIL PROTECTED] wrote:
Dhaval Shah wrote:
I am
Hi
Is there any method of clearing the serial numbering so that ID references
can start afresh without rebuilding the database.
Of I use postgresql as part of my application I would like to use pgdump to
ensure that I have the latest version and starting the serial numbering at
#1 would be
Dhaval Shah wrote:
No problem.
One more question, is there a way to find out, without going through a
test install, and from release notes etc. for 8.3 if the database
needs migration from 8.2 to 8.3 or not.
What is migration? Application changes? The release notes pretty much
tell you
On Nov 14, 2007, at 4:23 PM, Scott Marlowe wrote:
On Nov 14, 2007 2:40 PM, madhtr [EMAIL PROTECTED] wrote:
Quick question, are there any native functions in PostGreSQL 8.1.4
that will
strip HTML tags, escape chars, etc?
I can't think of a lot of native functions, but it's sure easy enough
On Nov 14, 2007 5:17 PM, Bob Pawley [EMAIL PROTECTED] wrote:
Hi
Is there any method of clearing the serial numbering so that ID references
can start afresh without rebuilding the database.
Of I use postgresql as part of my application I would like to use pgdump to
ensure that I have the
On Nov 14, 2007 5:19 PM, Dhaval Shah [EMAIL PROTECTED] wrote:
No problem.
One more question, is there a way to find out, without going through a
test install, and from release notes etc. for 8.3 if the database
needs migration from 8.2 to 8.3 or not.
Well, you HAVE to do a dump from one to
Hi
Thanks
PG version is 8.2.3
I queried the pg_depend using this query
select * from pg_depend where objid in (670739,670741) or refobjid in
(670739,670741)
looks like the OIDs are there
classid objid objsubid refclassid refobjid refobjsubid
deptype
--
Robert Landrum [EMAIL PROTECTED] writes:
Since we converted to PG8, we've been experiencing segfaults when the
psql client exits.
Hmm. We have heard that reported on OS X because of a bug in Apple's
version of libedit, but not on any flavor of Linux. Your tests seem
to eliminate libreadline
Scott-
In JavaScript
http://www.java2s.com/Tutorial/JavaScript/0520__Regular-Expressions/StripHTM
L.htm
M--
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: A.M. [EMAIL PROTECTED]
Cc: pgsql-general pgsql-general@postgresql.org
Sent: Wednesday, November 14, 2007 6:16 PM
Tom Lane wrote:
Robert Landrum [EMAIL PROTECTED] writes:
Since we converted to PG8, we've been experiencing segfaults when the
psql client exits.
Hmm. We have heard that reported on OS X because of a bug in Apple's
version of libedit, but not on any flavor of Linux. Your tests seem
to
Martin,
2000/11/15, Martin Gainty [EMAIL PROTECTED]:
Scott-
In JavaScript
http://www.java2s.com/Tutorial/JavaScript/0520__Regular-Expressions/StripHTM
L.htm
I don't remember what the consensus was back in 2000 (your mail's
timestamp), but in 2007 it's Not A Good Idea to rely on client-side
this is a very simple html tag strip routine
I dont understand what security you had in mind ..
so I take it you're not a fan of dojo or GWT?
M--
- Original Message -
From: Ian Barwick [EMAIL PROTECTED]
Cc: Scott Marlowe [EMAIL PROTECTED]; pgsql-general
pgsql-general@postgresql.org
Sent:
hello,
i have a database in postgresql that have a column boolean, then when i
create a query in ejb like this(SELECT e.letsaythisisboolean FROM sample e),
now problem is that when i query the database in ejb, it will return all the
false value in the column boolean, and the true value will
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 19:01:04 +
Richard Huxton [EMAIL PROTECTED] wrote:
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 12:49:37 -0600
Tony Caduto [EMAIL PROTECTED] wrote:
Here ya go:
Hi all.
I'd need to implement a parametric windowed select over a table
called atable. The idea is to have a one row table to maintain
the LIMIT and the OFFSET for the selects. If I try this:
create table limoff( l int, o int );
insert into limoff values ( 10,2 );
select a.* from atable a,limoff
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 18:35:00 -0500 (EST)
Bruce Momjian [EMAIL PROTECTED] wrote:
Dhaval Shah wrote:
No problem.
One more question, is there a way to find out, without going
through a test install, and from release notes etc. for 8.3 if the
Martin Gainty escribió:
this is a very simple html tag strip routine
I dont understand what security you had in mind ..
so I take it you're not a fan of dojo or GWT?
Let's say the user disables javascript on the browser?
--
Alvaro Herrera
You are right. There are no rows in pg_class with oids 670739 and 670741. Is
that the problem? How do I fix that. Will deleting those rows from pg_depend
fix this problem?
Also I have another question. Should the pg tables (like pg_class etc)
generally be vacuumed regularly?
Thanks
sharmila
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 15:44:39 -0500
brian [EMAIL PROTECTED] wrote:
I should have pointed out that I wasn't questioning whether or not
there was an article that stated this. I was simply pointing out that
the debugger
On Tue, Nov 13, 2007 at 08:50:36PM -0800, Willem Buitendyk wrote:
Will Postgresql ever implement an ignore on error feature when bulk
loading data? Currently it is my understanding that any record that
violates a unique constraint will cause the copy from command to
halt execution instead of
On Nov 14, 2007 4:51 PM, A.M. [EMAIL PROTECTED] wrote:
On Nov 14, 2007, at 4:23 PM, Scott Marlowe wrote:
On Nov 14, 2007 2:40 PM, madhtr [EMAIL PROTECTED] wrote:
Quick question, are there any native functions in PostGreSQL 8.1.4
that will
strip HTML tags, escape chars, etc?
I can't
Is there a way to force join conditions in queries i.e. When a join is
made to a table on a particular field, another column should also be
checked?
CREATE TABLE test (info_type varchar(3), info_reference integer);
(depending on info_type, info_reference will contain key values from
different
74 matches
Mail list logo