On Mon, 07 Oct 2002 15:07:29 +0530, Shridhar Daithankar
[EMAIL PROTECTED] wrote:
Only worry is database size. Postgresql is 111GB v/s 87 GB for mysql.
Shridhar,
here is an implementation of a set of user types: char3, char4,
char10. Put the attached files into a new directory contrib/fixchar,
On 9 Oct 2002 at 10:00, Manfred Koizar wrote:
On Mon, 07 Oct 2002 15:07:29 +0530, Shridhar Daithankar
[EMAIL PROTECTED] wrote:
Only worry is database size. Postgresql is 111GB v/s 87 GB for mysql.
Shridhar,
here is an implementation of a set of user types: char3, char4,
char10. Put
Has this fix been applied to the cvs yet, I am still getting the same
error
On Tue, 1 Oct 2002, Zeugswetter Andreas SB SD wrote:
Date: Tue, 1 Oct 2002 10:23:13 +0200
From: Zeugswetter Andreas SB SD [EMAIL PROTECTED]
To: Peter Eisentraut [EMAIL PROTECTED]
Cc: PostgreSQL Development [EMAIL
Manfred Koizar [EMAIL PROTECTED] writes:
here is an implementation of a set of user types: char3, char4,
char10.
Coupla quick comments on these:
CREATE FUNCTION charNN_lt(charNN, charNN)
RETURNS boolean
AS '$libdir/fixchar'
LANGUAGE 'c';
bool
charNN_lt(char *a, char *b)
{
On 9 Oct 2002 at 9:32, Tom Lane wrote:
Manfred Koizar [EMAIL PROTECTED] writes:
here is an implementation of a set of user types: char3, char4,
char10.
Coupla quick comments on these:
CREATE FUNCTION charNN_lt(charNN, charNN)
RETURNS boolean
AS '$libdir/fixchar'
I'd say yes replication can solve lot of issues, but is there a way to do replication
in postgres(active-active or active-passive)
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 8:27 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED];
Laurette Cisneros [EMAIL PROTECTED] writes:
A core file was found in datadir/base/326602604
and a backtrace shows:
(gdb) bt
#0 DeferredTriggerSaveEvent (relinfo=0x83335f0, event=0, oldtup=0x0,
newtup=0x8348150) at trigger.c:2056
Hm. Line 2056 is this:
for (i = 0; i
I've been working on kludging a working
for update barrier style lock (*) for reads
using HeapTupleSatisfiesDirty to test
accessibility to make the foreign keys
work better. I'm fairly close to getting
a testable kludge for the fk/noaction cases
for people to check real sequences against
(since
Just think, that maybe a postgresql php coder (or admin if you like it),
email me, and give me *.php sources. Seems like most of his scripts written
in a very insecure and lame style.
Best regards.
This letter has been
I wasn't particularly clear (sorry, wrote the message
1/2 right before bed, 1/2 right after getting up) so
I'm going to followup with details and hope that
I'm more awake.
A little background just in case there are people
that haven't looked.
Right now, foreign key checks always default to
On Wed, 9 Oct 2002, Sir Mordred The Traitor wrote:
Just think, that maybe a postgresql php coder (or admin if you like it),
email me, and give me *.php sources. Seems like most of his scripts written
in a very insecure and lame style.
Probably no worse than your writing style.
Vince.
--
Sure not. I even don't argue that.
But i dont like that a postgresql.org could be just that easily owned.
On Wed, 9 Oct 2002, Sir Mordred The Traitor wrote:
Just think, that maybe a postgresql php coder (or admin if you like it),
email me, and give me *.php sources. Seems like most of his
Still in queue. I will apply today.
---
Samuel A Horwitz wrote:
Has this fix been applied to the cvs yet, I am still getting the same
error
On Tue, 1 Oct 2002, Zeugswetter Andreas SB SD wrote:
Date: Tue, 1 Oct
Patch applied. Thanks.
---
Zeugswetter Andreas SB SD wrote:
and mb conversions (pg_ascii2mic and pg_mic2ascii not
found in the postmaster and not included from elsewhere)
shared libs on AIX need to be
Hi Sandeep. What you were calling Hot Backup is really called Point in
Time Recovery (PITR). Hot Backup means making a complete backup of the
database while it is running, something Postgresql has supported for a
very long time.
On Mon, 7 Oct 2002, Sandeep Chadha wrote:
Hello to all the
I'd have agree on most of what you said. I still think most crashes occur due to data
corruption which can only be recovered by using a good backup.
Anyways my problem is I have a 5 gig database. I run a cron job every hour which runs
pg_dump which takes over 30 minutes to run and degrades
On Wed, 2002-10-09 at 12:46, Sandeep Chadha wrote:
I'd have agree on most of what you said. I still think most crashes occur due to
data corruption which can only be recovered by using a good backup.
Anyways my problem is I have a 5 gig database. I run a cron job every hour which
runs
Now that we have relaxed the restriction on functions/languages, should
we make sure we have GRANTS for all of them, including /contrib, or
remove them all.
Not knowing what we will do for 7.4, it seems we should make sure they
all have GRANTs.
Comments?
--
Bruce Momjian
Rod Taylor wrote:
snip
Oh, if thats your problem then use asynchronous replication instead.
For specific info, the contrib/rserv package does master-slave
asynchronous replication as Rod is suggesting. From memory it was
having troubles working with PostgreSQL 7.2.x, but someone recently
On Wed, 2002-10-09 at 14:04, Justin Clift wrote:
Rod Taylor wrote:
snip
Oh, if thats your problem then use asynchronous replication instead.
For specific info, the contrib/rserv package does master-slave
Thanks. I was having a heck of a time remembering what it was called or
even
On Wed, 09 Oct 2002 09:32:50 -0400, Tom Lane [EMAIL PROTECTED]
wrote:
Coupla quick comments on these:
My first attempt on user types; thanks for the tips.
These functions are dangerous as written, because they will crash on
null inputs. I'd suggest marking them strict in the function
On Wed, 9 Oct 2002, Tom Lane wrote:
Laurette Cisneros [EMAIL PROTECTED] writes:
A core file was found in datadir/base/326602604
and a backtrace shows:
(gdb) bt
#0 DeferredTriggerSaveEvent (relinfo=0x83335f0, event=0, oldtup=0x0,
newtup=0x8348150) at trigger.c:2056
Hm. Line
Hello, i've got this query that's really slow...
Figure this:
testdb= select now() ; select gid from bs where gid not in ( select x
from z2test ); select now();
now
---
2002-10-09 22:37:21.234627+02
(1 row)
gid
--
lotsa rows
(524 rows)
On Wed, 9 Oct 2002, Magnus Naeslund(f) wrote:
Hello, i've got this query that's really slow...
Figure this:
testdb= select now() ; select gid from bs where gid not in ( select x
from z2test ); select now();
Per FAQ suggestion, try something like
select gid from bs where not exists (select
Magnus Naeslund(f) wrote:
Hello, i've got this query that's really slow...
Figure this:
testdb= select now() ; select gid from bs where gid not in ( select x
from z2test ); select now();
IN (subselect) is notoriously slow (in fact it is an FAQ). Can you rewrite
this as:
select b.gid from
Magnus Naeslund(f) wrote:
Joe Conway [EMAIL PROTECTED] wrote:
IN (subselect) is notoriously slow (in fact it is an FAQ). Can you
rewrite this as:
...
Stephan Szabo [EMAIL PROTECTED] wrote:
Per FAQ suggestion, try something like
...
Thanks alot, below are the results on your
Bruce Momjian [EMAIL PROTECTED] wrote:
We already have a TODO item:
* Allow Subplans to use efficient joins(hash, merge) with upper
variable
Cool.
One thing to note here is that the JOIN query that Joe suggested is both
faster than the subselect thing (no suprise) but also don't care if
Magnus Naeslund(f) wrote:
One thing to note here is that the JOIN query that Joe suggested is both
faster than the subselect thing (no suprise) but also don't care if
z2test has an index on it or not.
It's worth noting though that JOIN is not always the fastest method. I've
found situations
dear hacker,
hello.
I want to know how to build a function of my own which returns rows of resultset, not
just a row.
Can anybody help me?
Thank you in advance.
Jinqiang Han
---(end of broadcast)---
TIP 2: you can get off all lists at once
??? wrote:
dear hacker, hello. I want to know how to build a function of my own which
returns rows of resultset, not just a row.
Can anybody help me? Thank you in advance.
It is possible, but not very user friendly if you are using PostgreSQL 7.2.x
or before. See contrib/dblink/dblink.c
Bruce Momjian [EMAIL PROTECTED] writes:
Now that we have relaxed the restriction on functions/languages, should
we make sure we have GRANTS for all of them, including /contrib, or
remove them all.
I feel no strong need to do anything. The contrib entries that have
explicit GRANTs are okay
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Now that we have relaxed the restriction on functions/languages, should
we make sure we have GRANTS for all of them, including /contrib, or
remove them all.
I feel no strong need to do anything. The contrib entries that have
Bruce Momjian [EMAIL PROTECTED] writes:
I was looking for consistency so we could have things ready if we
tighten up in 7.4. I believe someone volunteered to fix them all so I
figured we should do that.
Someone did volunteer, but I haven't seen results. My point is that
it's not important
33 matches
Mail list logo