Re: [GENERAL] How to upgrade under redhat [was: alter user to change user's password returns pg_shadow: Permission

2001-07-31 Thread Jason Turner
> OK, so apparently the solution is to upgrade. My OS is currently RedHat > 6.2. I'm a little leary of upgrading Linux at this point. Is there a > way to run Postgresql 7 under RedHat 6.2 or do I have to upgrade? Currently running PostgreSQL under RedHat 6.0 over here. Works like a treat (tha

[GENERAL] Getting Primary * Foreign Key Information?

2001-07-31 Thread Bernie Holmes
How do I get primary and foreign key data for a table? Are there Postgres functions that return this information? What tables should I join to pg_index and pg_trigger to get this information? Thanks for any assistance. ---(end of broadcast)---

[GENERAL] Sequences and inheritance

2001-07-31 Thread Bruce Richardson
If I have a set of tables and I set their primary keys all to the same sequence, as in create sequence common_seq; create table alpha ( ID integer primary key default nextval('common_seq), other_field text ); create table beta ( ID integer primary key default

RE: [GENERAL] Please Help JDBC Error!!

2001-07-31 Thread Dave Cramer
Hi, First of call can you make sure you are using the latest source. There are binaries at http://jdbc.fastcrypt.com Second, my instincts are telling me that there is some sort of overflow occurring with 6k records. Is there some way to reduce the size of the resultset? Dave -Original Mess