Re: [GENERAL] Cannot Start Postgres After System Boot

2010-10-21 Thread Lennin Caro
--- On Thu, 10/21/10, Reid Thompson wrote: From: Reid Thompson Subject: Re: [GENERAL] Cannot Start Postgres After System Boot To: "Rich Shepard" Cc: pgsql-general@postgresql.org Date: Thursday, October 21, 2010, 4:28 AM On 10/20/2010 6:53 PM, Rich Shepard wrote: >   For reasons I do not unders

Re: [GENERAL] How to merge data from two separate databases into one (maybe using xlogs)?

2010-10-27 Thread Lennin Caro
--- On Wed, 10/27/10, Vick Khera wrote: From: Vick Khera Subject: Re: [GENERAL] How to merge data from two separate databases into one (maybe using xlogs)? To: "pgsql-general" Date: Wednesday, October 27, 2010, 8:26 PM On Wed, Oct 27, 2010 at 9:58 AM,  wrote: > So, the question would be: How

Re: [GENERAL] Partial Index Too Literal?

2008-06-26 Thread Lennin Caro
use this explain analyze select * from result where active = 't'; --- On Thu, 6/26/08, Phillip Mills <[EMAIL PROTECTED]> wrote: From: Phillip Mills <[EMAIL PROTECTED]> Subject: [GENERAL] Partial Index Too Literal? To: pgsql-general@postgresql.org Date: Thursday, June 26, 2008, 7:24 PM Under some

Re: [GENERAL] Undocumented Postgres error: "failed to fetch old tuple for AFTER trigger"

2008-06-26 Thread Lennin Caro
the table o tables have triggers? try to use  COMMIT --- On Thu, 6/26/08, Robert James <[EMAIL PROTECTED]> wrote: From: Robert James <[EMAIL PROTECTED]> Subject: [GENERAL] Undocumented Postgres error: "failed to fetch old tuple for AFTER trigger" To: "Postgres General" Date: Thursday, June 26, 2

Re: [GENERAL] ERROR: concurrent insert in progress

2008-06-27 Thread Lennin Caro
use REINDEX http://www.postgresql.org/docs/8.3/static/sql-reindex.html tell us the result thank --- On Fri, 6/27/08, Ganbold <[EMAIL PROTECTED]> wrote: From: Ganbold <[EMAIL PROTECTED]> Subject: [GENERAL] ERROR: concurrent insert in progress To: pgsql-general@postgresql.org Date: Friday, Jun

Re: [GENERAL] ERROR: concurrent insert in progress

2008-06-27 Thread Lennin Caro
use REINDEX REINDEX ip_dst_idx OR REINDEX table_name http://www.postgresql.org/docs/8.3/static/sql-reindex.html tell us the result thank --- On Fri, 6/27/08, Ganbold <[EMAIL PROTECTED]> wrote: From: Ganbold <[EMAIL PROTECTED]> Subject: [GENERAL] ERROR: concurrent insert in progress To:

Re: [GENERAL] Advice Wanted on Selecting Multi-row Data Requests in 10-Row Blocks

2008-06-27 Thread Lennin Caro
use a dynamic select in the web page $1 = 10 $2 = 5 select * from mytable limit $1 OFFSET $2 --- On Fri, 6/27/08, Bill Thoen <[EMAIL PROTECTED]> wrote: From: Bill Thoen <[EMAIL PROTECTED]> Subject: [GENERAL] Advice Wanted on Selecting Multi-row Data Requests in 10-Row Blocks To: pgsql-general@p

Re: [GENERAL] connecting to a remote pq always require a password

2009-06-18 Thread Lennin Caro
--- On Thu, 6/18/09, David Shen wrote: > From: David Shen > Subject: [GENERAL] connecting to a remote pq always require a password > To: pgsql-general@postgresql.org > Date: Thursday, June 18, 2009, 12:11 PM > Hi, > > I am trying to use the libpq to connect to my postgresql > 8.3 server. > I

Re: [GENERAL] Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function

2009-06-29 Thread Lennin Caro
--- On Mon, 6/29/09, Tguru wrote: > From: Tguru > Subject: Re: [GENERAL] Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql > function > To: pgsql-general@postgresql.org > Date: Monday, June 29, 2009, 1:33 PM > > To migrate the site, you can use an open source ETL tool. > > Talend Open

Re: [GENERAL] simulate multiple primary keys

