At 03:59 PM 8/19/2003 +0200, Bo Lorentsen wrote:
On Tue, 2003-08-19 at 15:47, Shridhar Daithankar wrote:
> Or have bugzilla setup somewhere. That way the tracking will be hell lot
> visible to outside world..
I agree on this, as it seems messy from outside not to be able to get an
overview of bot
On Tue, Aug 19, 2003 at 01:40:31PM +0530, Shridhar Daithankar wrote:
> On 19 Aug 2003 at 10:01, Francois Suter wrote:
>
> > I am pleased to announce the start of a PostgreSQL general mailing list
> > in French. Its name is pgsql-fr-generale. I hope many of you will join
> > it so that we can mak
I want to be able to generate SQL statements that will go through a list of
data, effectively row by row, enquire on the database if this exists in the
selected table- If it exists, then the colums must be UPDATED, if not, they
must be INSERTED.
Logically then, I would like to SELECT * FROM
WHERE
Hi,
On Tue, 19 Aug 2003, Lincoln Yeoh wrote:
> AFAIK bugzilla requires mysql (for now).
>
> I've recently installed it and if it can be easily made to work with
> postgresql I'd like to know.
https://bugzilla.redhat.com/bugzilla/index.cgi
Bugzilla News
===
January 1st, 2003
Current Red Hat v
On Tue, 2003-08-19 at 16:03, Tom Lane wrote:
> It's still bolted on. The entire concept that "transactional integrity
> is optional" is ludicrous, IMHO. "Integrity" and "optional" are
> contradictory.
Good point. Also the problem of MyISAM and InnoDB RI :-)
> One thing you should ask about MySQ
Before anyone can make an rpm for you they will need some more information.
What type of CPU are you using ? {SPARC, ALPHA, Pentium ...}
What kernel, and libraries are you using?
Good luck
Guy
Vilson farias wrote:
Hi again
I'm still using RedHat 6.2. I would be happy if I could find some Pos
Hi Philip,
Pg is more ansi compliant than most (GoodThing (TM)). You can use the 'when'
conditional but not to do what you need. If I understand you correclty you
should be able to acheive the same result using two seperate queries and the
(NOT) EXISTS or (NOT) IN clause. Failing that have a
On Tue, 2003-08-19 at 16:20, Lincoln Yeoh wrote:
> Install an application that can use both DBs. Muck around with it. If you
> can't tell the difference, then I'd say go with postgresql - transactions
> isn't bolted on, quite a number of other design wins too. If you can tell
> the difference a
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Yeah, but there's not too much you can do about it. You can check what
> goes on in the spanish list at
> http://tlali.iztacala.unam.mx/mailman/listinfo/pgsql-ayuda
> There's a respectable amount of traffic, and I don't think there's
> anyone who would
> > I am pleased to announce the start of a PostgreSQL general mailing
list
> > in French. Its name is pgsql-fr-generale. I hope many of you will
join
> > it so that we can make it an interesting place.
I'd be glad to join, but I couldn't find where or how to subscribe...
Erwan
---
"Philip Boonzaaier" <[EMAIL PROTECTED]> writes:
> I want to be able to generate SQL statements that will go through a list of
> data, effectively row by row, enquire on the database if this exists in the
> selected table- If it exists, then the colums must be UPDATED, if not, they
> must be INSERT
Doug McNaught <[EMAIL PROTECTED]> writes:
> "Philip Boonzaaier" <[EMAIL PROTECTED]> writes:
>
> > This message is privileged and confidential and intended for the addressee only.
> > If you are not the intended recipient you may not disclose, copy or
> > in any way use or publish the content her
On Tuesday 19 August 2003 20:54, Doug McNaught wrote:
> Doug McNaught <[EMAIL PROTECTED]> writes:
> > I have companies that force crap like this on mailing list postings...
>
> hate
>
> Arrghh.
Not to troll, but another mailing list I am on, anybody posting such
messages/footers is poli
> "BL" == Bo Lorentsen <[EMAIL PROTECTED]> writes:
BL> Hi ...
BL> I'm trying to convince my boss to use posgresql (I need RI, transactions
BL> and views), but he keeps comparing the project to mysql. Until now, I
BL> found the answers to he's questions on the www.postgresql.org page, but
BL> n
I'd be glad to join, but I couldn't find where or how to subscribe...
It's not yet posted on the web site, but you can subscribe by sending a
mail to [EMAIL PROTECTED], leave the subject line blank and put
in the body "SUBSCRIBE pgsql-fr-generale".
Bye
---
Francois
Home page: http:/
On Tuesday 19 August 2003 21:03, Vivek Khera wrote:
> Tops on my wish list is that postgres automatically notice when a row
> is no longer needed (all transactional references to it are gone) and
> 'free' it at that time, rather then needing a special scan to
> determine the row is no longer needed
Le Mardi 19 Août 2003 15:27, Erwan DUROSELLE a écrit :
> I'd be glad to join, but I couldn't find where or how to subscribe...
>
Juste send a mail to [EMAIL PROTECTED] with
subscribe pgsql-fr-generale
in your email's body.
--
Guillaume .
---(end of broadcast)
On Tue, 2003-08-19 at 02:56, Alexander Litvinov wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> I home your date field have date type. If it is try this:
>
> select date_part('year', date), count(*) from your_table group by
> date_part('year', date) order by date_part('year', date);
Le Mardi 19 Août 2003 15:35, Francois Suter a écrit :
> > I'd be glad to join, but I couldn't find where or how to subscribe...
>
> It's not yet posted on the web site, but you can subscribe by sending a
> mail to [EMAIL PROTECTED], leave the subject line blank and put
> in the body "SUBSCRIBE pgsq
On Tue, Aug 19, 2003 at 19:17:31 +0530,
Shridhar Daithankar <[EMAIL PROTECTED]> wrote:
>
> Making pgsql-bugs a open to non-subscription but moderated list might be a
> good idea. It really does not matter if a bug gets filed couple of days late
> but having to have subscribe to another list co
It's still bolted on. The entire concept that "transactional integrity
is optional" is ludicrous, IMHO. "Integrity" and "optional" are
contradictory.
Obviously you have never voted in a major election ;)
regards, tom lane
---(end of broadcast)---
On 19 Aug 2003, Bo Lorentsen wrote:
> On Tue, 2003-08-19 at 18:17, Vivek Khera wrote:
>
> > Since the beginning of time (at least MySQL v3.22) MySQL has silently
> > ignored the foreign key references in table create statement. Now
> > that they have foreign key support (version 4.x), do they ho
Hi,
> Before anyone can make an rpm for you they will need some more
information.
>
> What type of CPU are you using ? {SPARC, ALPHA, Pentium ...}
>
> What kernel, and libraries are you using?
I will build them for RedHat 6.2 and 7.3 this afternoon. You can find them
in a few hours at http://open
On Tue, 2003-08-19 at 23:10, scott.marlowe wrote:
> So the syntaxes are different, and one is apparently swallowed without
> error or anything, but in fact you have no fks in place.
Thanks, that helped.
/BL
---(end of broadcast)---
TIP 8: explain
On Tuesday 19 August 2003 23:10, scott.marlowe wrote:
> On 19 Aug 2003, Bo Lorentsen wrote:
> > On Tue, 2003-08-19 at 18:17, Vivek Khera wrote:
> > > Since the beginning of time (at least MySQL v3.22) MySQL has silently
> > > ignored the foreign key references in table create statement. Now
> > >
On Tue, 2003-08-19 at 12:13, Vivek Khera wrote:
> There's a big difference between "noticing that a table needs to be
> vacuumed and running it" and "automatically having the backend free a
> row as soon as we know it is eligible to be (as would normally be
> determined by vacuum)".
Changing Post
On Sat, 2003-08-09 at 21:25, Christopher Browne wrote:
> In 7.3 and 7.4, the "contrib" application, pg_autovacuum can do the
> trick, vacuuming anything that reaches thresholds of
> inserts/deletes/updates, and do so more or less as often as necessary.
Actually pg_autovacuum is not included with
> "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes:
MTO>
MTO> Changing Postgres to perform as mentioned above is non-trivial, it would
MTO> basicially change the entire core of the system. I think this is due to
MTO> the fact that postgres uses a non-overwriting storage manager. This
On Tuesday 19 August 2003 17:46, Sander Steffann wrote:
> I will build them for RedHat 6.2 and 7.3 this afternoon. You can find them
> in a few hours at http://opensource.nederland.net/, and maybe Lamar can put
> them on ftp.postgresql.org.
Ah, there you are. Good. I'll upload them tomorrow when
Hi,
sometime ago I heard that there will be a native win32 version of
postgresql 7.4.
Is this true or will there only be a cygwin version like now?
What do you think, how stable and fast is the cygwin version?
Best regards,
Christian
---(end of broadcast)
30 matches
Mail list logo
