[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

27;m trying to get upgraded does not give it it's seal of approval. -Jonathan > 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 p

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 eve

[GENERAL] how to select

Ok, I should be posting this to the kindergarden list... but I didn't subscribe... I've connected to a database psql -l testdb showed tables \d show table schema \d testtable now I want to select #select someColumn from testtable I get nothing... no output, nothing... I'm used to MySQL whe

Re: [GENERAL] how to select

or near "select" select project_name from project_group_list; ... ... ... that's odd... -Jonathan > On 7/29/05, Jonathan Villa <[EMAIL PROTECTED]> wrote: >> now I want to select >> #select someColumn from testtable >> >> I get nothing.

Re: [GENERAL] how to select

-Jonathan > 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" >> >&

[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] 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 &g

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 >> >>

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 &> ft

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/lo

[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

[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 created

[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 the

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:

[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 broadcast)--