go wrote:
Hi,
After about 2 month of greate work, my database (running under
PG 8.01 on Win2000) very slow.Reindexing all tables, Vacuum Full,Freeze
and Analyze didn't help(i did it from pg_admin III).
But after dropdb and pg_restore it become fast again.
(The same database -both very small
Steve - DND napisał(a):
Simple question I'm sure, but how can I get the transaction ID that a query
is currently running in? I can find all kinds of documentation talking about
transaction ids, but nothing about how to get the current one.
You can compile attached function - this will return cu
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> "Együd Csaba" <[EMAIL PROTECTED]> writes
>> I know the VALID UNTIL clause of CREATE USER command, but it is about the
>> password only.
>> I think something similar but regarding the whole user account.
> It is not about password only. Once current dat
"Együd Csaba" <[EMAIL PROTECTED]> writes
>
> I'm wonder how I can disable a user (without droping of course). Is there
a
> way to set an expiration date to prevent logins after that date?
>
> I know the VALID UNTIL clause of CREATE USER command, but it is about the
> password only.
> I think somet
Hi,
After about 2 month of greate work, my database (running under
PG 8.01 on Win2000) very slow.Reindexing all tables, Vacuum Full,Freeze
and Analyze didn't help(i did it from pg_admin III).
But after dropdb and pg_restore it become fast again.
(The same database -both very small , about 50
""jeremy `"" <[EMAIL PROTECTED]> writes
> get some screenshots, and i got this message:
> "Internal account lookup failure: No mappiong between account names and
> security IDs was done."
>
This was recently asked. Search "Internal account lookup failure" in list.
Regards,
Qingqing
-
Pailloncy Jean-Gerard <[EMAIL PROTECTED]> writes:
> I have a drive with a bad zone inside the file pgsql/pg_xlog/
> 005D00A1.
> How may I zap the bad pgxlog file ?
pg_resetxlog. Heed the warnings that your database is not guaranteed
good after you do this. I'd recommend a dump and relo
"Tom Lane" <[EMAIL PROTECTED]> writes
>
> Evidently that's not often enough. Or it could be that your
> FSM settings aren't large enough?
>
Setting various proper parameters of FSM is onerous for maintainence. Is
there any plan to make FSM buffer-file-able, just like what clog does now?
Regards
> On Jun 11, 2005, at 11:24 PM, Tatsuo Ishii wrote:
>
> > Thank you for interested in PostgreSQL CE. There is a sample
> > examination problems page:
> >
> > http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
> >
> > You could find some idea what the exam looks like.
> >
>
> question
>
> Well, you can take the xmin of a row and look for other rows with the
> same xmin, either in the same table or in different tables.
Do these columns appear inside the NEW/OLD variables for triggers, or from
some other method within a trigger?
Steve
---(end of broadc
Steve - DND wrote:
> > > Let's pretend I don't know how to do that. :) Do you have a
> > link to a page
> > > in the manual that describes this process, or can you give me a quick
> > > runthrough of what you're talking about?
> >
> > Every row has an invisible xmin/xmax columns that represent the
> > Let's pretend I don't know how to do that. :) Do you have a
> link to a page
> > in the manual that describes this process, or can you give me a quick
> > runthrough of what you're talking about?
>
> Every row has an invisible xmin/xmax columns that represent the xid of
> the row inserted, upda
Steve - DND wrote:
> > Steve - DND wrote:
> > > Simple question I'm sure, but how can I get the transaction ID
> > that a query
> > > is currently running in? I can find all kinds of documentation
> > talking about
> > > transaction ids, but nothing about how to get the current one.
> >
> > You can
> Steve - DND wrote:
> > Simple question I'm sure, but how can I get the transaction ID
> that a query
> > is currently running in? I can find all kinds of documentation
> talking about
> > transaction ids, but nothing about how to get the current one.
>
> You can look at the xmin of a tuple you cr
Steve - DND wrote:
> Simple question I'm sure, but how can I get the transaction ID that a query
> is currently running in? I can find all kinds of documentation talking about
> transaction ids, but nothing about how to get the current one.
You can look at the xmin of a tuple you created or an xma
Simple question I'm sure, but how can I get the transaction ID that a query
is currently running in? I can find all kinds of documentation talking about
transaction ids, but nothing about how to get the current one.
Thanks,
Steve
---(end of broadcast)
On Jun 14, 2005, at 6:17 PM, Zlatko Matić wrote:
When I create some user group and set permissions and then dump
(backup) database and install on some other computer, what will happen
with groups and permissions? Should they exist on other computers too
?
I don't understand whether permission
Hi,
I have a drive with a bad zone inside the file pgsql/pg_xlog/
005D00A1.
After trying to start few time pg, I get the follwing message in log:
2005-06-14 23:35:44 LOG: database system shutdown was interrupted at
2005-06-14 12:20:42 CEST
2005-06-14 23:35:44 LOG: checkpoint recor
Does anyone have some experience with users
management from MS Access front-end ?
When I create some user group and set permissions
and then dump (backup) database and install on some other computer, what will
happen with groups and permissions? Should they exist on other computers too
?
I don't understand whether permissions to groups
are something that is integrated in
On Tue, Jun 14, 2005 at 15:54:50 -0500,
Peter Fein <[EMAIL PROTECTED]> wrote:
>
> I'm unclear why I'd need to store the hash in a column. I suppose I
> could have the hash column populated by a trigger on inserts, but this
> seems to get me the same functionality & is less obvious.
>
> For the
Bruno Wolff III wrote:
> On Tue, Jun 14, 2005 at 08:33:34 -0500,
> Peter Fein <[EMAIL PROTECTED]> wrote:
>
>>Knowing the specifics of the data I'm putting in sometext, a halfway
>>decent hash function would make collisions so rare as to make the chance
>>insignificant (and collisions wouldn't br
Thanks! Well, it is time to upgrade my PostgreSQL
7.4.2. :)
Sophie
-Original Message-
From: "Igor Katrayev"
To:
Subject: Re: Set Membership operator -- test group
membership
Date: Tue, 14 Jun 2005 11:27:30 -0800
--
On Tue, Jun 14, 2005 at 08:33:34 -0500,
Peter Fein <[EMAIL PROTECTED]> wrote:
>
> Knowing the specifics of the data I'm putting in sometext, a halfway
> decent hash function would make collisions so rare as to make the chance
> insignificant (and collisions wouldn't break anything anyway). Is th
Hi,
I'm wonder how I can disable a user (without droping of course). Is there a
way to set an expiration date to prevent logins after that date?
I know the VALID UNTIL clause of CREATE USER command, but it is about the
password only.
I think something similar but regarding the whole user account.
Sophie,
The sql like this:
select * from tbl1 where (a, b) in ((1, 20), (2, 30), (3, 50));
works very well in PostgreSQL 8,
Sincerely,
Igor Katrayev, Data Systems Manager
North Pacific Research Board
1007 West Third Avenue, Suite 100
Anchorage, AK 99501
Phone: 907-644-6700
Fax: 907-644-6780
martin wrote:
> i try to find a new postgre rpm package for suse 9.2 but i didnt find some.
ftp://ftp.suse.com/pub/projects/postgresql/
select postgresql version first and then suse version...
miso
---(end of broadcast)---
TIP 9: the planner will i
Say I have a table tbl1 with two columns:
tbl1(a integer, b integer, c integer)
I want to select the rows in which a and b are members
of a list of integer pairs. The SQL in my mind is
something like:
select * from tbl1 where (a, b) in ((1, 20), (2,
30), (3, 50));
I know the SQL above does n
Dear all,
I am running Postgresql on windows xp. (not cygwin)
I am no longer able to start the server.
The pgadmin log file says:
ERROR: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Since then I am no lon
On Jun 11, 2005, at 11:24 PM, Tatsuo Ishii wrote:
Thank you for interested in PostgreSQL CE. There is a sample
examination problems page:
http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
You could find some idea what the exam looks like.
question 10 answer depends on if the s
I can not get work ilike, ~*, ~~* with not ascii chars, but upper,
lower, order by - work good.
db encoding is UNICODE.
test=> SELECT 'Тест' ~~* 'тест';
?column?
--
f
test=> SELECT 'Тест'' ~* 'тест';
?column?
--
f
test=> SELECT 'Тест'' ILIKE 'тест';
?column?
--
f
On Jun 13, 2005, at 11:42 AM, Chris Browne wrote:
And there is also the point: "What good is it to be using an 'open
source' database if you aren't competent to use that source?"
so the certification should include proficiency in C to be able to
find answers in source code? h
Vi
Thanks for the help but it was an SELinux policy problem.
I turned it off for now. I just do not have the time to learn SELinux
right now and my server is located behind a fire wall, contains not
sensitive data, and is just a test box for now.
Tom Lane wrote:
David Siebert <[EMAIL PROTECTED]>
--- Greg Stark <[EMAIL PROTECTED]> wrote:
>
> Note that MD5 is slow and CPU-intensive. By design.
>
> If you want a quick way to find matching records then you might find
> something
> like CRC to be more useful. With MD5 it's supposed to be hard for
> someone to
> come up with inputs that hash t
On 14 Jun 2005, at 14:33, Peter Fein wrote:
Alex Stapleton wrote:
On 13 Jun 2005, at 23:49, Peter Fein wrote:
Hi-
I wanted to use a partially unique index (dependent on a flag) on
a TEXT
column, but the index row size was too big for btrees. See the
thread
"index row size 2728 exc
Alex Stapleton wrote:
>
> On 13 Jun 2005, at 23:49, Peter Fein wrote:
>
>
>> Hi-
>>
>> I wanted to use a partially unique index (dependent on a flag) on a TEXT
>> column, but the index row size was too big for btrees. See the thread
>> "index row size 2728 exceeds btree maximum, 2713" from the
Thanx to Richard Huxton and Csaba.
I will upgrade PostgreSQL up to 8.0 and use:
> 2. Catch the error on the insert and try the update again. This
> requires version 8.0 or higher.
Best regards
---(end of broadcast)---
TIP 8: explain analyze is yo
Hi,
I tried to "create or replace" a function via PGAdmin3.
The first line immediatelly after the begin keyword was a comment line
(--X). The Function did not create at all - with no error messages or
similar, just did nothing.
Removing the comment from the first line the function was create
Dear Tom, Bruno,
thank you for your reply. Since these parameters
(max_fsm_pages,max_fsm_relations) can be set at server startup, I have to
wait for at least the evening - and plus a few days letting the system going
wrong or better, staying good. :)
I'm going to inform you about the results.
SUSE's dvd includes PostgreSQL 7.4
and i think it's also avalable via ftp from various mirrors.
Search at Google, or at Novell site.
But if you search a newer version, i can't help you.
On Mon, 13 Jun 2005, martin wrote:
> hi all
> i try to find a new postgre rpm package for suse 9.2 but i d
On 13 Jun 2005, at 23:49, Peter Fein wrote:
Hi-
I wanted to use a partially unique index (dependent on a flag) on a
TEXT
column, but the index row size was too big for btrees. See the thread
"index row size 2728 exceeds btree maximum, 2713" from the
beginning of
this month for someone w
Am Dienstag, den 14.06.2005, 02:40 -0400 schrieb Greg Stark:
> Shelby Cain <[EMAIL PROTECTED]> writes:
>
> > > My question is: is the builtin MD5 appropriate for this use or should I be
> > > using a function from pl/something? Figures on collision rates would be
> > > nice as well - the typical c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 13 Jun 2005, stig erikson wrote:
i just compiled a few versions of postgresql rpms for redhat 8.0 based on the
official srpms for redhat 9.
Thanks for the effort.
anyhow, if somebody is interested i have put the compiled files her
If this is a windows installation, I had a similar problem. My problems
was down to the user account created for the postgres service. You will
need to manually delete this user (Select User Accounts from the control
panel and remove the postgres account). This seems to be a minor problem
of th
Shelby Cain <[EMAIL PROTECTED]> writes:
> > My question is: is the builtin MD5 appropriate for this use or should I be
> > using a function from pl/something? Figures on collision rates would be
> > nice as well - the typical chunk of text is probably 1k-8k.
Note that MD5 is slow and CPU-intensiv
45 matches
Mail list logo
