[GENERAL] Queue Implementation for/with PostgreSQL

2005-11-27 Thread Cabbar Duzayak
Hi, Does Postgres support queues, I mean does it have something like Oracle's Advanced Queue. If not, can you please recommend an open-source, light-weight and more importantly RELIABLE point-to-point queue implementation, built on postgres? Something similar to Oracle's Advanced Queue? I don't ne

[GENERAL] Usability Question

2005-11-27 Thread Hill-Managementberatung
Title: Nachricht    Hi,   I have just started to have a look at Postgres for the first time (after downloading version 8.1.0). What I read about it in the past weeks sounded promising. As recommended I had shut down the firewall/virus checking software on my developer machine during install.

[GENERAL] need help in designing a database.

2005-11-27 Thread Haim Ashkenazi
Hi I'm writing an application that calculates working hours for billing. there are three levels of billing. one for regular hours, one for evening/nights, and one for saturdays/holidays. My first decision is wether I make these calculations in a database view (If I understand correctly, it would

Re: [GENERAL] Tcl Support in the FC4 rpms at posgresql.org?

2005-11-27 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sun, 27 Nov 2005, Jerry LeVan wrote: The "--rebuild" option is not recognized by the default rpm supplied with FC4. Arrgh... It was also a typo in README.rpm-dist file :( I've fixed in our CVS. (See below) There is an rpmbuild comman

Re: [GENERAL] Tcl Support in the FC4 rpms at posgresql.org?

2005-11-27 Thread Jerry LeVan
Hmm. The "--rebuild" option is not recognized by the default rpm supplied with FC4. There is an rpmbuild command, but it always appears to do an "install". Is there any way to simply build the binary rpms from the postgresql src rpm without doing an "install"? Browsing about, I found the P

Re: [GENERAL] Tcl Support in the FC4 rpms at posgresql.org?

2005-11-27 Thread Devrim GUNDUZ
Hi, On Sun, 27 Nov 2005, Jerry LeVan wrote: Is Tcl support included in any of the FC4 rpms located at postgresql.org? { I am talking about the 8.1 release }. No. If you need the tcl rpm, you need to rebuild our srpm: rpm --rebuild --define 'tcl 1' postgresql-8.1.0-2PGDG.src.rpm Regards, -

[GENERAL] Tcl Support in the FC4 rpms at posgresql.org?

2005-11-27 Thread Jerry LeVan
Is Tcl support included in any of the FC4 rpms located at postgresql.org? { I am talking about the 8.1 release }. (Tain't clear from the names of the rpms...) If tcl support is in one of the rpms then does the install proceed by downloading all of the rpms into a single directory and then issue

Re: FW: [GENERAL] GRANT question

2005-11-27 Thread Freemail
Dear Michael, certainly I tried and seems to be ok. Maybe I fogot to copy it into my letter? -- csaba -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Sunday, November 27, 2005 4:50 PM To: Együd Csaba (Freemail) Cc: 'Tom Lane'; pgsql-general@postgresql.org Subject:

[GENERAL] Default and PQexecParams

2005-11-27 Thread Jerry LeVan
Hi, How could one differentiate between DEFAULT and 'DEFAULT' as parameters to PQexecuteParams? Jerry ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: FW: [GENERAL] GRANT question

2005-11-27 Thread Michael Fuhr
On Sun, Nov 27, 2005 at 08:02:37AM +0100, Egyd Csaba (Freemail) wrote: > thak you very much! Now it works well. [...] > moson.gdb=# select current_schemas(true); >current_schemas > - > {pg_catalog,public} > (1 row) > > moson.gdb=# SELECT edenproc_usesysid('probauser'); >

Re: [GENERAL] Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1

2005-11-27 Thread Brendan Jurd
> Already done in 8.1. Here's an excerpt from the Release Notes: > > Automatically use indexes for MIN() and MAX() (Tom) > > In previous releases, the only way to use an index for MIN() > or MAX() was to rewrite the query as SELECT col FROM tab ORDER > BY col LIMIT 1. Index usage now

[GENERAL] Login limitation?

2005-11-27 Thread Együd Csaba
Hi All, I'd like to know if there is a method to let a user login into only predefined databases? I know that I could edit pg_hba.conf to achive this, but - there will be many databases on the server with the same structure but with different data - there will be "local admins" who must be able t