There should be no Problems runnig PostgreSQL on Windows 8 - it's still
Windows.
(I've tested 8.3.20 and yesterdays git head)
Regards,
Brar
K, Baraneetharan wrote:
Hi there,
Could you please let me know PostgreSql supports Windows 8 /Windows 2012?
If so pls provide the version from which its
> I think the OID
> argument will need to be the table not the index, but not 100% sure.
Yep, that's true. :-)
Paul
--
_
Pulchritudo splendor veritatis.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
> pg_get_indexdef() should help. If you really want just the WHERE
> clause, possibly pg_get_expr() would work, but I've not tried it on
> index clauses.
Thank you for such a quick response!
pg_get_indexdef is very helpful:
> select pg_get_indexdef(223630);
pg_get_indexdef
---
Paul Jungwirth writes:
> It'd be great to get just the WHERE clause if possible, although I can
> work around it if not. I couldn't find much documentation re
> pg_get_expr. Does this message mean I can't use it, or am I just doing
> something wrong?:
>> select pg_get_expr('{NULLTEST :arg {VA
> It'd be great to get just the WHERE clause if possible, although I can
> work around it if not. I couldn't find much documentation re
> pg_get_expr.
To answer my own question, this works:
> select pg_get_expr(indpred, indrelid) from pg_index where
indexrelid = 223630;
pg_get_expr
Disks are doing 150 read + 90 write ops/s when they should be able to do a
total of 1000 iops each as currently configured (this is the max that can
be set). Total bandwidth is 1000mb/s each too. So clearly, either there is
something wrong with ZFS/FreeBSD on Amazon (either because of config or
som
Hi there,
Could you please let me know PostgreSql supports Windows 8 /Windows 2012?
If so pls provide the version from which its starts supporting Windows8.
Thanks & Regards,
Baranee
Hello,
I'm having a problem accessing an extension's operator installed with a
schema.
PostgreSQL version: 9.1
CREATE SCHEMA inty AUTHORIZATION psql_user;
CREATE EXTENSION intarray SCHEMA inty;
SELECT inty.uniq(ARRAY[1,2,3]); --> OK, result: {1,2,3}
How can I access the operator with inty schem
xoip writes:
> CREATE SCHEMA inty AUTHORIZATION psql_user;
> CREATE EXTENSION intarray SCHEMA inty;
> SELECT inty.uniq(ARRAY[1,2,3]); --> OK, result: {1,2,3}
> How can I access the operator with inty schema?
The easy way is to change your search_path to include inty.
If you really don't want to
Here is the 9.0 versionand yes I meant maintenance_work_mem
# Postgresql Memory Configuration and Sizing Script
# By: James Morton
# Last Updated 05/16/2012
#
# Note This script is meant to be used with by the postgres user with a
configured .pgpass file
# It is for Postgres version 9 running on L
Paul Jungwirth writes:
> I'm not sure how to interpret that `indpred` column. Is there any way
> to reconstruct the WHERE clause I originally passed to the CREATE
> INDEX command?
pg_get_indexdef() should help. If you really want just the WHERE
clause, possibly pg_get_expr() would work, but I've
Hello,
I created some indexes with WHERE clauses, so that only part of the
table would be indexed. Now I'd like to get a list of indexes, and
include the WHERE clause if an index has one. This is what I'm trying
right now:
SELECT indc.relname, ind.indpred
FROM pg_index ind, pg_class indc
On Fri, Sep 14, 2012 at 10:37 AM, Tom Lane wrote:
> "Ing.Edmundo.Robles.Lopez" writes:
>> Debugging the program, found that the core is generated by atoi,
>> sprintf and similar functions; because that functions fails when
>> received a null pointer (NULL). But, if the functions received an
>
2012/9/14 Albe Laurenz
> Yvon Thoraval wrote:
> You may want to set log_statement='all' in postgresql.conf
>
i did this change , restart PostgreSQL and test again, with the same error,
however postgres log didn't report any error, as far as i understand the
log :
2012-09-14 18:43:14 CEST LOG:
2012/9/14 Albe Laurenz
>
> Is this repeatable?
>
YES, may be i didn't mention that about the same config on another computer
running mac OS X, works very well with same php script. Also this php
script was working 2 months ago...
i suspect something had changed on Xubuntu within pdo, php and psq
"Ing.Edmundo.Robles.Lopez" writes:
> Debugging the program, found that the core is generated by atoi,
> sprintf and similar functions; because that functions fails when
> received a null pointer (NULL). But, if the functions received an
> empty string ("") the program continues and run succ
Hi.
I hope you can help me. I have problems with some functions like
strcpy, atoi, etc and would like to know the correct list where I have
to ask this:
I have compiled a program under SCO Openserver, and run succesfully.
But when i compile the same program in Ubuntu 12.04, i got a co
Ivan Voras writes:
> I'm creating a new data in C, and everything is proceeding well, except
> that the data type should be parsed on input like an integer. Maybe it's
> best if I explain it with an example:
> Currently, I can do this:
> INSERT INTO t(my_data_type) VALUES ('1')
> but I cannot d
Hello,
I'm creating a new data in C, and everything is proceeding well, except
that the data type should be parsed on input like an integer. Maybe it's
best if I explain it with an example:
Currently, I can do this:
INSERT INTO t(my_data_type) VALUES ('1')
but I cannot do this:
INSERT INTO t(m
On 09/14/2012 05:35 AM, Andres Freund wrote:
Hi,
On Friday, September 14, 2012 01:29:59 AM Steve Crawford wrote:
2. CLUSTER is typically way faster than VACUUM FULL and rebuilds the
indexes as well but it temporarily requires sufficient disk-space to
write out a copy of the table being clustere
Fabrízio de Royes Mello wrote:
>> Has it moved somewhere else?
> Look at the pldebugger git repository in [1].
Thanks!
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2012/9/14 Albe Laurenz
> Dear Dave, dear Korry,
>
> I tried to build the debugger
> (http://pgfoundry.org/projects/edb-debugger/)
> with PostgreSQL 9.2 and it failed.
>
> The code seems to have bitrotted.
> The last commit was 16 months ago.
>
> Do you still maintain the project?
> Has it moved s
Dear Dave, dear Korry,
I tried to build the debugger
(http://pgfoundry.org/projects/edb-debugger/)
with PostgreSQL 9.2 and it failed.
The code seems to have bitrotted.
The last commit was 16 months ago.
Do you still maintain the project?
Has it moved somewhere else?
Yours,
Laurenz Albe
--
Se
Yvon Thoraval wrote:
> I do have a strange probleme when connecting to a database thru php using PDO.
> When connecting to the php script thru a browser i get the following error :
> HTTP 500 (Internal Server Error)
>
>
> Not really informative, then i've tried the php script thru Command Line
>
On Fri, Sep 14, 2012 at 1:47 AM, Pavel Stehule wrote:
> 2012/9/14 John R Pierce :
>> On 09/13/12 10:17 PM, Wells Oliver wrote:
>>>
>>> Do these tend to perform well? I have some simple formulas in functions
>>> like so:
>>
>>
>> if you code your function in SQL instead of plpgsql, and mark it immu
I do have a strange probleme when connecting to a database thru php using
PDO.
When connecting to the php script thru a browser i get the following error :
HTTP 500 (Internal Server Error)
Not really informative, then i've tried the php script thru Command Line
where i get :
yt@D620 /home/yt/Sites
How about using this way ?
\dt *.*
Or
\dt schemaname.*
--Raghav
Sent from my BlackBerry® smartphone from !DEA
-Original Message-
From: Robert Sosinski
Sender: pgsql-general-owner@postgresql.orgDate: Fri, 14 Sep 2012 08:47:54
To:
Subject: [GENERAL] Seeing tables with the same name o
Hey Everyone,
Question, I have multiple schemas on a database, and these schemas sometimes
have the tables of the same name. However, when I do \d to see what tables I
have, I only see the first table (based on the order of the search path), but
no the other tables that have the same name on
Hi,
On Friday, September 14, 2012 01:29:59 AM Steve Crawford wrote:
> 2. CLUSTER is typically way faster than VACUUM FULL and rebuilds the
> indexes as well but it temporarily requires sufficient disk-space to
> write out a copy of the table being clustered.
Thats not the case anymore since 9.0
Arvind Singh wrote:
> I have enabled the csvlog option.
>
> There seem to be 24 columns in the Log. I have difficulty in
understanding the following columns
>
> - virtual_transaction_id
Such a transaction ID is given to every transaction.
Can be used to track transactions in the log.
> - transa
Thanx for the reply,
I have enabled the csvlog option.
There seem to be 24 columns in the Log. I have difficulty in understanding the
following columns
- virtual_transaction_id
- transaction_id
- hint
- internal_query
- internal_query_pos
- context
I have correlated the column names from
On 09/13/2012 06:51 PM, Alexander Gataric wrote:
I need to determine relationships between several tables. Is there a
free tool to extract these from catalog tables? Is there an SQL that
also does this?
Thanks
Alex
Sent from my smartphone
I'm using http://squirrel-sql.sourceforge.net for thos
32 matches
Mail list logo
