What version of PostgreSQL are you running? The error seems to indicate
that you don't have the crosstab(text,text) form of the function.
In psql do:
contrib_regression=# \df crosstab
List of functions
Schema | Name | Result data type | Argument data types |
What version of PostgreSQL are you running? The error seems to indicate
that you don't have the crosstab(text,text) form of the function.
In psql do:
contrib_regression=# \df crosstab
List of functions
Schema | Name | Result data type | Argument data types |
I know that this is probably a religion issue but we are looking to move
Postgres to a Linux server. We currently have a Windows 2008 R2 active
directory and all of the other servers are virtualized via VMWare ESXi. One
of the reasons is that we want to use a 64 bit Postgres server and the UUID
This is a longshot, but here goes...
Is there a way to require that a check constraint be checked on insert but not
update?Worth knowing is that my check constraint runs a PLPgsql proc which
returns a yes/no kinf of flag which the constraint proper checks.
Thanks !
On Thu, Nov 4, 2010 at 8:00 AM, Michael Gould
mgo...@intermodalsoftwaresolutions.net wrote:
I know that this is probably a religion issue but we are looking to move
Postgres to a Linux server. We currently have a Windows 2008 R2 active
directory and all of the other servers are virtualized via
On 11/4/2010 9:00 AM, Michael Gould wrote:
What and why should I look at certain distributions? It appears from
what I read, Ubanta is a good desktop but not a server.
We use CentOS. I don't know of a good reason to look at other
distributions for a server today.
You may or may not see
In response to Michael Gould mgo...@intermodalsoftwaresolutions.net:
I know that this is probably a religion issue but we are looking to move
Postgres to a Linux server. We currently have a Windows 2008 R2 active
directory and all of the other servers are virtualized via VMWare ESXi. One
of
On 11/04/2010 11:10 AM, Bill Moran wrote:
In response to Michael Gouldmgo...@intermodalsoftwaresolutions.net:
I know that this is probably a religion issue but we are looking to move
Postgres to a Linux server. We currently have a Windows 2008 R2 active
directory and all of the other
On Thu, Nov 04, 2010 at 11:10:24AM -0400, Bill Moran wrote:
Beyond that, I think that any Linux distro that caters to a server
environment will work well for you.
The thing (in my experience) that's going to make you happy or angry
is how well the packaging system works. Find a distro whos
On Wed, Nov 3, 2010 at 1:04 PM, Gabriel Dinis
gabriel.di...@vigiesolutions.com wrote:
Dear all,
Imagine I have two users Maria and Ana using a PHP site.
There is a common Postgres user phpuser for both.
I'm creating audit tables to track the actions made by each PHP site user.
(...)
On Thu, Nov 4, 2010 at 11:03 AM, Gauthier, Dave dave.gauth...@intel.com wrote:
Is there a way to require that a check constraint be checked on insert but
not update? Worth knowing is that my check constraint runs a PLPgsql proc
which returns a yes/no kinf of flag which the constraint proper
On Thu, Nov 4, 2010 at 8:03 AM, Gauthier, Dave dave.gauth...@intel.com wrote:
Is there a way to require that a check constraint be checked on insert but
not update? Worth knowing is that my check constraint runs a PLPgsql proc
which returns a yes/no kinf of flag which the constraint proper
On Thu, Nov 4, 2010 at 9:00 AM, Michael Gould
mgo...@intermodalsoftwaresolutions.net wrote:
I know that this is probably a religion issue but we are looking to move
Postgres to a Linux server. We currently have a Windows 2008 R2 active
directory and all of the other servers are virtualized via
On 4 November 2010 15:00, Michael Gould
mgo...@intermodalsoftwaresolutions.net wrote:
I know that this is probably a religion issue but we are looking to move
Postgres to a Linux server. We currently have a Windows 2008 R2 active
directory and all of the other servers are virtualized via
On Thu, Nov 4, 2010 at 11:23 AM, Steve Clark scl...@netwolves.com wrote:
We have used FreeBSD but are moving to CentOS. Main reason is longer support
window.
FreeBSD usually goes EOL in a year or two. CentOS 5.x is supported thru at
least 2014.
FreeBSD 6.x was released in 2005 and was EOL'd
On 2010-11-04 16.00, Michael Gould wrote:
I know that this is probably a religion issue but we are looking to move
Postgres to a Linux server. We currently have a Windows 2008 R2 active
directory and all of the other servers are virtualized via VMWare ESXi. One
of the reasons is that we want
mgo...@intermodalsoftwaresolutions.net (Michael Gould) writes:
What and why should I look at certain distributions? It appears from
what I read, Ubanta is a good desktop but not a server.
There are Ubuntu versions that don't promise support (e.g. - ongoing bug
security fixes, and such) for
Dear group:
I have a table structure like following:
city:
city_blockage_from age_to name
SF 10 20grade1
SF 21 30grade1
SF 35 40grade1
SF 53 19grade2
SF 100 153 grade2
Hi
I'm sure you have had this question many times before but I feel as though I
have genuinely exhausted all of my option and followed all the advise I can
find
online.
During installation of Postgresql at the time when it tries to create the
account I get the message ' user account
Date: Thu, 4 Nov 2010 11:23:07 -0400
From: scl...@netwolves.com
To: wmo...@potentialtech.com
CC: mgo...@intermodalsoftwaresolutions.net; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Linux
On 11/04/2010 11:10 AM, Bill Moran wrote:
()
We have used FreeBSD but are
I would recommend Ubuntu Server 10.04 LTS (long time support - 5 years for
ongoing bug security fixes, and such).
Also, Ubuntu is in focus now, has great community and a most of recent books
on Linux target Ubuntu (which is valid factor for educating people on new
platform).
Ubuntu is great for
Now if you told people the OS, and the version of Postgres maybe ... ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Nov 4, 2010 at 1:58 AM, Gavin Burrows gavin_burr...@yahoo.com wrote:
Hi
I'm sure you have had this question many times before but I feel as though I
have genuinely exhausted all of my option and followed all the advise I can
find online.
During installation of Postgresql at the time
Hi Gavin,
On 2010/11/04, at 17:58, Gavin Burrows gavin_burr...@yahoo.com wrote:
I'm sure you have had this question many times before but I feel as though I
have genuinely exhausted all of my option and followed all the advise I can
find online.
During installation of Postgresql at the
On Thu, Nov 4, 2010 at 10:45 AM, Esmin Gracic esmin.gra...@gmail.com wrote:
I would recommend Ubuntu Server 10.04 LTS (long time support - 5 years for
ongoing bug security fixes, and such).
Also, Ubuntu is in focus now, has great community and a most of recent books
on Linux target Ubuntu
Whilst I won't discourage you from a move to Linux, which I think is a
good idea in general (and personally, my choice is RHEL - or CentOS if
you want free - for a production server), I will note that Hiroshi
Saito has ported ossp-uuid to Win64 now, and we're working on getting
it included in
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
Hey Fernando,
If you need to store binary data in a table you should use bytea data type.
Than, in case of libpq:
If you want to transmit binary data from client to server in text format you
must prepare (escape) it for including into you SQL command (e.g., INSERT).
If you can transmit the data
Hi,
I've read through numerous
forumshttp://forums.enterprisedb.com/posts/list/2328.pageto get past
the following error An error occurred executing the Microsoft
VC++ runtime installer.
As far as I can tell, the error can arise if user privileges are not
correctly set or if a firewall or
On 11/04/2010 04:00 PM, Michael Gould wrote:
I know that this is probably a religion issue but we are looking to
move Postgres to a Linux server. We currently have a Windows 2008 R2
active directory and all of the other servers are virtualized via VMWare
ESXi. One of the reasons is that we want
Greetings:
Lately, I've begun using views quite often especially when queries for various
reports, etc. become complicated. I am now wondering if there is a price to
pay in terms of overhead for this. In truth, I don't really understand how a
view works. I know that it takes on many of the
On Thu, Nov 4, 2010 at 12:18 PM, Marco Colombo pg...@esiway.net wrote:
On 11/04/2010 04:00 PM, Michael Gould wrote:
I know that this is probably a religion issue but we are looking to
move Postgres to a Linux server. We currently have a Windows 2008 R2
active directory and all of the other
On Thu, Nov 4, 2010 at 12:43 PM, Terry Lee Tucker te...@chosen-ones.org wrote:
Greetings:
Lately, I've begun using views quite often especially when queries for various
reports, etc. become complicated. I am now wondering if there is a price to
pay in terms of overhead for this. In truth, I
On Thursday, November 04, 2010 15:03:49 Scott Marlowe wrote:
On Thu, Nov 4, 2010 at 12:43 PM, Terry Lee Tucker te...@chosen-ones.org
wrote:
Greetings:
Lately, I've begun using views quite often especially when queries for
various reports, etc. become complicated. I am now wondering if
te...@chosen-ones.org (Terry Lee Tucker) writes:
Lately, I've begun using views quite often especially when queries for
various
reports, etc. become complicated. I am now wondering if there is a price to
pay in terms of overhead for this. In truth, I don't really understand how a
view
using PostgreSQL 8.4.5 on Ubuntu 10.04.1 LTS
I'm trying to create an INSERT trigger (plpgsql) based on the example
provided here:
http://www.postgresql.org/docs/current/interactive/ddl-partitioning.html
to automatically insert data into the currect yearly table partition.
For some reason, it
On 04/11/2010 19:58, Chris Browne wrote:
Under the hood, views represent a rewriting of the query.
http://www.postgresql.org/docs/8.4/static/rules-views.html
If you have two tables that are joined together, in a view, then when
you query the view, you're really running a more complex query
One of the benefits of writing views instead of using SQL in your code,
is that any developer or developer tool can use the view.
So the DB developer writes the view and maybe define indexes that can
speed up the query and any developer of any software that uses the DB
can refer to the View
Howdy,
I was hoping someone could help me with ye olde ldap authentication syntax.
I'm currently using PG 8.3.9 and an upgrade is not an option.
Now, that being said, since i'm very new to LDAP i decided to use PG 9 to
experiment with
since it looks like it has an easier syntax.
So what i've
On Thu, Nov 4, 2010 at 13:54, David Kerr d...@mr-paradox.net wrote:
Howdy,
I was hoping someone could help me with ye olde ldap authentication syntax.
I'm currently using PG 8.3.9 and an upgrade is not an option.
Now, that being said, since i'm very new to LDAP i decided to use PG 9 to
On Thu, Nov 04, 2010 at 02:07:29PM -0700, Magnus Hagander wrote:
-
- I'm trying to translate that to the old syntax of:
- hba stuff ldap ldap://w.x.y.z/ou=postgresql,dc=domain,dc=com;stuff
-
- basically, i don't know how to fit cn=admin and ldapbindpassword into that
string.
-
- The
On Thu, Nov 4, 2010 at 15:30, David Kerr d...@mr-paradox.net wrote:
On Thu, Nov 04, 2010 at 02:07:29PM -0700, Magnus Hagander wrote:
-
- I'm trying to translate that to the old syntax of:
- hba stuff ldap
ldap://w.x.y.z/ou=postgresql,dc=domain,dc=com;stuff
-
- basically, i don't
On Thu, Nov 04, 2010 at 03:35:11PM -0700, Magnus Hagander wrote:
- On Thu, Nov 4, 2010 at 15:30, David Kerr d...@mr-paradox.net wrote:
- On Thu, Nov 04, 2010 at 02:07:29PM -0700, Magnus Hagander wrote:
- -
- - I'm trying to translate that to the old syntax of:
- - hba stuff ldap
Hi,
It seems there are some demand to seek how to deal with automated
failover while using Streaming replication and Hot standby. I wrote a
small tutorial how to implement this by using pgpool-II. Please visit:
http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html
if you
I have a table column I want to change from a boolean to a smallint.
changing false to 0 and true to 1. How do I do that?
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 2010-11-04 15:41, Christine Penner wrote:
I have a table column I want to change from a boolean to a smallint.
changing false to 0 and true to 1. How do I do that?
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
ALTER TABLE ALTER col_name TYPE SMALLINT
USING CASE WHEN
Oops; see correction below:
On 2010-11-04 16:41, Dean Gibson (DB Administrator) wrote:
On 2010-11-04 15:41, Christine Penner wrote:
I have a table column I want to change from a boolean to a smallint.
changing false to 0 and true to 1. How do I do that?
Christine Penner
Ingenious Software
The choice depends more on what you want / need to have than what people
think you want / need.
If your corporation requires a support agreement, go either with Red Hat or
with SuSE (Novell).
If possible, have at least one of each of the above for a while -- one or
two years -- and see what is
Hello,
sorry for the stupid question, but why has the week number changed
from 44 to 45 this night? It is Friday, 2010-11-05 01:10, but I get now:
pref= SELECT to_char(current_timestamp, '-WW');
to_char
-
2010-45
(1 row)
pref= SELECT CURRENT_DATE;
date
2010-11-05
Alexander Farber alexander.far...@gmail.com writes:
sorry for the stupid question, but why has the week number changed
from 44 to 45 this night?
WW is defined as starting the first week on the first day of the year.
2010 started on a Friday so the week number increments on Fridays.
There are
We have procs that would benefit from returning IMMUTABLE results. The procs
are dependent on external tables that rarely change, but when they DO
change, it would be great if we could expire the cache that the procs read
from so that the procs are forced to re-evaluate the results.
Is this
On Fri, Nov 5, 2010 at 1:21 AM, Tom Lane t...@sss.pgh.pa.us wrote:
WW is defined as starting the first week on the first day of the year.
2010 started on a Friday so the week number increments on Fridays.
There are some other format codes with different behavior ...
Thank you, that is what I
I will try -IW
On Fri, Nov 5, 2010 at 1:28 AM, Alexander Farber
alexander.far...@gmail.com wrote:
But is there a format code for a week starting on Sunday or Monday?
Sorry, I can't find it at
http://www.postgresql.org/docs/8.4/interactive/functions-formatting.html
--
Sent via
On Friday 5. November 2010 01.24.14 Carlo Stonebanks wrote:
We have procs that would benefit from returning IMMUTABLE results. The procs
are dependent on external tables that rarely change, but when they DO
change, it would be great if we could expire the cache that the procs read
from so
On Thu, Nov 04, 2010 at 08:24:14PM -0400, Carlo Stonebanks wrote:
We have procs that would benefit from returning IMMUTABLE results.
The procs are dependent on external tables that rarely change, but
when they DO change, it would be great if we could expire the cache
that the procs read from
55 matches
Mail list logo