"Jason Tesser" <[EMAIL PROTECTED]> wrote:
> I completely disagree. I do a lot of programming with PHP and the
features
> of Postgres come in handy. Let me give you an example of just some
> basic things. Triggers! Why should I have to write insert and update
> triggers in the logic (PHP) if I c
wtf wrote:
> I to create schema with arbitrary name but it seems CREATE SCHEMA doesn't
> accept anythig different from a constant as an argument. I've tried with a
> function (CREATE SCHEMA some_func();), a SELECT (CREATE SCHEMA (SELECT
> somename FROM sometable);) or as a function (CREATE SCHEMA
Randolf Richardson Wrote:
> Although I view the GPL as well-intended to ensure that free software
> remains that way, I still find that the BSD License seems to be better
suited
> to the needs of businesses at this point in time.
>
As long as we are on the subject of licenses, here is my point
On Fri, 2003-11-28 at 21:45, Bruce Momjian wrote:
> Do SCSI drives even do relocation? I had a Seagate SCSI drive that
> would beep every time I tried to access a bad block, basically telling
> me to replace the drive.
I'm pretty sure that SCSI drives, or at least more modern ones, do. The
ones
"Jason Tesser" <[EMAIL PROTECTED]>
> MySQL cannot even handle sub-queries yet.
Ohh! Really?
Allow me to pay my highest respect to the genius mySQL
programmers!
I completely have no clue on how to construct any single
tiny database on a DBMS having no sub-query capability.
Being too dumb, I sol
On Fri, 28 Nov 2003 22:19:51 -0500 (EST) Richard Welty <[EMAIL PROTECTED]> wrote:
> On Fri, 28 Nov 2003 18:33:37 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > I know we have updated our license in the past, particularly to remove
> > the advertizing clause. I think we grabbed FreeBSD's
Richard Welty wrote:
> On Fri, 28 Nov 2003 18:33:37 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > I know we have updated our license in the past, particularly to remove
> > the advertizing clause. I think we grabbed FreeBSD's version. I don't
> > think we are inclined to update our wo
Richard Welty wrote:
> On Fri, 28 Nov 2003 18:33:37 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > I know we have updated our license in the past, particularly to remove
> > the advertizing clause. I think we grabbed FreeBSD's version. I don't
> > think we are inclined to update our wo
On Fri, 28 Nov 2003 18:33:37 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote:
> I know we have updated our license in the past, particularly to remove
> the advertizing clause. I think we grabbed FreeBSD's version. I don't
> think we are inclined to update our wording unless there is a
> sig
Nicholas Walker wrote:
I have been trying to execute a shell command from within postgresql
You ought to be using Version 1 calling conventions -- see:
http://www.postgresql.org/docs/current/static/xfunc-c.html#AEN29226
The following works fine for me on RH9:
#define GET_STR(textp) \
DatumGetCSt
Randolf Richardson Wrote:
> 2. Moving to table spaces (PostgreSQL version 8 maybe?) rather
> than just storing a whole bunch of files in a single directory. Oracle's
> implementation is nice because tables, indexes, etc., can span multiple
> table spaces, and there are great performance op
Tom Hebbron wrote:
When used, it outputs an array of the inputs, in order.
[...snip...]
CREATE AGGREGATE aggarray (BASETYPE = ANYELEMENT, SFUNC = aggregate_array,
STYPE = ANYARRAY);
There is really no need for the aggregate_array() function. See the
example in the docs:
http://www.postgresql.org
Richard Welty wrote:
> On Fri, 28 Nov 2003 17:58:19 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > OK, where did you get this wording? Is this something Berkeley released
> > as one of their versions of the BSD license.
>
> yes, i believe that it originally came from the Berkeley lawyer
On Fri, 28 Nov 2003 17:58:19 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote:
> OK, where did you get this wording? Is this something Berkeley released
> as one of their versions of the BSD license.
yes, i believe that it originally came from the Berkeley lawyers.
richard
--
Richard Welty
Richard Welty wrote:
> On Fri, 28 Nov 2003 17:23:56 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> > Richard Welty wrote:
> > > but you can consult with the attorneys for the Regents. they have
> > > changed the license at times, and have passed those changes on
> > > to other BSD licens
On Fri, 28 Nov 2003 17:23:56 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Richard Welty wrote:
> > but you can consult with the attorneys for the Regents. they have
> > changed the license at times, and have passed those changes on
> > to other BSD licensed projects (e.g., when they remo
Richard Welty wrote:
> but you can consult with the attorneys for the Regents. they have
> changed the license at times, and have passed those changes on
> to other BSD licensed projects (e.g., when they removed the
> advertising clause the advertising clause was also removed from
> all the code in
On Sat, 29 Nov 2003 09:01:39 +1100 Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> Correct me if I'm wrong, but wouldn't that also require permission from
> every other contributer to PostgreSQL ever? I mean, hypothetically there
> might be someone in there who disagrees with the change.
i don
Tom Lane wrote:
> Breen Ouellette <[EMAIL PROTECTED]> writes:
> > The result of this ambiguity is that the
> > latest CD release of OpenBSD (3.4) no longer includes Postgresql
>
> We are not changing the license text we inherited from Berkeley.
> We do not have the right to, nor any interest in do
On Fri, Nov 28, 2003 at 04:50:40PM -0500, Richard Welty wrote:
> On Fri, 28 Nov 2003 13:50:23 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> > Breen Ouellette <[EMAIL PROTECTED]> writes:
> > > The result of this ambiguity is that the
> > > latest CD release of OpenBSD (3.4) no longer includes Postgres
On Fri, 28 Nov 2003 13:50:23 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> Breen Ouellette <[EMAIL PROTECTED]> writes:
> > The result of this ambiguity is that the
> > latest CD release of OpenBSD (3.4) no longer includes Postgresql
> We are not changing the license text we inherited from Berkeley.
On Fri, 28 Nov 2003, Craig O'Shannessy wrote:
> >
> > From my point of view, it's just support for my demands to have each
> > mission-critical server supported by a UPS, if not redundant power
> > supplies and two UPSes.
> >
>
> Never had a kernel panic? I've had a few. Probably flakey ha
[sNip]
> If you read the GPL very carefully, you may find that it was crafted
> with considerable care and intent.
Oh, please don't misunderstand me, I wasn't implying that there was
anything wrong with such a loophole; after all, some loopholes are
intentional. =)
Although I v
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Rich Shepard) would write:
> On Thu, 27 Nov 2003, Carmen Wai wrote:
>
>> I would like to know whether there is any different in installing Postgresql
>> on the Linux system with file system of EXT2 or EXT3. I have two machines
>> with ident
[EMAIL PROTECTED] (Peter Eisentraut) writes:
> javier garcia - CEBAS writes:
>
>> I've just installed postgres7.4 and have realized tat the order of rows in
>> queries in different to that in 7.3.4. It seems that previously it was more
>> logic, ordering by the first column, then by the second,...
i am using postgres 7.0.3
and also postgres 7.2.1
I am new towards using blobs,I want to transfers
records with blobs from a table to different
database(postgres) using
perl without extracting the blob to disk(i.e without
using lo_export/lo_import).
Below is my perl script which is not working c
[EMAIL PROTECTED] ("Joshua D. Drake") writes:
> Happy Thanksgiving to everyone!
Hmm? In our country, Thanksgiving took place over a month ago...
--
wm(X,Y):-write(X),write('@'),write(Y). wm('aa454','freenet.carleton.ca').
http://www3.sympatico.ca/cbbrowne/lisp.html
"A touchstone to determine the
Randolf Richardson <[EMAIL PROTECTED]> writes:
> [sNip]
>>> In summary, you could be charging them for some very expensive courier
>>> services, if for which they don't pay then you won't deliver. =)
>>
>> Of course a competitor could purchase a copy or get it from a customer
>> and set up shop
[EMAIL PROTECTED] (Frédéric Touboul) writes:
> Is there any kind of support for XQL in PostgreSQL ? I tried to
> google to find the answer, but couldn't find anything very useful --
> aside from something related to OpenACS...
XQL is a query language using XML as its data model.
PostgreSQL does n
> Since we are on the topic of what prompted us to use PostgreSQL, I
> figured I would share my experiences as well, and some additional
> thoughts that I had.
>
> I chose PostgreSQL about 2 years ago when I realized that the
> application I was building needed something more robust than MySQL.
Is there a function or other way to get the user's ip address the moment
an insert is performed?
Supposed that many people with the same "pg_username" are conected to
the database so no username tracking is usefull.
Thanks in advance
Alexander Antonakakis
---(end of br
[EMAIL PROTECTED] (javier garcia - CEBAS) writes:
> I'm not an expert, not by far.
> I've just installed postgres7.4 and have realized tat the order of rows in
> queries in different to that in 7.3.4. It seems that previously it was more
> logic, ordering by the first column, then by the second,.
Something very important was recently raised on the [EMAIL PROTECTED]
list. Due to the current environment that SCO is fostering in the
open source community, it would be prudent for the PostgreSQL team to
consider this issue.
The website claims that "PostgreSQL is distributed under the flexible
On Fri, 28 Nov 2003, Alex Satrapa wrote:
> Doug McNaught wrote:
> > I took it as a garbled understanding of the "Linux does async metadata
> > updates" criticism. Which is true for ext2, but was never the
> > show-stopper some BSD-ers wanted it to be. :)
>
> I have on several occasions demonstr
Hello,
Is it possible to restore a database previously backed-up with "dump", and then
recover some of the changes made after the backup, until a specific timestamp, by
using some sort of "journal"? Is there such a feature in Postgresql?
Thanks
-
Philippe Lang
Attik Sys
Randolf Richardson <[EMAIL PROTECTED]> writes:
>> I _don't_ think what MySQL AB is doing with it is quite what was
>> intended, but the various side-effects that you see are, by and
>> large, quite intentional, even the ones that don't play into
>> scenarios of Richard Stallman as "Evil Overlord."
On Thu, 27 Nov 2003, Doug McNaught wrote:
> Tom Lane <[EMAIL PROTECTED]> writes:
>
> > Doug McNaught <[EMAIL PROTECTED]> writes:
> >> Alex Satrapa <[EMAIL PROTECTED]> writes:
> >>> 1) Under Linux, if you have the file system containing the WAL mounted
> >>> with asynchronous writes, "all bets are
Here's a quick list of my experiences with BLOB's and such.
Performance is just fine, I get about 1M hits a month and haven't had
any problems. Use a BLOB if you don't need to search though the data.
The main reason being that bytea and text types are parsed. To explain,
your entire SQL statement
Hi.
Is it posible to rename postgres database ?
something like "ALTER DATABASE mydb RENAME TO mydb_old " ?
i look to the documentation , but found nothing about.
thanx
---(end of broadcast)---
TIP 7: don't forget to increase your free space map s
Hy,
We are developing with php and postgres and a few days ago we tried to
update our
postgres 7.3 to 7.4.
We have one critical problem of performance with 7.4 version. We usually use
a select with the 'in' option in the following way:
select . where field in (value1,value2,value3).
With po
[EMAIL PROTECTED] (Peter Eisentraut) wrote in message news:<[EMAIL PROTECTED]>...
> Tim Farrell writes:
>
> > I use PostgreSQL as a default database in our solution and with the
> > 7.2 version I was able to tar up the area pointed to by the --prefix
> > build argument and untar to an arbitrary pa
I am looking to install the new Postgres V7.4 on RedHat Linux 7.2.
Is there an RPM available? If so, where?
TIA,
Paul Tilles
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail com
I was wondering if there is something I can do that would act similar to
a index over more than one table.
I have about 3 million people in my DB at the moment, they all have
roles, and many of them have more than one name.
for example, a Judge will only have one name, but a Litigant could have
Hi I am trying to do an insert query but for some reason although there
appears to be no exception thrown my data does not get into the database.
I will try to explain what I am doing
In SQL you can do the following sort of statement
INSERT INTO mytable (fname, lname, age) VALUES ('Joe', 'Bloggs
I have no idea where the backslashes are comming from... very strange.
Are you building your string, then printing it out and it has
backslashes in it from nowhere?
Also, you should probably use a PreparedStatement for this, it will
handle everything for you:
String sqlQuery = "INSERT INTO myt
In itself, the schema thing in version 7.4 is a good thing, but I'm
migrating from a postgres/msacces combination in 7.2 to 7.4, and I'm not to
keen on every table in msacces appearing a public_. Is there a
way to avoid this?
---(end of broadcast)-
Breen Ouellette <[EMAIL PROTECTED]> writes:
> The result of this ambiguity is that the
> latest CD release of OpenBSD (3.4) no longer includes Postgresql
We are not changing the license text we inherited from Berkeley.
We do not have the right to, nor any interest in doing so.
Our interpretation
hi,
> Maybe there's not such a need for the advanced features of PostgreSQL
> amongst PHP programmers as you seem to believe. Most of the PHP stuff I've
> seen is read-only content display stuff and that doesn't really require a
> top-notch RDBMS; a more limited database should also be up to
| Don't go on EXT2, its not reliable and takes lots of time to start
after an
Actually EXT2 is quite reliable and it is also quite fast. However your
point is accurate about start up time after a crash.
The most promising FS is Reiserfs v4
http://www.namesys.com/v4/v4.html
Although Reiser is p
Kamil Kukura <[EMAIL PROTECTED]> writes:
> Is there something I'm missing when data are passed from function to
> function?
I get the impression your function is expecting the contents of a text
datum to be null-terminated. It's not.
regards, tom lane
--
On 27/11/2003 09:19 Tony wrote:
Hi All,
I've just been reading an article in PHP Architect magazine
(http://www.phparch.com) which is the cover story for October called
"Migrating from MySQL to PostgreSQL". I must say that this is a highly
compelling article, especially for me, and is aimed a
El Vie 28 Nov 2003 10:38, Chris Travers escribió:
> One thing that I always have to remind myself of is this:
>
> string || NULL is NULL.
> It is usually a good idea to use coalesce() unless you want this to happen.
Pretty nice. :-)
Even though I don't have that problem, becuase the value comes f
Jon,
I have tried a little bench with pgbench on my 2 proc 2.4 Gb with 4 GB RAM and Linux
RH 9.0.
The database size is 700 MB, so it can be loaded in memory.
Postgres 7.4 is on disk sda (Root disk)
Meta Data are on disk sdb
bench data are on disk sdc
When pgbench is running, i can see with top t
On Fri, 28 Nov 2003, Marco Colombo wrote:
> On Fri, 28 Nov 2003, Craig O'Shannessy wrote:
>
> > >
> > > From my point of view, it's just support for my demands to have each
> > > mission-critical server supported by a UPS, if not redundant power
> > > supplies and two UPSes.
> > >
> >
> > N
> One thing that I always have to remind myself of is this:
>
> string || NULL is NULL.
> It is usually a good idea to use coalesce() unless you want this to
> happen.
>
See my recent post at
http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=24725
(and in general, every
One thing that I always have to remind myself of is this:
string || NULL is NULL.
It is usually a good idea to use coalesce() unless you want this to happen.
Best wishes,
CHris Travers
- Original Message -
From: "Martin Marques" <[EMAIL PROTECTED]>
As I said, it was in front of me, and
56 matches
Mail list logo
