$ psql --version
psql (PostgreSQL) 7.4.1
contains support for command-line editing

# SELECT version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk)
(1 row)



Michael Fuhr wrote:

On Fri, Jan 14, 2005 at 06:11:27PM +0000, Bradley Kieser wrote:



Okay, Michael gets that trophy! Thanks Michael, it needed a commit.
However, this is odd. I get a "No transaction in progress" error coming out on the commit, but at least it works, so I am happy!



What version of the client and server are you using? For the client run "psql --version"; for the server execute "SELECT version();". Where do you have autocommit set? PostgreSQL 7.4 removed autocommit from the server and added it to the client; I wonder if you're using differing client and server versions that are causing confusion.




---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to