[SQL] Debugging ?

How do I do some tracing to debug a Function... ? I've read that to raise warnings / Exception / ... is the only mean (beside not having any faults) & then look in Logs. Is it so ? Tx, Thomas, -- Thu Jan 4 20:19:03 CET 2001 Thomas SMETSe-mail

[SQL] Casting

t find the modulo function where is it ? tx, Thomas, -- Thu Jan 4 20:19:03 CET 2001 Thomas SMETSe-mail : [EMAIL PROTECTED] Av. de la Brabançonne 133 / 3 Tel. : +32 (0)2 742. 05. 94. 1030 Bruxelles === Quote of the Day = Jealousy is all the fun

Re: [SQL] Looking for comments

1. General comment: you use lettercase to divide words in table and fieldnames; this will be lost as soon as you create the tables, because PostgreSQL folds everything to lower case. Use _ to separate words instead. OK it should be done everywhere where I did some changes, at least. I

Re: [SQL] References to SERIAL

the documentation on contraints and > foreign keys (I believe they are under the CREATE TABLE documentation). > -- Sat Dec 30 15:23:42 CET 2000 Thomas SMETSe-mail : [EMAIL PROTECTED] Av. de la Brabançonne 133 / 3 Tel. : +32 (0)2 742. 05. 94. 1030 Bruxelles =

[SQL] References to SERIAL

f Book def ); create table books_authors ( ??? // I want to reference the book pk & the author pk to be able to make the X-ref ? ); tx, THomas -- Sat Dec 30 15:23:42 CET 2000 Thomas SMETSe-mail : [EMAIL PROTECTED] Av. de la Brabançonne 133 / 3 Tel.

[ADMIN] Toad version for PostgreSQL

Toad (the graphical interface for Oracle) has a functionnality that allows one to dispaly tables & have them defined in the tool accordingly. Is there an equivalent tool for PostgreSQL ? Tx, thomas, -- Sat Dec 30 00:39:50 CET 2000 Thomas SMETSe-mail : [E

Re: [SQL] [ADMIN] Running a file

Yep, Tx, Thomas, p.s. Sorry for the stupid question Raju Mathur wrote: > > Hi Thomas, > > Is it possible you're looking for: > >psql -f script.sql > > ? > > Regards, > > -- Raju > > >>>>> "Thomas"

[Fwd: [SQL] Looking for comments]

Admin <--> What to Config, How, Customisable ... Any help is most than welcome. thomas, -- Sat Dec 30 00:39:50 CET 2000 Thomas SMETSe-mail : [EMAIL PROTECTED] Av. de la Brabançonne 133 / 3 Tel. : +32 (0)2 742. 05. 94. 1030 Bruxelles === Quote of the Day =

Re: [SQL] Looking for comments

Oliver, At the moment Tx for all your remarks... I'll need some times to digest them all! I'll keep this thread inform on updates Regards, Thomas Oliver Elphick wrote: > > Thomas SMETS wrote: > > > >Rather thant making long sent

Re: [SQL] Running a file

Tx, Thomas, "Brett W. McCoy" wrote: > > On Sun, 24 Dec 2000, Thomas SMETS wrote: > > > I'm runnin postgres 7.?? (Last RPM package available from the site). > > > > I want to create a few DB creation scripts so I can "publish" that > >

[SQL] Looking for comments

Thu Dec 28 23:51:18 CET 2000 Thomas SMETSe-mail : [EMAIL PROTECTED] Av. de la Brabançonne 133 / 3 Tel. : +32 (0)2 742. 05. 94. 1030 Bruxelles === Quote of the Day = The story of the butterfly: "I was in Bogota and waiting for a lady friend. I w

[SQL] Running a file

missing one of the very first possibility of "pgsql". Could someone point me were I could find some more infos on that matter ? Tx, Thomas, p.s. : Merry Xmas for some / Enjoy Ead / Merry Solstice for the others :-) -- Sun Dec 24 13:32:35 CET 2000 Thomas SMETS

[SQL] Don't understand creation statement's answer

my author_id changesdin a "nextval('author_seq'::text)". There's no text here ? That for highlighting the meaning of this ? Thomas, -- Sun Dec 17 19:42:31 CET 2000 Thomas SMETSe-mail : [EMAIL PROTECTED] Av. de la Brabançonne 133 / 3 Tel. :

[SQL] [Fwd: inserting integer in Table]

values (" + i + > ")") > print " inserted" > except TypeError,e: > print '\nerror ', e, 'undefined' > #conn.query( "update test_blob_s set filename = '" + name + "')