2009-07-02 Thread Lennin Caro
--- On Thu, 7/2/09, Brandon Metcalf wrote: > From: Brandon Metcalf > Subject: [GENERAL] simulate multiple primary keys > To: pgsql-general@postgresql.org > Date: Thursday, July 2, 2009, 5:27 PM > I have the following table: > >   gms=> \d jobclock >                 >                 >      

Re: [GENERAL] No buffer space available

2009-09-01 Thread Lennin Caro
use pgpool to handle many connections Lennin Caro Pérez Usuario:GNU/LINUX PHP Developer PostgreSQL DBA Oracle DBA Linux counter id 474393

Re: [GENERAL] Ungooglable error message when running initdb: Symbol not found: _check_encoding_conversion_args

2009-09-02 Thread Lennin Caro
- On Wed, 9/2/09, August Lilleaas wrote: From: August Lilleaas Subject: [GENERAL] Ungooglable error message when running initdb: Symbol not found: _check_encoding_conversion_args To: pgsql-general@postgresql.org Date: Wednesday, September 2, 2009, 7:52 AM Hello there, I'm configuring with `./

Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread Lennin Caro
--- On Thu, 7/7/11, Craig Ringer wrote: From: Craig Ringer Subject: Re: [GENERAL] Oracle to Postgres migration open source tool To: "akp geek" Cc: "pgsql-general" Date: Thursday, July 7, 2011, 2:02 PM On 7/07/2011 9:55 PM, akp geek wrote: > Hi all - > >                 Are there any open sou

Re: [GENERAL] [9.0] On temporary tables

2010-09-30 Thread Lennin Caro
--- On Thu, 9/30/10, Vincenzo Romano wrote: From: Vincenzo Romano Subject: [GENERAL] [9.0] On temporary tables To: "PostgreSQL General" Date: Thursday, September 30, 2010, 11:09 AM Hi all. This is my case: -- begin snippet -- reset search_path; drop table if exists session cascade; create ta

Re: [GENERAL] Query

2008-06-30 Thread Lennin Caro
see trigger and estatus select tgname,tgenabled from pg_catalog.pg_trigger --- On Mon, 6/30/08, kartik <[EMAIL PROTECTED]> wrote: From: kartik <[EMAIL PROTECTED]> Subject: [GENERAL] Query To: pgsql-general@postgresql.org Date: Monday, June 30, 2008, 9:55 AM Hello , I am a beginner

Re: [GENERAL] Delete from Join

2008-07-02 Thread Lennin Caro
--- On Wed, 7/2/08, Gwyneth Morrison <[EMAIL PROTECTED]> wrote: > From: Gwyneth Morrison <[EMAIL PROTECTED]> > Subject: [GENERAL] Delete from Join > To: pgsql-general@postgresql.org > Date: Wednesday, July 2, 2008, 3:15 PM > Hello, > > Is it possible to use a join keyword in a delete? > > For

Re: [GENERAL] Delete from Join

2008-07-03 Thread Lennin Caro
--- On Wed, 7/2/08, Gwyneth Morrison <[EMAIL PROTECTED]> wrote: > From: Gwyneth Morrison <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] Delete from Join > To: pgsql-general@postgresql.org > Date: Wednesday, July 2, 2008, 7:12 PM > --- On Wed, 7/2/08, Gwyneth Morrison > <[EMAIL PROTECTED]> wrote:

Re: [GENERAL] pg_ctl start check sum failed

2008-07-03 Thread Lennin Caro
use... ps auxw | grep postgres --- On Wed, 7/2/08, Fernando Dominguez <[EMAIL PROTECTED]> wrote: > From: Fernando Dominguez <[EMAIL PROTECTED]> > Subject: [GENERAL] pg_ctl start check sum failed > To: pgsql-general@postgresql.org > Date: Wednesday, July 2, 2008, 11:30 PM > Hello, > > I try

