Re: [GENERAL] GROUP BY or alternative means to group

Thanks that is a help. I would be nice if any key could be used as those are normally the things I would do group by's Regards Mike Gould From my Samsung Android tablet on T-Mobile. The first nationwide 4G networkBruno Wolff III wrote:On Mon, Mar 12, 2012 at 16:18:05 -0400,    Mi

Re: [GENERAL] what Linux to run

Thanks to all Sent from Samsung mobile Chris Angelico wrote: >On Wed, Feb 29, 2012 at 3:58 PM, Scott Marlowe wrote: >> Note that Ubuntu also comes in a GUI free server edition as well.  I >> can definitely state that Ubuntu 10.04 LTS Server edition is rock >> solid stable for the hardware I've

Re: [GENERAL] GROUP BY or alternative means to group

You need to include all columns that are not aggregrative columns in the group by. Even though that is the standard it is a pain to list all columns even if you don't need them Best Regards Michael Gould Sent from Samsung mobile Alexander Reichstadt wrote: >Hi, > >the follo

Re: [GENERAL] version controlling postgresql code

We use svn for all our version control at the moment Sent from Samsung mobile akp geek wrote: >Hi all - > > Would like to know if any one of you have used CVS or some other >version controlling tools to version the postgres code? Any >recommendations? Appreciate your help > >Regards --

Re: [GENERAL] Question on Rules

new.tractortermloc, > new.cost, > new.batchno, > new.editdatetime, > new.edituser); > >Best Regards, > >Michael Gould >Intermodal Software Solut

Re: [GENERAL] Counting different strings (OK%, FB%) in same table, grouped by week number

Sent from Samsung mobile Adrian Klaver wrote: >On 02/22/2012 12:36 PM, Alexander Farber wrote: >> Hello, >> >> I have a table holding week numbers (as strings) >> and user ids starting with OK, VK, FB, GG, MR, DE >> (coming through diff. soc. networks to my site): >> >> afarber@www:~> psql >>

[GENERAL] How do I manually delete the odbc, oledb and .net drivers

anually clean this up, but how. Best Regards Michael Gould

[GENERAL] problems installing odbc and .Net drivers

stion on   Best Regards Michael Gould

Re: [GENERAL] Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64

gt;>>> The installer for windows for 64bit versions of postgresql doesn't >>>>>> include ossp-uuid.sql. >>>>>> Does anyone know where or how to get this? >>>>>> >>>>>> Thanks >>>>>> -- >>>>>> *Grace Batumbya* >>>>>> Research Assistant | Seneca CDOT >>>>>> Phone: 416-491-5050 x3548 >>>>>> cdot.senecac.on.ca <http://cdot.senecac.on.ca/> >>>>> >>> > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64

Thanks... I didn't know that this had been done. Will be downloading shortly, thanks Mike Gould "Hiroshi Saito" wrote: > Hi Grace-san. > > Is this helpful to you? > http://winpg.jp/~saito/pg_work/OSSP_win32/build-x86-64/ > > Regards, > Hiroshi Saito > > (2011/06/30 1:14), Grace Batumbya wrot

Re: [GENERAL] Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64

gards Michael Gould     "Grace Batumbya" wrote: >The installer for windows for 64bit versions of >postgresql doesn't include ossp-uuid.sql. >Does anyone know where or how to get this? > >Thanks >-- >Grace Batumbya

Re: [GENERAL] Gist Index: Problem getting data in GiST Support Functions "penalty".

Thursday of this week when we are supposed to show off a new module in our product. We've not had any problems in other customer locations trying to get in. Any ideas? Best Regards Michael Gould -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] UUID-OSP contrib module

I remember a few months ago that someone said that the UUID-OSP contrib module did not work on Windows 64.  Is this still a limitation?   Best Regards Michael GouldIntermodal Software Solutions -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250

Re: [GENERAL] "Service user account 'postgres' could not be created" -- 8.4.2-1 and Active Directory on Windows08 R2

With R2, I had to install using the admin account.  I got those errors before.  It worked once I used a admin account.  If that doesn't work you might want to try turning UAC off, do the install and then turn back on.   Best Regards Michael Gould   "Greg Corradini" w

