Re: [GENERAL] Extension table data

With the current design, I understand what you're saying now. Just doing some more testing, I was able to do a pg_dump -Fc -s for the entire database and looking through the resulting object list with pg_restore -l I'm actually seeing the extension table data included in the dump file. Doing a res

Re: [GENERAL] Extension table data

Keith Fiske writes: > I've read the documentation for extensions and how their data is not > normally dumped by pg_dump and how to configure the table so it should > dump its data > http://www.postgresql.org/docs/9.1/static/extend-extensions.html > However, after setting this option for the tables

[GENERAL] ctid ranges

Hi In 9.1.3, this is fast, handled with a tid scan using the physical address: SELECT ... FROM ... WHERE ctid = ...; This is slow, handled with a seq scan (as are various rephrasing with <, <=, etc): SELECT ... FROM ... WHERE ctid BETWEEN ... AND ...; Is there a way to retrieve the rows in a p

[GENERAL] New crosslinks in docs

So when did the links to other versions of the docs get rolled out? To whomever is responsible, thanks very much. -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpre

Re: [GENERAL] describe command for

Am 08.06.2012 14:50, schrieb Bartosz Dmytrak: 2012/6/8 Little, Douglas > Is there a postgres sql command/function that will display an object ddl? Hi, try some from this list: http://www.postgresql.org/docs/9.1/static/functions-info.html#FUNCTIONS-I

Re: [GENERAL] describe command for

2012/6/8 Little, Douglas > Is there a postgres sql command/function that will display an object ddl?* > *** > > > Hi, try some from this list: http://www.postgresql.org/docs/9.1/static/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE reagrds, Bartek

Re: [GENERAL] describe command for

Am 08.06.2012 14:31, schrieb Little, Douglas: Is there a postgres sql command/function that will display an object ddl?   I know of the psql metacharacters, but don’t know how I’d submit from a non-psql c

[GENERAL] describe command for

Is there a postgres sql command/function that will display an object ddl? I know of the psql metacharacters, but don't know how I'd submit from a non-psql client like sqldbx. I see that pgadmin generates a query and then formats into a ddl statement, but this seems like a lot of work for someth

Re: [GENERAL] Two databases on the same server, looking for idea how to restrict access.

Am 07.06.2012 23:03, schrieb Darren Duncan: Raymond O'Donnell wrote: On 07/06/2012 15:39, Condor wrote: I have two databases on postgresql in different servers, one main database and one secondary not much important, but the problem is they should use some tables both for reading and writing an

[GENERAL] Extension table data

I've read the documentation for extensions and how their data is not normally dumped by pg_dump and how to configure the table so it should dump its data http://www.postgresql.org/docs/9.1/static/extend-extensions.html However, after setting this option for the tables, the data is not being dumped

Re: [GENERAL] Question about load balance

Am 08.06.2012 00:39, schrieb Craig Ringer: On 06/07/2012 10:26 PM, Condor wrote: Hello ppl, I read in internet and in this mailing list, when some one asking about load balance, most of the answers is: pgpool. I want to asking how stable is pgpool ? How much query can handle ? What load aver

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

De : Craig Ringer [mailto:ring...@ringerc.id.au] Envoyé : June-08-12 9:20 AM On 06/08/2012 08:04 PM, Marc Watson wrote: Thanks, Craig It was failing on vcredist_x86 and vcredist_x64, because I had newer versions installed (10.0.40219). After uninstalling them, all is OK. Oooh! That should

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

On 06/08/2012 08:04 PM, Marc Watson wrote: Thanks, Craig It was failing on vcredist_x86 and vcredist_x64, because I had newer versions installed (10.0.40219). After uninstalling them, all is OK. Oooh! That shouldn't happen. At all. The vc redists should, as far as I know, either: (a) Si

Re: [GENERAL] Problem while restoring a database from SQL_ASCII to UTF-8

Hi, I took a slightly different approach to fix the issue. There is a CPAN module called Encoding::FixLatin, that takes mixed encoding input and produces UTF-8 output. It can be downloaded from the following link: http://search.cpan.org/dist/Encoding-FixLatin/lib/Encoding/FixLatin.pm This modu

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

Thanks, Craig It was failing on vcredist_x86 and vcredist_x64, because I had newer versions installed (10.0.40219). After uninstalling them, all is OK. Mark Watson De : Craig Ringer [mailto:ring...@ringerc.id.au] Envoyé : June-08-12 1:35 AM À : Marc Watson Cc : pgsql-general@postgresql.org