Hi,
I want to write a plpgsql function for use as a
BEFORE ... EACH ROW function. I want to modify
other tables even when the function returns NULL
and therefore the table on which the BEFORE
trigger is defined is not updated.
Can I count on this behavior being supported
in the future? There's
RPK wrote:
How is PGSQL Locking compared with Oracle's MVCC? How PGSQL handles
concurreny and how it differs with Oracle's Multi-Version Concurrency
Control (MVCC)?
The manuals are good for this type of thing:
http://www.postgresql.org/docs/8.2/static/mvcc.html
--
Richard Huxton
Archonet
RPK wrote:
I have installed PGSQL on server. How to install PGSQL client to connect to
the PGSQL database server.
You've installed on what? Windows? Solaris? FreeBSD? RedHat Enterprise?...
--
Richard Huxton
Archonet Ltd
---(end of broadcast)
[EMAIL PROTECTED] wrote:
> I'm working on a database that needs to handle insertion of
> about 10 large objects (50..60GB) a day. It should be
> able to run 200 days, so it will become about 10TB
> eventually, mostly of 200..500KB large objects.
> How does access to large objects work ? I gi
am Thu, dem 22.02.2007, um 23:23:42 -0800 mailte RPK folgendes:
>
> I have installed PGSQL on server. How to install PGSQL client to connect to
> the PGSQL database server.
Depends on the operating system and distribution. For Debian for
instance:
apt-get install postgresql-client-8.1
Andreas
How is PGSQL Locking compared with Oracle's MVCC? How PGSQL handles
concurreny and how it differs with Oracle's Multi-Version Concurrency
Control (MVCC)?
--
View this message in context:
http://www.nabble.com/PGSQL-Locking-vs.-Oracle%27s-MVCC-tf3277425.html#a9114584
Sent from the PostgreSQL - ge
I have installed PGSQL on server. How to install PGSQL client to connect to
the PGSQL database server.
--
View this message in context:
http://www.nabble.com/Installing-PGSQL-Client-tf3277417.html#a9114562
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
-
Bertram Scharpf wrote:
Hi,
it is very inconvenient for me that triggers aren't inherited:
Foreign keys too (which are a special type of trigger of course).
Is this behaviour to be implemented at any point of time in
the future? Could it be advisible to write the patch? Or is
it just too easy
John Smith wrote:
> sounds like you aren't happy with one of the products your company
> offers at
> http://www.commandprompt.com/community/plphp/ - "plphp stands for
> procedural
> language php. the language has the php engine at its core and provides php
> scripting support for procedures and fun
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>
> Joshua D. Drake escribió:
> > Andrej Ricnik-Bay wrote:
> > > On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
> > >> That depends greatly on what you're doing with it. Generally, as soon
> > >> as you start throwing a multi-user workload at it, MySQL st
sounds like you aren't happy with one of the products your company offers at
http://www.commandprompt.com/community/plphp/ - "plphp stands for procedural
language php. the language has the php engine at its core and provides php
scripting support for procedures and functions in postgresql. written
Ben wrote:
> I'm sorry maybe I missed something, but if you don't need NULLs and feel
> they just add extra work, why don't you just declare all your columns to
> be not null and have them default to zero or an empty string?
Stop making sense!
Joshua D. Drake
>
> On Feb 22, 2007, at 5:11 PM, Gl
I'm sorry maybe I missed something, but if you don't need NULLs and
feel they just add extra work, why don't you just declare all your
columns to be not null and have them default to zero or an empty string?
On Feb 22, 2007, at 5:11 PM, Glen Parker wrote:
Buy the same token, some application
On 2/23/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Andrej Ricnik-Bay wrote:
> On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
>> That depends greatly on what you're doing with it. Generally, as soon
>> as you start throwing a multi-user workload at it, MySQL stops
>> scaling. http://tweakers
Alvaro Herrera wrote:
> Joshua D. Drake escribió:
>> Alvaro Herrera wrote:
>>> Joshua D. Drake escribió:
Andrej Ricnik-Bay wrote:
> On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
>> That depends greatly on what you're doing with it. Generally, as soon
>> as you start throwing a m
Joshua D. Drake escribió:
> Alvaro Herrera wrote:
> > Joshua D. Drake escribió:
> >> Andrej Ricnik-Bay wrote:
> >>> On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
> That depends greatly on what you're doing with it. Generally, as soon
> as you start throwing a multi-user workload at it,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/22/07 19:04, Mark Walker wrote:
> I'm not sure what you're trying to do but, it appears that you database
> design is incorrect. What you need is something like
>
> CREATE TABLE temp_readings
> (
> _date Date,
> temperature double,
> source
Alvaro Herrera wrote:
> Joshua D. Drake escribió:
>> Andrej Ricnik-Bay wrote:
>>> On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
That depends greatly on what you're doing with it. Generally, as soon
as you start throwing a multi-user workload at it, MySQL stops
scaling. http://twea
Buy the same token, some application have no use whatsoever for the
distinction between NULL and ''. In that case, the distinction just
adds work.
I would love to see different ways to handle NULL implemented by the
server. For what I do, NULL could always compare equal to zero and ''.
I h
Joshua D. Drake escribió:
> Andrej Ricnik-Bay wrote:
> > On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
> >> That depends greatly on what you're doing with it. Generally, as soon
> >> as you start throwing a multi-user workload at it, MySQL stops
> >> scaling. http://tweakers.net recently did a s
I'm not sure what you're trying to do but, it appears that you database
design is incorrect. What you need is something like
CREATE TABLE temp_readings
(
_date Date,
temperature double,
source varchar(20),
)
No reading, no record. Are you suggesting that you would have a weekly
set of rec
Andrej Ricnik-Bay wrote:
> On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
>> That depends greatly on what you're doing with it. Generally, as soon
>> as you start throwing a multi-user workload at it, MySQL stops
>> scaling. http://tweakers.net recently did a study on that.
> I think I recall tha
Tim Tassonis wrote:
> Chris wrote:
>> Erick Papadakis wrote:
>>> So how should I make a database rule in MySQL to not allow blank
>>> strings. Basically to REQUIRE a value for that column, whether it is
>>> NULL or NADA or VOID or whatever you wish to call it. I just want to
>>> make sure that some
On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
That depends greatly on what you're doing with it. Generally, as soon
as you start throwing a multi-user workload at it, MySQL stops
scaling. http://tweakers.net recently did a study on that.
I think I recall that wikipedia uses MySQL ... they get
Ron Johnson wrote:
> On 02/21/07 18:09, Erick Papadakis wrote:
>> How would you like to use a database that has nuances like these --
>> http://forums.mysql.com/read.php?20,141120,141120#msg-141120
>
> Huh?
>
> A blank string (does that mean '' or ' '?) is not NULL, so of
> *course* it should pas
>-Original Message-
>From: Stephan Szabo [mailto:[EMAIL PROTECTED]
>Sent: donderdag 22 februari 2007 23:13
>To: Joris Dobbelsteen
>Cc: Martijn van Oosterhout; Robert Haas; pgsql-general@postgresql.org
>Subject: Re: [GENERAL] complex referential integrity constraints
>
>On Thu, 22 Feb 2007,
>-Original Message-
>From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED]
>Sent: donderdag 22 februari 2007 23:15
>To: Joris Dobbelsteen
>Cc: Robert Haas; pgsql-general@postgresql.org
>Subject: Re: [GENERAL] complex referential integrity constraints
>
>On Thu, Feb 22, 2007 at 06:51:49PM
Hi,
it is very inconvenient for me that triggers aren't inherited:
create table watch (
mod timestamp with time zone default '-infinity' not null
);
create function update_mod() returns trigger ...
create trigger update_mod before insert or update on watch
for each row e
On Thu, 2007-02-22 at 18:48 -0500, Brandon Aiken wrote:
> Digg and Slashdot use MySQL databases, so clearly they *can* be made to
> support a high-load, high-performance, limited-write style web
> application.
>
> You might remember a few months back when SlashDot had to turn off
> threaded repl
Digg and Slashdot use MySQL databases, so clearly they *can* be made to
support a high-load, high-performance, limited-write style web
application.
You might remember a few months back when SlashDot had to turn off
threaded replies because the schema for the parent-child field was still
an UNSIG
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/22/07 17:17, Jim Nasby wrote:
> On Feb 21, 2007, at 10:26 AM, Scott Marlowe wrote:
>> The only thing I can think of that rewrites a whole postgresql table
>> would be reindexing it, or an update without a where clause (or a where
>> clause that i
On 22.02.2007, at 16:03, Ted Byers wrote:
One of my problems with database development is how to construct
analogously strong test cases in order to prove the code correct.
With tests you can't prove that your code is correct. You can only
show that your code works with the test cases. Ther
On 22.02.2007, at 15:56, Jim Nasby wrote:
and "surrogate key fields should be named 'id'" (I *much* prefer
the form "object_id", ie: user_id, used *everywhere*, including the
user table (in that example)).
Fortunately, with rails extensibility it shouldn't be hard to
change those default be
On Feb 21, 2007, at 12:58 AM, Stefan Kaltenbrunner wrote:
Have you actually measured a performance improvment going beyond
250-350MB(that seemed about to be the sweet spot last I tested) or so
for index creation and friends ?
To be honest, no; I just set it high to play on the safe side. But I
On Feb 21, 2007, at 2:23 PM, Brandon Aiken wrote:
IMX, the only things going for MySQL are:
1. It's fast.
That depends greatly on what you're doing with it. Generally, as soon
as you start throwing a multi-user workload at it, MySQL stops
scaling. http://tweakers.net recently did a study on
>>>One of my problems with database development is how to construct
analogously strong test cases in order to prove the code correct. <<<
I have found the best method is to be as random as possible. I think
coders subconsciously only test with data they think will work so they
don't have worr
On Feb 21, 2007, at 10:26 AM, Scott Marlowe wrote:
The only thing I can think of that rewrites a whole postgresql table
would be reindexing it, or an update without a where clause (or a
where
clause that includes every row). Normal operations, like create
index,
add column, drop column, etc
On Feb 20, 2007, at 11:59 PM, Adam Rich wrote:
"As of 5.0.2, the server requires that month and day values
be legal, and not merely in the range 1 to 12 and 1 to 31,
respectively."
Yes, but any session is free to change that setting and insert
whatever garbage they want. AFAIK there's absolut
Mark> Similar issues with Mysql. It's faster,
But it doesn't matter *how* fast you get the *wrong* answer. :)
I thought one of the first rules of software engineering was "First make it
right and only then make it fast!"
Granted, most of my experience has more to do with number crunching an
The problem with using simple OS priority settings is you leave
yourself wide open to priority inversion.
There is already work being done on a queuing system; take a look at
the bizgres archives.
On Feb 20, 2007, at 5:19 PM, Ron Mayer wrote:
Bruce Momjian wrote:
Hard to argue with that.
On Feb 20, 2007, at 9:17 AM, Ian Harding wrote:
On 2/17/07, Rick Schumeyer <[EMAIL PROTECTED]> wrote:
I have three tables of interest...Account, Employee, and
AccountEmployeeRelation. There is a many-to-many relationship
between
accounts and employees. The join table also contains a column
On Feb 21, 2007, at 11:47 PM, sangeetha k.s wrote:
i want to know
1.what compression technique used in on disk implementation
of bitmap index.
Use the source, luke.
You should also take a look at the discussions on the mailing lists
surrounding it's development. I know early stuff w
Hi all !
I'm working on a database that needs to handle insertion of about 10 large
objects (50..60GB) a day. It should be able to run 200 days, so it will become
about 10TB eventually, mostly of 200..500KB large objects.
How does access to large objects work ? I give the oid and get the lar
Yes, exactly. And while you might not care about all of those (e.g. I
care about the first two but am not worried about the third one because
I'm the only one who will ever update that table), writing multiple
triggers to enforce each constraint of this type quickly gets old if
there are even a fe
The idea here is that a wolf can attack a sheep, or a wolf can attack
another wolf, but sheep can't attack anything. I suppose I could list
each wolf in both the predator and prey tables, but that seems a bit
duplicative (and causes other problems).
...Robert
-Original Message-
From: Dav
Hello,
thank you for the information, but it seems my messages are hold for
moderator approval.
A few of them seems to be dropped - I don't know.
Richard Huxton schrieb:
Alexander Elgert wrote:
Hello,
given is a postgres database in version
--
The ability to make a foreign key reference a specific partial unique
index (rather than just a set of columns that have a unique index) would
solve many problems of this type. As another example, you might have a
table where one of the columns is "is_deleted boolean not null". By
creating a part
I would do a CHECK (trim(a) <> '')
TRIM() would add some processing time, so I'd include it only if there
was a chance of spaces getting added. From a puritanical point of
view, it is definitely a good idea.
To the original poster, this syntax should work in MySQL as well:
create table myt
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x420
Jerry LeVan wrote:
>
>
> Is there an elegant way I can merge/update the two tables so that
> they will contain the same information ( with no duplicates or
> omissions)?
>
Well comparing algorithm is quite complex and depend on data.
You can use third patry software like
http://www.sqlmana
On 22/02/07, Shashank Tripathi <[EMAIL PROTECTED]> wrote:
> I would do a CHECK (trim(a) <> '')
TRIM() would add some processing time, so I'd include it only if there
was a chance of spaces getting added. From a puritanical point of
view, it is definitely a good idea.
To the original poster, t
If you don't know something, why are you trying to record it? From a strict
relational sense, the existence of NULL values in your fields indicates that
your primary keys are not
truly candidate keys for all your fields. That means your database isn't [BCNF]
normalized.<<<
I agree that ther
On Thu, Feb 22, 2007 at 06:51:49PM +0100, Joris Dobbelsteen wrote:
> >Err, foreign keys are implemented using triggers, so this
> >statement is self-contradictary.
>
> Are you really sure they are executed under the same visibility rules?
Reasonably. I have no idea what visibility rules would ma
On Thu, 22 Feb 2007, Joris Dobbelsteen wrote:
> >-Original Message-
> >From: [EMAIL PROTECTED]
> >[mailto:[EMAIL PROTECTED] On Behalf Of
> >Martijn van Oosterhout
> >Sent: donderdag 22 februari 2007 18:17
> >To: Joris Dobbelsteen
> >Cc: Robert Haas; pgsql-general@postgresql.org
> >Subject:
If you can remove NULLs without breaking OUTER JOIN, more power to you.
In the vast majority of cases, all fields in a table should have a NOT
NULL constraint. Storing a NULL value makes little sense, since you're
storing something you don't know. If you don't know something, why are
you trying
> "Mark" == Mark Walker <[EMAIL PROTECTED]> writes:
Mark> Similar issues with Mysql. It's faster,
But it doesn't matter *how* fast you get the *wrong* answer. :)
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
http://www.stonehenge.com/merlyn/>
Perl/Unix/sec
You're probably right. A good example of that is the difference between
the excellent pgadmin and the desktop mysql administrator which is very
buggy and strangely laid out. Whenever I have to deal with mysql I get
the feeling I'm messing around with a bunch of hacks. It's very strange
to de
I wasn't referring to projects written in both languages. I was
referring to projects written primarily for MySQL or "real" databases
(i.e. oracle, pgsql, mssql, db2, and on and on). No matter what
language is used, I think you'll find that apps written primarily for
mysql have poorer code than t
Hmm, I've never heard of an application that's written in both php and
Java. However, I know of many applications that run on both mysql and
postgresql. For instance phpbb which is the most common MB software is
written in php and runs with either postgresql or mysql. Database
server indepen
On 2/21/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Ian Harding" <[EMAIL PROTECTED]> writes:
> I had views that used syntax like
> WHERE datecol < current_date and (otherdatecol is null or otherdatecol
> > current_date)
> Suddenly, this is ungodly inefficient in 8.2.3. It worked just fine in 8.1.3.
On Thu, 2007-02-22 at 12:17, Mark Walker wrote:
While I'll admit to some similarities between PHP/java and mysql/pgsql,
I'd say that th gulf between php and java is far less than the gulf is
between mysql and pgsql.
Take a list of a hundred or so db based projects written in each
language. Corre
> Quick question, you mentioned LVM snapshots, and I am not aware what
> it does! Is there any doc that explains it? Can you point me to some
> such resources?
Newer LVM versions support read/write snapshots [essentially cheap clone of
all partition data].
http://tldp.org/HOWTO/LVM-HOWTO/snapshot
Tomas,
I plan to do something similar [except snapshots] so if I run into
issues, I will let you know.
Quick question, you mentioned LVM snapshots, and I am not aware what
it does! Is there any doc that explains it? Can you point me to some
such resources?
Regards
Dhaval
On 2/22/07, Tomas Simo
At 02:16 AM 2/23/2007, Joshua D. Drake wrote:
We do not compete with MySQL.
Does MySQL have the mindshare of the ignorant? Yes.
Does MySQL have the mindhare of the knowledgeable? No.
Our mindshare is *huge* with the knowledgeable.
I will take mindshare with the knowledgeable over the ignorant,
I think a lot of the reasons people use LAMP is that inexpensive ISPs
use LAMP. The reasons ISPs use LAMP as opposed to other, in my opinion
more powerful tools has to do with the complexities of hosting large
numbers of user applications on single machines.
For instance, I don't know anybody
>> O.k. this is bizarre. One, this discussion belongs on -advocacy not
>> -general.
>>
>> Two, you do realize that we have huge mind share right?
>
> Huge? Nah. AFAIK, Oracle hasn't tried to buy up the major suppliers[1]
> of postgresql's "backend" tech yet.
Ahh, because they can't? Oracle can't
Lincoln Yeoh wrote:
> At 01:30 AM 2/23/2007, Joshua D. Drake wrote:
>
> >Two, you do realize that we have huge mind share right?
>
> Huge? Nah. AFAIK, Oracle hasn't tried to buy up the major
> suppliers[1] of postgresql's "backend" tech yet.
>
> Link.
>
> [1] e.g. Tom Lane.
How do you know?
At 01:30 AM 2/23/2007, Joshua D. Drake wrote:
>> Answer for this is a bit complex, more newbies howtos, more people
>> saying that is better and so on
>
> Yeah. Would be good if we can figure out something that would help
> postgresql increase its usage or mind share.
O.k. this is bizarre.
Hi,
I've got following online-backup setup (v. 8.1.8):
- on master
-- archive_command = 'mv %p //%f
-- rsyncd with access to DB data and
- on slave
-- rsync client running every 10sec. to sync and
directories to slave:
rsync -a --delete master::
rsync -a --delete master::
-- pg_start_backu
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of
>Martijn van Oosterhout
>Sent: donderdag 22 februari 2007 18:17
>To: Joris Dobbelsteen
>Cc: Robert Haas; pgsql-general@postgresql.org
>Subject: Re: [GENERAL] complex referential integrity constraints
>
>O
On 2/22/07, Martijn van Oosterhout wrote:
On Thu, Feb 22, 2007 at 12:05:20PM +1100, Chris wrote:
> >SELECT foo, bar, COUNT(*)
> >FROM baz
> >GROUP BY foo
> That one actually comes in handy ;) Especially in older versions (4.0)
> that don't support subselects..
I must say I don't see any reaso
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/22/07 10:40, Joshua D. Drake wrote:
>>> Well no. PHP is not a professional language because it has no really
>>> design - and that has nothing to do with the fact it beeing a scripting
>>> language. Its a bad scripting language. (Say namespaces f
>> Answer for this is a bit complex, more newbies howtos, more people
>> saying that is better and so on
>
> Yeah. Would be good if we can figure out something that would help
> postgresql increase its usage or mind share.
O.k. this is bizarre. One, this discussion belongs on -advocacy not
No, the first X aren't more important, but being able to determine
word proximity is very important for partial phrase matching and
ranking. The closer the words, the "better" the match, all else being
equal.
exactly
---(end of broadcast)---
TIP
Hi,
Mike Rylander wrote:
No, the first X aren't more important, but being able to determine
word proximity is very important for partial phrase matching and
ranking. The closer the words, the "better" the match, all else being
equal.
Ah, yeah, for word-pairs, that certainly helps.
Thanks.
Re
At 12:54 AM 2/23/2007, Rodrigo Gonzalez wrote:
PHP is easy and cheap to start, so there are lots of programmers
using it, and someone like you, or any other company, can take a
cheap programmer to do the work. Most of programmer use it with
mysql, now this is the question to answerwhy?
Ma
On Thu, Feb 22, 2007 at 05:28:35PM +0100, Joris Dobbelsteen wrote:
> Even worse, I don't you can guarentee that this constraint is enforced
> at all times. That means, not if you are using triggers.
> The only option seems using foreign keys and put in a lot of redundant
> data.
Err, foreign keys
>> This whole discussion is about a language lawyer and a professional. The
>> reality is, professional programmers do use PHP. I would say probably
>> more than any other language out there.
>
> Yes, by the definition that they earn money by doing it.
>
>> Does that mean that PHP is a technical
On 2/22/07, Markus Schiltknecht <[EMAIL PROTECTED]> wrote:
Hello Teodor,
Teodor Sigaev wrote:
> byte offset of word is useless for ranking purpose
Why is a word number more meaningful for ranking? Are the first 100
words more important than the rest? That seems as ambiguous as saying
the first
>> P.S. I don't particularly like PHP either, but our company website is
>> coded in it because no other language (for the web) could have done the
>> job at the same TCO.
>>
>>
>
> PHP is easy and cheap to start, so there are lots of programmers using
> it, and someone like you, or any other com
Randal L. Schwartz wrote:
Russ> Take perl for example. I have still yet to see readable Perl code.
You can't read it if you're not familiar with it.
Seconded. Perl is like the churkendoose -- hybrid strength, ugly as
hell, only poultry known that can scare off a fox every time, whole
barnyar
>-Original Message-
>From: Tom Lane [mailto:[EMAIL PROTECTED]
>Sent: donderdag 22 februari 2007 17:16
>To: Joris Dobbelsteen
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Guarenteeing ordering constraints
>
>"Joris Dobbelsteen" <[EMAIL PROTECTED]> writes:
>> I have some troubl
On Thu, Feb 22, 2007 at 12:38:50PM +0100, Sergio Andreozzi wrote:
> Dear all,
>
> given a column which type is for instance varchar(20)[],
This is almost never a good design. If you must have an interface
like that, make it VIEW over an aggregate, which you can make
writeable.
> is it possible
Joshua D. Drake schrieb:
Well no. PHP is not a professional language because it has no really
design - and that has nothing to do with the fact it beeing a scripting
language. Its a bad scripting language. (Say namespaces for example,
confusing function interfaces, unicode flaws, missing usable f
Joshua D. Drake wrote:
Well no. PHP is not a professional language because it has no really
design - and that has nothing to do with the fact it beeing a scripting
language. Its a bad scripting language. (Say namespaces for example,
confusing function interfaces, unicode flaws, missing usable fra
>> Well no. PHP is not a professional language because it has no really
>> design - and that has nothing to do with the fact it beeing a scripting
>> language. Its a bad scripting language. (Say namespaces for example,
>> confusing function interfaces, unicode flaws, missing usable frameworks,
>>
>-Original Message-
>From: Robert Haas [mailto:[EMAIL PROTECTED]
>Sent: donderdag 22 februari 2007 15:58
>To: Joris Dobbelsteen; elein
>Cc: pgsql-general@postgresql.org
>Subject: RE: [GENERAL] complex referential integrity constraints
>
>The ability to make a foreign key reference a specif
Tino Wildenhain wrote:
totally off topic,
Tim Tassonis schrieb:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My definition is, "toy used/trumpeted by pseudo-professionals as a
professional tool, when it just doesn't measure up".
Boah, here surely speaks a true professio
"Joris Dobbelsteen" <[EMAIL PROTECTED]> writes:
> I have some trouble guarenteeing that an ordering constraint is enforced
> on the database. On the table ordering (see below) I want to enforce
> that for every tuple t, all tuples u where u.position < t.position this
> implies u.cumvalue <= t.cumva
At 10:22 PM 2/22/2007, Tim Tassonis wrote:
Chris wrote:
An empty string is a KNOWN value. You know exactly what that value
is - it's an empty string.
A NULL is UNKNOWN - it doesn't have a value at all.
I do still think it is a bit of an oddity, the concept of the null
column. From my experie
At 01:11 PM 2/22/2007, John Smith wrote:
On 2/21/07, Lincoln Yeoh wrote:
MySQL: the PHP of databases.
'd appreciate if you stick to the subject.
jzs
OK sorry... That was more of a footnote.
Link.
---(end of broadcast)---
TIP 6: explain a
Hello Teodor,
Teodor Sigaev wrote:
byte offset of word is useless for ranking purpose
Why is a word number more meaningful for ranking? Are the first 100
words more important than the rest? That seems as ambiguous as saying
the first 1000 bytes are more important, no?
Or does the ranking w
On Thu, Feb 22, 2007 at 03:01:59PM -, Chris Coleman wrote:
> Hi,
>
> Firstly I apologise for the large number of chunks of code and log file
> attached to this post, however without them I don't think there would be
> much point in the post.
There's a mailing list for slony, you might have be
totally off topic,
Tim Tassonis schrieb:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My definition is, "toy used/trumpeted by pseudo-professionals as a
professional tool, when it just doesn't measure up".
Boah, here surely speaks a true professional playing in the leagu
> "Russ" == Russ Brown <[EMAIL PROTECTED]> writes:
Russ> Take perl for example. I have still yet to see readable Perl code.
I could say the same for greek, and pl/pgsql.
You can't read it if you're not familiar with it. Please stop bashing Perl
until you've read at least Learning Perl or th
Even this can be violated.
Just create another table and change the first select statement of the
transactions to get data from that table.
Is there any way to actually enforce such ordering constraints under
postgresql?
- Joris
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMA
Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> En un mensaje anterior, Tom Lane escribió:
>> Fernando Schapachnik <[EMAIL PROTECTED]> writes:
>>> I've stumbled upon what seems to be a core-dumping infinite recursion
>>> in transformExpr(), on 8.1.6.
>>
>> A test case would help.
> The culpri
Rich Shepard wrote:
On Thu, 22 Feb 2007, Tim Tassonis wrote:
I do still think it is a bit of an oddity, the concept of the null
column.
From my experience, it creates more problems than it actually solves and
generally forces you to code more rather than less in order to achieve
your goals.
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> The real bottom line here, and one I'll reiterate every chance I get,
> is that we don't make updates to back branches because we're too bored
> to have anything else to do. If you're on 8.1.5, and the current
> release in that branch is 8.1.
Hi,
Firstly I apologise for the large number of chunks of code and log file
attached to this post, however without them I don't think there would be
much point in the post.
I have a slony replication system set up and working (slony 1.1.5,
Postgres 8.1), and am trying to add a new node to it as I
1 - 100 of 125 matches
Mail list logo