Re: [GENERAL] Protecting stored procedures

pes. Best Regards Michael Gould "Andrew Sullivan" wrote: > On Thu, Apr 07, 2011 at 07:46:36AM -0500, Michael Gould wrote: >> We want to protect the intellectual property of several of our stored >> procedures.  If we put them in a separate schema in the database and only &

[GENERAL] Protecting stored procedures

We want to protect the intellectual property of several of our stored procedures.  If we put them in a separate schema in the database and only allow execute on anything in that schema would that protect our stored procedures?   Best Regards     -- Michael Gould, Managing Partner

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

sql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-general mailing lis

Re: [GENERAL] Postgres forums ... take 2

se something that I can access from my phone browser. I do this even with my other company email because I don't want to use up the space on my phone. Best Regards Michael Gould > What I'm more interested in is still a word from the people who would > actually *use* a forum on how

Re: [GENERAL] The first dedicated PostgreSQL forum

I would like to see this type of setup used.  I use my cell phone for about 90% of my internet access during the day when I'm on the road.  I've found in the past that forums usually have better search tools and they also will not fill up my email address.  I find many things in these forums which

Re: [GENERAL] Linux

Thanks for all of the information. I will now need to spend some time looking at the various distributions that were mentioned here. Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Linux

orking on getting > it included in the next update of PG 9.0. > That is good news, but I'm still thinking of moving to Linux because it appears that much more tuning can be accomplished and that you don't get the kitchen sink when you don't need it. Best Regard -- Michael Gould, Man

[GENERAL] Linux

op but not a server.   Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

Re: [GENERAL] Missing uuid_generate_v1()

Is there a patch being worked on which will allow this contrib module to work properly under Windows 64 bit machines using the 64 bit Postgres server? We need to be able to support both Windows and Linux servers running Postgres. Best Regards Michael Gould "Mike Christensen" wrote:

Re: [GENERAL] Problem installing 9.0.1 on Windows 7 x64

It does appear so.. although I'm logged into the network administrator account. Weird but at least I can now track it down. Best Regards Mike Gould "Dave Page" wrote: > [CC'ing the list to close the loop] > > On Tue, Oct 5, 2010 at 7:43 PM, Michael Gould > w

[GENERAL] Problem installing 9.0.1 on Windows 7 x64

Best Regards Michael Gould -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

[GENERAL] Performance statistics

with a Windows based language. We will also be hosting smaller companies so I want to see the statistics and if Linux is a clear winner, the best distrubution to work with.   Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

Re: [GENERAL] Scratching my head why results are different between machines.

e and mine seems to be how the odbc driver is installed.  He's using the one he downloaded from EDB.  He sent it to me, I uninstalled the previous one I had, rebooted and installed the one he sent me.  Same results, no driver shows up in the odbc admin. Best Regards Michael Gould  

Re: [GENERAL] Scratching my head why results are different between machines.

machine and I'm logged into our domain as the domain administrator. Is there something else I need to do to install the odbc driver under windows? I've even turned UAC off and it didn't seem to help Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC

Re: [GENERAL] Scratching my head why results are different between machines.

"Justin Graf" wrote: > On 3/3/2010 3:40 PM, Michael Gould wrote: >> On my machine the UUID that is returned is 16 bytes and I cannot make >> out any relevant numbers from the UUID key in the citystateinfo >> table. I've tried this in a Windows XP machine an

[GENERAL] Scratching my head why results are different between machines.

;s running find on computers located in other locations but doesn't work properly on either one of my machines.  It seems to me that it must be enviornmental.  The author has both Windows 2008 server and Windows 7 64 bit. Best Regards Michael Gould

Re: [GENERAL] Roles with passwords; SET ROLE ... WITH PASSWORD ?

Regards Michael Gould >Tom Lane" wrote: > Craig Ringer writes: >> Anyway ... I'm curious about whether `SET ROLE rolename WITH PASSWORD' >> is something that's technically practical to implement in PostgreSQL and >> what people think about the idea. &g

[GENERAL] Public and Grants

eeded. 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 Inter

[GENERAL] Defining roles

