[SQL] creating variable views

e database. Is there a way to get the user name in Postgresql? Even if the variable pg_user is not available, is it possible to create views using variables like that? Thanks. -- Dado Feigenblatt Wild Brain, Inc. Technical Director (415

Re: [SQL] creating variable views

issions) with groups that describe projects (and its required permissions). But still, I'm not sure if I should implement that on the interface or use views that select rows pertaining only to the user's projects. Any pointer on that would be immensely appreciated. But the info yo

[SQL] indexing of hierarchical data

ojects and sequences, and their codes, which happens. Is this approach ok or should I stick to serial ID's and make the lookups? Any comment on problems like this? Thanks. --  Dado Feigenblatt Wild Brain, Inc.    Technical Director   (

Re: [SQL] indexing of hierarchical data

me soon I'll have to get you dinner ;) Thanks. PS: can't your e-mail client insert >'s on replies? It's kind of heard to sift through. --  Dado Feigenblatt Wild Brain, Inc.    Technical Director   (415) 553-8000 x??? [EMAIL PROTECTED]   San Francisco, CA.  

[SQL] duplicated OIDs ?

d the dumped data in again, with OIDs. So now I have duplicated records with *duplicated OIDs* !!! I thought that would *never* happen, even with COPY table WITH OIDS FROM stdin; PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96 -- Dado Feigenblatt Wild B

[SQL] ERROR: UNIQUE constraint matching given keys for referenced table "sequences" not found

ences" not found The problem is that the referenced field and table exist. Any hint? Using psql and PostgreSQL 7.1.1 on RedHat 7.1 Thanks. -- Dado Feigenblatt Wild Brain, Inc. Technical Director (415) 553-8000 x??? [

[SQL] nextval on insert by arbitrary sequence

on the client ? What is the approach for this problem? Thanks. PS: Hmmm... It doesn't look like I got my terminology right. Sorry for that. -- Dado Feigenblatt Wild Brain, Inc. Technical Director (415) 553-8

Re: [SQL] nextval on insert by arbitrary sequence

e sever turns out to be a drag. But I'd like to avoid that as much as possible. I wan't to keep the clients clean so it's easier for people here to hack them. On the other hand, the more obscure the code is, the safer my position here :) -- Dado Feigenblatt

Re: [SQL] nextval on insert by arbitrary sequence

Henry House wrote: >On Thu, Jul 19, 2001 at 07:17:20PM -0700, Dado Feigenblatt wrote: > >>I'm not sure if I worded the subject right, but my problem is this: >> >>I have a few entries in one table. Each row is the parent of many >>entries in a second table. &g

[SQL] PLpgSQL

iasing), or just use $1 in the string concatenation. I always get the same message. Considering that all the above is possible/fixable... 3. On the statement 'create sequence seq_name;', will 'seq_name' be evaluated properly? Thanks. -- Dado Feigenb

Re: [SQL] Get the tables names?

; The only thing is that this includes system tables. So if you want to strip those you need to SELECT relname , relowner FROM pg_class WHERE relkind = 'r' and relowner != 26; Is user postgres always 26? Maybe you have to find that out first. -- Dado Feigenbl

[SQL] Re: PLpgSQL

Although nowhere it is mentioned that you can only use INSERT, SELECT, UPDATE, DELETE. But still, the $1 is still plaguing me. Thanks. >>-----Original Message- >>From: Dado Feigenblatt [SMTP:[EMAIL PROTECTED]] >>Sent: Friday, July 20, 2001 2:26 PM >>To: Pgsql-Sql >

Re: [SQL] nextval on insert by arbitrary sequence

ence B Is it clear now, or is it me who's not understanding what you're saying? Sorry for the confusion. -- Dado Feigenblatt Wild Brain, Inc. Technical Director (415) 553-8000 x??? [EMAIL PR

Re: [SQL] oid's in views.

ll tables usq uniqueness between them. > >This strategy has allowed me to write a number of functions which are >table-agnostic, needing only the usq to do their job (such as a function >that creates modification hisotry). > >-Josh Berkus > Hi Josh! Once you have you