Re: [SQL] indexing of hierarchical data

Josh Berkus wrote: Dado,     Yeah, me again.  What can I say?  I'm procrastinating, and list stuff is a great way to do it.  And I prefer design theory issues. project    sequence shot CopFilm1   alley shooting   death of the bad guy CopFilm2   car chase    death of the bad guy Co

Re: [SQL] indexing of hierarchical data

Dado, Yeah, me again. What can I say? I'm procrastinating, and list stuff is a great way to do it. And I prefer design theory issues. project    sequence shot CopFilm1   alley shooting   death of the bad guy CopFilm2   car chase    death of the bad guy CopFilm3   car

[SQL] indexing of hierarchical data

We make cartoons here. But let's say we were working on 3 different Cop movies. Our projects are devided into project, sequence, and shot. project    sequence shot CopFilm1   alley shooting   death of the bad guy CopFilm2   car chase    death of the bad guy CopFilm3   car chase   

Re: [SQL] creating variable views

Dado, > Formatting functions? As in formatted output? Could you give an > example? Yes. For example, I have a function called: qf_format_contact_name (VARCHAR, VARCHAR, VARCHAR, VARCHAR) That produces (depending on data) formatted output like: Julie Snodgrass Ms. Keller, Law Clerk Human Re

Re: [SQL] creating variable views

Josh Berkus wrote: > Dado, > > Glad to have you with us. Incidentally, in answer to two of your > remarks: > > 1. "current_user", like "current_timestamp" is a built-in SQL92 > function, as opposed to a PostgreSQL function. As such, it does not > require () and takes no parameters. Hm

Re: [SQL] Is function atomic?

Richard Huxton writes: > All functions take place within a transaction, but since PG doesn't > support nested transactions yet you can't roll back the effects of a > nested function. Do you have any idea when it will? -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI

[SQL] view and performance

Is there any gain on performance if you choose to create a view over a very complex query instead of running the query itself directly? Thanks! -- Wei Weng Network Software Engineer KenCast Inc. ---(end of broadcast)--- TIP 4: Don't 'kill -9' t

Re: [SQL] Is function atomic?

Wei Weng writes: > What I wanted is simple: > I don't want other processes that run the function at the same time have > read/write access from the tables this function accesses(select and > insert/update). Is it possible, say, let other proccess blocked on this > function? See LOCK command. Bu

Re: [SQL] Is function atomic?

What I wanted is simple: I don't want other processes that run the function at the same time have read/write access from the tables this function accesses(select and insert/update). Is it possible, say, let other proccess blocked on this function? On 06 Jul 2001 18:49:49 +0200, Peter Eisentraut w

Re: [SQL] Is function atomic?

From: "Wei Weng" <[EMAIL PROTECTED]> > If it is not, is it possible to acquire a lock on a row ? how about a > lock on a table? All functions take place within a transaction, but since PG doesn't support nested transactions yet you can't roll back the effects of a nested function. - Richard Hux

Re: [SQL] Is function atomic?

Does that mean if I used DECLARE ... BEGIN DO_STUFF END; the DO_STUFF will not be interrupted (maintain atomicity) even when multiple threads use the function concurrently? On 06 Jul 2001 18:13:37 +0200, Peter Eisentraut wrote: > Wei Weng writes: > > > If it is not, is it possible to acquire a

Re: [SQL] Is function atomic?

Wei Weng writes: > Does that mean if I used > DECLARE > ... > BEGIN > DO_STUFF > END; > > the DO_STUFF will not be interrupted (maintain atomicity) even when > multiple threads use the function concurrently? Interruption, atomicity, and concurrency are separate issues. The function could of cou

[SQL] create type of table

I have a problem where I need to restrict queries by more than a million ids that are the result of another program. Typically I would in the application layer write those ids into an IN( ) clause, but that will not work for more than 10,000 ids. So I need to load these ids into the db into some s

Re: [SQL] PL/TclU

Roberto Mello writes: > I've heard quite a bit about PL/TclU, but what's the difference > between that and regular PL/Tcl?? It's untrusted ("U") and can do anything a normal Tcl interpreter can do. Regular PL/Tcl is constrained in various way to make it safe to offer it to normal users. -

Re: [SQL] Is function atomic?

Wei Weng writes: > If it is not, is it possible to acquire a lock on a row ? how about a > lock on a table? SQL statements issued by server-side functions operate with the same transaction isolation semantics as "normal" SQL statements. However, whatever the function does outside the database m

[SQL] PL/TclU

I've heard quite a bit about PL/TclU, but what's the difference between that and regular PL/Tcl?? Thanks, -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http:/

[SQL] Is function atomic?

If it is not, is it possible to acquire a lock on a row ? how about a lock on a table? Thanks a lot! -- Wei Weng Network Software Engineer KenCast Inc. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Cross database foreign keys

Morgan Curley writes: > Does anyone know if it is possible to connect to a differernt db from > within a plsql function. > I have multilple inter-related schemas and want to enforce some fk > relationships. Not possible -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~pete

Re: [SQL] finding current oid

postgresql writes: > Is there a way to return the current oid of a transaction? Transactions don't have oids, only table rows do. The libpq function PQoidValue() will possibly give you the last affected oid. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---

Re: [SQL] Cross database foreign keys

Morgan, > Does anyone know if it is possible to connect to a differernt db from > within a plsql function. > I have multilple inter-related schemas and want to enforce some fk > relationships. Currently Postgres does not support any SQL operations between databases. It may someday in the futur

[SQL] Re: [GENERAL] Cross database foreign keys

Morgan Curley wrote: > Does anyone know if it is possible to connect to a differernt db from > within a plsql function. > I have multilple inter-related schemas and want to enforce some fk > relationships. PL/pgSQL doesn't support external database connects. PL/TclU does. But keep i

Re: [SQL] While Using COPY COMMAND ...

Bhuvan A writes: > bhuvan=# copy f_addr_phones with oids to > '/home/bhuvan/fap-table'; > ERROR: COPY command, running in backend with effective uid > 1015, could not open file '/home/bhuvan/fap-table' for > writing. Errno = Permission denied (13). The server is probably running under a differ

[SQL] finding current oid

Is there a way to return the current oid of a transaction? I am trying to: begin; insert into db something; select current session oid commit; I will only ever be inserting one row during the transaction. Is this doable? Thanks for your time. Ted ---(end of broad