[GENERAL] Postgres and bambooinvoice

Hi all, Was wondering if someone has experience with bommbooinvoice and postgres as the backend. Hoping for some off list help if the combination does actually work. Thanks Allan The material contained in this email is confidential and may be subject to legal privilege and/or copyright. Pleas

Re: [GENERAL] Should casting to integer produce same result as trunc()

> -Original Message- > From: Alban Hertroys [mailto:haram...@gmail.com] > Sent: Wednesday, 12 October 2011 1:35 AM > To: Tom Lane > Cc: Harvey, Allan AC; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Should casting to integer produce same > result as trunc

[GENERAL] Should casting to integer produce same result as trunc()

Hi all, Had to squash timestamps to the nearest 5 minutes and things went wrong. My simple understanding of trunc() and casting to an integer says that there is a bug here. Expect it is my understanding though. Can someone set me straight? And thank you all for a wonderfull RDBMS. Allan sele

Re: [GENERAL] SQL Syntax - like FIELD and BITPATTERN = BITPATTERN?

> I do not know how to really describe this... > > In pascal I would do > > If (AField and Flag3)=Flag3 then ... > > Checking to see if AField contains the BIT(s) FLAG3 is set to... is > there a way to do this in a SELECT statement -- select * from ATable > where AField and 0x0004=0x

Re: [GENERAL] handle audiofiles in postgres

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org]on Behalf Of edisan Sent: Thursday, 3 September 2009 2:48 PM To: pgsql-general@postgresql.org Subject: [GENERAL] handle audiofiles in postgres Can anyone used or tell me how to handl

Re: [GENERAL] Is there a function for Converting a Decimal into BINARY ?

> Eg: > I have a datatype in the DB which needs to be converted. > > DEC = 192 > BINARY = 1100 How about this gwmdb=> select 192::bit(16); bit -- 1100 (1 row) Hope that helps Allan The material contained in this email may be confidential, p

Re: FW: [GENERAL] how many connections can i use????

> On Fri, May 8, 2009 at 10:08 AM, Edmundo Robles L. > wrote: > >> Operative system: SCO OpenServer 5.0.7 > > > > --> double egad (and a bit at odds with your sig...) > > > > jeje  :-) yes , this is because in my work   we use SCO but > personally i  use ubuntu on my desktop pc and laptop. > >

Re: [GENERAL] LISTEN/NOTIFY problem

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org]on Behalf Of Dmitri Girski Sent: Monday, 23 March 2009 10:00 PM To: pgsql-general@postgresql.org Subject: [GENERAL] LISTEN/NOTIFY problem Hi everybody, I've got a weird problem wit

Re: [GENERAL] bash & postgres

> -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org]on Behalf Of Greenhorn > Sent: Monday, 23 March 2009 3:03 PM > To: pgsql-general@postgresql.org; pgsql-...@postgresql.org > Subject: [GENERAL] bash & postgres > > > Hi, > > I'm

Re: [GENERAL] tuples

> I have a question concerning psql. I found that psql has a defined > command '-t' and that it turns off printing of column names > and result > row count footers, etc. > > what I look for, is a command, which would turn off result row count > footer, but would print column names. > > is the

Re: [GENERAL] How to echo statements in sourced file?

right in my psql terminal after each statement in the file gets executed. But now I need a way to have these statements that are being timed themselves echoed to the terminal. Is there a way to do this? start psql with the -a switch, I think. Allan The material contained in this em

Re: [GENERAL] inserting only new rows from csv file

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Scott Marlowe > Sent: Thursday, 2 October 2008 7:39 AM > To: Seb > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] inserting only new rows from csv file > > > On Wed, Oct 1, 2008 at 3:16 PM, S

Re: [GENERAL] 8.3.3 regression test on SCO 5.0.7

> "Harvey, Allan AC" <[EMAIL PROTECTED]> writes: > >> "Harvey, Allan AC" <[EMAIL PROTECTED]> writes: > >>> creating template1 database in > /upgrades/postgres/postgresql-8.3.3/src/test/regress/./tmp_che > ck/data/base/1 ... =: is not

Re: [GENERAL] 8.3.3 regression test on SCO 5.0.7

> "Harvey, Allan AC" <[EMAIL PROTECTED]> writes: > >> "Harvey, Allan AC" <[EMAIL PROTECTED]> writes: > >>> creating template1 database in > /upgrades/postgres/postgresql-8.3.3/src/test/regress/./tmp_che > ck/data/base/1 ... =: is not

Re: [GENERAL] 8.3.3 regression test on SCO 5.0.7

