Hi,
I just learned that bison 1.50 was released on Oct. 5th and it indeed
compiles ecpg just nicely on my machine. Could we please install this on
our main machine and merge the ecpg.big branch back into main?
Michael
--
Michael Meskes
[EMAIL PROTECTED]
Go SF 49ers! Go Rhein Fire!
Use Debian GN
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 importa
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
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 oka
??? 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
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
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 situation
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
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
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 suggestions, quite an
dramatic
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.g
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 (s
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
--
(524 rows)
On Wed, 9 Oct 2002, Tom Lane wrote:
> Laurette Cisneros <[EMAIL PROTECTED]> writes:
> > A core file was found in /base/326602604
> > and a backtrace shows:
> > (gdb) bt
> > #0 DeferredTriggerSaveEvent (relinfo=0x83335f0, event=0, oldtup=0x0,
> > newtup=0x8348150) at trigger.c:2056
>
> Hm.
On Wed, 2002-10-09 at 14:04, Justin Clift wrote:
> Rod Taylor wrote:
> >
>
> > 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
>decl
Rod Taylor wrote:
>
> 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
submi
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
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
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 the
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 D
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
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
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
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.
--
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 usi
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 de
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
Laurette Cisneros <[EMAIL PROTECTED]> writes:
> A core file was found in /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 < ntriggers
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]; pgsql-
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/fix
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, cha
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
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,
> cha
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,
> cha
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/fixch
36 matches
Mail list logo
