[SQL] unsubscribe

[beyaNet]

unsubscribe
---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

[SQL] test1

[beyaNet]

2,3,4,5
---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

[SQL] problems using phpPgAmin

[beyaNet]

Hi,
to those of you that may be using the above named admin tool, any ideas 
why I am unable to login with the postgres username even though I have 
amended the pg_hb file? Are there any other admin tools out there that 
i could use on a a unix box?

many thanks
Andrew
---(end of broadcast)---
TIP 8: explain analyze is your friend

[SQL] postgreSQL 8beta

[beyaNet]

Hi,
does postgresql have a datatype 'other' which in hsqldb is an Object? I am trying to convert the table below into postgreSQL 8:


 create table TIMERS ( 
TIMERID varchar(50) not null, 
TARGETID varchar(50) not null, 
INITIALDATE timestamp not null, 
INTERVAL bigint, 
INSTANCEPK other, 
INFO other, 
constraint timers_pk primary key (TIMERID) 


regards


Andrew

[SQL] Mechanics of UpDate:Cascade

[beyaNet Consultancy]

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 A what happens in B?

regards

Andrew

---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

[SQL] postgreSQL and Hibernate

[beyaNet Consultancy]

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?

[beyaNet Consultancy]

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 well!

2. Would it be better to make reference to mp3 files (i.e. storing the 
address of the image /images/*.jpg)  or is it feasible to store the mp3 
in the database as bytea or blobs as well?

many thanks in adavance

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[SQL] Trace for postgreSQL

[beyaNet Consultancy]

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)---
TIP 7: don't forget to increase your free space map settings

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

[beyaNet Consultancy]

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 database. I have decided to store my images on the database 
and wanted to know what *best practice* performance tweaks you suggest 
I make to postgreSQL in terms of minimising the time it takes to serve 
binary data to users?

many thanks in advance

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

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

[beyaNet Consultancy]

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.

So for example:

select (base64)byteaColumn from tableName where artistID = x

many thanks in advance

---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

[SQL] trace facility

[beyaNet Consultancy]

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 match

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

[beyaNet Consultancy]

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=5432001, size=10444800, 
03600).
HINT:  This error usually means that PostgreSQL's request for a shared 
memory segment exceeded your kernel's SHMMAX parameter.  You can either 
reduce the request size or reconfigure the kernel with larger SHMMAX.  
To reduce the request size (currently 10444800 bytes), reduce 
PostgreSQL's shared_buffers parameter (currently 1000) and/or its 
max_connections parameter (currently 100).
If the request size is already small, it's possible that it is 
less than your kernel's SHMMIN parameter, in which case raising the 
request size or reconfiguring SHMMIN is called for.
The PostgreSQL documentation contains more information about 
shared memory configuration.

Any ideas on how i can resolve this issue?

many thanks in advance

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[SQL] SQL Query

[beyaNet Consultancy]

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 more efficient way to do this?

many thanks

Peter