[SQL] plpythonu + os.spawnv

Dear all, I'm not sure if I'm at the right place to ask my question so please excuse me if I'm not. I'm trying to spawn a process from plpythonu using psql 8.1.11. The code is working fine from Python shell but if I put it into a plpythonu function it seems like the process isn't starting at

Re: [SQL] Composite UNIQUE across two tables?

Hi Jorge, On 3/7/08, Jorge Godoy <[EMAIL PROTECTED]> wrote: > Em Thursday 06 March 2008 22:10:14 Jamie Tufnell escreveu: > > I'm not sure how I would enforce that the site_group_id > > added to the users table would correspond correctly with > > the site_id (as per the sites table). Perhaps I wou

Re: [SQL] Composite UNIQUE across two tables?

Hi Bart, On 3/7/08, Bart Degryse <[EMAIL PROTECTED]> wrote: > I haven't tested these two statements, but I'm using exactly this > concept on some tables myself. > My equivalent of your users table contains some 3,000,000 records. > My equivalent of your sites table contains some 150,000 records. >

Re: [SQL] Composite UNIQUE across two tables?

Hi Ray, On 3/7/08, Ray Madigan <[EMAIL PROTECTED]> wrote: > How I think about it. > > A user has access to a site and all of the sites within the site group that > the site is in. > > if you reword your condition > > A user has access to all of the sites in a site group with a default defined > by

Re: [SQL] UPDATE .. FROM

"Markus Bertheau" <[EMAIL PROTECTED]> writes: > I'm kind of stuck as to why postgresql doesn't understand what I mean in the > following queries: > UPDATE tag_data td SET td.usage_counter = td.usage_counter + 1 FROM > tag_list_tag_data ltd WHERE ltd.tag_id = td.id AND ltd.id = 102483; > ERROR: c

Re: [SQL] RETURN QUERY generates error

> The error sounds suspiciously like what would happen if you tried to > use RETURN QUERY in a pre-8.3 version. > > regards, tom lane > Thanks a lot to all. Actually there were a mass of errors in my function. Now I rewrite it so as it works. It would be much more complica

[SQL] UPDATE .. FROM

I'm kind of stuck as to why postgresql doesn't understand what I mean in the following queries: UPDATE tag_data td SET td.usage_counter = td.usage_counter + 1 FROM tag_list_tag_data ltd WHERE ltd.tag_id = td.id AND ltd.id = 102483; ERROR: column "td" of relation "tag_data" does not exist LINE 1:

Re: [SQL] Composite UNIQUE across two tables?

Hi Bart, I'm following this topic with interest. Could you describe me more how you design an unique index with both a column name and a function name by an example Thx. Sebastien De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Bart Degryse E

Re: [SQL] Composite UNIQUE across two tables?

I haven't tested these two statements, but I'm using exactly this concept on some tables myself. My equivalent of your users table contains some 3,000,000 records. My equivalent of your sites table contains some 150,000 records. And it works fine... CREATE OR REPLACE FUNCTION "fnc_idx_sitegroupid

Re: [SQL] Composite UNIQUE across two tables?

create a function that, given the siteid returns the sitegroupid create a unique index on username and that function >>> "Jamie Tufnell" <[EMAIL PROTECTED]> 2008-03-06 20:04 >>> Hi, I'm remodeling our authentication tables at the moment to accomodate future changes. I've hit a wall and thought I