[GENERAL] last entry per person

like the following: gradeid serial primary key, user text, grade char(1), entered timestamp, Any help would be appreciated. Regards Garry <> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] last entry per person

On 03/02/2012 08:30, Chris Travers wrote: On Fri, Feb 3, 2012 at 12:26 AM, garry <mailto:ga...@scholarpack.com>> wrote: I have a table which holds a user name and their results in exams. There can be multiple entries per user. I am trying to return the last entry for eac

[GENERAL] windows service

t the sc command to accept the above string on the command line. Any help would be much appreciated. Regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] time without time zone

explain why time has todays date and time zone? I am confused, I only want time, such as: 13:00:00 regards garry ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] time without time zone

On Monday 18 June 2007 21:15, Tom Lane wrote: > Garry Saddington <[EMAIL PROTECTED]> writes: > > Can anyone explain why time has todays date and time zone? > > Works for me: > > regression=# insert into periods values(1,1,'now','now'); > INSERT 0 1

Re: [GENERAL] Excell

xcel as a > single table. > > I am using Excel 2000 and PostgreSql 8.1. > Save as CSV from Excel and use Posrgres 'copy' command to import the data, would be a straightforward solution, works both ways -copy to, copy from. http://www.postgresql.org/docs

[GENERAL] execute pg_dump via python

dump.exe','database','>','c:/dir/dir/output file']) The command string works perfectly in a terminal. Does anyone know how I should be doing this? I get no errors or traceback when I try the method through Zope. regards garry ---(end

[GENERAL] Unable to install EASM postgre due to error 8023

installing at VM with OS: Windows Server 2012 R2 *Regards, * *Garry Sim* Professional Service Consultant *NETRUST PTE LTD* 70 Bendemeer Road #05-03 Luzerne Singapore 339940 DID: +65 6212 1393 | Fax +65 6212 1366 |Website http://www.netrust.net

Re: [GENERAL] Unable to install EASM postgre due to error 8023

Hi Scott, Is there a difference between postgre and Entrust Authority Security Manager Postgresql Database? But even if end of support, anyway of letting me have a better understanding of the error code ? *Regards, * *Garry Sim* Professional Service Consultant *NETRUST PTE LTD* 70

Re: [GENERAL] Unable to install EASM postgre due to error 8023

Hi Scott, Thank you so much for your prompt response. Have a great day ahead. *Regards, * *Garry Sim* Professional Service Consultant *NETRUST PTE LTD* 70 Bendemeer Road #05-03 Luzerne Singapore 339940 DID: +65 6212 1393 | Fax +65 6212 1366 |Website http://www.netrust.net

Re: [GENERAL] first message: SELECT FROM

u were one of my students I would say "check your table definition or your spelling". Regards Garry ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Find Number Of Sundays Between Two Dates

ulated with all dates and days between two years that are important to your application and then just do simple selects on that table. Regards Garry ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] two not null columns

How would I write a table check constraint to make sure that two columns don't both have nulls at the same time. The following doesn't do it because it because it does not allow one column to be null while the other holds data? check(teachgroup is not null AND set is not null) reg

Re: [GENERAL] two not null columns

On Monday 14 April 2008 17:44, Andreas Kretschmer wrote: > Garry Saddington <[EMAIL PROTECTED]> schrieb: > > How would I write a table check constraint to make sure that two columns > > don't both have nulls at the same time. > > The following doesn't do it bec

[GENERAL] UTF8 encoding problem

I am getting illegal UTF8 encoding errors and I have traced it to the £ sign. I have set lc_monetary to "lc_monetary = 'en_GB.UTF-8'" in postgresql.conf but this has no effect. How can I sort this problem? Client_encoding =UTF8. Regards Garry -- Sent via pgsql-general

Re: [GENERAL] UTF8 encoding problem

On Wednesday 18 June 2008 02:04, Michael Fuhr wrote: > On Tue, Jun 17, 2008 at 10:48:34PM +0100, Garry Saddington wrote: > > I am getting illegal UTF8 encoding errors and I have traced it to the £ > > sign. > > What's the exact error message? > > > I h

Re: [GENERAL] UTF8 encoding problem

