[GENERAL] help me on a trigger

I need to create a trigger that decreases on a "stocks" table the amount that have been inserted on the "tooken_from_stock" table.the trigger should be something like:CREATE TRIGGER triggerdecrease BEFORE INSERT ON tooken_from_stockEXECUTE PROCEDURE decrease();then i need to create the procedure de

Re: [GENERAL] Restoring databases from a different installment on Windows

On Wed, May 31, 2006 at 00:26:02 -0700, Berislav Lopac <[EMAIL PROTECTED]> wrote: > > Actually, my situation is like this: > > I had a properly running version of Postgres when my Windows crashed. I > Installed a fresh copy on Windows on another disk, and then Postgres on > top of it. Then I st

Re: [GENERAL] SCSI disk: still the way to go?

Maximum througput of a single drive is around 80MB/second, a 300MB/sec interface won't change that.AlexOn 6/1/06, Riccardo Inverni < [EMAIL PROTECTED]> wrote:Hi Alex,   thanks for the answer (thanks to the other guys too!). http://www.cdw.com/shop/products/default.aspx?EDC=912784 SATA - ~$320 Is

[GENERAL] Problem adding a record with vb6

I have visual basic 6 with sp6 and I'm trying to add data to PG table, but it gives a error msg like this:Current recordset doesn't support updating. This may be a limitation of the provider or  of the selected locktype.and I don't know what can it be, this is the code that I use:strSql = "Provider

Re: [GENERAL] problemas con psql -l

On May 31, 2006, at 3:32 PM, Eliana Providel wrote: cuando intento listar todas las bases de datos existentes con "psql -l" me sale el siguiente error: ERROR: no existe la relación "pg_catalog.pg_user" I think you must be using a PostgreSQL server version 8.1 with an older version of p

Re: [GENERAL] Best open source tool for database design / ERDs?

On 6/1/06 12:29 PM, "Tomi NA" <[EMAIL PROTECTED]> wrote: > On 6/1/06, Sean Davis <[EMAIL PROTECTED]> wrote: >> You might look into Eclipse (the java-based IDE). It has at least one ERD >> design plugin that allows graphical layout, editing of schema, and >> generation of DDL directly from the

Re: [GENERAL] Problem in Pg 8.1.4 with CREATEDB

> > I don't think anyone ever imagined that the bug actually allowed > > people to use utilities in a way that was useful to them, but > > unintended by everyone else. Had we done, we would > certainly have made > > the warnings more obvious and considered workarounds. > > Actually, we thought

Re: [GENERAL] Problem in Pg 8.1.4 with CREATEDB

"Dave Page" writes: > I don't think anyone ever imagined that the bug actually allowed people > to use utilities in a way that was useful to them, but unintended by > everyone else. Had we done, we would certainly have made the warnings > more obvious and considered workarounds. Actually, we thou

Re: [GENERAL] SCSI disk: still the way to go?

On 5/31/06, Chris Browne <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] ("Merlin Moncure") writes: > Xyratex From their web site, they sound like they'll be as challenging to get straight answers from as any of the other disk array vendors :-(. valid concerns. I don't have an answer yet except

[GENERAL] PostgreSQL authentication as my application's authentication.

Hello,I'm developing a web application, I normally write the authentication using a database table for usernames and passwords, I would like to implement this app using postgresql's authentication, the user types his user/pass and that's the user/pass used for database connectivity, so each user ar

[GENERAL] Is there a database file system?

Is there a database file system? I have a project that needs very advanced permission control like that offered by Novell NDS. I am wanting to know if anyone knows of a (PHP | Perl | Samba | SQL ) (object | plug-in | module ) that would allow me to serve files from a connection that is control

Re: [GENERAL] postgres in windows

On 1 Jun 2006 at 16:28, Antonios Katsikadamos wrote: > First of all is there an installer for postgres for windows? You'll find the installer for the Windows version of PostgreSQL here: http://www.postgresql.org/ftp/binary/v8.1.4/win32/ Note that it will run only on 32-bit Windows, so Win98, ME

Re: [GENERAL] Best high availability solution ?

Michael Meskes a écrit : Josh, don't you think the better starting point when looking for support would be http://www.postgresql.org/support/professional_support ? :-) There are support companies in France and other parts of Europe which might be a better idea for a company in France. After all

Re: [GENERAL] Best high availability solution ?

> >But you have a point that having a contact for postgresql support is a > >very good idea anyway ! > > Here ya go: > > http://www.commandprompt.com/support > > (DISCLAIMER: I represent the company) Josh, don't you think the better starting point when looking for support would be http://www.p

