I should add that I have no problems running Postgres in Windows 7.
The Windows installer works Ok for me.
In this thread I am not clear about whether it is postgres data (data
written and read by PostgreSQL) or user data that is being discussed.
Regards
Andrew
On Thu, Jul 8, 2010 at 5:53 PM
It is a vexed issue with Vista/Windows 7.
I found this somewhere on a blog on the web (it may help):
--
When I'm working to resolve compatibility issues, there are always
multiple options to mitigate. The solution we prefer to use is to update
the code.
A common applicati
He is not going to Australia there are none here!
Regards
Andrew
On Thu, Jul 8, 2010 at 10:54 AM, David Fetter wrote:
> On Wed, Jul 07, 2010 at 02:31:04PM -0700, Josh Berkus wrote:
>> Folks,
>>
>> I'll be unexpectedly in Madison next week for an onsite contract. Is
>> there a user group in Ma
Can't we have a data type called say "image" that is just a
representation of the bytes and nothing else?
It seems to me that bytea is a hangover from the old days.
Is there some underlying physical reason why postgresql and other
databases cannot handle binary data without going through all this
Thanks for this. I can't take the machines out of service at present,
but when I can, I'll look into shutting down services and seeing what
happens.
Andrew
On Tue, Jun 23, 2009 at 11:49 AM, Tom Lane wrote:
> Andrew Maclean writes:
>> Messages in the log are consistently o
Thanks for this, I can easily determine the number of records I want.
Andrew
On Tue, Jun 23, 2009 at 10:52 AM, Steve
Crawford wrote:
> Andrew Maclean wrote:
>>
>> Is this the best way of getting a table of hourly dates?
>>
>> -- How to generate a table of dates at h
Is this the best way of getting a table of hourly dates?
-- How to generate a table of dates at hourly intervals between two dates.
-- select timestamp 'epoch' + generate_series * interval '1 second' as
dates from generate_series(extract(epoch from date_trunc('hour',
timestamp '2001-02-16 20:38:4
[snipity snip snip]
Notwithstanding all the previous discussion. I still think there is a
problem with postgresql on windows.
Messages in the log are consistently of the form:
2009-06-23 08:28:26 EST WARNING: worker took too long to start; cancelled
FATAL: could not reattach to shared memory (k
I would NEVER run a production server in windows!
These are just laptops/workstations that are used for development e.g, when
network connections are not available or when travelling. But these things
still shouldn't occur. I will also try the beta release on these machines to
see if it goes away
009-06-19 at 10:50 +1000, Andrew Maclean wrote:
>
>> 2009-06-19 07:54:51 EST LOG: could not receive data from client:
>> Unknown winsock error 10061
>
> Winsock error 10061 is WSAECONNREFUSED (10061) Connection Refused. I
> presume that means the client has sent an RST packe
led
FATAL: could not reattach to shared memory (key=252, addr=0208): 487
On Fri, Jun 19, 2009 at 10:40 AM, Craig
Ringer wrote:
> On Fri, 2009-06-19 at 09:12 +1000, Andrew Maclean wrote:
>> I posted this a while back but got no useful responses.
>>
>> I have the following
I posted this a while back but got no useful responses.
I have the following error message:
"Error connecting to the server: server closed the connection unexpectedly.
This probably means that the server terminated abnormally before or
while processing the request."
It happens intermittently bo
I tried the pgInstaller instead of the One Click Installer and
everything installed correctly.
Andrew
On Thu, May 14, 2009 at 10:34 AM, Andrew Maclean
wrote:
> I did a fresh installation after deleting every reference to postgres
> and pgAdmin in the registry and removing the relevant f
uot;C:\Program Files\PostgreSQL\8.3" "C:\Program
Files\PostgreSQL\8.3\data" 5432 : Program ended with an error exit
code
Write the data directory to the ini file...
Write the port number, service ID, locale and superuser to the ini file...
********
ng of connections
On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean
wrote:
> I have the following error message:
>
> "Error connecting to the server: server closed the connection
unexpectedly.
> This probably means that the server terminated abnormally before or
> while process
unexpected closing of connections
On Wed, May 13, 2009 at 5:36 PM, Andrew Maclean
wrote:
> I have the following error message:
>
> "Error connecting to the server: server closed the connection
unexpectedly.
> This probably means that the server terminated abnormally before or
&
I have the following error message:
"Error connecting to the server: server closed the connection unexpectedly.
This probably means that the server terminated abnormally before or
while processing the request.
"
It happens intermittently both when using pgAdminIII and when using QT
so it is not a
Thankyou very much.
On Tue, May 12, 2009 at 9:37 AM, Tom Lane wrote:
> Andrew Maclean writes:
>> Is it possible to query the database system tables and get a list of
>> available database encodings?
>
> The pg_encoding_to_char() function might help you, eg
>
> s
Is it possible to query the database system tables and get a list of
available database encodings?
i.e UTF8, LATIN2, SQL_ASCII ... etc.
I don't know what view or table to use.
Thanks for any help
Andrew
--
___
Andrew J. P. Maclean
Centre for Autonomous
I am using C++ and trying to programatically import a large object
from the client side into a server. I am using QT and, for the server
side I can pass a command like:
insert into x values('x1',lo_import('c:/temp/x1.txt'));
Which works.
However this will not work from the client side.
For the cli
-Original Message-
From: Bill Moran [mailto:[EMAIL PROTECTED]
Sent: Thursday, 21 August 2008 22:36
To: [EMAIL PROTECTED]
Cc: Andrew Maclean; General
Subject: Re: [GENERAL] Single character bitfields
In response to "Andrew Maclean" <[EMAIL PROTECTED]>:
> I have a l
-Original Message-
From: Tomasz Ostrowski [mailto:[EMAIL PROTECTED]
Sent: Thursday, 21 August 2008 18:46
To: [EMAIL PROTECTED]
Cc: General
Subject: Re: Single character bitfields
On 2008-08-21 05:29, Andrew Maclean wrote:
> Is char(1) one byte in size?
No. It will also depend
On Thu, Aug 21, 2008 at 12:56 PM, Joshua Drake <[EMAIL PROTECTED]> wrote:
> On Thu, 21 Aug 2008 12:40:29 +1000
> "Andrew Maclean" <[EMAIL PROTECTED]> wrote:
>
>> I have a large database and I want to have several fields (among many)
>> that are single c
I have a large database and I want to have several fields (among many)
that are single character fields (in fact they are bitfields).
1) Is char(1) the most efficient way to store these fields? If not
what is better?
2) I need to test the field against constants, e.g if the field is
called source
We have a database that grows in size quite quickly. Of course we
backup nightly and keep a weeks worth of data
However we need to keep a few months data online, but the rest can be
archived as it will be unlikley that it will be used again.
As I see it we can:
1) Run a query to drop/delete old d
Thankyou very much.
You have fixed my synax issues!
It is much appreciated.
Andrew
On Nov 23, 2007 8:51 AM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Andrew Maclean wrote:
> > This extracts the time zone in seconds, but how do I add it to the
> datetime
> > that
I have a problem in that dates are stored as UTC in my dataase. I.e. without
timezone.
What I want to do: is to get this date from the server and add the server's
current time zone to it. Then I will present a list of dates and times to
the user in their time-zone. How can I do this? I have been
esql.org/developer/testing.
>
>
> -----------
>
>
> Andrew Maclean wrote:
> > In Table 9.4 of the documentation atan2 is described as follows:
> > atan2(*x*, *y*) inverse tangent of *x*/*y*
> >
> > I am sure it should read as:
> > atan2(*y*, x) in
Run it as a service. This is the best way.
--
___
Andrew J. P. Maclean
Centre for Autonomous Systems
The Rose Street Building J04
The University of Sydney 2006 NSW
AUSTRALIA
Ph: +61 2 9351 3283
Fax: +61 2 9351 7474
URL: http://www.acfr.usyd.edu.au/
__
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, 5 September 2007 12:34
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Documentation fix regarding atan2
On Wed, Sep 05, 2007 at 10:37:18 +1000,
Andrew Maclean <[EMAIL PROTECTED]> wrote:
> In Table 9
In Table 9.4 of the documentation atan2 is described as follows:
atan2(*x*, *y*) inverse tangent of *x*/*y*
I am sure it should read as:
atan2(*y*, x) inverse tangent of y/x
This looks to be the standard C++/c atan2(y,x) function.
You can easily test this:
If y = 2, x = 1, then degrees(atan(
difficult to answer, but after giving it a lot of thought,
I think it is, mainly on the grounds of elegance and convenience. However
when I construct a GUI all may change!
Thankyou all for your input.
On 6/20/07, Sean Davis <[EMAIL PROTECTED]> wrote:
Andrew Maclean wrote:
> I got no an
I got no answer so I am trying again.
In a nutshell, if I have a recrusive relationship as outlined below, how do
I implement a rule for the adjustments table that prevents the entry of an
Id into the Ref column if the id exists in the Id column and vice versa?
If I have a payments table which h
Hmmm... you should name a date. The first day of Spring doesn't start here
until 1st September.
Regards
Andrew
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Thursday, 2 March 2006 06:48
To: Tony Caduto
Cc: pgsql-general@postgresql.org
Subject: Re: Special offer with
I can't agree more.
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 25 January 2006 15:16
To: Tony Caduto
Cc: Magnus Hagander; Dave Page; pgsql-general@postgresql.org
Subject: Re: Does this look ethical to you?
The people who develop, package, and host
I am accessing PostgreSQL through MS Access.
Everything works Ok if I manually connect through Access using the ODBC
Dialog.
However I wrote a VB function that opens the database and connects to it.
This works provided there is no int8 column in the PostgresSQL table.
When I use the ODBC interface
Version of Postgresql: 8.0.4
I have created a function:
-- Function: avg_max_speed_hr(timestamp, timestamp)
-- DROP FUNCTION avg_max_speed_hr("timestamp", "timestamp");
CREATE OR REPLACE FUNCTION avg_max_speed_hr("timestamp", "timestamp")
RETURNS SETOF t_avgmaxspeedhr AS
$BODY$
SELECT date_tr
37 matches
Mail list logo