rror says that the database received a byte with > the value 0xa3 (163) in a sequence of bytes that wasn't valid UTF-8. > > The UTF-8 byte sequence for the pound sign (£) is 0xc2 0xa3. If > Garry got this error (I don't know if he did; I was asking) then > the byte 0xa3 mu

[GENERAL] Losing data

? regards garry -- 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] Losing data

On Thursday 19 June 2008 16:55, Joshua D. Drake wrote: > On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote: > > I have had a serious loss of data and wondered if anyone could shed any > > light on what may have happened. > > My users have been writing reports on studen

Re: [GENERAL] Losing data

On Thursday 19 June 2008 18:10, Bill Moran wrote: > In response to Garry Saddington <[EMAIL PROTECTED]>: > > On Thursday 19 June 2008 16:55, Joshua D. Drake wrote: > > > On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote: > > > > I have had a serious

Re: [GENERAL] Losing data

On Thursday 19 June 2008 18:15, Alan Hodgson wrote: > On Thursday 19 June 2008, Garry Saddington <[EMAIL PROTECTED]> > > wrote: > > I read in a > > Postgres manual that the hard disk may report to the OS that a write has > > occured when it actually has not, is th

Re: [GENERAL] Losing data

On Thursday 19 June 2008 18:09, Scott Marlowe wrote: > On Thu, Jun 19, 2008 at 9:55 AM, Garry Saddington > > <[EMAIL PROTECTED]> wrote: > > I have had a serious loss of data and wondered if anyone could shed any > > light on what may have happened. > > My u

Re: [GENERAL] Losing data

On Thursday 19 June 2008 18:52, Adrian Klaver wrote: > -- Original message -- > From: Garry Saddington <[EMAIL PROTECTED]> > > > On Thursday 19 June 2008 16:55, Joshua D. Drake wrote: > > > On Thu, 2008-06-19 at 16:55 +0100, Garry Sa

Re: [GENERAL] Losing data

On Thursday 19 June 2008 19:03, Joshua D. Drake wrote: > On Thu, 2008-06-19 at 19:06 +0100, Garry Saddington wrote: > > On Thursday 19 June 2008 18:15, Alan Hodgson wrote: > > > On Thursday 19 June 2008, Garry Saddington <[EMAIL PROTECTED]> > > Although I appreciat

Re: [GENERAL] Losing data

On Friday 20 June 2008 05:26, Robert Treat wrote: > On Thursday 19 June 2008 14:06:38 Garry Saddington wrote: > > > In any case, however, if PostgreSQL reported the transaction complete > > > and the machine didn't experience any hardware problems (like sudden > > &

[GENERAL] Unicode problem again

, it seems there are already UTF8 encodings in the DB that have no equivalent in Latin1 from before the change. How can I get over this problem, and still allow special characters, ie have no error reports. Regards Garry

Re: [GENERAL] Unicode problem again

k you mean 0x92. > > > So it could have been that client_encoding was (correctly) set to WIN1252 > > and the quotation mark was entered as a single byte character. > > Yes, *if* client_encoding was set to win1252. However, in the > following thread Garry said that he was gett

[GENERAL] running pg_dump from python

27;,'r') r=data.read() data.close return r However, when I run this script it creates the file scholarpack.sql but the file is empty. Any help much appreciated. Regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

Re: [GENERAL] running pg_dump from python

Scott Mead wrote: On Sun, Jun 14, 2009 at 4:06 PM, Garry Saddington mailto:ga...@schoolteachers.co.uk>> wrote: I ahve the following python file that I am running as an external method in Zope. def backup(): import os os.popen("c:/scholarpack/postgres/

[GENERAL] distributing postgresql binaries

tried the binaries only install from the download area for 8.3.7 and it won't start either with the same error message. Any help would be much appreciated. Regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

Re: [GENERAL] distributing postgresql binaries

Alan McKay wrote: Why not populate the registry properly? It is not that difficult to do. Good idea, but where do I find the correct entries? Regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] distributing postgresql binaries

Garry Saddington wrote: I have developed an application using Zope and Postgresql and I want to be able to distribute the application with a full database of data so that there are no setup worries for users. The platform is Windows. When I copy the app over to windows XP home, Postgres

Re: [GENERAL] difficulty running pg on XP as appl.

