[SQL] Mechanics of UpDate:Cascade

Hi, could someone please explain to me the mechanics of an UpDate:Cascade? Delete:Cascade I fully understand but not Update. I have 2 tables A and B. On B I have created a foreign key on user_id in both B and A for Update and Delete cascade. If I delete from A it deletes all from B. If I update

[SQL] postgreSQL and Hibernate

hi, just wanted to know whether anyone on this group uses Hibernate in conjunction with postgreSQL 7.4.1? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] bytea or blobs?

Hi, what I am trying to do is to be able to store images in my database. What I wanted to know is this: 1. Would it be better to have the image field type as a bytea or a blob? I have heard it mentioned that bytea would be better as doing data dumps would also insure that the image was saved as

[SQL] Trace for postgreSQL

Hi, can anyone tell me whether there is a trace facility (application) available for postgreSQL version 7.4.1 which will enable me to see all incoming requests being made to the database (ala SQL Server)? many thanks in advance. ---(end of broadcast)-

[SQL] Binary retrieval - *Best practice* recommendations...

Hi, I have a table in postgreSQL, ver. 7.4.1, which serves up image data(JPEG) to users browsers. In various posts I have read there has been a favour towards storing image data as bytea (byte[]) instead of storing the filesystem location of the image, or whatever binary data is, in the databa

[SQL] Read bytea column from table and convert into base64.....

Hi, I have a bytea column which I want to convert into base64. At the moment I am reading the bytea colum into my java app as a byte[]. I am then calling another static method to convert the byte[] into base64. I want postgreSQl to handle the conversion so my app can read in the base64 string.

[SQL] trace facility

Is there a trace facility that i can use with postgreSQL 7.3.4, ala SQLServer 2000? many thanks in advance ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not ma

[SQL] could not create shared memory segment: Invalid argument

Hi, I have just installed the latest version of OS X panther (10.3.3) and am now getting the following error message: postgres$ /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data FATAL: could not create shared memory segment: Invalid argument DETAIL: Failed system call was shmget(key=5

[SQL] SQL Query

Hi, I am trying to create a query which basically goes along the lines of: INSERT INTO tableX ( COL1, COL2 ) VALUES ( x, y ) where COL1 !=x and COL2 !=Y So, insert a record into tableX where there is not already an existence of COL1 and COL2 Can this be done as I have described or is there a mor