On 2017-03-08 00:20, Ken Tanzer wrote:
Hi. I've got a recurring problem with character encoding for a
Postgres-based web PHP app, and am hoping someone can clue me in or at
least point me in the right direction. I'll confess upfront my
understanding of encoding issues is extremely limited. Her
On Tue, Mar 7, 2017 at 11:55 PM, Scott Marlowe wrote:
> On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma wrote:
>> Dear David,
>>
>> I want to apply explicitly lock mechanism once inset operation is in
>> progress then REINDEX will wait.
>> And vice versa.
>> So, please let me know this type of ha
On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma wrote:
> Dear David,
>
> I want to apply explicitly lock mechanism once inset operation is in
> progress then REINDEX will wait.
> And vice versa.
> So, please let me know this type of handling is possible.
> Regrds,
> Yogesh
Create two roles grant
Dear David,
I want to apply explicitly lock mechanism once inset operation is in
progress then REINDEX will wait.
And vice versa.
So, please let me know this type of handling is possible.
Regrds,
Yogesh
On Wednesday, March 8, 2017, David G. Johnston
wrote:
> On Tuesday, March 7, 2017, Yogesh S
On Tuesday, March 7, 2017, Yogesh Sharma wrote:
> Dear all,
>
> Thanks for your support.
>
> I need to perfrom INSERT and REINDEX operation exclusively.
> For example:
> If REINDEX operation is in progress then INSERT operation will wait and
> vice versa.
>
> Please let me know if any approach i
On 03/07/2017 08:17 PM, John Iliffe wrote:
I was unable to get postgres started so I did a very basic compile/install
to test it. The configuration line was:
./configure --prefix=/usr/postgres-9.6.2
Then I ran make which completed as expected:
make[1]: Leaving
John Iliffe writes:
> Now, running as user postgres I try and start as stated in the manual
> postgres -D /usr/pgsql_tablespaces
> The result is:
> [postgres@prod04 postgresql-9.6.2]$ postgres -D /usr/pgsql_tablespaces
> LOG: could not bind IPv4 socket: Cannot assign requested address
> HINT: I
Dear all,
Thanks for your support.
I need to perfrom INSERT and REINDEX operation exclusively.
For example:
If REINDEX operation is in progress then INSERT operation will wait and
vice versa.
Please let me know if any approach is available.
Regards,
Yogesh sharma
On Tue, Mar 7, 2017 at 11:17 PM, John Iliffe wrote:
> I was unable to get postgres started so I did a very basic compile/install
> to test it. The configuration line was:
>
> ./configure --prefix=/usr/postgres-9.6.2
>
>
> Then I ran make which completed as expect
I was unable to get postgres started so I did a very basic compile/install
to test it. The configuration line was:
./configure --prefix=/usr/postgres-9.6.2
Then I ran make which completed as expected:
make[1]: Leaving directory '/tmp/postgresql-9.6.2/config'
Al
Hi Ken,
On Tue, 2017-03-07 at 15:20 -0800, Ken Tanzer wrote:
> Hi. I've got a recurring problem with character encoding for a
> Postgres-based web PHP app, and am hoping someone can clue me in or
> at least point me in the right direction. I'll confess upfront my
> understanding of encoding issu
On 03/07/2017 03:20 PM, Ken Tanzer wrote:
Hi. I've got a recurring problem with character encoding for a
Postgres-based web PHP app, and am hoping someone can clue me in or at
least point me in the right direction. I'll confess upfront my
understanding of encoding issues is extremely limited.
On Tue, Mar 7, 2017 at 4:20 PM, Ken Tanzer wrote:
> As I understand it, those are likely encoded in something non-UTF-8, like
> WIN-1251 or something. And that one way or another, the encoding needs to
> be translated before it can be placed into the database. I'm not clear how
> this is suppos
Hi. I've got a recurring problem with character encoding for a
Postgres-based web PHP app, and am hoping someone can clue me in or at
least point me in the right direction. I'll confess upfront my
understanding of encoding issues is extremely limited. Here goes.
The app uses a Postgres database
On 03/07/2017 01:33 PM, John Iliffe wrote:
Perfect! Thank you.
Same issue then occurred with zlib and I installed the dev pieces and it
worked too.
Might be a good idea if the documentation listed these somewhere as
prereqs. In the past all the servers I have worked on had these installed
> On Mar 7, 2017, at 12:24 PM, Mark Dilger wrote:
>
> Hello,
>
> I am attempting to get the tap tests working under windows so as to
> help review patches for the 10.0 development cycle. I can compile
> the sources on windows 2008 using the MS Visual C and run the
>
> vcregress.bat chec
Perfect! Thank you.
Same issue then occurred with zlib and I installed the dev pieces and it
worked too.
Might be a good idea if the documentation listed these somewhere as
prereqs. In the past all the servers I have worked on had these installed
already but this one is a bit basic.
Regard
Hi,
On Tue, 2017-03-07 at 15:38 -0500, John Iliffe wrote:
> Trying to compile pgsql 9.6.2 on Fedora 25
>
> I get the following message:
>
> configure:9345: error: readline library not found
Please install readline-devel.
(BTW, https://yum.PostgreSQL.org has 9.6.2 and Fedora 25 RPMs already)
On Tue, Mar 7, 2017 at 1:29 PM, Pavel Stehule
wrote:
>
>
> 2017-03-07 21:04 GMT+01:00 Caleb Cushing :
>
>> Thank you. Apparently I never saw this response, for some reason...
>>
>> So reading that leaves me confused on one point, which is the right way
>> to do it if you're inserting an integer?
Trying to compile pgsql 9.6.2 on Fedora 25
I get the following message:
configure:9345: error: readline library not found
If you have readline already installed, see config.log for details on the
Use --without-readline to disable readline support.
pgac_cv_check_readline=no
libreadline does exis
2017-03-07 21:04 GMT+01:00 Caleb Cushing :
> Thank you. Apparently I never saw this response, for some reason...
>
> So reading that leaves me confused on one point, which is the right way to
> do it if you're inserting an integer? would this be right? is there a
> difference between the single a
Hello,
I am attempting to get the tap tests working under windows so as to
help review patches for the 10.0 development cycle. I can compile
the sources on windows 2008 using the MS Visual C and run the
vcregress.bat check
without any problems or failures. In an attempt to run the tap
On 03/07/2017 01:22 AM, Johann Spies wrote:
Thanks (again Adrian) and Tom.
The situation was that I had a table with 731million records which I
wanted to copy into a partitioned one where there was a unique
constraint on the fields used in my query.
The "backup" table was the single one.
While
Greetings,
* Stephen Frost (sfr...@snowman.net) wrote:
> * Frank van Vugt (ftm.van.v...@foxi.nl) wrote:
> > Well, I didn't run into this issue with any of my db's that 'nicely' use
> > tables in various schema's, it was actually the one 'older' db with
> > everything
> > in the public schema th
On Tue, Mar 7, 2017 at 2:02 AM, Panagiotis Atmatzidis
wrote:
> I want to make a clone of database1 which belongs to user1, to database2
> which belongs to user2. Database1 has 20+ tables. I want to avoid copying
> the DATA sitting on 5 tables on database1 (many Gigs).
>
> I've read one too many p
Thanks (again Adrian) and Tom.
The situation was that I had a table with 731million records which I wanted
to copy into a partitioned one where there was a unique constraint on the
fields used in my query.
The "backup" table was the single one.
While inserting into the partitioned table from the
On 07/03/2017 09:02, Panagiotis Atmatzidis wrote:
Hello,
I have 2 RDS instances on AWS running PSQL 9.4.7.
I want to make a clone of database1 which belongs to user1, to database2 which
belongs to user2. Database1 has 20+ tables. I want to avoid copying the DATA
sitting on 5 tables on databas
27 matches
Mail list logo