Re: [GENERAL] Fat 32/NTFS

On Thursday 1. June 2006 16:18, Antonios Katsikadamos wrote: >Hi all again. sorry for the disturbance but I am not aware of the > postgres installation procedure. my laptop runs Win xp on format > fat32. I get a message from installation >that requires NTFS format. Is there a way of installing post

Re: [GENERAL] Fat 32/NTFS

  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Antonios KatsikadamosSent: 01 June 2006 15:18To: pgsql-general@postgresql.orgSubject: [GENERAL] Fat 32/NTFS Hi all again. sorry for the disturbance but I am not aware of the postgres installation proced

[GENERAL] Fat 32/NTFS

Hi all again. sorry for the disturbance but I am not aware of the postgres installation procedure. my laptop runs Win xp on format fat32. I get a message from installation that requires NTFS format. Is there a way of installing postgres on fat 32 without using linux?   what do u propose?   thnx a

Re: [GENERAL] postgres in windows

On 6/1/06, Antonios Katsikadamos <[EMAIL PROTECTED]> wrote: Hi all. My name is Antonios and I am doing an MSc in Advanced computing at Imperial College London. I need to install postgres for my individual project on windows. Would it be a problem to ask one- or -two questions? First of all is

Re: [GENERAL] Best open source tool for database design / ERDs?

Dia itself is just a diagramming tool. However, there are a number of apps at http://www.gnome.org/projects/dia/links.html that will take Dia diagram files and generate db schemas for you... [EMAIL PROTECTED] wrote: Anyone know if DIA will generate CREATE TABLE statements from an ER diagram?

Re: [GENERAL] Best open source tool for database design / ERDs?

Hi, tedia2sql will do the job: http://tedia2sql.tigris.org Greetings, Leif On Thu, 1 Jun 2006 [EMAIL PROTECTED] wrote: > Anyone know if DIA will generate CREATE TABLE statements from an ER > diagram? > > I'd like to have a program where I can create my db design, then be > able to

Re: [GENERAL] Best open source tool for database design / ERDs?

On Thu, 1 Jun 2006, Sean Davis wrote: You might look into Eclipse (the java-based IDE). It has at least one ERD design plugin that allows graphical layout, editing of schema, and generation of DDL directly from the schema. It works with many DB platforms and is FREE!!! Allow me to second th

Re: [GENERAL] Best open source tool for database design / ERDs?

You might look into Eclipse (the java-based IDE). It has at least one ERD design plugin that allows graphical layout, editing of schema, and generation of DDL directly from the schema. It works with many DB platforms and is FREE!!! Sean On 6/1/06 5:44 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]

[GENERAL] postgres in windows

Hi all. My name is Antonios and I am doing an MSc in Advanced computing at Imperial College London.   I need to install postgres for my individual project on windows.   Would it be a problem to ask one- or -two questions?   First of all is there an installer for postgres for windows?   what do i n

Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

Hi, I made some tests, with and without Hyperthreading: with hyperthreading, on a dual-processor, top mentions a 25% load, and without, 50%, but computing time is exactly the same. Philippe -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Arnaud Lesauva

Re: [GENERAL] GPL Licensed Files in 8.1.4

Am Mittwoch, 31. Mai 2006 16:50 schrieb Charles Comiskey: > PostgreSQL 8.1.4 appears to have 2 GPL licensed files according to > licenses embedded in the source. In both cases, the files have had a > history of discussion within the PostgreSQL forums. I'm hoping, through > this question, to find

Re: [GENERAL] Problem V8.1.4 - providing pwd for commandline tools doesn't

> I don't understand why the change should be "more secure", > but I see that nobody took care about the possible > consequences for installation scripts, third party > applications and so on. :-((( If the installation scripts and third party apps followed the standard way of doing it, they wou

Re: [GENERAL] Problem in Pg 8.1.4 with CREATEDB

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Alexander Scholz > Sent: 31 May 2006 09:56 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Problem in Pg 8.1.4 with CREATEDB > > Yes, we have the same problem! Refer to the thread wi

Re: [GENERAL] strange stable function behavior

Thank you very much. It works!!!Where can I read about such features? 2006/6/1, Martijn van Oosterhout : On Thu, Jun 01, 2006 at 03:09:47PM +0400, Dan Black wrote:> Hi> I have a stable function test.test_stable> But if I want to display field sid twice>> SELECT id, sid, sid FROM