Re: [GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-07 Thread Lennin Caro
sound like you have a postmaster.pid in your PGDATA directory. Rename file postmaster.pid and launch the postgresql again --- On Sat, 7/5/08, Scott Frankel <[EMAIL PROTECTED]> wrote: > From: Scott Frankel <[EMAIL PROTECTED]> > Subject: [GENERAL] roll back to 8.1 for PyQt driver work-around > To:

Re: [GENERAL] To store and retrive image data in postgresql

2008-07-07 Thread Lennin Caro
for hot_backup and restore check this http://www.postgresql.org/docs/8.3/static/continuous-archiving.html for logic backup (dump) use this http://www.postgresql.org/docs/8.3/static/app-pgdump.html --- On Mon, 7/7/08, aravind chandu <[EMAIL PROTECTED]> wrote: > From: aravind chandu <[EMAIL P

Re: [GENERAL] SPACE FOR POSTGRESQL DATABASE

2008-07-10 Thread Lennin Caro
in this link have information about database size http://www.postgresql.org/docs/8.1/static/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE --- On Thu, 7/10/08, aravind chandu <[EMAIL PROTECTED]> wrote: > From: aravind chandu <[EMAIL PROTECTED]> > Subject: [GENERAL] SPACE FOR POSTGRESQL DATABASE >

Re: [GENERAL] Initdb problem on debian mips cobalt: Bus error

2008-07-18 Thread Lennin Caro
--- On Fri, 7/18/08, Glyn Astill <[EMAIL PROTECTED]> wrote: > From: Glyn Astill <[EMAIL PROTECTED]> > Subject: [GENERAL] Initdb problem on debian mips cobalt: Bus error > To: pgsql-general@postgresql.org > Date: Friday, July 18, 2008, 10:26 AM > Hi Chaps, > > I'm attempting to run 8.3.3 on an

Re: [GENERAL] Clone a database to other machine

2008-07-28 Thread Lennin Caro
you can use slony-i http://slony.info/ --- On Mon, 7/28/08, Garg, Manjit <[EMAIL PROTECTED]> wrote: > From: Garg, Manjit <[EMAIL PROTECTED]> > Subject: [GENERAL] Clone a database to other machine > To: pgsql-general@postgresql.org > Date: Monday, July 28, 2008, 4:44 PM > Hi All, > > I'm stuck

Re: [GENERAL] CAST(integer_field AS character) truncates trailing zeros

2008-07-31 Thread Lennin Caro
--- On Thu, 7/31/08, Warren Bell <[EMAIL PROTECTED]> wrote: > From: Warren Bell <[EMAIL PROTECTED]> > Subject: [GENERAL] CAST(integer_field AS character) truncates trailing zeros > To: pgsql-general@postgresql.org > Date: Thursday, July 31, 2008, 8:03 PM > I am trying to cast an int to a charac

Re: [GENERAL] eliminating records not in (select id ... so SLOW?

2008-07-31 Thread Lennin Caro
--- On Thu, 7/31/08, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: > From: Ivan Sergio Borgonovo <[EMAIL PROTECTED]> > Subject: [GENERAL] eliminating records not in (select id ... so SLOW? > To: "PostgreSQL" > Date: Thursday, July 31, 2008, 9:45 PM > I'm doing something like: > > delete fr

Re: [GENERAL] eliminating records not in (select id ... so SLOW?

2008-08-01 Thread Lennin Caro
; > Subject: Re: [GENERAL] eliminating records not in (select id ... so SLOW? > To: > Cc: "PostgreSQL" > Date: Thursday, July 31, 2008, 11:01 PM > On Thu, 31 Jul 2008 14:59:29 -0700 (PDT) > Lennin Caro <[EMAIL PROTECTED]> wrote: > > > > The box is a 2x dua

Re: [GENERAL] recovery via base + WAL replay failure

2008-08-04 Thread Lennin Caro
what error show the log file? --- On Mon, 8/4/08, Greg Smith <[EMAIL PROTECTED]> wrote: > From: Greg Smith <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] recovery via base + WAL replay failure > To: "Rob Adams" <[EMAIL PROTECTED]> > Cc: "postgres general" > Date: Monday, August 4, 2008, 5:58 PM >

Re: [GENERAL] Create Table Dinamic

2008-08-07 Thread Lennin Caro
try whit this http://www.postgresql.org/docs/8.3/interactive/ecpg-dynamic.html --- On Thu, 8/7/08, Anderson dos Santos Donda <[EMAIL PROTECTED]> wrote: > From: Anderson dos Santos Donda <[EMAIL PROTECTED]> > Subject: [GENERAL] Create Table Dinamic > To: pgsql-general@postgresql.org > Date: Thur

Re: [GENERAL] ALTER ROLE role-name-with-hyphen

2008-08-08 Thread Lennin Caro
use the double quotes (") ALTER USER "foo-bar" WITH ENCRYPTED PASSWORD 'foo-bar' --- On Fri, 8/8/08, Tom Copeland <[EMAIL PROTECTED]> wrote: > From: Tom Copeland <[EMAIL PROTECTED]> > Subject: [GENERAL] ALTER ROLE role-name-with-hyphen > To: pgsql-general@postgresql.org > Date: Friday, August 8

Re: [GENERAL] automatic REINDEX-ing

2008-08-12 Thread Lennin Caro
you can use a cron job --- On Tue, 8/12/08, Joao Ferreira gmail <[EMAIL PROTECTED]> wrote: > From: Joao Ferreira gmail <[EMAIL PROTECTED]> > Subject: [GENERAL] automatic REINDEX-ing > To: "pgsql-general" > Date: Tuesday, August 12, 2008, 3:13 PM > Hello all > > [[[ while dealing with a disk si

Re: [GENERAL] schema name in SQL statement.

2008-08-20 Thread Lennin Caro
--- On Tue, 8/19/08, Masis, Alexander (US SSA) <[EMAIL PROTECTED]> wrote: > From: Masis, Alexander (US SSA) <[EMAIL PROTECTED]> > Subject: [GENERAL] schema name in SQL statement. > To: pgsql-general@postgresql.org > Date: Tuesday, August 19, 2008, 10:52 PM > I have to explicitly specify the sch

Re: [GENERAL] PITR - base backup question

2008-08-27 Thread Lennin Caro
--- On Tue, 8/26/08, Richard Broersma <[EMAIL PROTECTED]> wrote: > From: Richard Broersma <[EMAIL PROTECTED]> > Subject: [GENERAL] PITR - base backup question > To: "pgsql-general@postgresql.org" , [EMAIL > PROTECTED] > Date: Tuesday, August 26, 2008, 10:53 PM > From the following link: > http

Re: [GENERAL] MySQL LAST_INSERT_ID() to Postgres

2008-09-01 Thread Lennin Caro
--- On Thu, 8/28/08, Masis, Alexander (US SSA) <[EMAIL PROTECTED]> wrote: > From: Masis, Alexander (US SSA) <[EMAIL PROTECTED]> > Subject: [GENERAL] MySQL LAST_INSERT_ID() to Postgres > To: pgsql-general@postgresql.org > Date: Thursday, August 28, 2008, 4:14 PM > I was mapping C++ application c

Re: [GENERAL] Postgres does not start, gives no error

2008-09-04 Thread Lennin Caro
--- On Wed, 9/3/08, Akhtar Yasmin-B05532 <[EMAIL PROTECTED]> wrote: > From: Akhtar Yasmin-B05532 <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] Postgres does not start, gives no error > To: "Tom Lane" <[EMAIL PROTECTED]> > Cc: "Joshua Drake" <[EMAIL PROTECTED]>, pgsql-general@postgresql.org > Dat

Re: [GENERAL] Postgres does not start, gives no error

2008-09-04 Thread Lennin Caro
--- On Wed, 9/3/08, Akhtar Yasmin-B05532 <[EMAIL PROTECTED]> wrote: > From: Akhtar Yasmin-B05532 <[EMAIL PROTECTED]> > Subject: [GENERAL] Postgres does not start, gives no error > To: pgsql-general@postgresql.org > Date: Wednesday, September 3, 2008, 7:11 PM > HI, > > I am facing this pecilia

Re: [GENERAL] 3 postgres processes

2008-09-09 Thread Lennin Caro
--- On Tue, 9/9/08, Markova, Nina <[EMAIL PROTECTED]> wrote: > From: Markova, Nina <[EMAIL PROTECTED]> > Subject: [GENERAL] 3 postgres processes > To: pgsql-general@postgresql.org > Date: Tuesday, September 9, 2008, 2:50 PM > Hi, > > After issuning initdb and starting the postgres server, I > che

Re: [GENERAL] how to return the first record from the sorted records which may have duplicated value.

2008-09-19 Thread Lennin Caro
--- On Fri, 9/19/08, Yi Zhao <[EMAIL PROTECTED]> wrote: > From: Yi Zhao <[EMAIL PROTECTED]> > Subject: [GENERAL] how to return the first record from the sorted records > which may have duplicated value. > To: "pgsql-general" > Date: Friday, September 19, 2008, 8:51 AM > hi all: > I have a tab

Re: [GENERAL] Error in ALTER DATABASE command

2008-09-24 Thread Lennin Caro
--- On Tue, 9/23/08, William Garrison <[EMAIL PROTECTED]> wrote: > From: William Garrison <[EMAIL PROTECTED]> > Subject: [GENERAL] Error in ALTER DATABASE command > To: "Postgres General List" > Date: Tuesday, September 23, 2008, 3:49 PM > In Postgresql 8.2.9 on Windows, you cannot rename a da

Re: [GENERAL] Counting unique rows as an aggregate.

2008-09-30 Thread Lennin Caro
--- On Tue, 9/30/08, r_musta <[EMAIL PROTECTED]> wrote: > From: r_musta <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] Counting unique rows as an aggregate. > To: pgsql-general@postgresql.org > Date: Tuesday, September 30, 2008, 6:55 AM > On Sep 30, 2:36 am, [EMAIL PROTECTED] (Tom Lane) wrote: >

Re: re[GENERAL] moving a portion of text

2008-10-20 Thread Lennin Caro
--- On Mon, 10/20/08, pere roca <[EMAIL PROTECTED]> wrote: > From: pere roca <[EMAIL PROTECTED]> > Subject: re[GENERAL] moving a portion of text > To: pgsql-general@postgresql.org > Date: Monday, October 20, 2008, 11:21 AM > hi, > I have a column with full of data like ATB-OO NCK-TT > h

Re: [GENERAL] INSERT with RETURNING clause inside SQL function

2008-11-04 Thread Lennin Caro
> Hi all, > > I'm re-writing some functions and migrating bussines > logic from a > client application to PostgreSQL. > > I expected something like this to work, but it doesn't: > > -- simple table > CREATE TABLE sometable ( >id SERIAL PRIMARY KEY, >text1 text, >text2 text > ); > >

Re: [GENERAL] ERROR

2008-11-17 Thread Lennin Caro
> From: Gustavo Rosso <[EMAIL PROTECTED]> > Subject: [GENERAL] ERROR > To: pgsql-general@postgresql.org > Date: Monday, November 17, 2008, 3:08 PM > I create a db wiht user postgres, but other users can't > no create tables, and I give all privileges. > > (banco is my db) > > grant all on databas

[GENERAL] alocate table in memory and multui listener

2008-12-18 Thread Lennin Caro
I have two cuestion: 1- postgresql have the method to allocate a table in memory 2- In postgresql can have multiple port to listen thank... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/p

Re: [GENERAL] inconsistency in aliasing

2009-01-14 Thread Lennin Caro
--- On Wed, 1/14/09, Louis-David Mitterrand wrote: > From: Louis-David Mitterrand > Subject: Re: [GENERAL] inconsistency in aliasing > To: pgsql-general@postgresql.org > Date: Wednesday, January 14, 2009, 11:27 AM > On Wed, Jan 14, 2009 at 12:06:47PM +0100, A. Kretschmer > wrote: > > In respons

Re: [GENERAL] pg_hba reload

2009-02-15 Thread Lennin Caro
--- On Sat, 2/14/09, Bob Pawley wrote: > From: Bob Pawley > Subject: Re: [GENERAL] pg_hba reload > To: "John R Pierce" , "PostgreSQL" > > Date: Saturday, February 14, 2009, 11:31 PM > I'm running 8.3 on Windows XP. > > I input > pg_ctl reload -D c:\program > files\postgresql\8.3\data- or

Re: [GENERAL] ask: select right(column) ???

2009-02-16 Thread Lennin Caro
> I have simple question > I tried following code > > select right(column, number_of_character) from table > > but it didn't work, saying that pg doesn't have the > function > is there any way to achieve such output? > > honestly I have no idea that such simple feature > doesn't exist in post

Re: [GENERAL] connecting using libpq breaks printf

2009-02-18 Thread Lennin Caro
> This is my first attempt at using libpq, and I'm running > across a strange > problem. Here is my bare-bones program: > > #include > #include "libpq-fe.h" > > int main(int argc, char **argv) { > PGconn *conn; > fprintf(stderr, "connecting\n"); > conn = PQconnectdb("dbname=postgres"); >

Re: [GENERAL] Problem setting up PostgreSQL

2009-02-26 Thread Lennin Caro
--- On Wed, 2/25/09, Bill Herbert wrote: > From: Bill Herbert > Subject: [GENERAL] Problem setting up PostgreSQL > To: "pgsql-general@postgresql.org" > Date: Wednesday, February 25, 2009, 4:30 AM > Hello, > > I am attempting to install PostgreSQL. I downloaded > 8.2.12-1zip from ftp9.us.pos