Re: [GENERAL] [SQL] Result set granularity..

On Sat, 27 Sep 2003, Rasmus Aveskogh wrote: > > Hi, > > Since I went from Oracle to PostgreSQL I've been missing the "invisable" > column 'rownum'. I often used it to lower the granularity of my data. > For example, say I have a large table containing some sort of statistical > data and want to

[GENERAL] Access - can't close Form

Hi, i use Access as a frontend via ODBC to an Linux-based postgresql. I have a problem in a form where I use a lot of subforms. In some cases ( i couldn't detect when - but I really try to) the form and Access hangs. The only way to close the form is to close Access via "cross" (upper right corne

[GENERAL] Seeking insight from heavy lifters

A manager friend of mine sent me the following concern. He's preparing to shift to Postgresql from a proprietary DB and 4gl system: --- To that end, I've also started studying up on Postgresql. It seems to have all the necessary features for a transaction heavy DB. The recent release is

[GENERAL] Access - can't close Form

Hi, i use Access as a frontend via ODBC to an Linux-based postgresql. I have a problem in a form where I use a lot of subforms. In some cases ( i couldn't detect when - but I really try to) the form and Access hangs. The only way to close the form is to close Access via "cross" (upper right corn

Re: [GENERAL] numeric rounding

On Mon, Sep 29, 2003 at 12:47:05AM -0700, Gezeala 'Eyah' BacuXo II wrote: > You can see I already added a value of 0.0001 to the computation but I also get > the same results.. :( Why 0.0001? If you want to round to the second digit by cutting the number you have to add 0.005. Michael --

Re: [GENERAL] Seeking insight from heavy lifters

John Wells wrote: > Bruce, > > A system called Progress, which is a 4GL/database combo I'm not really > that familiar with. > > They're aware that Postgresql doesn't have a 4gl per se, but I think they > view the savings they'll gain by switching to an open solution as well > worth it. OK, that

Re: [GENERAL] Seeking insight from heavy lifters

Bruce, A system called Progress, which is a 4GL/database combo I'm not really that familiar with. They're aware that Postgresql doesn't have a 4gl per se, but I think they view the savings they'll gain by switching to an open solution as well worth it. Thanks, John Bruce Momjian said: > > What

[GENERAL] Where is libpq++ on redhat 9?

Title: Where is libpq++ on redhat 9? Hello,     I've installed redhat 9 on my box and postgresql (with it's -devel package) and found that it didn't contain libpq++. I tried a search on redhat and rpmfind with no luck (rpmfind found only suse packages).     I know that I can downloa

Re: [GENERAL] Access - can't close Form

On Monday 29 September 2003 10:34 am, E. Zorn (RDG-rational) postsql wrote: > Hi, > i use Access as a frontend via ODBC to an Linux-based postgresql. > > I have a problem in a form where I use a lot of subforms. In some > cases ( i couldn't detect when - but I really try to) the form and Access > h

Re: [GENERAL] Modification Dates

Sven Schwyn <[EMAIL PROTECTED]> writes: > CREATE TRIGGER _modified AFTER UPDATE ON any_table FOR EACH ROW > EXECUTE PROCEDURE > touch(); You want BEFORE UPDATE here. AFTER UPDATE happens, well, after the update. :) -Doug ---(end of broadcast)---

Re: [GENERAL] Where are user-defined types stored/viewed

<[EMAIL PROTECTED]> writes: > After I execute a command like > CREATE TYPE employee_wage_journal_sum AS (supplier_pk integer, > employee_pk integer, > hourly_dollars double precision, > annual_dollars double precision); > I don't see the new type show up anywhere in pgAdmin

Re: [GENERAL] Seeking insight from heavy lifters

What are the transfering from, exactly? --- John Wells wrote: > A manager friend of mine sent me the following concern. He's preparing to > shift to Postgresql from a proprietary DB and 4gl system: > > --- > To tha

[GENERAL] Access - can't close Form

Hi, i use Access as a frontend via ODBC to an Linux-based postgresql. I have a problem in a form where I use a lot of subforms. In some cases ( i couldn't detect when - but I really try to) the form and Access hangs. The only way to close the form is to close Access via "cross" (upper right corn

[GENERAL] Conditional row grained + FK dependency oriented lazy replication

Hi, first off, i broadcast my case to as many people as possible, maybe off topic for many, but maybe as well of interest for some. Also i speak sort of DBMirror terminology ( a great and simple tool). The problem is as follows: Tables must be replicated to remote sites (1 master, many slaves). Th

Re: [GENERAL] Edward

On Monday 29 September 2003 14:41, [EMAIL PROTECTED] wrote: > Hi!, First i'm a beginner working with php. And i've a problem working > with that and postgresql of course, i cann't connect both. > I've been working with debian sid, and like usually the webserver is > apache; the error is somethi

Re: [GENERAL] numeric rounding

On Mon, Sep 29, 2003 at 12:47:05AM -0700, Gezeala 'Eyah' Bacuño II wrote: > my problem is my function just won't round some numbers properly.. > what i want it to do is like this. > > example: > > 721.875 = 721.88 a=> select round(721.875, 2); round 721.88 (1 row) -- Alvaro Herrera

Re: [GENERAL] downloading latest source from cvs

On Mon, Sep 29, 2003 at 10:57:20AM -0400, Bruce Momjian wrote: > Relaxin wrote: > > try to compile the libpq library with > > bcc32.mak under bcb5, but have some problems when linked. > > Oh, WIN32_DEV is just for server Win32 development. Beta3 or CVS > snapshot will give you a working win32 cl

[GENERAL] Seeking insight from heavy lifters

A manager friend of mine sent me the following concern. He's preparing to shift to Postgresql from a proprietary DB and 4gl system: --- To that end, I've also started studying up on Postgresql. It seems to have all the necessary features for a transaction heavy DB. The recent release is

Re: [GENERAL] Result set granularity..

Short answer, no there's no trick to doing this in postgres like rownum. You would have to either add a column with sequential or random keys and then select on it, or else pull down all the rows and only process the ones you want. Rownum is handy though, I wonder how easy it would be to add it t

Re: [GENERAL] PostgreSQL SSL communication with SecureTcpClient (Ssl

Kris Jurka <[EMAIL PROTECTED]> writes: > On Mon, 29 Sep 2003, Angel Todorov wrote: >> : An error occurs while communicating with the remote host. ---> >> Org.Mentalis.Security.Ssl.Shared.SslException: The server hello message >> uses a protocol that was not recognized. >> >> Do you have any idea w

Re: [GENERAL] downloading latest source from cvs

Relaxin wrote: > > > Relaxin wrote: > > > But how do you tell it that I only want what's tagged as WIN32_DEV? > > > > > > Thanks > > > >"Bruce Momjian" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > I think you need -rWIN32_DEV > > ok, I did as you suggested and I got only and

Re: [GENERAL] Modification Dates

Hi Nigel I suspect you're misunderstanding something about triggers, an on update trigger setting a such a field to the current timestamp shouldn't be causing a second update. You're actually doing an update statement within the trigger I presume? That's not the way, just set NEW.modified to th

Re: [GENERAL] Modification Dates

Hi again Got it, quite obvious too. The trigger has to be called BEFORE the UPDATE, not AFTER. (Hmmm, very obvious even.) CREATE TRIGGER _modified BEFORE UPDATE ON any_table FOR EACH ROW EXECUTE PROCEDURE touch(); That does the trick! Greets, -sven ---(end of broadca

Re: [GENERAL] Rewriting pg_upgrade

[EMAIL PROTECTED] (Bruce Momjian) writes: > Jim C. Nasby wrote: >> FWIW, FreeBSD just removed it (in the 5.x versions). Of course you can >> still easily install it from ports. > > Interesting. Why would they remove it? Because it's a REALLY BIG ball of mud to include as a core dependancy? Don't

[GENERAL] numeric rounding

hey guys..need your help on this.. i have a plpgsql function where in i compute numeric values for my php scripts.. my problem is my function just won't round some numbers properly.. what i want it to do is like this. example: 721.875 = 721.88721.865 = 721.87721.765 = 721.77721.775 = 721.78 here's

[GENERAL] Edward

Hi!, First i'm a beginner working with php. And i've a problem working with that and postgresql of course, i cann't connect both. I've been working with debian sid, and like usually the webserver is apache; the error is something like thist: "error cannot locale host:localhost...", but i t

Re: [GENERAL] downloading latest source from cvs

> Relaxin wrote: > > But how do you tell it that I only want what's tagged as WIN32_DEV? > > > > Thanks > >"Bruce Momjian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I think you need -rWIN32_DEV ok, I did as you suggested and I got only and everything that was tagged as WIN32_D

Re: [GENERAL] CASE tools

> FYI I have found 2 CASE tools that support PostgreSQL > > CASE Studio 2 > > > DDS-Lite > > > However, they are both for Windows. > > Can you point me to others? Hopefully multi-platform ones. Another one is at http://ww

Re: [GENERAL] Where are user-defined types stored/viewed

On Monday 29 September 2003 13:35, [EMAIL PROTECTED] wrote: > After I execute a command like > > CREATE TYPE employee_wage_journal_sum AS (supplier_pk integer, > employee_pk integer, > hourly_dollars double precision, > annual_dollars double precision); > > where does this d

Re: [GENERAL] Time problem again?

On Monday 29 September 2003 12:47, Bjørn T Johansen wrote: > Well, I don't.. But normal timespan is about 6-7 hours +- (so one can > assume max timespan = 12 hours really...) Well, if you don't know what order you want, how can you tell PG to show them in that order? I think you might want to lo

[GENERAL] Where are user-defined types stored/viewed

After I execute a command like CREATE TYPE employee_wage_journal_sum AS (supplier_pk integer, employee_pk integer, hourly_dollars double precision, annual_dollars double precision); where does this definition get stored, and what query can I run to get teh definition back

Re: [GENERAL] Time problem again?

Title: Nachricht Yes, I could do that... I was just hoping to catch the odd times when records aren't inserted in order BTJ On Mon, 2003-09-29 at 13:44, Daniel Schuchardt wrote: No, not really   perhaps you can do a ORDER BY (oid || yourtimefield). So you have the RecordOrde

Re: [GENERAL] Time problem again?

Well, I don't.. But normal timespan is about 6-7 hours +- (so one can assume max timespan = 12 hours really...) BTJ On Mon, 2003-09-29 at 13:40, Richard Huxton wrote: On Monday 29 September 2003 12:26, Bjørn T Johansen wrote: > The problem is that I don't have such a "period". I can have a

Re: [GENERAL] Time problem again?

Title: Nachricht No, not really   perhaps you can do a ORDER BY (oid || yourtimefield). So you have the RecordOrder in the way the records where inserted.   Daniel     I need to sort some data based on a Time field and the times can cross both midnight and noon. As far as I can tell, th