Re: [GENERAL] PgUS 501c3 Public Charity

Joshua D. Drake wrote: > Hello, > > Yeah its not general technical discussion but this little bit of news > warrants more widely read attention. PgUS (http://www.postgresql.us/) > received its 501c3 public charity status today. You can view the > determination letter here: > > https://www.postgr

Re: [GENERAL] date ranges in where

Erik Jones wrote: On May 6, 2009, at 2:19 PM, Adrian Klaver wrote: On Wednesday 06 May 2009 2:12:47 pm Miguel Miranda wrote: Hi, what is the recommended way to select a range of dates? Lets say a have a table with a lastlogin (timestamp) column and i want toknow what users logged in for last

Re: [GENERAL] Transaction settings: nowait

durumdara wrote: If set wait and timeout, the Firebird is waiting for the locked resource (record) for X seconds before it show deadlock error. But when you set no wait, the deadlock error immediately shown by the server. Waiting on a lock doesn't mean there's a deadlock. A deadlock only o

Re: [GENERAL] PGSQL x iptables

Slansky Lukas wrote: Craig Ringer wrote: After a long period of inactivity, perhaps? Is 15 seconds long period? I don't think so. No. If you see a connection that was working 15 and active seconds ago suddenly die, it's not due to time-based state table expiry. Do you see anything in `dme

Re: [GENERAL] PgUS 501c3 Public Charity

On Wed, May 6, 2009 at 4:53 PM, Joshua D. Drake wrote: > Hello, > > Yeah its not general technical discussion but this little bit of news > warrants more widely read attention. PgUS (http://www.postgresql.us/) > received its 501c3 public charity status today. You can view the > determination lette

Re: [GENERAL] date ranges in where

On May 6, 2009, at 2:59 PM, Adrian Klaver wrote: On Wednesday 06 May 2009 2:51:08 pm Erik Jones wrote: On May 6, 2009, at 2:48 PM, Miguel Miranda wrote: Well, i tried all your sugestions, and i found some funny issues, i use the query to count exactly in a day by day basis, and running the qu

Re: [GENERAL] date ranges in where

On May 6, 2009, at 2:55 PM, Miguel Miranda wrote: On Wed, May 6, 2009 at 3:51 PM, Erik Jones wrote: On May 6, 2009, at 2:48 PM, Miguel Miranda wrote: Well, i tried all your sugestions, and i found some funny issues, i use the query to count exactly in a day by day basis, and running

Re: [GENERAL] XML -> PG ?

On May 6, 2009, at 4:16 PM, Eric Schwarzenbach wrote: Gauthier, Dave wrote: Is there a way to read an XML file into a postgres DB? I’m thinking that it will create and relate whatever tables are necessary to reflect whatever’s implied by the XML file structure. Thanks for any pointers !

Re: [GENERAL] date ranges in where

On Wednesday 06 May 2009 2:51:08 pm Erik Jones wrote: > On May 6, 2009, at 2:48 PM, Miguel Miranda wrote: > > Well, i tried all your sugestions, and i found some funny issues, i > > use the query to count exactly in a day by day basis, and running > > the query with > > > > WHERE lastlogin >= '2009

Re: [GENERAL] date ranges in where

sorry, i edited the date, the correct one is 05-03-2009 12:00:00 AM If i group by day, it count 1 user for day 2009-05-03 in the output, so it adds 1 to the total count of the range regards On Wed, May 6, 2009 at 3:51 PM, Erik Jones wrote: > > On May 6, 2009, at 2:48 PM, Miguel Miranda wrote

[GENERAL] PgUS 501c3 Public Charity

Hello, Yeah its not general technical discussion but this little bit of news warrants more widely read attention. PgUS (http://www.postgresql.us/) received its 501c3 public charity status today. You can view the determination letter here: https://www.postgresql.us/determination_letter Thanks to

Re: [GENERAL] date ranges in where

On May 6, 2009, at 2:48 PM, Miguel Miranda wrote: Well, i tried all your sugestions, and i found some funny issues, i use the query to count exactly in a day by day basis, and running the query with WHERE lastlogin >= '2009-05-01' AND lastlogin < '2009-05-03' OR WHERE lastlogin >= 'X' AN

Re: [GENERAL] date ranges in where

Well, i tried all your sugestions, and i found some funny issues, i use the query to count exactly in a day by day basis, and running the query with WHERE lastlogin >= '2009-05-01' AND lastlogin < '2009-05-03' OR WHERE lastlogin >= 'X' AND lastlogin <= 'Y' + '1 day'::interval it includes the 0

Re: [GENERAL] XML -> PG ?

Gauthier, Dave wrote: Is there a way to read an XML file into a postgres DB? I’m thinking that it will create and relate whatever tables are necessary to reflect whatever’s implied by the XML file structure. Thanks for any pointers ! As others have said, the fundamental problem is that ge

Re: [GENERAL] date ranges in where

On May 6, 2009, at 2:19 PM, Adrian Klaver wrote: On Wednesday 06 May 2009 2:12:47 pm Miguel Miranda wrote: Hi, what is the recommended way to select a range of dates? Lets say a have a table with a lastlogin (timestamp) column and i want toknow what users logged in for last time between 20

Re: [GENERAL] date ranges in where

On May 6, 2009, at 2:17 PM, Erik Jones wrote: On May 6, 2009, at 2:12 PM, Miguel Miranda wrote: Hi, what is the recommended way to select a range of dates? Lets say a have a table with a lastlogin (timestamp) column and i want toknow what users logged in for last time between 2009-05-01

Re: [GENERAL] XML -> PG ?

Gauthier, Dave wrote: > > Is there a way to read an XML file into a postgres DB? I’m thinking > that it will create and relate whatever tables are necessary to > reflect whatever’s implied by the XML file structure. > > > > Thanks for any pointers ! > That's a pretty common problem, and not one

Re: [GENERAL] date ranges in where

On Wednesday 06 May 2009 2:12:47 pm Miguel Miranda wrote: > Hi, what is the recommended way to select a range of dates? > > Lets say a have a table with a lastlogin (timestamp) column and i want > toknow what users logged in for last time between 2009-05-01 and > 2009-05-02? > > I know that a simpl

Re: [GENERAL] date ranges in where

On May 6, 2009, at 2:12 PM, Miguel Miranda wrote: Hi, what is the recommended way to select a range of dates? Lets say a have a table with a lastlogin (timestamp) column and i want toknow what users logged in for last time between 2009-05-01 and 2009-05-02? I know that a simple where la

Re: [GENERAL] date ranges in where

On 06/05/2009 22:12, Miguel Miranda wrote: > Hi, what is the recommended way to select a range of dates? > > Lets say a have a table with a lastlogin (timestamp) column and i want > toknow what users logged in for last time between 2009-05-01 and 2009-05-02? > > I know that a simple > > where la

[GENERAL] date ranges in where

Hi, what is the recommended way to select a range of dates? Lets say a have a table with a lastlogin (timestamp) column and i want toknow what users logged in for last time between 2009-05-01 and 2009-05-02? I know that a simple where lastlogin between '2009-05-01' and '2009-05-02' doesnt work b

[GENERAL] Question on pg_xlog and pg_control placement

Hi, I'm installing a new 8.3.7 system and have a question on placement locations for pg_xlog and pg_control. I've read in the documentation pertaining to pg_xlog, that it may be "...of advantage if the log is located on another disk than the main database files." As PostGRES is installed on one

[GENERAL] WARNING: silent data corruption possible from PL/ruby 0.5.0 (after Ruby upgrade)

Dear all, since upgrading Ruby from 1.8.6.287 to 1.8.7.72, and recompiling PL/ruby 0.5.0, functions written in PL/ruby may ignore their given parameters and instead compute with undefined values, providing nonsense results. The test-suite provided with PL/ruby will show the problem. Upgrading

Re: [GENERAL] Is thre a way?

On 06/05/2009 21:28, Anderson dos Santos Donda wrote: > I have a table with 2000 names and emails.. and I did UPDATE list SET > email = '' without the WHERE and now all rows is null in column > email.. They're not null, they're just filled with empty strings :-) > I have a backup made with

Re: [GENERAL] Is thre a way?

Look at the cheat-sheet: http://www.postgresonline.com/journal/index.php?/archives/63-PostgreSQL- 8.3-Pg_dump-Pg_Restore-Cheatsheet-Overview.html From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Anderson dos Santos Donda Sent: Wednesday, May

[GENERAL] Is thre a way?

Hi o/ I have a table with 2000 names and emails.. and I did UPDATE list SET email = '' without the WHERE and now all rows is null in column email.. I have a backup made with pg_dump.. is there a way to restore only the email data? Thanks!!

Re: [GENERAL] Postgres partially hang after inactivity

On Wed, May 6, 2009 at 12:48 PM, Marco Maccaferri wrote: > Hi. > > I have a weird problem with PostgreSQL on a Windows machine. This is a test > installation used to beta test a webapplication running with Tomcat, so most > of the times it sits idle. Yesterday and today I had to update some table

Re: [GENERAL] how to select temp table

Robert Gravsjö escribió: > On 2009-05-06 14.34, liuzg4 liuzg4 wrote: >> ver 8.4 >> i create two table with same name named 'testtable' >> >> one is temp table >> >> i select * from testtable >> then this table is a public or a temp ??? > > Temp. To access public use "select * from public.testta

Re: [GENERAL] how to select temp table

On 2009-05-06 14.34, liuzg4 liuzg4 wrote: ver 8.4 i create two table with same name named 'testtable' one is temp table i select * from testtable then this table is a public or a temp ??? Temp. To access public use "select * from public.testtable". "Temporary tables exist in a special

[GENERAL] Postgres partially hang after inactivity

Hi. I have a weird problem with PostgreSQL on a Windows machine. This is a test installation used to beta test a webapplication running with Tomcat, so most of the times it sits idle. Yesterday and today I had to update some table definitions, so issued the 'alter table...' command and the se

Re: [GENERAL] prepared statements and DBD::Pg

2009/5/7 JP Fletcher : > Hi, > > I see different behavior with DBI/DBD::Pg (1.607/2.11.8, pg 8.1) when the > first command in a prepared statement is 'CREATE TEMP TABLE'. > > For instance, this works: > > my $prepare_sql =< CREATE TEMP TABLE foo( id int, user_id int,); > > INSERT INTO

Re: [GENERAL] Yahoo Everest MPP - open source release?

On Wed, 2009-05-06 at 09:38 -0700, David Fetter wrote: > > I'm looking for an open source solution for doing efficient queries > > on 300 million+ row tables, and it sounds like Everest would be > > perfect. > > Community PostgreSQL handles situations like this just fine. Yes it does. 300 milli

Re: [GENERAL] prepared statements and DBD::Pg

On May 6, 2009, at 9:39 AM, JP Fletcher wrote: Hi, I see different behavior with DBI/DBD::Pg (1.607/2.11.8, pg 8.1) when the first command in a prepared statement is 'CREATE TEMP TABLE'. For instance, this works: my $prepare_sql =

Re: [GENERAL] Yahoo Everest MPP - open source release?

On Wed, May 06, 2009 at 09:28:37AM -0700, digital_illumin...@yahoo.com wrote: > > There was some talk of Yahoo possibly open sourcing the source for > the PostgreSQL MPP column store they built. Actually, Yahoo! acquired a company that had built this store. > Does anyone know if this is actually

[GENERAL] Yahoo Everest MPP - open source release?

There was some talk of Yahoo possibly open sourcing the source for the PostgreSQL MPP column store they built. Does anyone know if this is actually slated to happen, when, etc? I'm looking for an open source solution for doing efficient queries on 300 million+ row tables, and it sounds like Ev

Re: [GENERAL] PGSQL x iptables

> Slansky Lukas wrote: > > > 1. -A RH-Firewall-1-INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT > > > > 2. -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp -s > > aaa.bbb.ccc.ddd --dport 5432 -j ACCEPT > > > > 3. -A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited

[GENERAL] how to select temp table

ver 8.4 i create two table with same name named 'testtable' one is temp table i select * from testtable then this table is a public or a temp ??? drop table testtable then is this table a public or a temp? i test ,it drop temp table fisrst! so am i must show public or pg_temp_1 when i h

Re: [GENERAL] XML -> PG ?

On Wed, 2009-05-06 at 16:53 +0100, Joao Ferreira gmail wrote: > hello, > > as a perl addict I am... I recommend checking this out: > > http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm > > it's pretty flexible and allows you to specify to some extent just how > the database st

Re: [GENERAL] XML -> PG ?

Gauthier, Dave, 06.05.2009 17:40: Maybe... EMP EMP_NAME="FRANK" JOB="PLUMBER"/> EMP EMP_NAME="SUE" JOB="CARPENTER"/> ...equals... create table employees (emp_name varchar[64], job varchar[64]); create table jobs (job_name varchar[64], salary float); insert

[GENERAL] prepared statements and DBD::Pg

Hi, I see different behavior with DBI/DBD::Pg (1.607/2.11.8, pg 8.1) when the first command in a prepared statement is 'CREATE TEMP TABLE'. For instance, this works: my $prepare_sql =

Re: [GENERAL] XML -> PG ?

On Wed, 2009-05-06 at 16:53 +0100, Joao Ferreira gmail wrote: > hello, > > as a perl addict I am... I recommend checking this out: > > http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm > > it's pretty flexible and allows you to specify to some extent just how > the database st

Re: [GENERAL] XML -> PG ?

hello, as a perl addict I am... I recommend checking this out: http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm it's pretty flexible and allows you to specify to some extent just how the database structure is infered from the XML... check it out Joao On Wed, 2009-05-06

Re: [GENERAL] XML -> PG ?

Maybe... EMP EMP_NAME="FRANK" JOB="PLUMBER"/> EMP EMP_NAME="SUE" JOB="CARPENTER"/> ...equals... create table employees (emp_name varchar[64], job varchar[64]); create table jobs (job_name varchar[64], salary float); insert into employees (emp_name,job) values

Re: [GENERAL] XML -> PG ?

On May 6, 2009, at 10:47 AM, Gauthier, Dave wrote: Is there a way to read an XML file into a postgres DB? I’m thinking that it will create and relate whatever tables are necessary to reflect whatever’s implied by the XML file structure. There's no built-in functionality that does what you

Re: [GENERAL] Transaction settings: nowait

2009/5/6 Albe Laurenz : > durumdara wrote: >> In FireBird the transactions have these settings: >> >> >> SET TRANSACTION >>    [NAME hostvar] >>    [READ WRITE | READ ONLY] >>    [ [ISOLATION LEVEL] { SNAPSHOT [TABLE STABILITY] >>                          | READ COMMITTED [[NO] RECORD_VERSION] } ]

Re: [GENERAL] PGSQL x iptables

On Wed, May 6, 2009 at 3:47 AM, Craig Ringer wrote: > Slansky Lukas wrote: > >> 1. -A RH-Firewall-1-INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT >> >> 2. -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp -s >> aaa.bbb.ccc.ddd --dport 5432 -j ACCEPT >> >> 3. -A RH-Firewall-1-INPUT -

Re: [GENERAL] XML -> PG ?

On Wed, May 6, 2009 at 10:47 AM, Gauthier, Dave wrote: > Is there a way to read an XML file into a postgres DB?  I’m thinking that it > will create and relate whatever tables are necessary to reflect whatever’s > implied by the XML file structure. since xml is basically completely unstructured, y

[GENERAL] XML -> PG ?

Is there a way to read an XML file into a postgres DB? I'm thinking that it will create and relate whatever tables are necessary to reflect whatever's implied by the XML file structure. Thanks for any pointers !

Re: [GENERAL] Transaction settings: nowait

durumdara wrote: > In FireBird the transactions have these settings: > > > SET TRANSACTION >[NAME hostvar] >[READ WRITE | READ ONLY] >[ [ISOLATION LEVEL] { SNAPSHOT [TABLE STABILITY] > | READ COMMITTED [[NO] RECORD_VERSION] } ] >[WAIT | NO WAIT] >[LOCK

Re: [GENERAL] Transaction settings: nowait

Hi! 2009.05.06. 11:54 keltezéssel, Richard Huxton írta: durumdara wrote: So: have PGSQL same mechanism like nowait? When you take a lock: http://www.postgresql.org/docs/8.3/interactive/sql-lock.html http://www.postgresql.org/docs/8.3/interactive/sql-select.html#SQL-FOR-UPDATE-SHARE As I se

[GENERAL] tsearch2 memory problem

Hi! I realized that loading a dictionary with ~16 words consumes additional ~40 MB of memory for each connection. It obviously doesn't use a shared memory. Is it possible to decrease the memory consumption? I found this thread http://www.mail-archive.com/pgsql-general@postgresql.org/msg116924

[GENERAL] Transaction settings: nowait

Hi! In FireBird the transactions have these settings: SET TRANSACTION [NAME/|hostvar|/] [READ WRITE | READ ONLY] [ [ISOLATION LEVEL] { SNAPSHOT [TABLE STABILITY] | READ COMMITTED [[NO] RECORD_VERSION] } ] [WAIT | NO WAIT] [LOCK TIMEOUT/|seconds|/] And thi

Re: [GENERAL] PGSQL x iptables

Slansky Lukas wrote: 1. -A RH-Firewall-1-INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT 2. -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp -s aaa.bbb.ccc.ddd --dport 5432 -j ACCEPT 3. -A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited I was wondering when

Re: [GENERAL] PGSQL x iptables

Slansky Lukas wrote: Hello, we’re using PG and Application Server (JBoss) on separate CentOS servers with Cisco PIX in between. On DB side is iptable with following relevant rules: 1. -A RH-Firewall-1-INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT 2. -A RH-Firewall-1-INPUT -m state -

[GENERAL] PGSQL x iptables

Hello, we're using PG and Application Server (JBoss) on separate CentOS servers with Cisco PIX in between. On DB side is iptable with following relevant rules: 1. -A RH-Firewall-1-INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT 2. -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp

Re: [GENERAL] bizgres

On Tue, 5 May 2009, Glyn Astill wrote: I'm looking at building an olap reporting environment and I came across this project on pgfoundry. However it was last updated over 3 years ago, am I correct in assuming that this probably isn't something I should be looking at? It's actually closer to