We have had a problem with postgresql 8.3 on a Windows server 2008. I
wonder whether there has been any other experiences like this. We have
connected to Potsgres from Zope via a Psycopg adapter and noticed that
sometimes when data is inserted via a form in Zope, the data is
available in Zope
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:
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
Phil Jackson wrote:
I have latest Postgresql installed on a notebook and now trying to
install the driver which I have downloaded and run so that it is now
available in the ODBC Data Source Administrator
This machine has CA security suite, latest version installed and I have
added a network
Frank Heikens wrote:
Hi
I recently bought Windows 7 32 bit professional.
Unfortunately Postgresql 8.4.3 did not install or work.
Tell us about your problems, error messages and logs, then we can help
you to get it working.
I started searching Google and found that a lot of other people
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
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
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 your
PG Subscriber wrote:
I'm on Windows XP SP 2, trying to run PostgreSQL 8.3.4.
Running postgres.exe gives the error:
Execution of PostgreSQL by a user with administrative permissions is
not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security
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 refuses to start and I
get a
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:
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
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/bin/pg_dump scholarpack
c:/scholarpack/ancillary/scholarpack.sql)
data=open('c:/scholarpack/ancillary/scholarpack.sql','r')
r=data.read()
Scott Mead wrote:
On Sun, Jun 14, 2009 at 4:06 PM, Garry Saddington
ga...@schoolteachers.co.uk 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
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
Is there a way to make the following statement return the total of all effort.
At the moment it gives a list of sum vs case.
select sum(effort),
CASE WHEN effortandattainment.effort=5 THEN -3
WHEN effortandattainment.effort=4 THEN -2
WHEN effortandattainment.effort=3 THEN 1
WHEN
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
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 done the trick.
Regards
Garry
--
Sent
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-general@postgresql.org)
To make
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 addresses
...
Define not work. What are you expecting it to do versus what
Can someone suggest how I could speed up the execution of this query?
select count(distinct attendance.studentid)
from attendance
where attendance.studentid not in (select studentid from attendance where auth
not in('C','E','F','G','H','I','M','N','O','R','S','T','U'))
It returns the correct
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 your subscription:
On Thursday 26 June 2008 15:41, Michael Fuhr wrote:
On Thu, Jun 26, 2008 at 03:31:01PM +0200, Albe Laurenz wrote:
Michael Fuhr wrote:
Your input data seems to have a mix of encodings: sometimes you're
getting pound signs in a non-UTF-8 encoding, but if characters like
U+2019 RIGHT
I have the following error:
Postgres 8.3 via psycopg 1.1.21 and zope 2.10.
ProgrammingError Error Value: ERROR: character 0xe28099 of encoding UTF8 has
no equivalent in LATIN1 select distinct teachers.teacherid,teachers.teacherid
as thisteacherid,teachers.initials,
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
power or disk failure), I would certainly
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 students. No error messages have been
produced and when called back up the reports seem to be present at the time
of writing. However, next day they
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 students. No error messages have
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 loss of data and wondered if anyone could shed
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 this possible?
Yeah. But unless the power
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 users have been writing reports on students. No error
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 Saddington wrote:
I have had a serious
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 appreciate that this is a funky problem, the 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 have set lc_monetary to lc_monetary = 'en_GB.UTF-8
On Wednesday 18 June 2008 14:00, Michael Fuhr wrote:
On Wed, Jun 18, 2008 at 08:25:07AM +0200, Giorgio Valoti wrote:
On 18/giu/08, at 03:04, Michael Fuhr wrote:
Is the data UTF-8? If the error is 'invalid byte sequence for
encoding UTF8: 0xa3' then you probably need to set
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 mailing list
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)
regards
garry
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 because it because it does not allow one
column
On Wednesday 05 March 2008 06:16, raghukumar wrote:
Hai EverBody,
Can I know what is the query by which we can find the number of
sundays between two given dates in postgres
Thanks In Advance,
Raghu...
I think the easiest way is to set up a table populated with all dates and
On Saturday 02 February 2008 17:43, Aílsom F. Heringer wrote:
Hi,
This is my first message, and I need some help. I have just installed
Postgresql 8.2. (Windows).
At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all
columns correctly. But when I try to get only one column,
I am using zope on windows with an external python method to backup my
database. I am struggling to run the following command:
pg_dump.exe database file
I have tried using os.popen - no luck
and also subprocess.Popen.
eg:
import subprocess
On Wednesday 20 June 2007 03:09, Bob Pawley wrote:
Thanks
Does one version of ODBC work for all versions of Excel and Postgresql.
I am wanting to transfer one or two tables from Excel and manipulate the
information in Postgresql then transfer the results back to Excel as a
single table.
I
This is a select on table periods defined as such:
CREATE TABLE periods
(
periodid serial NOT NULL,
periodnumber integer NOT NULL,
periodstart time without time zone,
periodend time without time zone,
PRIMARY KEY (periodid)
)
PeriodidPeriodnumberPeriodstart Periodend
6
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
regression=# select * from periods;
periodid
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:
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
and s1.sibling=175
Can anyone
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:
delete from siblings s1 using siblings s2
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
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, please send an
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 rendered in the format (y,m,d) . How can I change this behaviour?
ISO
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 remember to restart the server
after changing
On Sunday 04 March 2007 17:09, Martijn van Oosterhout wrote:
On Sun, Mar 04, 2007 at 05:05:44PM +, 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 pgAdmin3 on windows to run 'select now
I have this query which essentially returns records that exist in one
table (studentclass) and not another (effortandattainment) to check when
teachers have entered their student grades.
select
distinct(studentclass.studentclassid),classes.subject,studentclass.studentid as
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,
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 serial primary key,
entered date DEFAULT current_date
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
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
Thanks to this list I have managed to install into a none standard
location and have the socket where I want it -thanks all. However, now I
am getting a socket.lock as well and my application is getting a
permission denied error on connect, how can I prevent this? I have
checked that all directory
I have the following result from the sql below. Can anyone help by
explaining why the last record could be returned. Periodstart and
periodend are time data types. I have tried to cast '10.35' to a time
type with the same results.
I have the following table def.
CREATE TABLE periods
(
periodid serial NOT NULL,
periodnumber integer NOT NULL,
periodstart time with time zone,
periodend time with time zone,
PRIMARY KEY (periodid)
)
This definition does not insert time zone. If I use without time zone
then the time
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 time with time zone,
periodend time with time zone
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
I am getting a syntax error at or near 'as' in this method, can anyone
help?
create table iclasses
(classid serial,
subject text,
year text,
groups text,
teacher text,
set text
)
as select distinct subject,year,groups,teacher,set from interimclasses
I need to make a new table with a classid.
I need to count the days between two dates that are not saturdays or
sundays. I have read the manual and searched the lists but I am
struggling. I can count the days but am finding difficulty excluding sat
and sun from the count. I need this without reference to any tables.
Does anyone have any
63 matches
Mail list logo
