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 tabl
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
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 instea
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
> >
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
--
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 Herrerahttp://www.advogato.org/
-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.
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,lim
-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:
> >> Her
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 no
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"
Sent: Wednesday, Novembe
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
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 elim
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"
Sent: Wednesday, November 14, 2007 6:16 PM
Subject: Re: [GENERAL]
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
-- -
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 on
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 hav
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 yo
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
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:
> >
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 libreadli
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 enoug
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
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
--
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
backpa
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 function
-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 r
nd your RAM will still 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)--
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 n
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
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
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 Postg
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: \
> --- 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
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 an
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,
Jo
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 debugg
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 incor
-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 a
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 broa
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?
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 err
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
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
_
-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
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 referri
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
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?
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 wr
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
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
>
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 f
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,
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 ("defra
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. M
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
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.
"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 behavio
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 n
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 w
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 null
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
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 stateme
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. My
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:
>
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: Wal
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
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) indexes
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 th
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:
http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulat
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 th
74 matches
Mail list logo
