On 11/27/2015 06:07 PM, Tom Lane wrote:
> Adrian Klaver writes:
>> On 11/27/2015 08:15 AM, Bruce Momjian wrote:
>>> My guess is you are sharing the constraint name "seqno_not_null" with
>>> multiple tables. I think you are going to have to dig into the system
>>> tables to see where that is refer
Adrian Klaver writes:
> On 11/27/2015 08:15 AM, Bruce Momjian wrote:
>> My guess is you are sharing the constraint name "seqno_not_null" with
>> multiple tables. I think you are going to have to dig into the system
>> tables to see where that is referenced and fix it.
> In the post below the OP
On 11/27/2015 01:17 PM, anj patnaik wrote:
Hello,
Yes, postgres is currently installed on a nfs mounted file system. So
when graphical installer runs, there is a form which asks location for
installation. I specified this path /opt/nfsDir/Postgres where nfsDir is
a nfs mount. So currently this is
On 11/27/2015 01:17 PM, anj patnaik wrote:
Hello,
Yes, postgres is currently installed on a nfs mounted file system. So
when graphical installer runs, there is a form which asks location for
installation. I specified this path /opt/nfsDir/Postgres where nfsDir is
a nfs mount. So currently this is
On 11/27/2015 08:15 AM, Bruce Momjian wrote:
> On Fri, Nov 27, 2015 at 04:05:46PM +, Benedikt Grundmann wrote:
>> > [as-proddb@nyc-dbc-001 upgrade-logs]$ tail pg_upgrade_dump_16416.log
>> > pg_restore: creating CHECK CONSTRAINT seqno_not_null
>> > pg_restore: creating CHECK CONST
On 11/26/2015 08:16 PM, Nava Jyothi wrote:
/Hi PostGresSQL Team
Could you advise us on how to commit records in a batch when one is
doing batch wise deletion/. I came across
http://www.postgresql.org/message-id/60644bymua@dba2.int.libertyrms.com,
That post references untested pseudo code.
*Hi PostGresSQL TeamCould you advise us on how to commit records in a batch
when one is doing batch wise deletion*. I came across
http://www.postgresql.org/message-id/60644bymua@dba2.int.libertyrms.com,
but use of vacuum is giving an error as follows from function.
*** Error **
On 2015-11-27 10:31:03 +0100, NTPT wrote:
> Thanx for help, I grab the source code that match old cluster fs backup.
>
> However: Should it run fine compiled with recent gcc 4.9.3 ?
>
> while compiled with this gcc , I got a lot of strange errors like
>
> ERROR: could not identify an ord
Jan de Visser writes:
> On 2015-11-27 9:44 AM, Adrian Klaver wrote:
>> To me nonsensical would be trying to compile newer code using an old
>> compiler. What the OP did seemed to be in the realm of possibility as
>> I would think backwards compatibility kicks in.
> Well, maybe. But there's no
On 11/27/2015 08:05 AM, Benedikt Grundmann wrote:
On Fri, Nov 27, 2015 at 4:04 PM, Bruce Momjian mailto:br...@momjian.us>> wrote:
On Fri, Nov 27, 2015 at 09:38:54AM +, Benedikt Grundmann wrote:
> That worked (I also swapped the password columns so that I don't have to
change
>
On Fri, Nov 27, 2015 at 04:05:46PM +, Benedikt Grundmann wrote:
> > [as-proddb@nyc-dbc-001 upgrade-logs]$ tail pg_upgrade_dump_16416.log
> > pg_restore: creating CHECK CONSTRAINT seqno_not_null
> > pg_restore: creating CHECK CONSTRAINT seqno_not_null
> > pg_restore: [archiver (d
On Fri, Nov 27, 2015 at 4:04 PM, Bruce Momjian wrote:
> On Fri, Nov 27, 2015 at 09:38:54AM +, Benedikt Grundmann wrote:
> > That worked (I also swapped the password columns so that I don't have to
> change
> > pgpass entries). But I then ran into a different problem a little later
> on. I
>
On Fri, Nov 27, 2015 at 09:38:54AM +, Benedikt Grundmann wrote:
> That worked (I also swapped the password columns so that I don't have to
> change
> pgpass entries). But I then ran into a different problem a little later on.
> I
> thought I quickly mention it here in case somebody can poin
On 11/25/2015 10:28 AM, anj patnaik wrote:
Hello all,
I've got 2 more questions. The cron job is now setup and email gets
generated with proper body.
I've one setup with NFS which appears to work smoothly. Now soon, I will
be given a Linux VM on a different physical server, but will retain my
NF
On 2015-11-27 9:44 AM, Adrian Klaver wrote:
You realize how old 9.0 is, right? And you understand how nonsensical
your question is? How can you guarantee that code compiles properly on a
compiler which is released years after you write the code?
To me nonsensical would be trying to compile newe
On 11/27/2015 06:24 AM, Jan de Visser wrote:
On 2015-11-27 4:31 AM, NTPT wrote:
Thanx for help, I grab the source code that match old cluster fs
backup.
However: Should it run fine compiled with recent gcc 4.9.3 ?
You realize how old 9.0 is, right? And you understand how nonsensical
your
On 2015-11-27 4:31 AM, NTPT wrote:
Thanx for help, I grab the source code that match old cluster fs
backup.
However: Should it run fine compiled with recent gcc 4.9.3 ?
You realize how old 9.0 is, right? And you understand how nonsensical
your question is? How can you guarantee that cod
On Wed, Nov 25, 2015 at 2:43 PM, Bruce Momjian wrote:
> On Wed, Nov 25, 2015 at 08:04:49AM +, Benedikt Grundmann wrote:
> > You can see the 9.5 requirements in the pg_upgrade function
> > check_is_install_user(). You might as well just honor what that
> > requires as you will eve
Thanx for help, I grab the source code that match old cluster fs backup.
However: Should it run fine compiled with recent gcc 4.9.3 ?
while compiled with this gcc , I got a lot of strange errors like
ERROR: could not identify an ordering operator for type name at character
3336
HINT: U
It is difficult to read your e-mails.
Ramesh T wrote:
>> When this thread started you said you where selecting 20 rows.
>
> Yes.
>> Which is correct 20 rows or columns and if columns how many rows?
>
> Yes,I did selected 20 columns from two tables.
>> Where are you measuring this time?
>
> He
anj patnaik wrote:
> I've got 2 more questions. The cron job is now setup and email gets generated
> with proper body.
>
> I've one setup with NFS which appears to work smoothly. Now soon, I will be
> given a Linux VM on a
> different physical server, but will retain my NFS mount. I've installed
21 matches
Mail list logo