ly starts a transaction and
ALL the changes you do are recorder but never commited until you press
a specified button (commit ro rollback). Also, on errors I am not
forced to press any button, it just automatically rollbacks (as I have
no other choice anyway).
On 5/12/05, Andreas Pflug <[EMAIL PR
Anyone has an idea? On the subject?
-- Forwarded message --
From: Tom Lane <[EMAIL PROTECTED]>
Date: May 12, 2005 5:43 PM
Subject: Re: [NOVICE] Autocommit in Postgresql
To: Vitaly Belman <[EMAIL PROTECTED]>
Cc: Olivier Thauvin <[EMAIL PROTECTED]>, Postgre
>From simple to complex:
1) Smart tabs: It is a standard in most editing programs. If user TABs
and then presses enter, the cursor should keep the tab position.
2) Upper case for keywords: How about UPPERCASING the keywords of SQL/plpgsql?
3) A bit complex but sure would come handy. I wish there
I have the following problem, when I am editing a function in PGAdmin
that is not in a public schema yet that it is in the search_path and
doing apply it does the following:
CREATE OR REPLACE FUNCTION blabla();
Meaning it omits the schema name and so even though the function I
edited was not in p