Re: [GENERAL] Practical question.

On 3/17/07, louis gonzales [EMAIL PROTECTED] wrote: Statement-level triggers follow simple visibility rules: none of the changes made by a statement are visible to statement-level triggers that are invoked before the statement, whereas all modifications are visible to statement-level after

Re: [GENERAL] Creation of a read-only role.

actually - you dont need the read-only role, if this is only for slave nodes. slony takes care about the issue and doesn't allow any writes on slaves. Great! But what about a role which can modify the data, but cannot modify the database schema? On 3/17/07, hubert depesz lubaczewski [EMAIL

Re: [GENERAL] Creation of a read-only role.

Oh, sorry for the previous question - I can create a scheme-changes-disallowed role by revoking the CREATE permission from all the database schemas. The issue seems to be closed now, thanks. On 3/18/07, Dmitry Koterov [EMAIL PROTECTED] wrote: actually - you dont need the read-only role, if

[GENERAL] Design / Implementation problem

This is possibly not a DB only problem, the solution may involve application logic as well. But PG users are the smartest bunch I know. Ass kissing aside, here are the details: *** The Scenario *** We are running a customer loyalty program whereby customers earn points for purchasing

Re: [GENERAL] Design / Implementation problem

Here it is again with more sensible wrapping: *** The Scenario *** We are running a customer loyalty program whereby customers earn points for purchasing products. Each product has a value of points that are earned by purchasing it, and a value of points required to redeem it. In order to

Re: [GENERAL] Design / Implementation problem

Naz Gassiep [EMAIL PROTECTED] writes: that calculating the point balance on the fly is not an unfeasibly heavy duty calculation to be done at every page view? One alternative to calculate it everytime is calculating it once a day. If there are calculations for today, then just read the

Re: [GENERAL] Is This A Set Based Solution?

On Thu, 15 Mar 2007 09:47:27 -0500, [EMAIL PROTECTED] (George Weaver) wrote: in [EMAIL PROTECTED] Stefan Berglund wrote: foo WHERE (ID = 53016 OR ID = 27 OR ID = 292 OR ID = 512) or I could alternatively pass the string of IDs ('53016,27,292,512') to a table returning function which TABLE

[GENERAL] Own messages for constraints?

Hi ! Is it possible in postgres to define own message for some constraint? Example: If i create check constraint on zip_code column , i want to get a message: Zip code is invalid.Please,input code in format: nn-nnn and I want to send this message to the end user. It will be much better(in my

Re: [GENERAL] Is This A Set Based Solution?

On Thu, 15 Mar 2007 15:46:33 -0500, [EMAIL PROTECTED] (Bruno Wolff III) wrote: in [EMAIL PROTECTED] On Mon, Mar 12, 2007 at 11:15:01 -0700, Stefan Berglund [EMAIL PROTECTED] wrote: I have an app where the user makes multiple selections from a list. I can either construct a huge WHERE

Re: [GENERAL] Is This A Set Based Solution?

On Fri, 16 Mar 2007 09:38:52 -0300, [EMAIL PROTECTED] (Jorge Godoy) wrote: in [EMAIL PROTECTED] Tino Wildenhain [EMAIL PROTECTED] writes: Show me a user which really clicks on 1000 or more checkboxes on a webpage or similar ;) I'd think around 20 values is plenty. On the other hand, show

Re: [GENERAL] issue with SELECT settval(..);

thanks a lot Christian. On 3/18/07, Christian Schröder [EMAIL PROTECTED] wrote: Alain Roger wrote: insert into immense.statususer (statususer_id, statususer_type) values (SELECT nextval( 'statususer_statususer_id_seq' ),'customer'); The correct syntax would be: insert into

Re: [GENERAL] Is This A Set Based Solution?

On Sat, 10 Mar 2007 08:26:32 +0300 (MSK), oleg@sai.msu.su (Oleg Bartunov) wrote: in [EMAIL PROTECTED] I don't know if you could change your schema. but I'd consider your problem as a overlapping arrays task and use contrib/intarray for that. That's a nice piece of work, Oleg, and extremely

Re: [GENERAL] PgSql on Vista?

Ok thanks i've fixed. The problem is with 8.2.3 installer, i tried 8.1.8 and I had no problem. Thanks On 3/15/07, Dave Page [EMAIL PROTECTED] wrote: --- Original Message --- From: Alvaro Herrera [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 15/03/07, 22:32:50 Subject:

[GENERAL] cannot get build (initdb) to work after trying for a week

I am getting truly desperate! I am trying to build any version of Postgres on Windows from source. First experience with Postgres source. I have struggled for days trying to solve a problem. Would be willing to pay for the solution!!! The following error occurred when issuing a vanilla initdb

Re: [GENERAL] cannot get build (initdb) to work after trying for a week

Eric wrote: I am getting truly desperate! I am trying to build any version of Postgres on Windows from source. First experience with Postgres source. I have struggled for days trying to solve a problem. Would be willing to pay for the solution!!! The following error occurred when issuing

Re: [GENERAL] cannot get build (initdb) to work after trying for a week

Eric wrote: I am getting truly desperate! I am trying to build any version of Postgres on Windows from source. First experience with Postgres source. I have struggled for days trying to solve a problem. Would be willing to pay for the solution!!! The following error occurred when issuing

Re: [GENERAL] Design / Implementation problem

Naz First, there is nothing you can do about the computational load except make your code as efficient as possible. Get it right and then make it fast. But there is only so much you can do. If a calculation requires an integer sum and an integer difference, you inevitably have two integer

Re: [GENERAL] Is This A Set Based Solution?

On Thu, Mar 15, 2007 at 10:26:48AM -0700, Stefan Berglund wrote: that PostgreSQL would allow a substitutable parameter in the IN clause. However, it seems that it can't be done in this fashion without using dynamic SQL unless I'm missing something. The substitutable list has to be an array,

[GENERAL] Shell script to determine if PostgreSQL is accepting connections?

Hi, Is there a simple way to determine with a shell script if PostgreSQL is ready to accept connections? PostgreSQL is started and controlled by daemontools. This shell script is called by the /etc/netstart script as a part of bringing up the first interface. Unfortunately, it will never

Re: [GENERAL] Is This A Set Based Solution?

Stefan Berglund [EMAIL PROTECTED] writes: I tried this: create or replace function foo(plist TEXT) RETURNS SETOF Show_Entries as $$ SELECT * FROM Show_Entries WHERE Show_ID = 1250 AND Show_Number IN ($1); $$ LANGUAGE sql; When I use select * from foo('101,110,115,120'); I get

Re: [GENERAL] PostgreSQL 8.2.3 VACUUM Timings/Performance

On Fri, Mar 16, 2007 at 07:06:57PM -, Bruce McAlister wrote: Okay, I'm getting a little further now. I'm about to create entries in the pg_autovacuum system tables. However, I'm a little confused as to how I go about finding out the OID value of the tables. The pg_autovacuum table

[GENERAL] phpPgAdmin - prior version available?

Hi all, I have been struggling with phpPgAdmin 4.1 - login failures. There does not yet seem to be a fix. Where can I find a prior version for FC6 - rpm, tar.gz etc. Thanks, Bob ---(end of broadcast)--- TIP 5: don't forget to increase your

Re: [GENERAL] Shell script to determine if PostgreSQL is accepting connections?

On 10:44 Sun 18 Mar , Jeff Ross wrote: Hi, Is there a simple way to determine with a shell script if PostgreSQL is ready to accept connections? PostgreSQL is started and controlled by daemontools. This shell script is called by the /etc/netstart script as a part of bringing up the