Chrishelring wrote on 10.06.2011 22:45:
HI all,
below is the view i´ve tried to create on a table. The purpose was to do
some math on one of the columns (retning). The column is a double precision
number. The result is that the function is not recognized ("ERROR: function
to_number(double preci
HI all,
below is the view i´ve tried to create on a table. The purpose was to do
some math on one of the columns (retning). The column is a double precision
number. The result is that the function is not recognized ("ERROR: function
to_number(double precision, unknown) does not exist"). I´m a bit
Both the servers are having 9.0.2
Thanks
On Fri, Jun 10, 2011 at 4:09 PM, Guillaume Lelarge
wrote:
> On Fri, 2011-06-10 at 15:46 -0400, akp geek wrote:
> > Hi all -
> >
> >
> > After making the required changes to the Primary and slave ,
> > I have restarted the slave and I keep seeing
On Fri, 2011-06-10 at 15:46 -0400, akp geek wrote:
> Hi all -
>
>
> After making the required changes to the Primary and slave ,
> I have restarted the slave and I keep seeing the following in the
> logs.
>
>
> Operating system is solaris.
>
> on the primar
Hi all -
After making the required changes to the Primary and slave , I have
restarted the slave and I keep seeing the following in the logs.
Operating system is solaris.
on the primary . postgresql.conf has the following changes
listen_addresses = '*'
On Fri, Jun 10, 2011 at 2:10 PM, Marc Munro wrote:
> I'd like to be able to wait for notify events using a user-defined C
> function. All of the examples and code I can find use libpq.
>
> Is there some way I can synchronously wait for notify events using SPI?
>
> Is there some reason this is a d
I'd like to be able to wait for notify events using a user-defined C
function. All of the examples and code I can find use libpq.
Is there some way I can synchronously wait for notify events using SPI?
Is there some reason this is a dumb idea? I wondered about the risk of
deadlocking a backend
John R Pierce writes:
> today has been like deja vu, I'm seeing all kinda postings from
> yesterday regurgitated.
> is this just me? or did the server hiccup and send a lot of stuff twice?
It appears that one alexis.mic...@ibcp.fr at athena.ibcp.fr regurgitated
a lot of postings. To judge by
On 06/10/11 11:02 AM, Carlos Mennens wrote:
On Fri, Jun 10, 2011 at 1:57 PM, Bill Moran wrote:
I don't think ALTER COLUMN TYPE will implicitly convert from varchar
to INT.
Try:
ALTER TABLE reference
ALTER COLUMN color
TYPE INT
USING CAST(color AS INT);
Your command suggestion worked
In response to Carlos Mennens :
> On Fri, Jun 10, 2011 at 1:57 PM, Bill Moran wrote:
> > I don't think ALTER COLUMN TYPE will implicitly convert from varchar
> > to INT.
> >
> > Try:
> > ALTER TABLE reference
> > ALTER COLUMN color
> > TYPE INT
> > USING CAST(color AS INT);
>
> Your comma
On Fri, Jun 10, 2011 at 1:57 PM, Bill Moran wrote:
> I don't think ALTER COLUMN TYPE will implicitly convert from varchar
> to INT.
>
> Try:
> ALTER TABLE reference
> ALTER COLUMN color
> TYPE INT
> USING CAST(color AS INT);
Your command suggestion worked perfect but can you explain why yo
Carlos Mennens wrote:
> For some reason I'm unable to change a column's TYPE from VARCHAR(20)
> to INTERGER or SMALLINT. I'm required to note the manufactures color
> code (value = 198) in the table data but keep getting this error and I
> don't understand why:
>
> The error I'm recieving is:
>
In response to Carlos Mennens :
> For some reason I'm unable to change a column's TYPE from VARCHAR(20)
> to INTERGER or SMALLINT. I'm required to note the manufactures color
> code (value = 198) in the table data but keep getting this error and I
> don't understand why:
>
> The error I'm recievi
For some reason I'm unable to change a column's TYPE from VARCHAR(20)
to INTERGER or SMALLINT. I'm required to note the manufactures color
code (value = 198) in the table data but keep getting this error and I
don't understand why:
The error I'm recieving is:
ERROR: column "color" cannot be cast
today has been like deja vu, I'm seeing all kinda postings from
yesterday regurgitated.
is this just me? or did the server hiccup and send a lot of stuff twice?
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-gen
Le vendredi 10 juin 2011 à 11:34 +0430, Arash pajoohande a écrit :
>
> > and documents must display on web page when corresponding
> user
> > requests occurs.
>
>
> I wonder why that is? is there any reason you can't just store
> a
HI John,
I would not mind to go for linux. Is there any guide to setup failover
safe postgres servers on linux/windows ?
I found few, but noe of them is complete/descriptive.
Regards,
Sanjay Rao
On 6/9/2011 11:30 PM, John R Pierce wrote:
On 06/09/11 2:45 AM, Sanjay Rao wrote:
Hi,
If anybod
On Friday 10. June 2011 09.04.18 Arash pajoohande wrote:
> Actually, my word files consists of many exam questions. for each user, a
> random subset of questions must selected and displayed.
> it seem's that it would be nice if I have each question as an easy to
> handle document section (e.g. htm
On 06/10/2011 05:22 PM, Vikram A wrote:
I am new to postgreSQL. I would like to use encrypt/decrypt using PGP
keys on windows.
It'd be helpful to know in more detail what you want to encrypt and
decrypt, and how. Getting crypto right is about a lot more than using
good algorithms and good im
On 06/10/2011 03:26 PM, John R Pierce wrote:
actually, for THAT requirement, I think I'd store the questions in the
database as plain text and wrap them in HTML formatting in your View or
Presentation layer as its being sent to the user
I agree - sending a PDF, Word doc, RTF, etc for that
Hi,
is there a way to change the sample size for statistics (that analyze
gathers)?
It is said to be 10%. i would like to raise that, because we are getting bas
estimations for n_distinct.
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all others
because you were
Hi there,
I am new to postgreSQL. I would like to use encrypt/decrypt using PGP keys on
windows.
May i know,
1. What should i know before i proceed?
2. Any manual to follow the steps ?
Thank you in advance
Vikram
On 06/10/11 12:50 AM, Bruno Boettcher wrote:
Hello,
seems a stupid problem, but somehow i am not able to solve it
i want to set up an environment identical to one on another server, thus i need
a user and db
which match the ones on the production server and the whole thing with password
i
Hello,
seems a stupid problem, but somehow i am not able to solve it
i want to set up an environment identical to one on another server, thus i need
a user and db
which match the ones on the production server and the whole thing with password
identification...
so i tried the following:
cr
I would love to say it solves my problem, but it really don't ;)
> wstrzalka wrote:
> > Hi
>
> > Is there any estimate where 9.1 potentially could be released?
>
> Sure. When it's ready ;-)
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unint
On 06/10/11 12:04 AM, Arash pajoohande wrote:
Actually, my word files consists of many exam questions. for each
user, a random subset of questions must selected and displayed.
it seem's that it would be nice if I have each question as an easy to
handle document section (e.g. html div) and displa
hello all and thank you for your advices
On Thu, Jun 9, 2011 at 7:05 PM, Vincent Veyron wrote:
> Le mercredi 08 juin 2011 à 14:43 +0430, Arash pajoohande a écrit :
>
> > and documents must display on web page when corresponding user
> > requests occurs.
>
> I wonder why that is? is there any reas
27 matches
Mail list logo
