On Jul 17, 2012, at 2:32, Rafal Pietrak wrote:
> On Mon, 2012-07-16 at 14:08 -0400, David Johnston wrote:
> []
>>
>> Specific, but unknown (e.g., day of week, month, year, etc...) results could
>> return "NaN" though "NULL" is also, probably more, reasonable given the
>> context.
>>
> Crashed how? Did the *server* crash, or the database?
> When is your last backup from?
> Have you made a complete file-system level copy of the database yet?
I don't know how it crashed yet, I'm checking what the reason was.
We will check if we have a recent backup.
Yes, we made a compile file-
Hello,
I'm running Postgres 9.0.2 on RHEL 5.6 x86_64 and trying to run the
following statement:
alter table samples add column in_esp1234 text;
When I do this the command just hangs. ps output indicates that it's
waiting:
postgres: postgres exomeSNP [local] ALTER TABLE waiting
When I look
so nobody can help? :(
On Fri, Jul 13, 2012 at 10:56 AM, KOTa wrote:
> there is no log, only thing which is left after failed installation
> attempt is %TEMP%\postgresql_installer\
> with following files:
> http://gyazo.com/01c378f7c55c876f937ca3798b255d37.png?1342165847
>
> On Fri, Jul 13, 2012
Hello,
I have been trying to find out all the bug list statistics for all previous
version releases but I could not get any information regarding this on internet.
So can you please help me to get these details.
Also please let me know if this is not right mailing list for such question
th
I'm trying to create a discrete range type and I'm having trouble with
the canonical function.
--Create shell type
CREATE TYPE dt_range;
--Create subtype diff
CREATE OR REPLACE FUNCTION dt_subtype_diff(timestamptz, timestamptz)
RETURNS float8 AS
$$
SELECT EXTRACT(EPOCH FROM $1 - $2);
$$ LANGU
On Wed, Jul 18, 2012 at 1:24 AM, Brian McNally wrote:
> Hello,
>
> I'm running Postgres 9.0.2 on RHEL 5.6 x86_64 and trying to run the
> following statement:
>
> alter table samples add column in_esp1234 text;
>
> When I do this the command just hangs. ps output indicates that it's
> waiting:
>
>
Scott Bailey writes:
> I'm trying to create a discrete range type and I'm having trouble with
> the canonical function.
Yeah, right now you really can't write canonical functions in anything
except C, for which we don't enforce the no-shell-types restriction.
Before range types, this wasn't a b
On 07/17/2012 03:29 AM, KOTa wrote:
so nobody can help? :(
If I followed correctly the problem is:
1) You are on Windows 7 Home
2) You have an admin account and Guest account.
3) You are using the One-Click Installer
4) Using either account the install fails when it asks for the superuser
pas
Hi.
If I have a lot (10k) tables, and each table has a btree index, and all the
tables are being constantly inserted into, would all the indexes have to be
in memory, and would effectively start fighting for space?
Thank you,
Pawel.
On 07/18/2012 12:02 PM, Pawel Veselov wrote:
Hi.
If I have a lot (10k) tables, and each table has a btree index, and
all the tables are being constantly inserted into, would all the
indexes have to be in memory, and would effectively start fighting for
space?
Quite likely, yes.
You could m
On Tue, Jul 17, 2012 at 9:18 PM, Craig Ringer wrote:
> On 07/18/2012 12:02 PM, Pawel Veselov wrote:
>
> Hi.
>
> If I have a lot (10k) tables, and each table has a btree index, and all
> the tables are being constantly inserted into, would all the indexes have
> to be in memory, and would effect
Hi,
Can you guys please help me? My question sounds like this.
When I insert a new record in a table, can I create a trigger to add
another record based on the inserted record in the same table?
For example,
INSERT INTO employee (emp_id, emp_name) VALUES (0001, 'Jack');
The result:
Select * f
Hello,
I deleted my Postgresql and try to reinstall it. I try to reset the
password by typing in net user postgres *. However, the new password
doesn't work when the installer prompt me to input the password.
Could you please help me?
Thanks,
Keith
--
Sent via pgsql-general mailing list (pgs
I'm trying to create a discrete range type and I'm having trouble with
the canonical function.
--Create shell type
CREATE TYPE dt_range;
--Create subtype diff
CREATE OR REPLACE FUNCTION dt_subtype_diff(timestamptz, timestamptz)
RETURNS float8 AS
$$
SELECT EXTRACT(EPOCH FROM $1 - $2);
$$ LANGU
You can use an already existing account by specifying --serviceaccount CLI
option. So you can:
i) Create a new account and then use it.
ii) Use an already existing account.
See if this helps.
On Wed, Jul 18, 2012 at 11:07 AM, KOTa wrote:
> yes, many other programs.
> although none of them nee
yes, many other programs.
although none of them needed to create an account
On Wed, Jul 18, 2012 at 6:19 AM, Adrian Klaver wrote:
> On 07/17/2012 03:29 AM, KOTa wrote:
>>
>> so nobody can help? :(
>>
>
> If I followed correctly the problem is:
> 1) You are on Windows 7 Home
> 2) You have an admin
17 matches
Mail list logo
