Re: [GENERAL] getting a list of users

2009-05-09 Thread Eric Smith
Tom, Thanks for the detailed info... makes my life a lot easier! Eric On May 9, 2009, at 7:07 PM, Tom Lane wrote: I wrote: That isn't exactly a trivial thing to do, because the pg_config.h data differs for the two arches. It will *not* work to just run a basic configure and build with CFL

Re: [GENERAL] getting a list of users

2009-05-09 Thread Eric Smith
Tom, 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 water on the PPC. I'll lo

Re: [GENERAL] getting a list of users

2009-05-09 Thread Tom Lane
I wrote: > That isn't exactly a trivial thing to do, because the pg_config.h data > differs for the two arches. It will *not* work to just run a basic > configure and build with CFLAGS set like that. (If you troll the > pgsql-archives archives for "universal binary" you can probably > find some d

Re: [GENERAL] getting a list of users

2009-05-09 Thread Tom Lane
Eric Smith writes: > You bet... here you go. Hmm, I see you are trying to build universal binaries: > CFLAGS=-arch i386 -arch ppc ... That isn't exactly a trivial thing to do, because the pg_config.h data differs for the two arches. It will *not* work to just run a basic configure and build wit

Re: [GENERAL] getting a list of users

2009-05-09 Thread Eric Smith
You bet... here you go. Thanks, Eric BINDIR = /Users/esmith/SoftwareBuilds/DentalImagingV3/Release/RadioVision.app/Contents/Resources/postgresql/bin DOCDIR = INCLUDEDIR = /Users/esmith/SoftwareBuilds/DentalImagingV3/Release/RadioVision.app/Contents/Resources/postgresql/include PKGINCLUDEDIR =

Re: [GENERAL] getting a list of users

2009-05-09 Thread Tom Lane
Eric Smith writes: > I actually started with the source: postgresql-8.3.5.tar.gz, from the > source download location. I just build straight from that source... > no mucking around with any of the sources. Hmph, now I'm really mystified. If the straight source build were this broken we'd su

Re: [GENERAL] getting a list of users

2009-05-09 Thread Eric Smith
I actually started with the source: postgresql-8.3.5.tar.gz, from the source download location. I just build straight from that source... no mucking around with any of the sources. Eric On May 9, 2009, at 5:44 PM, Tom Lane wrote: Eric Smith writes: Yep, using that command gives me the e

Re: [GENERAL] getting a list of users

2009-05-09 Thread Tom Lane
Eric Smith writes: > Yep, using that command gives me the error. > I'm using a build that came from the postgres website, and just uses > the config that comes with it. Hmm, you mean the EDB one-click installer? I don't offhand see another binary distro for OSX there. It seems unlikely that t

Re: [GENERAL] getting a list of users

2009-05-09 Thread Eric Smith
Yep, using that command gives me the error. I'm using a build that came from the postgres website, and just uses the config that comes with it. Eric On May 9, 2009, at 5:16 PM, Tom Lane wrote: Eric Smith writes: When I try the command below, I get the very familiar error: "expected ju

Re: [GENERAL] getting a list of users

2009-05-09 Thread Tom Lane
Eric Smith writes: > When I try the command below, I get the very familiar error: "expected > just one rule action" You mean this? regression=# SELECT usename FROM pg_catalog.pg_user; usename -- postgres (1 row) If you're getting that sort of error from standard views then there

Re: [GENERAL] getting a list of users

2009-05-09 Thread Eric Smith
All, When I try the command below, I get the very familiar error: "expected just one rule action" I'm running 8.3.5 on Mac OS 10.5.6. Any ideas? Thanks, Eric On May 7, 2009, at 11:24 PM, Albe Laurenz wrote: Eric Smith wrote: How do I get a list of database usernames using the postgres C

[GENERAL] lack in psql console

2009-05-09 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] limit-offset different result sets with same query

2009-05-09 Thread Tom Lane
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 encourages proper use of order by, > because the natural ordering resul

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

2009-05-09 Thread Merlin Moncure
On Fri, May 8, 2009 at 5:40 PM, Alvaro Herrera wrote: > David Fetter escribió: >> On Fri, May 08, 2009 at 06:10:18PM -0300, Emanuel Calvo Franco wrote: >> > Hi all. >> > >> > I'll make this faster. >> > >> > I hace this table and this function: >> >> You should only ever assume that your SELECT's

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

2009-05-09 Thread Emanuel Calvo Franco
2009/5/8 David Fetter : > On Fri, May 08, 2009 at 06:40:33PM -0300, Emanuel Calvo Franco wrote: >> >> I test it in the first time :) >> >> With the 'order by' it works well, but in 'theory' > > The theory under which you should operate is that the underlying > implementation only gives you the orde

Re: [GENERAL] keeping track of function execution

2009-05-09 Thread Wojtek
Scott Marlowe wrote: On Sun, May 3, 2009 at 9:38 AM, Wojtek wrote: (...) You could raise notice and then tail the logs as it runs. Or the other option mentioned of using dblink() works well too. dblink did the trick, thanks guys! foo -- Sent via pgsql-general mailing list (pgsq

Re: [GENERAL] Remote access

2009-05-09 Thread Andreas
George Weaver schrieb: I have a client with a main office and a branch office about 90 miles away. [...] What would be the best solution for them to access a PostgreSQL database located at the main office from the branch office? I read the other messages and the advice about fixed IP or dynam