--- 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
--- 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
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
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
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
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:
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
--- 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
--- 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
--- 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
>
>
>
use pgpool to handle many connections
Lennin Caro Pérez
Usuario:GNU/LINUX
PHP Developer
PostgreSQL DBA
Oracle DBA
Linux counter id 474393
- 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 `./
--- 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
--- 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
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
--- 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
--- 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:
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
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:
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
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
>
--- 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
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
--- 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
--- 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
;
> 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
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
>
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
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
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
--- 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
--- 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
--- 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
--- 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
--- 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
--- 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
--- 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
--- 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
--- 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:
>
--- 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
> 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
> );
>
>
> 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
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
--- 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
--- 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
> 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
> 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");
>
--- 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
48 matches
Mail list logo