Re: [GENERAL] Some advanced database features, are they present in PostgreSQL

2000-10-10 Thread Marc SCHAEFER
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.

[GENERAL] CREATE FUNCTION LANGUAGE C

2000-10-11 Thread Marc SCHAEFER
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 ?

Re: [GENERAL] True ACID under linux (no fsync)?

2000-11-01 Thread Marc SCHAEFER
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)

Re: [GENERAL] Some problem on the data base server !

2000-11-20 Thread Marc SCHAEFER
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

Re: [GENERAL] Can PostGreSQL handle 100 user database?

2000-11-30 Thread Marc SCHAEFER
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

Re: [GENERAL] Help me for "DBI->connect failed: Sorry, too many clients already."

2000-12-19 Thread Marc SCHAEFER
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.

Re: [GENERAL] Problem with inheritance

2001-01-26 Thread Marc SCHAEFER
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

Re: [GENERAL] Re: Problem with inheritance

2001-01-27 Thread Marc SCHAEFER
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

[GENERAL] Search engine doesn't work

2001-01-27 Thread Marc SCHAEFER
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

Re: [GENERAL] Re: Slowdown problem when writing 1.7million records

2001-02-27 Thread Marc SCHAEFER
> 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

Re: [GENERAL] Why Size Of Data Backed Up Varies Significantly In SQL 6.5?

2001-04-26 Thread Marc SCHAEFER
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

[GENERAL] ER diagrams

2001-05-10 Thread Marc SCHAEFER
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)---

Re: [GENERAL] COPY INTO and the SERIAL data type

2001-05-10 Thread Marc SCHAEFER
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

Re: [GENERAL] debian packages for Postgresql 7.1 or higher ?

2001-05-22 Thread Marc SCHAEFER
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