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

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 f...@twine.pl 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

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

2009-05-09 Thread Emanuel Calvo Franco
2009/5/8 David Fetter da...@fetter.org: 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

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 alvhe...@commandprompt.com 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

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

2009-05-09 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Fri, May 8, 2009 at 5:40 PM, Alvaro Herrera alvhe...@commandprompt.com 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

[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

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

Re: [GENERAL] getting a list of users

2009-05-09 Thread Tom Lane
Eric Smith eric_h_sm...@mac.com 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

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 eric_h_sm...@mac.com writes: When I try the command below, I get the very familiar

Re: [GENERAL] getting a list of users

2009-05-09 Thread Tom Lane
Eric Smith eric_h_sm...@mac.com 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

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 eric_h_sm...@mac.com writes: Yep, using that

Re: [GENERAL] getting a list of users

2009-05-09 Thread Tom Lane
Eric Smith eric_h_sm...@mac.com 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

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 eric_h_sm...@mac.com 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

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

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

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