On Thu, Jun 16, 2011 at 10:59 PM, Jeff Hamann wrote:
> Please don't respond with "Why don't you just use the ports collection?"
> There's reasons - like: 1) need to build from source, 3) it's for a
> tutorial, and 3) postgresql90-server isn't building.
>
> Respectfully,
> Jeff.
>
>
>
While I can
I'm still finding pg_create_restore_point in 9.1a2 documentation:
http://www.postgresql.org/docs/9.1/static/functions-admin.html
But I've compiled that version and I didn't found it:
postgres=# \df *create_restore*
List of functions
Schema | Name | Result data type | Argum
Hallo,
Using libpqexec many error details can retrieved:
http://www.postgresql.org/docs/8.4/interactive/libpq-exec.html
(such as PG_DIAG_SEVERITY, PG_DIAG_MESSAGE_HINT,
PG_DIAG_STATEMENT_POSITION.. as on the site above)
eg:
http://pgsql.privatepaste.com/656698b511
but when u try to trap/catch all
Hi,
I've got a lot of databases, unfortunately applications need to get a lot of
data (a lot of means too much).
The whole request takes about 3s, while pure explain analyze only 250ms.
The amount of downloaded data cannot be changed.
I'm just wondering if I can do anything about that.
Maybe there
Hello
2011/6/22 Wim Bertels :
> Hallo,
>
> Using libpqexec many error details can retrieved:
> http://www.postgresql.org/docs/8.4/interactive/libpq-exec.html
> (such as PG_DIAG_SEVERITY, PG_DIAG_MESSAGE_HINT,
> PG_DIAG_STATEMENT_POSITION.. as on the site above)
> eg:
> http://pgsql.privatepaste.co
The answer is: SSL. SSL will compress things, before encrypting
(depends on setup obviously).
As far as I know, postgresql it self doesn't compress any data over the wire.
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
On Wed, Jun 22, 2011 at 3:28 AM, Emanuel Calvo wrote:
> I'm still finding pg_create_restore_point in 9.1a2 documentation:
> http://www.postgresql.org/docs/9.1/static/functions-admin.html
>
> But I've compiled that version and I didn't found it:
>
> postgres=# \df *create_restore*
>
Hi!
I have 3 tables. I want to run a query that collect some data from
them, and join into one result table.
I show a little example, how to do this in another DB with script:
create temp table tmp_a as select id, name, sum(cost) cost from items
where... group by id, name with data;
create temp
Hallo,
does anyone have know of a free CRUD generator
for generating plpgsql functions for doing CRUD operations on all the
tables of a database or schema or just one table or..
cf
http://postgresql.1045698.n5.nabble.com/CRUD-functions-similar-to-SQL-stored-procedurs-for-postgresql-tables-td33720
On Wed, Jun 22, 2011 at 1:35 PM, Durumdara wrote:
> Hi!
>
> I have 3 tables. I want to run a query that collect some data from
> them, and join into one result table.
>
> I show a little example, how to do this in another DB with script:
>
> create temp table tmp_a as select id, name, sum(cost) co
Durumdara, 22.06.2011 12:35:
Hi!
I have 3 tables. I want to run a query that collect some data from
them, and join into one result table.
I show a little example, how to do this in another DB with script:
with tmp_a as (
select id, name, sum(cost) cost
from items
...
),
temp_b as (
s
2011/6/22 Jaime Casanova :
> On Wed, Jun 22, 2011 at 3:28 AM, Emanuel Calvo wrote:
>> I'm still finding pg_create_restore_point in 9.1a2 documentation:
>> http://www.postgresql.org/docs/9.1/static/functions-admin.html
>>
>> But I've compiled that version and I didn't found it:
>>
>> postgres=# \df
how to fix it?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-could-not-get-socket-error-status-Invalid-argument-tp1884036p4513496.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@po
Hi Tarlika,
I hope this approach is of interest.
This is how I would design a database to solve the problem -
unfortunately, this
may not be appropriate for your particular situation.
This design ensures that: names of towns are unique within a given
country and
region. plus it can support
On Wed, 22 Jun 2011 02:42:42 -0700 (PDT), simon wrote:
how to fix it?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-could-not-get-socket-error-status-Invalid-argument-tp1884036p4513496.html
Sent from the PostgreSQL - general mailing list archive at
Nabble.com.
Hi Tarlika,
I think easy solution could be:
create baseTable with just one column as PK
TableA inhertis baseTable, it will have inherited Column + additianl tables
for TableA
TableB inherits baseTable, it will aslo have inherited Column + additianl
tables for TableB
Insert in any table TableA o
On Tue, Jun 21, 2011 at 9:15 PM, Joel Stevenson wrote:
> Does anyone know if temp tables and the operations on them (like inserting or
> copying to) are replicated from master to standby servers via the new PG WAL
> shipping replication? Given that temp tables are only accessible per-session
Misa,
Your statement is utterly false simply by virtue of the documentation.
Inserts never propagate to other tables in a hierarchy
Indexes/Constraints only apply to individual tables
Since inserts do not propagate the base table never sees the records and thus
the index on the base t
true :(
My applogize to all - my BIG fault - i haven't tested that before sent
suggestion
Kind Regards,
Misa
2011/6/22 David Johnston
> Misa,
>
> ** **
>
> Your statement is utterly false simply by virtue of the documentation.
>
> ** **
>
> Inserts never propagate to other tables in a
On Wed, Jun 22, 2011 at 5:40 AM, Wim Bertels wrote:
> Hallo,
>
> does anyone have know of a free CRUD generator
> for generating plpgsql functions for doing CRUD operations on all the
> tables of a database or schema or just one table or..
>
> cf
> http://postgresql.1045698.n5.nabble.com/CRUD-func
Jaime Casanova writes:
> On Wed, Jun 22, 2011 at 3:28 AM, Emanuel Calvo wrote:
>> I'm still finding pg_create_restore_point in 9.1a2 documentation:
>> http://www.postgresql.org/docs/9.1/static/functions-admin.html
>> But I've compiled that version and I didn't found it:
> the function exists...
On 06/22/2011 08:02 AM, Merlin Moncure wrote:
> On Wed, Jun 22, 2011 at 5:40 AM, Wim Bertels wrote:
>> Hallo,
>>
>> does anyone have know of a free CRUD generator
>> for generating plpgsql functions for doing CRUD operations on all the
>> tables of a database or schema or just one table or..
>>
On Wed, Jun 22, 2011 at 9:59 AM, Rob Sargent wrote:
> On 06/22/2011 08:02 AM, Merlin Moncure wrote:
>> On Wed, Jun 22, 2011 at 5:40 AM, Wim Bertels wrote:
>>> Hallo,
>>>
>>> does anyone have know of a free CRUD generator
>>> for generating plpgsql functions for doing CRUD operations on all the
>>
On 13 May 2010 18:28, Guillaume Lelarge wrote:
> Le 13/05/2010 19:24, Thom Brown a écrit :
>> On 13 May 2010 17:49, Guillaume Lelarge wrote:
>>
>>> Le 13/05/2010 14:12, Thom Brown a écrit :
On 5 March 2009 12:08, Thom Brown wrote:
> [...]
I'm bringing this thread back to life to se
2011/6/22 Grzegorz Jaśkiewicz :
> The answer is: SSL. SSL will compress things, before encrypting
> (depends on setup obviously).
> As far as I know, postgresql it self doesn't compress any data over the wire.
Could you elaborate a bit on using SSL for that purpose? How do you
set it up for compr
On Wed, Jun 22, 2011 at 8:34 AM, David Johnston wrote:
> Your statement is utterly false simply by virtue of the documentation.
>
>
>
> Inserts never propagate to other tables in a hierarchy
>
> Indexes/Constraints only apply to individual tables
>
>
>
> Since inserts do not propagate the base tab
On 06/21/2011 06:58 PM, Rob Sargent wrote:
>
>
> On 06/21/2011 06:49 PM, Tom Lane wrote:
>> Rob Sargent writes:
>>> Seems to me a lot of the needed standard libraries are in '/lib64' and
>>> the linker isn't looking for them there? So far I've hit libreadline
>>> and libz. Do I just keep mak
> yeah -- postgresql table inheritance [...] underpins the table inheritance
feature [...]
Thank you Master of the Obvious ;)
I do think you meant to say it underpins the "Table Partitioning Feature"
which, through the use of INSERT triggers to at least propagate the inserts
to the proper tables
http://httpd.apache.org/docs/2.0/ssl/ssl_faq.html#comp
That applies in general to SSL apps.
In cryptography it is always recommended, and sometimes even mandatory
to compress data before encryption. This reduces the risk of finding
patterns, etc.
And SSL includes that option as well.
But that's
On 06/22/2011 09:10 AM, Merlin Moncure wrote:
> On Wed, Jun 22, 2011 at 9:59 AM, Rob Sargent wrote:
>> On 06/22/2011 08:02 AM, Merlin Moncure wrote:
>>> On Wed, Jun 22, 2011 at 5:40 AM, Wim Bertels
>>> wrote:
Hallo,
does anyone have know of a free CRUD generator
for generat
On Wed, Jun 22, 2011 at 11:30 AM, David Johnston wrote:
>> yeah -- postgresql table inheritance [...] underpins the table inheritance
> feature [...]
>
> Thank you Master of the Obvious ;)
>
> I do think you meant to say it underpins the "Table Partitioning Feature"
> which, through the use of IN
Has anyone successfully used encfs with postgresq recently?
I'm not sure if this is specifically a postgresql problem, but I'm trying to
get postgresql to run on an
encrypted file system that is a copy of my live data directory tree
(after a shutdown, of course) and am getting the following errors
Michael Nolan writes:
> Has anyone successfully used encfs with postgresq recently?
> PANIC: could not open file "pg_xlog/00010009000D" (log file 9,
> segment 13): Invalid argument
> The database version here is 8.2.11, running on a Linux Fedora Core 14
> server.
Does it work any b
On Wed, Jun 22, 2011 at 3:48 PM, Tom Lane wrote:
> Michael Nolan writes:
> > Has anyone successfully used encfs with postgresq recently?
>
> > PANIC: could not open file "pg_xlog/00010009000D" (log file
> 9,
> > segment 13): Invalid argument
>
> > The database version here is 8.2.11
On 06/22/2011 10:27 AM, Rob Sargent wrote:
>
>
> On 06/21/2011 06:58 PM, Rob Sargent wrote:
>>
>>
>> On 06/21/2011 06:49 PM, Tom Lane wrote:
>>> Rob Sargent writes:
Seems to me a lot of the needed standard libraries are in '/lib64' and
the linker isn't looking for them there? So far
On Jun 20, 2011, at 10:49 PM, CSS wrote:
> Hello,
>
> I couldn't find much information in the archives on this -- perhaps this
> is a bit of a specialized need, but I was hoping for some input from
> some experienced postgres admins.
>
> I'm moving some DNS servers from djbdns/tinydns to PowerD
On 22/06/11 16:38, Szymon Guz wrote:
> Hi,
> I've got a lot of databases, unfortunately applications need to get a
> lot of data (a lot of means too much).
> The whole request takes about 3s, while pure explain analyze only 250ms.
> The amount of downloaded data cannot be changed.
What client ar
On 06/22/2011 10:27 AM, Rob Sargent wrote:
>
>
> On 06/21/2011 06:58 PM, Rob Sargent wrote:
>>
>>
>> On 06/21/2011 06:49 PM, Tom Lane wrote:
>>> Rob Sargent writes:
Seems to me a lot of the needed standard libraries are in '/lib64' and
the linker isn't looking for them there? So far
38 matches
Mail list logo
