[GENERAL] Don't understand transaction error

I'm getting the following error when attempting to use my application: ERROR: current transaction is aborted, commands ignored until end of transaction block I have no clue... the only idea I have is to somehow release any transaction locks, but I don't how to list, or even if possible, to list

Re: [GENERAL] Adding contrib modules

Jonathan Villa schrieb: Thanks... at least know I'm doing to correctly... but I still get the errors. I've done everything as it states on the tsearch-V2-intro.html page... and then I run psql ftstest tsearch2.sql fts.out for testing of course the fts.out file has things like

Re: [GENERAL] Adding contrib modules

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonathan Villa schrieb: Yes, I'm running on Linux I did not try ldconfig, however I just have... and same result tsearch2.so is in /usr/local/pgsql/lib and my home /usr/local/pgsql Also, logs say the same thing that fts.out says I'm

Re: [GENERAL] Adding contrib modules

Jonathan Villa schrieb: I'm having some trouble getting one of the contrib modules to load correctly... it's for tsearch2.sql I've tried ./configure --prefix=/usr/local/pgsql gmake all gmake install and I've also tried, from the contrib/tsearch2/ dir, gmake but that fails when

Re: [GENERAL] Adding contrib modules

Jonathan Villa schrieb: thanks, that seemed to work ok... now.. how do I use tsearch2? meaning, how do I run the script? is it against the database I was to use it with? example psql -d mytestdb tsearch2.sql Granted, this is a new database that has not worked with tsearch2 before

[GENERAL] Adding contrib modules

I'm having some trouble getting one of the contrib modules to load correctly... it's for tsearch2.sql I've tried ./configure --prefix=/usr/local/pgsql gmake all gmake install and I've also tried, from the contrib/tsearch2/ dir, gmake but that fails when looking for flex, which by the way, is

Re: [GENERAL] how to select

project_name from project_group_list; ... ... ... that's odd... -Jonathan quote who=Brian Wong On 7/29/05, Jonathan Villa [EMAIL PROTECTED] wrote: now I want to select #select someColumn from testtable I get nothing... no output, nothing... Try terminating the statement

Re: [GENERAL] how to select

-Jonathan quote who=Jaime Casanova On 7/29/05, Jonathan Villa [EMAIL PROTECTED] wrote: Ok, this is odd... I tried ending with a semicolon before, and received this error ERROR: parser: parse error at or near select I have to do it twice before I get it works...here's an example

[GENERAL] Upgrading from 7.1

I've been googling a little bit and appears that 7.1 pretty old. What steps are advised to upgrade from 7.1 to 7.4? -Jonathan ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Upgrading from 7.1

quote who=Richard Huxton Jonathan Villa wrote: I've been googling a little bit and appears that 7.1 pretty old. What steps are advised to upgrade from 7.1 to 7.4? 1. Dump the old db using 7.4's pg_dump. 2. Read the release notes for the in-between versions to make sure nothing will impact

Re: [GENERAL] Upgrading from 7.1

Interesting, How would I specify the order of the tables on the commandline To Thomas: I decided to separate the schema/data export/import to make sure the schema was at least being created correctly... How can I export one table by itself? Not just table, but a view/trigger, etc... Is it

[GENERAL] Segmentation Fault using PHP code

I'm trying to add some functionality to an already existing application...this applications works fine, and uses the PHP function pg_pconnect to make a persistent connection to the database. This works very well. My part is to make a new non-persistent connection (or whatever), to a newly

[GENERAL] created databases as other users...

Is it possible to create a database to be owned by a user that only exists to postgresql or do they have to be shell accounts as well. $ createdb --owner=testcon testdb but the owner ends up being postgres I'm planning to create a different database for each different project I have. I want

Re: [GENERAL] created databases as other users...

For some reason, I never tried $psql --username=testcon testdb I'm trying to use phpPGAdmin at the same time...I guess I was having a tough time using both... thanks Tom for the reply. On Mon, 2004-10-11 at 16:01, Tom Lane wrote: Jonathan Villa [EMAIL PROTECTED] writes: $ createdb --owner

[GENERAL] Converting to Java date example

Quick question, hopefully... How do you store a date in Postgresql using Java date format, i.e. 2004-00-01 where that would be January 1, 2004 (looking for the 00 as Jan.) I've googled but only found someone else with the same problem. ---(end of