Re: [ADMIN] disable auto-commit

> Anyway even if you do not commit the changes are stored > in the operating system disk cache and you cannot undo them. I disagree, witness the following : testbunker=> create table temptable ( testbunker-> foo int4, testbunker-> bar text testbunker-> ); CREATE testbunker=> insert into tempt

Re: [ADMIN] disable auto-commit

If are deleting something, then you probably want delete it... I mean that the DELETE command phisically removes some rows from a table, and after the command they are gone forever. If you want to delete something that can be restored later, then you are not actually deleting anything, you are

[ADMIN] postgres - initdb error

Ok, I am ready to pull my hair out, what I have left!! Here is what I got: RedHat Linux 6.2 on an PIII 733 dual processor with 1Gig RAM and 33 gig of drive space. What my problem is: During the installation of PostgreSQL 6.5.1, I execute the initdb command using the postgres user account. I ge

[ADMIN] Re: Postgres and Macintosh Clients

Samuel, you should have a look at RealBasic version Pro: Even if their PostgreSQL driver is (a bit) buggy, it allows access to your databases from MacOS. There's also a PostgreSQL extension to Frontier, a widely used cross-platform scripting tool:

Re: [ADMIN] Create Procedure syntax

> "S" == Sivagami <[EMAIL PROTECTED]> writes: S> [1 ] S> Hi, S> I have 3 simple questions: S> 1. What is the exact syntax to create a procedure? CREATE FUNCTION name ( [ ftype [, ...] ] ) RETURNS rtype AS definition LANGUAGE 'langname' [ WITH ( attribute [, ...] )