Server encoding is UTF8
Client encoding is UTF8
Creating sample schema sampledb1
DBD::Pg::db do failed: ERROR: cannot execute CREATE SCHEMA in a read-only
transaction at ./pg_sample line 296.
main::__ANON__('DBD::Pg::db do failed: ERROR: cannot execute CREATE SCHEMA
i...', 'DBI::db=HASH(0xab2388)
sudo yum install perl-CPAN
Also do a "yum search perl-" and you should find most, if not all what you
need natively packaged for your particular Linux distro. You're better off
just sticking with the pre-packaged perl modules unless you specifically
need something special.
You'll find more modul
On 08/26/2018 02:44 PM, Tom Lane wrote:
Ron writes:
On 08/26/2018 01:42 PM, Tom Lane wrote:
Perhaps I don't understand *your* question. What concrete problem are you
having?
I want to track the progress of pg_dump so as to estimate completion time.
Well, if you don't use --jobs then you sho
Ron writes:
> On 08/26/2018 01:42 PM, Tom Lane wrote:
>> Perhaps I don't understand *your* question. What concrete problem are you
>> having?
> I want to track the progress of pg_dump so as to estimate completion time.
Well, if you don't use --jobs then you should get more or less the same
beha
On 08/26/2018 01:42 PM, Tom Lane wrote:
Ron writes:
On 08/26/2018 10:24 AM, Tom Lane wrote:
Ron writes:
In what order does the 9.6 pg_dump dump tables?
I don't believe the ordering rules have changed materially since 8.4;
it's intended to be by object kind, and within that by name, except
Ron writes:
> On 08/26/2018 10:24 AM, Tom Lane wrote:
>> Ron writes:
>>> In what order does the 9.6 pg_dump dump tables?
>> I don't believe the ordering rules have changed materially since 8.4;
>> it's intended to be by object kind, and within that by name, except
>> where dependencies force doi
Wilhansen Li writes:
> I have a web application with a bunch of unit tests which involve accessing
> a PostgreSQL database. My schema contains composite types and stored
> procedures.
> When running the tests, I'm getting a
> "com.impossibl.postgres.jdbc.PGSQLSimpleException: cache lookup failed
Sir i'm getting error in both commands
[root@ip-88-8-8-17 ~]# perl -MCPAN -e 'install Bundle::DBI'
Can't locate CPAN.pm in @INC (@INC contains: /usr/local/lib64/perl5
/usr/local/share/perl5 /usr/lib64/perl5/vendor_perl
/usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .).
BEGIN faile
On Thu, Aug 23, 2018 at 4:51 PM, Tom Lane wrote:
>
> Mark Jeffcoat writes:
> > I would have claimed before seeing this example that it wasn't even
> > grammatical; I thought the only legal place to write the ON clause was
> > immediately after the JOIN. Apparently not.
>
> You read it as
>
> SEL
On 08/26/2018 10:24 AM, Tom Lane wrote:
Ron writes:
In v8.4, I noticed that the tables seemed to be dumped in alphabetical
order. Not so much, though, in a multithreaded 9.6 dump of an 8.4 database;
there's no pattern that I can discern.
In what order does the 9.6 pg_dump dump tables?
I don't
Hi all,
I have a web application with a bunch of unit tests which involve accessing
a PostgreSQL database. My schema contains composite types and stored
procedures.
When running the tests, I'm getting a
"com.impossibl.postgres.jdbc.PGSQLSimpleException: cache lookup failed for
type 64790" when tr
Ron writes:
> In v8.4, I noticed that the tables seemed to be dumped in alphabetical
> order. Not so much, though, in a multithreaded 9.6 dump of an 8.4 database;
> there's no pattern that I can discern.
> In what order does the 9.6 pg_dump dump tables?
I don't believe the ordering rules have
12 matches
Mail list logo
