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

2009-05-10 Thread Harvey, Allan AC
> 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: FW: [GENERAL] how many connections can i use????

2009-05-10 Thread Craig Ringer
Scott Marlowe wrote: 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. This

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

2009-05-10 Thread Scott Marlowe
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. This would be one i

Re: [GENERAL] limit-offset different result sets with same query

2009-05-10 Thread Scott Marlowe
On Sun, May 10, 2009 at 2:03 AM, David Fetter wrote: > On Sat, May 09, 2009 at 01:28:03PM -0400, Tom Lane wrote: >> Merlin Moncure writes: >> > On Fri, May 8, 2009 at 5:40 PM, Alvaro Herrera >> > wrote: >> >> Yeah, we went over this on the spanish list, turned out that I >> >> couldn't remember

[GENERAL] OLE DB

2009-05-10 Thread Glyn Astill
Hi Chaps, I was just wondering about the state of ole db connectivity for postgresql. From what I can see my options are; http://pgfoundry.org/projects/oledb/ Which doesn't seem to have been updated for 3 years - anyone using it? Or http://www.pgoledb.com/ Any others? -- Sent via pgsq

Re: [GENERAL] getting a list of users

2009-05-10 Thread Dave Page
Fyi, this is exactly what i saw in my first attempts to build a universal binary. Running configure for each architecture and hacking up pg_config.h (per one of the archives links you posted previously) does fix it, though iirc, 32 & 64 bit builds in the same binary will take some more work. On 5/

Re: [GENERAL] getting a list of users

2009-05-10 Thread Tom Lane
Eric Smith writes: > You are correct. On an Intel, the failed command I mentioned earlier > works just fine. > I'm building for, and running on, both PPC and Intel. I've been able > to avoid these snags in the past, but I'm now adding user management > to the app, and I'm dead in the wate

Re: [GENERAL] lack in psql console

2009-05-10 Thread Craig Ringer
Juan Camilo Marín wrote: > => select * from \d summary_table; > > The sentense start after "=> select * from" I don't know why this is > happen. Probably a terminal emulation issue. Readline will be sending the wrong escape sequences to control your terminal or your terminal will be misbehaving

Re: [GENERAL] lack in psql console

2009-05-10 Thread Juan Camilo Marín
Hello I have a problem in my psql console (psql 8.2.5 on Mac 10.5.6), the problem is, when I write a sentence and then I use the up and down key to see the previous sentences the sentence is loaded above the previous sentences and I should use the left and rigth keys to go to the begining of the s

Re: [GENERAL] A question about RAISE NOTICE

2009-05-10 Thread Alban Hertroys
On May 7, 2009, at 4:35 PM, Luigi N. Puleio wrote: Hello everyone, DO where it calls this function. The result I'd like would be to notice me with a on-display message with a window having an OK button (like when I use EXCEPTION). which would tell me the condition is verified Mayb

Re: [GENERAL] limit-offset different result sets with same query

2009-05-10 Thread David Fetter
On Sat, May 09, 2009 at 01:28:03PM -0400, Tom Lane wrote: > Merlin Moncure writes: > > On Fri, May 8, 2009 at 5:40 PM, Alvaro Herrera > > wrote: > >> Yeah, we went over this on the spanish list, turned out that I > >> couldn't remember about syncscan :-) > > > I like the new behavior. It really