Re: [SQL] -query sql

2000-10-09 Thread John McKown
On Tue, 3 Oct 2000, Nema, Vivek wrote: > Hi! >a small query may be u can help me. > i just wanted to compare 2 columns in 2 tables.how can i do it in sql > statement.i know it is possible somehow i am not able to write my query. > i am using RDB 6.0 > > Any pointer or help will be highly ap

Re: [SQL] "Delete before" in ms sql?

2000-10-09 Thread Josh Berkus
Mr. Vadsholt, This is a Postgre-SQL list. If you are using Microsoft SQL Server you should proceed to http://msdn.microsoft.com/ -Josh Berkus -- __AGLIO DATABASE SOLUTIONS___ Jos

[SQL] "Delete before" in ms sql?

2000-10-09 Thread Lars Vadsholt
Hi. Sorry for the newbie question. Does MS SQL have something like a "before delete" when using a trigger? best regards Lars

[SQL] -query sql

2000-10-09 Thread Nema, Vivek
Hi! a small query may be u can help me. i just wanted to compare 2 columns in 2 tables.how can i do it in sql statement.i know it is possible somehow i am not able to write my query. i am using RDB 6.0 Any pointer or help will be highly appreciated. Thanx -vivek

Re: [SQL] OID Perfomance - Object-Relational databases

2000-10-09 Thread Bruce Momjian
There is an FAQ item about oid's already on the web site. It may not be in 7.0.2. > Tom, Bruce, > > Thanks. I think that gives me a pretty clear picture. How can we > submit this whole OID thing to the PGSQL FAQ? Want me to write it up? > > -Josh

[SQL] Re: [HACKERS] foreign key introduces unnecessary locking ?

2000-10-09 Thread Stephan Szabo
On Mon, 2 Oct 2000, Rini Dutta wrote: > When two tables (table2 and table3) have foreign keys > referring to a common table(table1), I am unable to > have 2 concurrent transactions - one performing insert > on table1 and the other on table2, when the records > being inserted have the same foreign

[SQL] RE: [HACKERS] foreign key introduces unnecessary locking ?

2000-10-09 Thread Mikheev, Vadim
Try this for both FK tables: create table tmp2(idx2 int4, col2 int4, constraint tmpcon2 foreign key(col2) references tmp1(idx) INITIALLY DEFERRED); This will defer constraint checks till transaction commit... though constraint triggers should use SnapshotDirty instead of SELECT FOR UPDATE anyway

Re: [SQL] OID Perfomance - Object-Relational databases

2000-10-09 Thread Josh Berkus
Tom, Bruce, Thanks. I think that gives me a pretty clear picture. How can we submit this whole OID thing to the PGSQL FAQ? Want me to write it up? -Josh Berkus P.S. BTW, my conclusion based on this discussion is that I will not use the OIDs for

Re: [SQL] Q: spinlock on Alpha? (PG7.0.2)

2000-10-09 Thread Fabrice Scemama
Try this: http://www.rkirkpat.net/software/ Emils Klotins wrote: > > RedHat Linux 6.2 on Alphaserver DS10 (egcs-1.1.2, glibc-2.1.3, > libstdc++-2.9.0). > Postgresql-7.0.2 source > > Compiles and installs just fine. However, both the regular initdb and > parallel regression testing's initdb stag

Re: [SQL] OID Perfomance - Object-Relational databases

2000-10-09 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] > Bruce, Tom, etc.: > > > > This is what I mean. Does the DB engine only recycle > > > *unused* OIDs (that is, does it check for teh continued > > > existance of a tuple with OID 198401)? If that's the > > > method, then there isn't really a pro

Re: [SQL] OID Perfomance - Object-Relational databases

2000-10-09 Thread Josh Berkus
Bruce, Tom, etc.: > > This is what I mean. Does the DB engine only recycle > > *unused* OIDs (that is, does it check for teh continued > > existance of a tuple with OID 198401)? If that's the > > method, then there isn't really a problem even if I do > use > > OIDs as a primary index. None of

Re: [SQL] OID Perfomance - Object-Relational databases

2000-10-09 Thread Josh Berkus
ruce, > The oid counter is preserved with -o on reload. It is > not reset. I'll let you and Tom duke this one out. :-) It's all beyond me. > > 2. When OID's "wrap around" does the whole database go > > kablooie? If so, why hasn't it happened to anyone yet? > If

Re: [SQL] Table Attribute Help

2000-10-09 Thread omid omoomi
Hi, >From: "Brian C. Doyle" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [SQL] Table Attribute Help >Date: Mon, 09 Oct 2000 11:21:21 -0400 > >Hello all, > >I am trying to find a query to retrive the attributes of a table as in \d >tablename but as a select command. Is this possible? > >

Re: AW: [SQL] Table Attribute Help

2000-10-09 Thread Brian C. Doyle
That is great thank you. How would I grab the attribute type for an attribute with it so that the out put would look like attname atttype -- -- userid varchar(30) I know that is not correct but is it possible to get that out put At 05:27 PM 10/9/00 +0200, you

Re: [SQL] Table Attribute Help

2000-10-09 Thread Jeff Hoffmann
"Brian C. Doyle" wrote: > > Hello all, > > I am trying to find a query to retrive the attributes of a table as in \d > tablename but as a select command. Is this possible? run "psql -E" -- it will echo all of the sql queries that those commands use. -- Jeff Hoffmann PropertyKey.com

[SQL] Table Attribute Help

2000-10-09 Thread Brian C. Doyle
Hello all, I am trying to find a query to retrive the attributes of a table as in \d tablename but as a select command. Is this possible?

Re: [SQL] Loading JDBC Driver

2000-10-09 Thread Peter Mount
On Thu, 5 Oct 2000, Jos Hernndez Zavala wrote: > Hello. > > I am trying to load a jdbc driver for postgres, only I > want to make it from an Applet. For an application I > used the form: > > Class.forName ("postgresql.Driver"); > > Which the correct form would be to be able to mak