done, the prompt still shows 'test#' so it's not like I've
changed databases.
I only have one schema, 'public'.
Can't figure out why a simple example works but a large file requires an
extra \c.
Sure appreciate any help.
Blake McBride
I should also mention that I am using PostgreSQL 9.3.22 on a 64 bit Linux
box.
On Tue, Mar 27, 2018 at 6:22 AM, Blake McBride wrote:
> Hi,
>
> I have been using PostgreSQL for many years but all of a sudden a db load
> script I've been using no longer works. What id does
On Tue, Mar 27, 2018 at 6:48 AM, rob stone wrote:
> Hello Blake,
>
> On Tue, 2018-03-27 at 06:23 -0500, Blake McBride wrote:
> > I should also mention that I am using PostgreSQL 9.3.22 on a 64 bit
> > Linux box.
> >
> > On Tue, Mar 27, 2018 at 6:22 AM, B
et seq=seq+1 where listid='abc';
What I get is a duplicate primary key. I wouldn't think I'd get that
because I'd think the whole thing is done in a transaction so that
duplicate checks wouldn't be done till the end (essentially).
Is there a clean way to do this?
Thanks!
Blake McBride
kkw4mu4 ~]#
I have no idea how to fix this. Any help would sure be appreciated.
Blake McBride
Secondly, you'd have to maintain far fewer
builds.
The only negative to using one of these is that the installations would be
a bit larger. This is a very small penalty to get the portable and
convenience these package managers provide.
Thanks.
Blake McBride
True but they're usually out-of-date.
On Sat, Nov 27, 2021 at 2:09 PM Chuck Davis wrote:
> Have you checked your distro repositories? The distro I use ships pgAdmin
> together with the latest and previous versions of postgresql.
>
> On Sat, Nov 27, 2021 at 10:52 AM Blake
me to fix this (like export with some
compatibility flag)?
Thanks!
Blake McBride
data existed. When I
use --exclude-table-data
it works.
Thanks.
Blake
On Sat, Dec 9, 2017 at 9:53 AM, Rob Sargent wrote:
>
>
> > On Dec 9, 2017, at 8:42 AM, Blake McBride wrote:
> >
> > Greetings,
> >
> > I am using pg_dump on version 9.5.10 and trying to im
