On 06.02.2007 21:39, Worky Workerson wrote:
Is it possible to configure the tsearch2 parser? I'd like a very dumb
parser that splits on everything that is not [a-zA-Z0-9.]. The
default parser seems to work well on my dataset except for the '/'
character ... it doesn't split mike/john into two l
.
TIA.
Ed
***
* PostgreSQL File/Block Formatted Dump Utility - Version 3.0
*
* File: 16408.backup-20070207-01:11:58PST
* Options used: -y -f -R 110 110
*
* Dump created on: Wed Feb 7 01:
[EMAIL PROTECTED] wrote:
I am wondering what the limit is on the number of joins in a View or a
Select.
Background: I have many tables with similar flags such as Active,
Inactive, High, Medium, Low. I am storing the flags in a flag table and
then putting an int4 foreign key to the flag in the
On Wed, Feb 07, 2007 at 03:00:20AM -0700, Ed L. wrote:
> How do I fix this 7.4.6 issue short of initdb?
>
> invalid page header in block 110 of relation "pg_statistic"
Take a copy of the file, then you should be able to truncate it.
There's also the zero_damaged_pages option, though I don't
"Ed L." <[EMAIL PROTECTED]> writes:
> How do I fix this 7.4.6 issue short of initdb?
> invalid page header in block 110 of relation "pg_statistic"
> I looked at the block via pg_filedump (included below), and it
> does not appear to me to be corrupted, so not sure what I would
> zero out, i
>Richard Huxton wrote on 02/07/2007 01:33:05 AM:
> [EMAIL PROTECTED] wrote:
> > I am wondering what the limit is on the number of joins in a View or a
> > Select.
> >
> > Background: I have many tables with similar flags such as Active,
> > Inactive, High, Medium, Low. I am storing the flags i
Paul Lambert wrote:
Are there any companies in the great land of Australia that offer
Postgres training courses?
I see a number listed for around the US on the postgresql.org website
- just curious if anything similar goes on down under.
Cheers,
P.
I believe that Fujitsu offers PostgreSQL t
Paul Lambert wrote:
Are there any companies in the great land of Australia that offer
Postgres training courses?
I see a number listed for around the US on the postgresql.org website
- just curious if anything similar goes on down under.
Cheers,
P.
Sorry, that apparently got sent out premat
Hi there, first post. I would like to share a solution for Windows
users having problems installing PostgreSQL 8.2.2. I couldn't find
anything in the docs and FAQ.
My installation routine went fine until it tried to start the postgres
service. This failed and there was no hint of why. So went to
>Richard Huxton wrote on 02/07/2007 01:33:05 AM:
> [EMAIL PROTECTED] wrote:
> > I am wondering what the limit is on the number of joins in a View or a
> > Select.
> >
> > Background: I have many tables with similar flags such as Active,
> > Inactive, High, Medium, Low. I am storing the flags
On Tue, 06 Feb 2007 21:28:49 +0100, Tomas Vondra <[EMAIL PROTECTED]> wrote:
>
> We're using sequence to generate the sessions(id) value, but that should
> not be a problem - with the structure / rules everything works fine (the
> current value in sessions_id_seq is about 870 so the values ar
[EMAIL PROTECTED] wrote:
Richard,
I have a few questions on the domain.
1) How do I add a domain to an existing table? Can I add it to an existing
column or do I need to make a new column with the domain and copy the
existing data into it?
Try ALTER TABLE ... ALTER COLUMN col TYPE ...
http
> It's likely to be a problem because of multiple evaluations of volatile
> expressions
> in the rule rewrite systemshort example:
>
> CREATE TABLE sessions(id SERIAL PRIMARY KEY, value TEXT);^
> CREATE TABLE sessions_100(CHECK(id BETWEEN 1 AND 100), PRIMARY KEY(id))
> INHERITS(sessions);
Paul Lambert wrote:
> Are there any companies in the great land of Australia that offer
> Postgres training courses?
I would be happy to fly to Australia and teach a class :)
Sincerely,
Joshua D. Drake
>
> I see a number listed for around the US on the postgresql.org website -
> just curious i
Hi,
Our database filled up and now I'm getting this error on one of the
tables. Is there any way to recover from this? Please let me know if
more information is needed.
pg_version version
---
Also, all files in pg_clog are sequential with the last file being 0135.
Michael Guerin wrote:
Hi,
Our database filled up and now I'm getting this error on one of the
tables. Is there any way to recover from this? Please let me know if
more information is needed.
pg_version
On Wed, Feb 07, 2007 at 08:09:57PM +0100, Tomas Vondra wrote:
> But I don't understand why the nextval('sessions_id_seq') is evaluated
> multiple times? Even when I do
RULE expand like macros, so every expression passed in is simply copied
to each place, leading to multiple evaluations.
If you've
[ if this belongs on another list, such as -advocacy, i apologize. ]
dear sir or madam ---
permit me to submit a plan which, imho,
will transform the recent lemon into lemonade.
we all know the famous motto,
"there is no such thing as a total failure.
it can always serve as a negative exa
>> But I don't understand why the nextval('sessions_id_seq') is evaluated
>> multiple times? Even when I do
>
> RULE expand like macros, so every expression passed in is simply copied
> to each place, leading to multiple evaluations.
>
> If you've played with the C preprocessor: that has the same
> I wouldn't call myself a novice, but yes - this surprised me a little.
> Now it seems so natural ... I think there should be a clear explanation
> / example in the docs about this - I've read the documentation on RULE
> sytem several times and as far as I remember.
... and as far as I remember t
The 8.2.2 source code is coming back in 1-2 days once everyone knows
they should upgrade to 8.2.3.
---
rob_spellberg wrote:
> [ if this belongs on another list, such as -advocacy, i apologize. ]
>
> dear sir or madam ---
>
On Wednesday February 7 2007 9:01 am, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > How do I fix this 7.4.6 issue short of initdb?
> > invalid page header in block 110 of relation "pg_statistic"
> > I looked at the block via pg_filedump (included below), and
> > it does not appear t
this is good news; i thank you.
any chance for 8.1.7?
rob
Bruce Momjian wrote:
The 8.2.2 source code is coming back in 1-2 days once everyone knows
they should upgrade to 8.2.3.
---
rob_spellberg wrote:
[ snip ]
--
rob_spellberg wrote:
> this is good news; i thank you.
>
> any chance for 8.1.7?
Same, all are coming back.
---
>
> rob
>
>
>
> Bruce Momjian wrote:
> > The 8.2.2 source code is coming back in 1-2 days once everyone kn
Michael Guerin <[EMAIL PROTECTED]> writes:
> Also, all files in pg_clog are sequential with the last file being 0135.
Hmm, that makes it sound like a plain old data-corruption problem, ie,
trashed xmin or xmax in some tuple header. Can you do a "select
count(*)" from this table without getting th
wonderful!
thank you very much.
have a great day, one and all.
rob
Bruce Momjian wrote:
rob_spellberg wrote:
this is good news; i thank you.
any chance for 8.1.7?
Same, all are coming back.
---
rob
Bruce M
Hmm, that makes it sound like a plain old data-corruption problem, ie,
trashed xmin or xmax in some tuple header. Can you do a "select
count(*)" from this table without getting the error?
no, select count(*) fails around 25 millions rows.
PostgreSQL 8.1RC1 on x86_64-unknown-linux-gnu, com
Is there any buil-in function to return the lesser of two numbers?
i.e. lesser(100,125) would return 100.
Do I need to roll my own?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an inde
FYI, getting back to you, both /contrib/userlock and /contrib/dbmirror
were removed from the 8.2 source tree. They have been moved to
pgfoundry.
---
Charles Comiskey wrote:
> PostgreSQL 8.1.4 appears to have 2 GPL licensed
jws wrote:
Is there any buil-in function to return the lesser of two numbers?
i.e. lesser(100,125) would return 100.
Do I need to roll my own?
Which is it--greatest or least?
No matter, TFM has something to say about it:
http://www.postgresql.org/docs/current/static/functions-math.html#FUNC
I don't see greatest or least anywhere on that page... But they ARE
here:
http://www.postgresql.org/docs/8.2/interactive/functions-conditional.htm
l#AEN13140
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of brian
Sent: Wednesday, February 07, 2007 10:07
brian wrote:
> jws wrote:
> > Is there any buil-in function to return the lesser of two numbers?
> >
> > i.e. lesser(100,125) would return 100.
> >
> > Do I need to roll my own?
> >
>
> Which is it--greatest or least?
>
> No matter, TFM has something to say about it:
> http://www.postgresql.or
Hello,
I would like to ask for a hint for a good SQL textbook. I don't want just a
reference manual but real textbook with a theoretical background so I could
to design my databases following the general rules as normal forms and so
on.
I mean something on the net of course.
Thank you
Jan Mura
> Uh, what function in that table helps him --- I don't see it.
I found GREATEST() and LEAST(), which in combination with COALESCE()
returns exactly what I needed. I missed it because I was looking for
numerical functions. Like so many other things in life, in retrospect,
it's completely obvious.
Having developed a complex query, I want to wrap it up as a function
so that it can take a parameter and return a set of rows. This query
is currently written as multiple sql statements that create a few
interstitial temp tables that are then joined. If I put this into a
function definition, do tho
>>Hi all,
>>
>>As I am inserting 100million rows daily into partitioned tables (daily wise),
>>it is getting slower.
>What is - the inserts? By how much? What tables? What indexes? How are you
>inserting these rows?
I take my words back as 100million rows. The insert of 20million rows
every
On Wed, Feb 07, 2007 at 20:40:09 -0800,
jws <[EMAIL PROTECTED]> wrote:
> Having developed a complex query, I want to wrap it up as a function
> so that it can take a parameter and return a set of rows. This query
> is currently written as multiple sql statements that create a few
> interstitial t
Michael Guerin <[EMAIL PROTECTED]> writes:
>> Hmm, that makes it sound like a plain old data-corruption problem, ie,
>> trashed xmin or xmax in some tuple header. Can you do a "select
>> count(*)" from this table without getting the error?
>>
> no, select count(*) fails around 25 millions rows.
g f wrote:
Shane,
thanks for the advice.
I created the user: net user postgres /add
I still get the error. When I try to start the postgres service in
windows-->services I get a "The service did not start due to logon failure"
As long as the postgres user account is not in the admin group check
Something like this will help you:
execute immediate 'create temporary table test (a number) on commit drop';
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/8/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Wed, Feb 07, 2007 at 20:40:09 -0800,
jws <[EMAIL PROTECTED]> wrote:
> Havi
Adam Rich wrote:
I don't see greatest or least anywhere on that page... But they ARE
here:
http://www.postgresql.org/docs/8.2/interactive/functions-conditional.htm
l#AEN13140
Yes--my bad. Wrong page.
---(end of broadcast)---
TIP 4: Have you se
I have this query which essentially returns records that exist in one
table (studentclass) and not another (effortandattainment) to check when
teachers have entered their student grades.
select
distinct(studentclass.studentclassid),classes.subject,studentclass.studentid as
classstudent,classes.te
On 07.02.2007 17:59, [EMAIL PROTECTED] wrote:
Is there any form of manual for DBI-link out there?
Any link is greatly appreciated!
I think all available documentation comes with it in various README
files. Do you have a specific problem?
--
Regards,
Hannes Dorbath
43 matches
Mail list logo