> "Harvey, Allan AC" <[EMAIL PROTECTED]> writes: > > creating template1 database in > /upgrades/postgres/postgresql-8.3.3/src/test/regre > > ss/./tmp_check/data/base/1 ... =: is not an identifier > > I'd guess you have an incompatible awk or p

[GENERAL] 8.3.3 regression test on SCO 5.0.7

Hi All, I have been working through upgrades on legacy business systems on old Linux and SCO plateforms. With the help of this list the Linux problems are handled, thanks. The SCO build is not yet done. I have managed to compile 8.3.3 with the help of the archives. But there were lots of warning

Re: [GENERAL] 8.3.3 Complie issue

> Old Slackware? If you really want to compile there, I think it should > work by just removing the -Wl,--version-script param from the > link line. Thanks Alvaro, Worked through them. Regression tests show all is OK, save for the handling of "Infinity". Don't think that will be a problem 'caus

Re: [GENERAL] 8.3.3 Complie issue

> I think we've seen this before: do you have utf8_and_euc_jis_2004.c > in that directory? There seem to be some broken versions of tar out > there that can't deal with extracting such a long file name from the > distribution tarball. Thanks Tom, The "c" on the end was missing. Fixed that, how ab

[GENERAL] 8.3.3 Complie issue

Hi All, Compile issue I was hoping someone might have a suggestion for: Did ./configure --prefix /removeExt2/pgsql8.3 make make[3]: Entering directory `/removeExt2/postgresql-8.3.3/src/backend/utils/mb/conversion_procs/utf8_and_euc_jis_2004' make[3]: *** No rule to make target `utf8_and_euc_ji

Re: [GENERAL] Updating

> Would it be possible to get an example of such coding?? This trigger has an argument passed. When the trigger is "assigned" I know whether the column is of type txt or float. It uses the column name to determine what to do. Hope this helps Allan create or replace function insert_if_diff() re

Re: [GENERAL] PostgresSQL vs Ingress

Ow Mun Henq wrote:- > Ingress is also an open source RDBM (and DataWarehouseing) and I'm > wondering if anyone here has anything to say about it. They also offer > community editions but I've not gone to see how much it differs/offers > compared to PG. > > I've tried to DL the community edition,

Re: [GENERAL] looking for some real world performance numbers

> As far as real world numbers, we have a data-intensive app > (network data > collection for a telecom company) that is currently inserting > about 16 > million rows a day. I benchmarked PG for that app and with some > tweaking, PG could handle it. Me too, not telco though. 5.5 million per d

Re: [GENERAL] Excell

> > Because I'm delivering reports to dozens of people who have windows, no > > psql client, and just want to go to a web page, click a button, and get > > their report (or was that a banana?) I do exactly this with bog basic HTML and bash scripts. Can send you a copy if you want examples. Allan

Re: [GENERAL] Trigger function that works with both updates and deletes?

> Second, while I could write two trigger functions, one dealing with > add/update, the other with deletes, it's probably neater to > have a single > trigger function and have it discriminate "am I being called > for a delete, > or an add/update?" I don't know how to determine the type > record

Re: [GENERAL] 'Expensive' column in result set

Tom, Thank you. I shall experiment. > "Harvey, Allan AC" <[EMAIL PROTECTED]> writes: > > select > > b.block, > > b.p_code, > > p.description, > > p.blk_speed as "set", > > blk_speed( b.block ) as "actual

[GENERAL] 'Expensive' column in result set

Hi all, I have a select that involves a column in the result set that is expensive to get. I need to use the expensive column in a subsequent calculated column. Is there a syntax to run the expensive function once only or does it just have to be done, blk_speed() is the expensive function. Exa

Re: [GENERAL] selective export for subsequent import (COPY)

Chris, > I know about: psql dbname -tc "select * from tableX where whatever" > > tableX.dat What about psql $DATABASEHOST -U $DATABASEUSER -d $DATABASE -q -P footer -A -F , -c "$DETAIL_SQL" >table.csv To produce a comma separated file of tuples only. If I'm not mistaken, as happens quite a bit

Re: [GENERAL] Storing blobs in PG DB

I find it fine. Bit different usage though. I store about 200 50MB items. Allan > Hi All! > > Question is : How suitable PG for storing about 2 000 000 binary files > 0,5-2,0 Mb size each ? It is not planned the big number of clients or a > plenty of updatings. Like photoalbum on local host

Re: [GENERAL] PGSQL with high number of database rows?

Tim, > massive, around 20,000 new rows in one of the tables per day. As an example... I'm doing about 4000 inserts spread across about 1800 tables per minute. Pisses it in with fsync off and the PC ( IBM x3650 1 CPU, 1 Gig memory ) on a UPS. Allan The material contained in this email may be co

