Re: [GENERAL] View prevents index

by splitting the UNION(s) out. I suppose you could try some magic to alias names by position in the select phrase, but that seems difficult. -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [GENERAL] Vacuum problems ... HELP !!!

reading 5 /usr/local/progs/pgsql/bin/postmaster: ServerLoop: handling reading 5 What is status 139 ? 139 = 128 + 11 ; Sig 11 ? -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands

Re: [GENERAL] ORDER BY Problem

On Wed, Jun 06, 2001 at 03:17:36AM +0200, Severin Olloz wrote: Hello... Why does Postgresql order the uppercase letters first? Because all uppercase letters come before the lowercase letters. Maybe ORDER BY lower(column) will work? This should also be locale dependent ... -- Eric G

Re: [GENERAL] Sequences in transaction context

it that is free from concurrency issues? AFAIK, postgresql uses some magic so the currval() call always returns the last sequence number used by the current process. This is why currval() will generate an error in a new session if nextval() hasn't been called for the given sequence. -- Eric G. Miller

Re: [GENERAL] Implicit row locking during an UPDATE

. Hmm, SET TRANSACTION ISOLATION LEVEL doesn't seem to be taking in 7.1.1... Is that a bug? Guess the only way to be sure is to use the transaction semantics above... -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe

Re: [GENERAL] initdb doesn't work with cygwin 1.3.1?

directive. -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] how can i change my table/column constraint

TO lab; ALTER TABLE tb2_new RENAME TO tb2; -- Re add foreign key constraint (optionally named) ALTER TABLE tb2 ADD [CONSTRAINT foo] FOREIGN KEY (kd_lab) REFERENCES lab (kd_lab); -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3

Re: [GENERAL] arbitrary number of values from a sequence

instead of FOR UPDATE since its behavior depends on the TRANSACTION ISOLATION LEVEL. -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] Arrays and COPY FROM: Help!!!

of nesting of braces "{}" indicates the dimensions of the array. 1-dim {} , 2-dim {{},{}}, etc. -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send &

Re: [GENERAL] Question about SELECT FOR UPDATE in transaction, isolation level

intended at all! What gives? Does anybody know how to do this in PostgreSQL? SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; Note: Every other transaction will block until you do a commit or rollback -- so be quick about it... You might consider using a sequence if you can... -- Eric G. Miller

Re: [GENERAL] Query

(Sam *s) { return s-nCtr1; } Etc... Then, maybe, you can call the function(s) to get/set it's parts... SELECT sample_get_ctr1(mysample) INTO foo FROM ... ; -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our

Re: [GENERAL] Inheritance and referential integritry in 7.0.3

Doesn't work with inheritance... Do instead: create table "products1" ( "product_id" NOT NULL REFERENCES "products" ("id"), "attribute1" text, "attribute2" text ); Then: BEGIN TRANSACTION; INSERT INTO "products" (...) VALUES

Re: [GENERAL] function to operate on same fields, different records?

On Sat, Mar 31, 2001 at 12:17:46AM -0600, will trillich wrote: On Fri, Mar 30, 2001 at 06:34:45PM -0800, Eric G. Miller wrote: On Fri, Mar 30, 2001 at 06:40:13PM -0600, will trillich wrote: even using PLPGSQL, is it possible to send VARYING relation tuples to a procedure/function -- so

Re: [GENERAL] storing small binary objects

(and there is definitely a valid record), the "someVariable" memory location is blank. What am I doing wrong? In addition to examples available with the distribution, pointers to some more sample code would help. -- Eric G. Miller [EMAIL PROTECTED] ---(end of bro

Re: [GENERAL] function to operate on same fields, different records?

ng as the attributes (fields) accessed are common to all of them. impossible? -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] Re: function to operate on same fields, different records?

someone points it out, yes I saw the DBZ. dbz? Division By Zero. Also, the above would perform integer division, would need a cast to 'float8' on one of the operands. -- Eric G. Miller [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have

Re: [GENERAL] dynamic field names in a function.

nown relation called "units". select pg_attribute.* from pg_attribute, pg_class where pg_attribute.attrelid = pg_class.oid and pg_class.relname = 'units' and pg_attribute.attnum 0; You'll probably be most interested in "pg_attribute.attname". -- Eric G. Miller [EMAIL PRO

Re: [GENERAL] serial properties

reates. IMHO, automatically incremented number fields used for primary keys are both a blessing and a curse. It is almost always better to use some other data that *means something* for a primary key. If there's no possible candidate key, *then* maybe an autonumber key is appropriate. -- Eric G. Miller [EMAIL PROTECTED]

Re: R: [GENERAL] Date types in where clause of PreparedStatement

[:ss[-hh[mm]]] '2001-03-01 23:42:58-0800' Always having year first makes a good heuristic that date/time is in ISO format, and there's no question that each successive part represents a decreasing date/time part. -- Eric G. Miller [EMAIL PROTECTED]

Re: [GENERAL]

')); SELECT lo_export(image.raster, '/tmp/motd') from image WHERE name = 'beautiful image'; -- Eric G. Miller [EMAIL