Re: [GENERAL] UTF-8 context of BYTEA datatype??

On Thu, 2006-06-01 at 02:00 +, Greg Sabino Mullane wrote: > #!perl > > package testone; > use DBI; > > printf "SQL_INTEGER is %d\n", SQL_INTEGER; > > package testtwo; > use DBI qw(:sql_types); > > printf "SQL_INTEGER is %d\n", SQL_INTEGER; But this is not as bad as having to "use DBD:Pg" (

Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

Philippe Lang a écrit : Hardware is much more powerful: intel server motherboard, dual-xeon 3GHz, SCSI disks (raid 1), 4GB RAM. Do you need the hyperthreading ? Depending on your case, you might have better results with 2x3GHz thant 4x1.5GHz. -- Arnaud ---(end of br

[GENERAL] GPL Licensed Files in 8.1.4

PostgreSQL 8.1.4 appears to have 2 GPL licensed files according to licenses embedded in the source.  In both cases, the files have had a history of discussion within the PostgreSQL forums.  I'm hoping, through this question,  to find more concrete information that the GPL code is really approved t

Re: [GENERAL] Best open source tool for database design / ERDs?

Anyone know if DIA will generate CREATE TABLE statements from an ER diagram? I'd like to have a program where I can create my db design, then be able to instantiate the design in PostgreSQL as well as MySQL. I'll pay for a good commercial tool if it costs less than USD $100. Thanks. --

Re: [GENERAL] Problem V8.1.4 - providing pwd for commandline tools doesn't

I don't understand why the change should be "more secure", but I see that nobody took care about the possible consequences for installation scripts, third party applications and so on. :-((( If you change such essential behaviour (the old behaviour of the commandline tools did work well since 8.0!

Re: [GENERAL] Best open source tool for database design / ERDs?

Thanks Thomas. That's too bad about DB Designer. I didn't realize it had been abandoned. What do y'all think of DIA? ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Insert into partition table hangs

I am still having the same problem. I tried to eliminate any possible network issues by placing the application on the server itself, but the same thing happened. However, I had an interesting discovery today that I don't understand. I left the insert query that was stuck running. Then, without c

Re: [GENERAL] Problem in Pg 8.1.4 with CREATEDB

Yes, we have the same problem! Refer to the thread with the subject "Problem V8.1.4 - providing pwd for commandline tools doesn't work anymore". They seem to have change the old behaviour of the commandline tools, which worked well since 8.0! I don't understand why the change should be "more secu

Re: [GENERAL] Restoring databases from a different installment on Windows

Bruno Wolff III wrote: > Yes it should work. There should be a recovery if postgres was running when > the boc crashed. > Note, you don't want to copy files out from under a running server to do > backups. That won't work. Actually, my situation is like this: I had a properly running version of P

Re: [GENERAL] strange stable function behavior

On Thu, Jun 01, 2006 at 03:09:47PM +0400, Dan Black wrote: > Hi > I have a stable function test.test_stable > But if I want to display field sid twice > > SELECT id, sid, sid FROM > (SELECT *, test.test_stable(id) AS sid FROM generate_series(10, 100) AS id) > tbl > > I can see that function te

[GENERAL] strange stable function behavior

HiI have a stable function test.test_stableCREATE OR REPLACE FUNCTION test.test_stable(int4)  RETURNS int4 AS$BODY$DECLARE  _param ALIAS FOR $1;BEGIN  RAISE NOTICE 'ID: %, TIME: %', _param, timeofday()::timestamp;   RETURN _param;END$BODY$  LANGUAGE 'plpgsql' STABLE STRICT SECURITY DEFINER;Everythi

Re: [GENERAL] SCSI disk: still the way to go?

Hi Alex,   thanks for the answer (thanks to the other guys too!). http://www.cdw.com/shop/products/default.aspx?EDC=912784 SATA - ~$320 Is there a particular reason why you chose a SATA-150 drive? What about SATA-300?Cheers,Riccardo

Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

About three years ago I did a test to compare the performance of an Apache-PHP-PostgreSQL web application on Linux vs. FreeBSD. I used the same machine with the then current versions of the said software. The results were better by 30-35% on FreeBSD. Since then I have been having the sneaking f

Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

Hi Tom, hi Ludwig, Thanks for your support. Yes, this query has grown very big with time, and I was always asked to add exceptions in it, so the result is quite frightening! >>> TOM: If you try setting enable_bitmapscan off, >>> you'll probably find 8.1 beating 7.4 handily for this query. Cor