Re: [GENERAL] Multiple atributes with -P switch to psql

Stuart, Thanks for the reply. You are dead right, and as expected the problem is not with psql. > $ psql -H -P tableattr='width="80%" bgcolor="#FF"' > > works for me. Carefully study my nice simple quoting: single quotes '' > around the whole > tableattr='THING' shebang and non-escaped dou

[GENERAL] Multiple atributes with -P switch to psql

Hi all, Trying to get psql to produce multiple table attributes in the tag when psql is used with the -H switch. eg TABLEOPTIONS="-P border=5 -P tableattr=width=\"80%\"" psql $DATABASEHOST -U $DATABASEUSER -d $DATABASE -q -P footer -P title=Summary -H $TABLEOPTIONS produces ... ... As expe

Re: [GENERAL] How can I list the function. SOLVED

Thank you all, > I know the function is there. > What am I doing wrong? Talking to a 8.2.0 server with a 7.4.5 client. Sorry for the noise, I sometimes get lost on which versions I have where of this wonderful software. Allan The material contained in this email may be confidential, privileged

[GENERAL] How can I list the function.

I know the function is there. What am I doing wrong? galvdb=# galvdb=# \df+ delete_old List of functions Result data type | Schema | Name | Argument data types | Owner | Language | Source code | Description --++--+-

Re: [GENERAL] plpgsql dynamic queries and optional arguments

Curtis, Here is an example function that uses dynamic sql. I use it under 7.4.5 Hope this helps. Allan -- Function to delete old data out of the point tables. -- tablename is a column in the points table that holds the name -- of the table in which this points data is stored. create or replace

Re: [GENERAL] Is PostgreSQL an easy choice for a large CMS?

The open source offerings of ingres, ingres R3, runs the Wire section of our business http://www.onesteel.com Allan > > Postgres than from MySQL. I am financing this myself. hence the > > apprehension about the cost. Is there another contender I > > should think > > about. The material contai

Re: [GENERAL] deleting table content through command prompt

Try psql.exe -h localhost -U your_user -d your_database -c "drop table your_tablename;" Assumption: windows switches are the same as the *nix ones > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, 20 April 2006 9:0

[GENERAL] Help to realise function

Hi all, Can anyone offer suggestions on how to realise this function It is the $1 as the table name that is the problem. I'm using Version 7.4.5 create or replace function last_scan( varchar, varchar ) returns float as ' declare result float; begin result := value f

[GENERAL] Is this possible.

Hi all, Can sombody please help me realise a function, the intent as described by... -- Function to create the table for a new point CREATE OR REPLACE FUNCTION make_table( varchar ) RETURNS VARCHAR AS ' CREATE TABLE $1( parameter varchar(8) NOT NULL, value float NOT NULL,

Re: [GENERAL] automating backup ?

Start->Control Panel->Scheduled Tasks > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Zlatko Matic > Sent: Monday, 27 June 2005 9:21 AM > To: Michael Fuhr > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] automating backup ? > > > Thanks Fuh

[GENERAL] Performance suggestions?

Hi all, I'm after suggestions on how to keep the initial performance of a system I've put together for longer than 2 minutes. I have a small table about 20 rows, a constant, that is receiving about 160 updates per second. The table is used to share gathered data to other process asynchronously. A

[GENERAL] SCO installation help

Hi all, Hope someone might know the answer. Trying to install 7.4.5 ('cause its what I have) from source on SCO OpenServer 5.0.7 The compile succeeds, all be it with warnings... gmake install -- OK create the data directories -- OK /usr/local/pgsql/bin/initdb - D /usr/local/pgsql/data -- OK /

Re: [GENERAL] table configuration tweak for performance gain.

706.179 ms (4 rows) > -Original Message- > From: Michael Fuhr [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 17 November 2004 12:19 > To: Harvey, Allan AC > Cc: Tom Lane > Subject: Re: [GENERAL] table configuration tweak for performance gain. > > > On Wed, Nov

Re: [GENERAL] table configuration tweak for performance gain.

85606.9 85606.9 85606.9 85606.9 85606.9 85606.9 etc..... I have obviously used it wrong but cannot see how/why. Thanks again. Allan > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 16 November 2004 2:26 > To: Michael Fuhr > Cc: Harvey, Al

[GENERAL] table configuration tweak for performance gain.

Hi all, I was hoping someone might be able to set me straight so that I can get some select performance improvements. The table in question has several thousand rows currently, planning several million, it has a date time stamp column. All selects will be on ranges of the date time column. I crea