would have thought this would be outomatic, but evidently not)? TIA Try using pg_ctl to start the server. Regards Garry begin:vcard fn:Garry Saddington n:Saddington;Garry org:ScholarPack Ltd. adr:;;Histon House;Hogsthorpe;Lincolnshire;PE24 5QA;England email;internet:ga...@scholarpack.com title

Re: [GENERAL] Trying to install ODBC driver on Windows XP notebook

rule that allows all applications using TCP and UDP on Port 4532 to gain access In and Out Is port *4532* above a typo? No Connection could be made because the target machine actively refused it. (192.168.1.7:5432) Regards Garry -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Open Source Forum Software using PostgreSQL?

Andre Lopes wrote: Hi, I need to use an Forum Software. There is any Open Souce Forum Script using PostgreSQL? Best Regards, André. Zforum does, but you will need to install Zope to run it. Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] filter tables from database

I can retrieve the table names in my database, but I would like to filter them based on the name of a field. Is this possible? Thanks Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[GENERAL] disappearing data

ndidate but we can't understand how this could happen, explanations also welcome. Regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] regexp help

I have the following simple regular expression: "SELECT substring(addressline1 from '(^[0-9]+)') from addresses" How could I find non-matches of this same pattern? regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

[GENERAL] query takes a long time

','M','N','O','R','S','T','U')) It returns the correct results but very slowly. regards garry

[GENERAL] case expression

Can anyone tell me why this will not work? select *, CASE WHEN postcode ilike '%OO%' THEN '' END from addresses where studentid=1234 and addresstype='C' There are postcodes like this: OO00 0OO Regards Garry -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] case expression

On Wednesday 24 September 2008 21:03, Tom Lane wrote: > Garry Saddington <[EMAIL PROTECTED]> writes: > > Can anyone tell me why this will not work? > > > > select *, > > CASE WHEN postcode ilike '%OO%' THEN '' > > END > > from addre

[GENERAL] grant privileges

Is there a way to grant all priveleges on all tables and sequences in a database at the same time? regards Garry -- 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] grant privileges

On Saturday 08 November 2008 13:01, Andreas Kretschmer wrote: > Garry Saddington <[EMAIL PROTECTED]> schrieb: > > Is there a way to grant all priveleges on all tables and sequences in a > > database at the same time? > Thanks I've just installed pgAdmin and that has

[GENERAL] aggregates and case statements

effortandattainment.effort=2 THEN 2 WHEN effortandattainment.effort=1 THEN 3 END from effortandattainment group by case Regards Garry

[GENERAL] all empty tables

How could I list all the tables in a database that do not contain any data? I have looked at reltuples but can't quite work out how to use it, any pointers would be much apreciated. Regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

[GENERAL] modelling question

Anyone have any ideas/suggestions on how to model siblings in a database so that it is possible to eg. only send letters to the parents once. In this scenario each sibling has the contact parents input separately (secretarial input!). Garry -- Sent via pgsql-general mailing list (pgsql

[GENERAL] accounting package

Does anyone know of a web based accounting(finance) package that uses Postgresql as a backend? Thanks Garry -- 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 7 compatiblity?

ed out and then back in using the Administrator account that came with W7 (no password - security, what security?), ran the setup again and everything worked fine. The services were then available to all other accounts. HTH, just my experience. Garry -- Sent via pgsql-general mailing list

[GENERAL] timestamp differences

I have a timestamp column that I want to compare with current timestamp. I want to get all rows that are less than 10 minutes old. I have searched but can not find how to do this, any pointers? regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Which SQL is the best for servers?

On Feb 15, 10:09 pm, pg wrote: > I am involved with a SQL server project. The server would be used in a > very heavy duty environment, with hundreds of thousands, if not > millions of database enquiries per minutes. > > The server would run Linux or one of the BSD variant, with at least > 32GB of

Re: [GENERAL] Which SQL is the best for servers?

On Feb 16, 11:12 am, Paulie wrote: > On Feb 16, 5:51 pm, joel garry wrote: > > > Check out Oracle XE and apex.  No cost to you, and you can pay to > > scale as appropriate. > > Before rushing to download Oracle XE, check out > > http://www.oracle.com/technology/pu

[GENERAL] getting dates in the past

How could I translate this into sql? select result from results where date_entered between (last september and the one before that) Its the part in brackets that has me guessing. I am still experimenting but any help will be gratefully recieved. Kind Regards Garry

[GENERAL] time type strange behaviour

hat I want is to just have the time inserted. Any ideas? regards garry ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] time type strange behaviour

