[GENERAL] how to enforce index usage with +0

2007-06-12 Thread Timasmith
Hi, In Oracle there are instances when as a developer I know how the data is spread in the tables and I want to be sure the database uses the right index. Does the following hold true in Postgresql for a query like this: select s.order_id from small_orders_table s, orders o where s.find_these_id

[GENERAL] Upgrading schemas

2006-09-19 Thread timasmith
Hi, I have an application using Postgresql with a large (100+) number of tables. Are there any free/open source tools that can ease the process of updating the schema. Specifically I would like to compare a source and a target, determine the differences and the best way to update the target to

[GENERAL] postgresql ddl scripts - drop object fails entire script

2006-09-26 Thread timasmith
On the one hand I like how the schema scripts fail when there is a single problem with a DDL statement. On the other hand sometimes it is a pain - especially to take out all the 'drop sequence', 'drop table' etc commands when creating a new database. Is there a 'drop if doesnt exist' or a better

[GENERAL] SQL to get a table columns comments?

2007-01-29 Thread Timasmith
Hi, What query can I run to get the comments for my table columns. i.e. the ones on my 8.1 database added with this command: COMMENT ON COLUMN addresses.address_id IS 'Unique identifier for the addresses table'; thanks Tim ---(end of broadcast)---

Re: [GENERAL] SQL to get a table columns comments?

2007-01-31 Thread Timasmith
haracter varying::text = sfl.column_name::text > WHERE pa.attnum > 0 > ORDER BY pc.relname::character varying, pa.attnum; > > "Timasmith" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > > Hi, > > > What query can I

[GENERAL] Can I getting a unique ID from a select

2007-03-01 Thread Timasmith
I am using hibernate, using a view like a read only table and I need a primary key each time a select is issued. So in Oracle terms this might work, though I am skeptical that Hibernate is going to return a cached result. create view myview as select rownum, t1.field, t2.field from tableOne t1, t

Re: [GENERAL] Can I getting a unique ID from a select

2007-03-04 Thread Timasmith
On Mar 3, 7:12 pm, [EMAIL PROTECTED] (Bruno Wolff III) wrote: > On Thu, Mar 01, 2007 at 06:16:02 -0800, > Timasmith<[EMAIL PROTECTED]> wrote: > > > I am using hibernate, using a view like a read only table and I need a > > primary key each time a select is issued.

Re: [GENERAL] Can I getting a unique ID from a select

2007-03-06 Thread Timasmith
On Mar 5, 3:35 am, [EMAIL PROTECTED] (Bruno Wolff III) wrote: > On Sat, Mar 03, 2007 at 16:46:45 -0800, > Timasmith<[EMAIL PROTECTED]> wrote: > > > On Mar 3, 7:12 pm, [EMAIL PROTECTED] (Bruno Wolff III) wrote: > > > On Thu, Mar 01, 2007 at 06:16:02 -0800, > > &

[GENERAL] which is more scalable for the database?

2007-03-08 Thread Timasmith
Suppose I have a database table with 20 fields which are lookups to a single table. configtable(configtable_id, a_field, something_lookup_id, another_lookup_id, ...) lookup(lookup_id, value, description, ...) what is going to be faster to map the rows to an Object which needs the 'value' for eve

Re: [GENERAL] which is more scalable for the database?

2007-03-15 Thread Timasmith
On Mar 8, 2:26 pm, [EMAIL PROTECTED] (Shane Ambler) wrote: > Timasmithwrote: > > Suppose I have a database table with 20 fields which are lookups to a > > single table. > > > configtable(configtable_id, a_field, something_lookup_id, > > another_lookup_id, ...) > > lookup(lookup_id, value, descripti

[GENERAL] One step install, up and running?

2006-09-03 Thread timasmith
Hi, I have a program which uses Postgresql as a database for persistence. The application uses IzPack to install. Ideally I would like to also install Postgresql in the same wizard conversation, plus get it up and running as a windows service (or daemon on 'nix). Is all of that possible - has an