[SQL] 9.0+ way of determining if a LISTEN channel has a backend listening?

* session is listening on; I'd like to find out if a given listen channel has *any* (i.e other session) listeners. Thanks! James Robinson Socialserve.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

[SQL] 8.4 versus 8.2 against nonexistent column "name" ...

BLE INSERT 0 3 ERROR: column "name" does not exist LINE 1: select name from foo; ^ name (1,23) (2,43) (4,45) (3 rows) A quick skim through the 8.3. and 8.4. release notes found nothing interesting related to 'name'. Thanks! James Robinso

[SQL] Index to enforce non-overlapping ranges?

of r-tree index? James Robinson Socialserve.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Subselects in CHECK clause ...

ntial integrity constraint) modifications on that other table could also cause the constraint to be violated, but that isn't caught by the CHECK function(...) case and you'll probably need triggers or other constraints on that table. James Robinson Socialserve.com -

[SQL] Subselects in CHECK clause ...

ently, CHECK expressions cannot contain subqueries nor refer to variables other than columns of the current row." Is this due to someone not yet writing the necessary code to remove the subquery clause, or is there a more fundamental reason? ---- James Robinson Socia

Re: [SQL] SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join

Oh that's sweet and all I needed anyway thanks. On Oct 6, 2006, at 12:25 PM, Tom Lane wrote: Note that you can select "FOR UPDATE OF a" in this situation, it's just the B side that is problematic. James Robinson Socialserve.com

[SQL] SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join

cannot be applied to the nullable side of an outer join Is this behavior spec-mandated, or could only the rows in B which are not-null be locked? James Robinson Socialserve.com ---(end of broadcast)--- TIP 1: if posting/reading through

Re: [SQL] Design question: Scalability and tens of thousands of tables?

into separate schemas (say, schema 'a' -> 'z' according to username or some better hashing routine like brute-force round-robin assignment at user creation time). Assignment of objects -> schema would be one additional column in your centralized user directory

Re: [SQL] [JDBC] Prepared Statements and large where-id-in constant blocks?

if we're going to test for membership as opposed to performing selection searches on a list. Probably a dead-horse beaten elsewhere. Many Thanks. James Robinson Socialserve.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Prepared Statements and large where-id-in constant blocks?

lanned differently from the 800-value form, since the 800-value form might well prefer a full sequential scan, since the table might only have 900 live rows in it. Anyone have any insight or opinions? [ crossposted to pgsql-sql for anyone's insight into the pure SQL /

[SQL] Utility of recursive queries?

r_par; cur_par := parent from list where id = prev_par; END LOOP; return prev_par; END; ' language 'plpgsql'; James Robinson Socialserve.com ---(end of broadcast)--- TIP 2: you can get off al