[GENERAL] date expressions

I checked the manual on this but couldn't find a clear answer: I've got two dates in a database, a start date and and end date, which are type "date." I want to compare these dates to today's date in the SQL statement, something along the lines of "startdate date enddate". Can this be done

[GENERAL] postgresql and web application

Hello All, I am trying to develop web application with postgresql as datastorage, using zope. I read in documentation that postgresql is not multithreaded. So, I understand that I can't use one connection to database for all users and I must to open new connection for every user. Am I right? Or

Re: [GENERAL] date expressions

surfer girl wrote: I checked the manual on this but couldn't find a clear answer: I've got two dates in a database, a start date and and end date, which are type "date." I want to compare these dates to today's date in the SQL statement, something along the lines of "startdate date

[GENERAL] DB replication

Hi, We have an application which has databases in 2 different machines. The databases are small (25 MB). Every 15 minutes we want DB of one machine to be synced with another machine. Are there ready made utilities in postgres to do this. One way is to take a pgdump, tar it, ftp it and then

[GENERAL] postgresql and web application

Hello All, I am trying to develop web application with postgresql as datastorage, using zope. I read in documentation that postgresql is not multithreaded. So, I understand that I can't use one connection to database for all users and I must to open new connection for every user. -- Best

[GENERAL] demande d'aide

bonjour; tout d'abord, je me presente. je suis un étudiant marocain de la 4eme année et je prépare un projet de fin d'étude dans les deux mois qui suivent. j'aimerais savoir,s'il vous plait, si POSTGRES est intégré dans une version de LINUX et aussi, j'aimerais savoir le mieux entre POSTGRES et

Re: [GENERAL] unexpected error with array

This example is straight from bruce's book but I am getting an error. Help! [PostgreSQL 6.5.3 on i386-pc-bsdi3.0, compiled by gcc2 ] [snip] test= select col1[4] from array_test; ERROR: Unable to locate type name 'col1' in catalog This is a known bug and will be fixed in 7.0. I think

Re: [GENERAL] postgresql and web application

On Fri, 24 Mar 2000, Yury Don wrote: I am trying to develop web application with postgresql as datastorage, using zope. I read in documentation that postgresql is not multithreaded. So, I understand that I can't use one connection to database for all users and I must to open new connection

Re: [GENERAL] avoiding duplicates

Hi everyone, I have a generel SQL question. What is the best way to avoid inserting duplicate tuples in a table ? using constraints ? Please refer me to a resource about this topic. Thank you for your time, -Sheila __ Get Your Private, Free

Re: [GENERAL] DB replication

I've had the same question, I believe the best it gets will be something like running rsync over an encrypted (if needed for security) tunnel (ssh). But you'll have to user some dump utility as far as I know. Cheers Wim. - Oorspronkelijk bericht - Van: Differentiated Software Solutions

Re: [GENERAL] use of currval and nextval in PHP3

You only need grants on select and update for sequence tables. Mikio Mike Mascari wrote: sheila bel wrote: Hi everyone, I'm trying to use currval from php3. This is what I'm doing : $result=pg_Exec($conn,$addstmt) (where $addstmt is a insert statement)

Re: [GENERAL] demande d'aide

'jour Linux, soi-meme, ca n'est plus que le "kernel", ou la systeme d'operation soi-meme. On dit aussi la systeme Gnu/Linux, parce que presque tous les utilities au niveau de fiche sont ecrit par la groupe GNU (http://www.gnu.org), aussi que des applications, comme emacs, etc. Mais tous les

[GENERAL] Should've used postgresql! ;-)

http://linuxtoday.com/ -- Timothy H. Keitt National Center for Ecological Analysis and Synthesis 735 State Street, Suite 300, Santa Barbara, CA 93101 Phone: 805-892-2519, FAX: 805-892-2510 http://www.nceas.ucsb.edu/~keitt/ Fatal error: Call to unsupported or undefined function mysql_errno()

Re: [GENERAL] DB replication

I'd recommend changing the structure of your tables, adding a record_added field, and then do a SELECT * FROM table WHERE record_added CURRENT_TIMESTAMP - '15min' ::datetime and having a PERL program pipe the results of the select into the other database using DBI with two connections. BTW:

Re: [GENERAL] avoiding duplicates

On Fri, 24 Mar 2000, sheila bel wrote: Hi everyone, I have a generel SQL question. What is the best way to avoid inserting duplicate tuples in a table ? using constraints ? Please refer me to a resource about this topic. primary key -- which you can say is also a contraint. of course,

[GENERAL] Postgres and clustering/scaling....

Our company is getting to where we need to think of turning our Postgres server into a cluster. We've come up with a few very viable ideas, but we'd love to hear of anything that others have done along this line. steve

[GENERAL] postgresql 7.0beta2 - bugs?

hi, i just upgraded to postgresql 7.0beta2 on a i586 linux machine running redhat 6.1. the compile/install went without a hitch. when trying to run the regression tests, here is what i noticed... regress.sh: psql does not support the -X option. not too sure what it was for in earlier

Re: [GENERAL] demande d'aide

Postgres fait partie de RedHat linux. Postgres ne se compare pas facilement a MYSQL car il est un vrai RDBMS (relational database). MYSQL est une emulation partielle. Patrick Robin chriqi abdelkarim wrote: bonjour; tout d'abord, je me presente. je suis un étudiant marocain de la 4eme année

[GENERAL] limit on 'text' field?

Hi folks, I have an UPDATE command that's storing news articles and writing an article to a field of type 'text' and it's failing with a "query too long" error message. I tried pasting the query into psql and it's giving me the "query buffer max length of 16384 exceeded" error. So, I guess