[SQL] Table secure problem.

Hi. (Sorry for my english -I'am not a nativ speaker) I have some problem. I show it with example: I have base names for e.g. "db". I have also user "joe" (in pg_shadow). Joe is not a superuser or somethink like that his is normal user. He connect to db. He can't do anything because I don't give

Re: [SQL] how to index a numeric(12,2) column?

>> I'd like to create an index on a column whose type is NUMERIC(12,2). >> There appears to be no default operator class for the numeric type. > >Uh, what version are you using? Works fine for me in 7.0.2. Sorry; I hit send before adding that information. I'm using postgres 6.5.3 on i386 Red Ha

Re: [SQL] how to index a numeric(12,2) column?

Forest Wilkinson <[EMAIL PROTECTED]> writes: > Sorry; I hit send before adding that information. I'm using postgres > 6.5.3 on i386 Red Hat 6.1. Time to update, then. > It allows me to create an index on a NUMERIC(12,2) field using the > int8_ops class, but I'm wondering if this might have some

[SQL] ./configure problems

HI! I did this to install postgres in a new machine: ./configure --prefix=/usr/local/pgsql --with-tcl --with-perl and I got this: loading cache ./config.cache checking host system type... /usr/src/pgsql/postgresql-7.0.2/src/config.guess: 13497442: No space left on device /usr/src/pggsql/postgres

[SQL] shared memory problem

HI all! I did this: /usr/local/pgsql/bin/postmaster -B 1000 -o "-S 2000" -S -D /usr/local/pgsql/data and it says: IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=8899584,permission=600 This type of erro is usually caused by an improper shared memory or System V IPC semaphore

Re: [SQL] shared memory problem

<[EMAIL PROTECTED]> writes: > /usr/local/pgsql/bin/postmaster -B 1000 -o "-S 2000" -S -D > /usr/local/pgsql/data > and it says: > IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, > size=8899584,permission=600 > This type of erro is usually caused by an improper shared memory or Syst

Re: [SQL] Help! Storing trees in Postgres

> Is there any way to implement a query in Postgres that would be in some way > analogues to Oracle's START WITH/CONNECT BY structure? Unfortunately, no such statements. Instead, you should write your own functions which can operate on your own defined table. The table represents the edges of the

[SQL] Oracle, ODBC, MS IIS -> problem!

Hi, My problem is: I have to create a web interface for an Oracle database. I use MS Internet Information Server, ODBC driver (tried one from MS and one from Oracle) and an Oracle database (I have no permission to change anything in that database). I don't have a problem accessing one table, bu

[SQL] Help with GROUP BY

Hi, I have a (quite) big table with ~3M rows. Every row has a NBPOINTS (int4) and a REASON (int4) select sum(nbpoints) from points; it takes about 10s select sum(nbpoints) from points group by reason it takes about 210s Same table structure, same data on Oracle gives respectively 8 and 22

[SQL] insert value of form - checkboxes

Hello all, I have a form which has got checkboxes and I am having problems to have their values stored in different rows of a table. What I have done is: # colour_id is the name of my checkboxes in the input tag etc ... # I put all the values into the array and split them $colour = $fo

[ADMIN] alter pg_shadow

Is it safe to rename 'postgres' to any__name? like update pg_shadow set usename = 'any__name' where usename = 'postgres'; Sherwin