Demokratie gefordert 85. M. und
Demokratie 412. M. und Judentum 350 f., 352, 498. Staatsauffassung 420. V
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
this fails with duplicate key value:
CREATE TABLE x (
i INT NOT NULL UNIQUE
);
INSERT INTO x (i) VALUES (1), (2), (3);
UPDATE x SET i = i + 1;
are there any plans to make this work?
--
Roman Neuhauser
--
Sent via pgsql-general mailing list (pgsql-general
expand.
Thanks for the hints!
--
Ian Smith
www.ian.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Smith
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
...)
200803/1396: Re: pl/pgsql and controling loops
200803/1397: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1398: Re: dunction issue
200803/1399: table of US states' neighbours
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
?
200803/1345: Using tables in other PostGreSQL database
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
: Timezones in 8.2.7
200803/1379: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1380: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1381: Re: Using tables in other PostGreSQL database
--
Sent via pgsql-general mailing list
of update
200803/1362: Re: returned value from SQL statement
200803/1363: Re: Using tables in other PostGreSQL database
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/1420: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1457: SELECT DISTINCT ON and ORDER BY
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
: Using tables in other PostGreSQL database
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
: table of US states' neighbours
200803/1472: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1473: Re: Persistent user-defined functions
200803/1474: Re: Users, groups and inheritance questions
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
Where does PostgreSQL rank nulls when sorting a column of timestamps, is this
behaviour deterministic, and can I rely on it not changing in the future?
Apologies if this shows up as a repost, I've had gateway problems at this end.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
Many thanks Tom. Inconvenient from the point of view of the application but
still useful information.
The situation is that I've got a query with numerous subselects, each of which
has to return exactly one row so I was doing a union with a nulled record then
selecting the most recent: obviously
hello,
I have read the documentation couple of times and I still can not figure
out
the following aspects.
if a function does insert/update/delete it needs to be stable or
volatile ?
if a immutable function executes 'nextval' should itself be also
volatile ?
thanks,
Razvan Radu
Justin Clift wrote:
Did you get any feedback on this? :-)
Unfortunately not, but I live in hope. [If you live in Hope, you'll die
in Caergwrle]. I can afford very little time to play with it at present,
however I'll come back to it as soon as I can since one of our ongoing
issues is trying to
I'm successfully storing
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
Tony Grant wrote:
These are film and director pages in a movie site. I am looking at
HTML-XML tools then with a parser I should be able to create a tab
delimited text file.
I'm successfully storing scripts in tables which are pulled and executed
on a client system, works well so far except
Marco Colombo wrote:
BTW, the document contains some limits. FS size limit is reported to be
2TB (block-device size limit). I don't know if it applies to LVM logical
volumes. Ext2 FS size limit is 16TB (for 4kB blocks FS). You need to put
some effort to place 16TB on a single FS.
Thanks for
Martijn van Oosterhout wrote:
What the limit on NT?
I'm told 2^64 bytes. Frankly, I'd be surprised if MS has tested it :-)
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
---(end of
Can a single database be split over multiple filesystems, or does the
filesystem size under e.g. Linux (whatever it is these days) constrain
the database size?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
Ian Willis wrote:
Postgresql transparently breaks the db into 1G chunks.
Yes, but presumably these are still in the directory tree that was
created by initdb, i.e. normally on a single filesystem.
The main concern is during dumps. A 10G db can't be dumped if the
filesustem has a 2G limit.
Hello,
We have been putting a lot of work into Part IV of the book.
We would appreciate some fresh feedback on the chapters 9 and 10.
As always, the link:
http://www.opendocspublishing.com/entry.lxp?lxpe=92
Thanks!
OpenDocs
---(end of
Hello,
We have decided that we will not be including GreatBridge PostgreSQL and
instead will be focussing on the community released version.
As always updated information on the book can be found on the web at:
http://www.opendocspublishing.com/entry.lxp?lxpe=92
Joshua Drake
Hello,
Heh... I wrote that :)
J
On Sat, 2 Jun 2001, Michael wrote:
http://www.zend.com/zend/art/databases.php
Needless to say Postgresql comes out looking pretty good. Good to have
links like this to show the advantages of Postgresql when I'm trying to
convert others to using it.
25 matches
Mail list logo