On Tue, 2006-10-10 at 11:58 -0400, Tom Lane wrote: > garry saddington <[EMAIL PROTECTED]> writes: > > I have the following table def. > > CREATE TABLE periods > > ( > > periodid serial NOT NULL, > > periodnumber integer NOT NULL, > > periodstart t

[GENERAL] odd result set

ere '10:35' > periodstart Kind regards Garry ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get thro

[GENERAL] build for none standard socket

I have searched and Googled but can't find how to do a ./configure to use a different socket than /tmp/.s.PGSQL.5432. It says in the manual that it can be done but then does not say how. Anyone done this before? Regards Garry ---(end of broa

[GENERAL] None standard install directories

permissions are OK. Regards Garry ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] starting postgres on windows

How would I start Postgres on windows as an un-privileged user without logging into an un-privileged account. I have tried the -U switch but it still complains. I have version 8. kind regards Garry ---(end of broadcast)--- TIP 1: if posting/reading

[GENERAL] counting query

I have a table definition such as: CREATE TABLE attendance ( attendanceid serial primary key, entered date DEFAULT current_date NOT NULL, absent boolean, authorization text default 'N', timeperiod char(2) check(timeperiod in('AM','PM')), days varchar(10), studentid int, unique(ente

Re: [GENERAL] counting query

On Sun, 2007-01-28 at 09:57 -0600, Ron Johnson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 01/28/07 07:05, garry saddington wrote: > > I have a table definition such as: > > > > CREATE TABLE attendance > > ( > > attendanceid seri

[GENERAL] simplifying SQL

exists to do the same thing or is this OK. Regards Garry ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] date format

I have 'datestyle ISO,DMY' set in postgresql.conf but the date output is still rendered in the format (y,m,d) . How can I change this behaviour? regards garry ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, plea

Re: [GENERAL] date format

On Sunday 04 March 2007 15:28, Raymond O'Donnell wrote: > On 04/03/2007 12:58, Jorge Godoy wrote: > > Garry Saddington <[EMAIL PROTECTED]> writes: > >> I have 'datestyle ISO,DMY' set in postgresql.conf but the date output is > >> still render

Re: [GENERAL] date format

On Sunday 04 March 2007 16:16, Raymond O'Donnell wrote: > On 04/03/2007 16:16, Garry Saddington wrote: > > I tried pgAdmin3 on windows to run 'select now()' and it still does not > > return the correct datestyle. > > Probably a silly question, but did you re

Re: [GENERAL] date format

On Sunday 04 March 2007 17:09, Martijn van Oosterhout wrote: > On Sun, Mar 04, 2007 at 05:05:44PM +0000, Garry Saddington wrote: > > On Sunday 04 March 2007 16:16, Raymond O'Donnell wrote: > > > On 04/03/2007 16:16, Garry Saddington wrote: > > > > I tried pgA

[GENERAL] delete with self join

I am trying this syntax which is my interpretation of the docs: delete from siblings s1 using siblings s2 WHERE s1.principal = s2.principal and s1.sibling=175 Can anyone tell me where I am going wrong? regards Garry ---(end of broadcast

Re: [GENERAL] delete with self join

On Tue, 2007-04-17 at 09:21 +0100, Richard Huxton wrote: > garry saddington wrote: > > I am trying this syntax which is my interpretation of the docs: > > > > delete from siblings s1 using siblings s2 > > WHERE s1.principal = s2.principal > >

Re: [GENERAL] delete with self join

On Tue, 2007-04-17 at 10:15 +0100, Richard Huxton wrote: > garry saddington wrote: > > On Tue, 2007-04-17 at 09:21 +0100, Richard Huxton wrote: > >> garry saddington wrote: > >>> I am trying this syntax which is my interpretation of the docs: > >>> > &g

[GENERAL] xml to db converter

Does anyone know of a tool that will generate a postgres database schema given an xml schema(xsd). Have tried xmlspy which says it does so but it only has limited postgres support and then it crashes. regards Garry ---(end of broadcast)--- TIP 4

[GENERAL] counting days

pointers please. Regards Garry ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] create table as problem

a classid. Any comments are more than welcome. regards garry ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org