In our system we have a hybrid security system. We have tables that I want to make sure that based on membership in a group that update and/or delete is not allowed to a specific group. We also have application level security which is much more granular and is much more job function based. Our app

[GENERAL] DDL with Reference on them.

) , cost DECIMAL(7,2) DEFAULT 0 , createdatetime TIMESTAMP , createuser CITEXT , editdatetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP , edituser CITEXT DEFAULT CURRENT_USER ) As you can see there are a few columns which reference back to another table. What I need to know is how does Postg

[GENERAL] LDAP using Active Directory

rated logins. Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Partition tables

er to disconnect the partion tables to use for historial use when we close a location. We probably would get 10 or so queries on the closed locations 6 months after closing. Does this seem like an appropriate use of table partitioning? Best Regards -- Michael Gould, Managing Partner Inter

Re: [GENERAL] Problem trying to load trigger

Thanks to everyone who answered. Getting used to PostGres's unique syntax can take time getting used to. Best Regards Michael Gould "Tom Lane" wrote: > Michael Gould writes: >> CREATE OR REPLACE FUNCTION iss.accessor_trigger() RETURNS "trigger" AS $$ >&

[GENERAL] Problem trying to load trigger

QUERY: SELECT current_timestamp $1 := current_user ELSIF ( $2 = 'UPDATE') THEN INSERT into iss.auditaccessor SELECT 'B','C', $3 .* CONTEXT: SQL statement in PL/PgSQL function "accessor_trigger" near line 8 ** Error ** ERROR: syntax error at or ne

[GENERAL] citext contrib module (building indexes)

the index to search or will it always do a table scan?   Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

Re: [GENERAL] 8.4.0 installer for Windows from EnterpriseDB does not seem to include pgagent

Dave, Are there any plans to add the plug-ins that were available in the 8.3 install to the stackbuilder component? Best Regards Michael Gould "Dave Page" wrote: > On Thu, Jul 23, 2009 at 8:06 AM, Magnus Hagander wrote: >> On Thu, Jul 23, 2009 at 08:45, Steffen Kuhn wr

Re: [GENERAL] uuid-ossp for PostGres 8.4 running on Windows

Thanks, that worked perfectly. Best Regards Michael Gould   "Sachin Srivastava" wrote:   >Hello Michael, > >In the EnterpriseDB installer, uuid-ossp contrib module is available but >not loaded/enabled by default. To enable uuid-ossp module simply run the >u

[GENERAL] uuid-ossp for PostGres 8.4 running on Windows

to be added back into the EnterpriseDB installer? At any rate my main concern now is to get the uuid-ossp install for 8.4 so that I can use 8.4 for our new development.   Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

[GENERAL] Custom Class variables

I have created the following in my postgres.conf file custom_variable_classes = 'iss' In a SQL session I've tried Set iss.one = '1' set iss.two = '2' Select * from iss; How do I access the values from the custom class in sql code? Best Regards Micha

[GENERAL] Ascending / Descending Indexes

In some SQL engines the engine doesn't need to define both Ascending and Descending indexes on the same column.  Does Postgres need to have indexes defined for both Ascending and Descending sorts?  We use quite a few of these types of sorts.   Best Regards -- Michael Gould, Managing Pa

[GENERAL] Request for features

I would like to know what the formal method of requesting new features are for Postgres and how are decisions made which features are included in a future release or not. Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent

Re: [GENERAL] Execute Immediate

uot; wrote: > 2009/7/12 Michael Gould : >> It does look to me that PostGres supports temporary tables and using with >> the commit preserve rows appears to work similar to how global or local temp >> tables would work. The only thing I need to know (or test) is whether they &g

[GENERAL] Execute Immediate

In many SQL dialets there is the availability of Execute immediate which allows you to build global temp tables or views at run time and even stored procedures at runtime and then execute them inline.  Is there a way to do this in PostGres 8.4   Best Regards   -- Michael Gould, Managing

[GENERAL] Client only install

e run just the client side on the workstations? Do we just not start the postmaster on the client? Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch

[GENERAL] Added parameter for CREATE ROLE

It would be nice if during create role we could have a parameter to set the number of days that a password is valid instead of just a timestamp. Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-general mailing