On Tue, 10 Oct 2000, Peter Eisentraut wrote:
> Will be in 7.1.
[ ... ]
> Something like this has recently been announced as add-on from PostgreSQL,
[ ... ]
> That has been available for quite a while.
[ ... ]
So, those are very good news. Thanks, and keep the good work.
Hi,
CREATE FUNCTION LANGUAGE C (and maybe others) allow to load shared
libraries. However the path can be specified arbitrarily by the user. Is
that a way for a user X to gain the UID rights of the user running the
postmaster ?
On 31 Oct 2000, Gary Howland wrote:
> Just a quickie - I heard that linux does not have a working fsync() call
At least the manpage for fsync says that it does.
The implementation:
/* .. finally sync the buffers to disk */
dev = inode->i_dev;
return sync_buffers(dev, 1)
On Mon, 20 Nov 2000, Mickaƫl Jouanne wrote:
> We had a database server on Mysql and we move to postgres last month.
Not enough. You need to specify the exact version, and also the version of
your operating system. Let's assume Linux.
> 'load average: 3.23' or some times higher than that.
Who i
On Thu, 30 Nov 2000, The Hermit Hacker wrote:
> Note that this is a Linux limitation ... and even then, I'm not quite sure
> how accurate that is anymore ... the *BSDs have supported >2gb file
> systems for ages now, and, since IBM supports Linux, I'd be shocked if
> there was a 2GB limit on memo
On Tue, 19 Dec 2000, Joseph wrote:
> $dbh=DBI->connect("dbi:Pg:dbname=$dbname",$dbusername,$dbpassword) or die "can
I would assume that if you never disconnect and are running under
mod_perl, you will have problems.
On Fri, 26 Jan 2001, Alfonso Peniche wrote:
> user
> |
>--
>||
> student employee
Why not store the common data between student and employee in user, and
then store the additional data for student and employee in the relation
itsel
On Fri, 26 Jan 2001, Alfonso Peniche wrote:
> I like the idea, there's just one problem, a user can be both a student and an
> employee...
- If the guy is an user only, then just fill the user template
- If the guy is a student, add a tuple to the is_student relation.
- If the guy is an employee
Hi,
I wanted to try in the archives how to store a md5sum best in a database
(origin is 16 bytes binary, if I don't get a good answer I will use ASCII
like the output of the md5sum UNIX command since this is easy to debug).
I got this error:
Not Found The requested URL /mhonarc/pgsql-general/se
> Server (v6.2), I am accessing the files using JDBC from a Windows 2000 PC.
I don't use Microsoft software, nor Java, but a few general suggestions
for you:
- you may want to create the INDEX at the end (using CREATE INDEX)
in one operation
- you may want to run your requests in trans
On Thu, 26 Apr 2001, Wendy wrote:
> I backed up a database at night and noted the size to be about over 300MB.
Backuped with pg_dump, or dumped the raw database files ? In the latter
case you want to stop the PostgreSQL server first.
> The following morning, I again backed up the same database
Hi,
do you know of a tool which could be used to easily generate
entity-relationship diagrams (with integrity constraints, etc), in LaTeX
for example ?
This is a bit unlinked with PostgreSQL but I hope you won't hit me :)
Thank you.
---(end of broadcast)---
On Thu, 10 May 2001, Jonathan Sand wrote:
> I want to use the COPY command to read a bunch of data files. These
> files don't contain an id, so I want to use the SERIAL data type to
> auto-number the generated rows. COPY complains.
Destination table:
CREATE TABLE destination (id SERIAL, truc
On Wed, 16 May 2001, Alex wrote:
> Are there any debian packages for Postgresql 7.1 or higher for Potato?
> I've tried to get the src-deb from unstable (7.1.1) but it won't compile
> under potato, not unless I upgrade the perl packages as well, which is not
> my idea.
http://people.debian.org/~e
14 matches
Mail list logo