Re: [SQL] Matching several rows

It is easier to think of this as SET INTERSECTION which leads to: SELECT id FROM urights WHERE right = 2 INTERSECT SELECT id FROM urights WHERE right = 5 INTERSECT SELECT id FROM urights WHERE right = 10 Ivan Steganov wrote: Thank you to everyone for the great help! I will evaluate all methods

[SQL] Unique Constraint with foreign Key

have varchar types of size 50 as primary keys in Postgres. please let me know --Mohan ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[SQL] date function problem

Hi All I have an expiration_date column in my table with data type as timestamp. I need to set that as one year after the current time. how do i do that. I am getting a casting problem whenever i try something. something like now()+ 1 year. Please let me know --mohan

PROBLEM SOLVEDRe: [SQL] java.lang.StringIndexOutOfBoundsException: String index

Thank you all guys. Thank you very much. Yeah it was the driver issue. I was runnin postgres 7.4 but using the pg73jdbc3.jar driver. I did not know that. Thank you all once again for your help. --mohan > O kyrios [EMAIL PROTECTED] egrapse stis Jan 29, 2004 : > >> Now i a get another

Re: [SQL] java.lang.StringIndexOutOfBoundsException: String index

ported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource please let me know if any has an idea Thanks in Advance --Mohan > O kyrios [EMAIL PROTECTED] egrapse stis Jan 29, 2004 : > >> Hi All >> >> I am having the torque3.1.jar and postgresql-7.4. I have compiled the >> new jdbc dri

[SQL] java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460)

smoothly.Please let me know if there is a way to configure jdbc with torque or any other configuration issue for postgres you know might have been creating this problem. I am having one heck of a night mare wid this issue. thanks --Mohan ---(end of broadcast

[SQL] migration between databases and versions

'person' with fields A,B New Database to be put under prodcution also has an Table named 'person' with field A, B,C If i do a pg_dump from old to new does it fill the A,B and leave C alone or will it give an error given that C is not a null field. Ple

[SQL] Postgres: MS Access and Tomcat

is by uncommenting the #Max_connections=32 in the postgresql.conf. What are the effects of uncommenting this part in postgresql.conf. Do i need to make any more changes when uncomment the Max_connections=32 in the postgresql.conf file Thank you very much --Mohan ---(e

[SQL] Problem: Postgresql not starting

Hi All I am using postgresql 7.2 on Linux. It does not start when i am trying this /etc/rc.d/init.d/postgresql restart. It give an error saying "postmaster already running". I have done rm -f /var/lib/pgsql/data/postmaster.pid and rm -f /var/run/postmaster.pid But it still says the same. whenever

[SQL] Error with DROP column

Hi All i am trying to DROP the column but i keep getting this error. ALTER TABLE institution DROP COLUMN name CASCADE; ERROR: ALTER TABLE / DROP COLUMN is not implemented please help me in solving this issue. ---(end of broadcast)--- TIP 8:

[SQL] URGENT!!! changing Column size

Hi can we change the size of a column in postgres. I have a table named institution and column name is name varchar2(25), i want to change it to varchar2(50). Please let me know. --Mohan ---(end of broadcast)--- TIP 2: you can get off all