Re: [SQL] Does a the block of code within a stored procedure constitute a transaction?

>> What I need to know is whether or not this is multi-user safe, i.e., >> will the block of code in the procedure execute as a transaction so >> that if more than one clerk creates an expense report for the same >> employee simultaneously is it possible or impossible that value of >> the >> employ

[SQL] Using contrib/fulltext on multiple tables

I am running into a problem with using contrib/fulltext on several tables. Here's the details... I have one sql script which drops everything and recreates the database structure, then populates it with some test data. In this script I create tables a,b and c and setup the triggers for fulltext i

Re: [SQL] select query that would join two databases

Take a look at the dblink() contrib module. PostgreSQL does not currently support inter-database joins BUT it does offer Schemas which is often enough. Take each of your source databases and toss them into two different schemas of the same database. On Wed, 2003-07-30 at 07:28, Keith H.K. Lam (U

Re: [SQL] join optimization problem

How about this? It should spit out the same number, but be quite a bit quicker at it. Untested of course... select t.thread_id, t.forum_id, t.thread_title, t.thread_owner, t.thread_owner_id, t.date_created,

Re: [SQL] join optimization problem

Toby Tremayne <[EMAIL PROTECTED]> writes: > the explain data I'm currently getting is this: "explain analyze" would be much more useful. Also, I assume you've vacuum analyzed these tables recently? regards, tom lane ---(end of broadcast)--

Re: [SQL] Does a the block of code within a stored procedure constitute

> What I need to know is whether or not this is multi-user safe, i.e., will > the block of code in the procedure execute as a transaction so that if > more than one clerk creates an expense report for the same employee > simultaneously is it possible or impossible that value of the > employee.expen

Re: [SQL] [GENERAL] ALTER TABLE ... DROP CONSTRAINT

--- Elielson Fontanezi <[EMAIL PROTECTED]> wrote: > Hi all! > > Who can tell me what postgres version supports > ALTER TABLE... DROP > CONSTRAINT without > the need of droping the table to remove a simple > coinstraint. (link) > > Elielson Fontanezi > PRODAM - Technical Support > Analyst I

[SQL] select query that would join two databases

dear all, How to create a query that would join two databases? In MSSQL, i use select * from dbA.dbo.tableA a dbB.dbo.tableB b where a.id=b.id Is there anyway to write the above query in postgressql ? Please email me back. Thanks, Keith ---(end of broadcast)

Re: [SQL] One to many query question

On Wed, Jul 30, 2003 at 02:35:20PM -0500, Dave Dribin wrote: > Hi, I'm having trouble with what I think should be an easy query. For > simplicity, I will use a CD database as an example. Each CD may have > multiple genres. Here's some sample data: > > Artist Title

[SQL] Does a the block of code within a stored procedure constitute a transaction?

I need to "manually" keep a sequence for each row of the employee table, i.e., I don't want to use postgres's built-in sequences for this application because the sequence numbers are used to generate expense report numbers on a "per-employee" basis. That is, each employee has a separate sequence co

[SQL] length of recordset read through a cursor

After declaring a cursor, one way of obtaining the length of the resultset is to perform a "MOVE 0" and read the PQcmdStatus which returns a "MOVE nn" where nn is the length of the resultset. (A negative MOVE can then be used to allow starting to fetch records from the beginning of the resultse

[SQL] join optimization problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm trying to optimize what I had thought was a simple enough query but I'm not having much success. It's from a forum based application, and the query in question is operating on two tables - fbof_msg (8563 rows) and fbof_thread(1

[SQL] converting interval to timestamp

The difference of two dates/timestamps always gives an interval. is there a way to convert this interval into number such as number of milliseconds or number of days? Also does anyone know what field type an interval would map to in jdbc? thanks ---(end of broadcast)

[SQL] Problem with looping on a table function result

I've met the following problem. I had successfully written a function divide_into_days(timestamp, timestamp) which returns setof (timestamp, timestamp) pairs - a list of days the given interval is divided into. What I want is to use each record from resultset to pass to another function, something

[SQL] RI_ConstraintTrigger_11264756

All, I have inherited a table (below) with a RI trigger. I believe this table was created where both clone_id & blastx_id are FKs w/ stipulation 'ON DELETE CASCADE'. My question is, is this specified in the trigger: RI_ConstraintTrigger_11264756? If so how would I learn the content of the trigge

[SQL] Problem login to phpPgAdmin 2.x and 3.x

Hi, i have PostgreSQL 7.2.1 . I create new user as postgres. When i login to phpPgAdnin them phpPgAdmin return "Login failed". Where is problem ? My php script runing without problems. Thanks. -- Rado Petrik <[EMAIL PROTECTED]> ---(end of broadcast)---

Re: [SQL] problem in database backup

On Thursday 31 July 2003 12:13, vijaykumar M wrote: *please* don't post HTML only emails to mailing lists OK - you seem to have two pg_dump - one in /usr/bin/pg_dump and one in /usr/local/pgsql/bin/pg_dump. If you type "which pg_dump" as the user who normally does the dump, which one does it sh

Re: [SQL] problem in database backup

Hi Tomasz Myrta, Thanks for ur info, u r correct .. after pointing to /usr/bin/pgsql/bin/pg_dump, i'm able to take backup.. Thank u very much.. With Regards Vijay   >From: Tomasz Myrta <[EMAIL PROTECTED]> >To: vijaykumar M <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: [SQL] problem in

Re: [SQL] problem in database backup

Dnia 2003-07-31 13:13, Użytkownik vijaykumar M napisał: Hi All, I'm using Postgresql V7.3.3, on that i created one database with name "mydb". * PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)* While taking a backup of my postgresql datab

[SQL] problem in database backup

Hi All, I'm using Postgresql V7.3.3, on that i created one database with name "mydb".  PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) While taking a backup of my postgresql database, i'm getting the below error. bash-2.05b$ pg_dump mydb >myd

Re: [SQL] Fwd: Bad Join moment - how is this happening?

> I have a view: > > create or replace view addenda as > select > documents.id, > documents.oid, > documents.projects_id, > documents.doc_num, > documents.description, > documents.date, > documents.createdate, > documents.moddate, >

[SQL] Unsubscribe

Unsubscribe

Re: [SQL] NEW and a subselect in a rule

> > So, I met such a problem: it's impossible to use NEW in a subselect > used in a (non-select) rule. The error is: exist>. Is this a way to do that newertheless (without using of a > function, of course)? > Could we see the CREATE RULE command causing the error? Regards, Christoph -

Re: [SQL] One to many query question

> > On Wed, Jul 30, 2003 at 05:26:23PM -0400, Dmitry Tkach wrote: > > >How do I write a query to find all CDs that are NOT Rock? > > > > > What about > > select * from cd where not exists (select 1 from cd_genres where cd_id > > = cd.id and genre='Rock')? > > Thanks everyone! This did indeed work,