[SQL] Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4

hi I am upgrading from pgsql 7.4.1 to pgsql 8.1.4. However, some of the application queries won't run on the newer version of pgsql. An example of the type of query is: SELECT protein_external_links.protein_id, external_links.external_id, proteins.public_name WHERE protein_external_links.external_

Re: [SQL] [GENERAL] ALTER TABLE ... DROP CONSTRAINT

DAM - Technical Support > Analyst I performed that task yesterday using PostgreSQL 7.3.3: Alter table mkt drop constraint mkt_pkey; I don't know if it's supported in earlier versions. Best regards, Andrew Gould ---(end of broadcast)---

[SQL] Schema's, roles and privileges

d. We have a separate userid for the security administrator. All of the functions that the security administrator needs are provided by a application module and they will not be directly accessing the database via a SQL utility at all. Best Regards -- Michael Gould, Managing Partner Intermodal Sof

Re: [SQL] Schema's, roles and privileges

Thanks Mike Gould "Adrian Klaver" wrote: > On Monday 30 November 2009 6:50:27 am Michael Gould wrote: >> I have a database with a schema called ISS. This is where all of our >> application definitions are stored. We did add 2 contribute modules >> (citext) and g

[SQL] Proper case function

g the contrib module citext which makes searching very nice. Best Regards Michael Gould -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Proper case function

a the 80''s), and jada pinkett-smith all showed up to [cHris o''donnell''s] party...donning l''oreal lIpstick! They''re heading to o''neil''s pub later on t''nite. the_underscore_test. the-hyphen-test) This wouldn'

[SQL] Issue with insert

is a issue for us because we want the user to type in either the zipcode if known to bring back the city and state, or the city,state to bring back the zipcode. Any idea's on why this could be happening. I'm running on Windows 7 x64 using 8.4.2 Best Regards -- Michael Gould, Managing Pa

Re: [SQL] Issue with insert

Here is the table DDL, To test you can either use the record below or make up anything you want. I've changed the isscontrib.citext to varchar and text data types and the results are the same. Best Regards Michael Gould CREATE TABLE "iss"."citystateinfo" ( "

Re: [SQL] Issue with insert

Tom, Thanks, that's exactly what it was. Best Regards Mike Gould "Tom Lane" wrote: > Michael Gould writes: >> Here is the table DDL, > > Can't really test this since you didn't supply the source code for > those triggers: > >> CREATE T

[SQL] placement of stored procedures and contrib modules

. We don't get any error messages however we also don't get the results we are looking for, namely case insensitive search results. However, if we move the contrib module to the public schema, everything appears to work fine. Best Regards Mike Gould -- Michael Gould, Managing Pa

[SQL] strange issue with UUID data types

ut 10 days now trying to figure out why it works in one location and not others. Best Regards Michael Gould   -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

Re: [SQL] strange issue with UUID data types

ramme been migrated from 32 bit? The program is a Win32 program Best Regards Mike Gould -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] fix uuid contrib module for Windows 64

As the subject implies, has this been fixed and is it in a currently released GA build?   Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

[SQL] Case Insensitive searches

ng to be required to use the lower() on all selects in order to make sure that they are case insensitive? In some db's if you use a lower() or upr() it will always do a table scan instead of using a index Best Regards, Michael Gould, Manager Information Technology All Coast Intermodal S