Hi Team,
Can you please help me to understand the PostgreSQL installer’s debug log.
I am installing PostgreSQL in CentOS 7.6 system with PostgreSQL binary (
postgresql-9.6.6-1-linux-x64.run). I am using the below command to install
it in unattended mode.
./postgresql-9.6.6-1-linux-x64.run --i
Hello,
We operate a PostgreSQL 8.4.22 database on RHEL 6.10. Over the years,
we've attempted to intelligently distribute tables and indexes across
multiple tablespaces. After introducing a new tablespace, we attempted to
inventory which tables and indexes were on which tablespaces only to find
t
On 8/8/19 11:35 AM, Bryn Llewellyn wrote:
Please try the following.
Stop PostgreSQL with this:
pg_ctl -D /usr/local/var/postgres stop
Edit the file "/usr/local/var/postgres/postgresql.conf” and add these
lines at the end:
log_statement = 'all'
log_directory = 'log'
logging_collector = on
T
Hi,
After many years of using Oracle Forms and Oracle Reports with Oracle
DB, I have been using Lazarus and "Code Typhon"
for many years now.
Both work with Free Pascal Compiler and both are open source and free.
Both have a very good IDE, the code produced is Pascal (very easily
readable), and
All,
No Web driven, but . . . . we’ve had some success with using LibreOffice(calc)
as a frontend. Fairly easy to build forms, etc. Only limited experience so
far, but was able to build domain lists from SQL calls, for form pulldown
lists, etc.
bobb
> On Aug 8, 2019, at 2:10 PM, Rich Shep
On Thu, 8 Aug 2019, Tim Clarke wrote:
We tried Django without any pleasant results.
Tim,
That's unexpected and too bad.
I'd also caution using MS Access, we're desperate to get away from it.
Sharing code has challenges and it is horribly aggressive with caching
unless you use un-bound forms
Please try the following.Stop PostgreSQL with this:pg_ctl -D /usr/local/var/postgres stopEdit the file "/usr/local/var/postgres/postgresql.conf” and add these lines at the end:log_statement = 'all'log_directory = 'log'logging_collector = onThen start PostgreSQL with this:pg_ctl -D /usr/local/var/p
On Thu, Aug 8, 2019 at 1:30 PM Tim Clarke wrote:
> On 08/08/2019 17:55, Stuart McGraw wrote:
> >
> > I would be a little cautious about Django. Last time I checked,
> > like many other web frameworks, it treats the database as just another
> > component, one that provides data persistence for it
On 08/08/2019 17:55, Stuart McGraw wrote:
>
> I would be a little cautious about Django. Last time I checked,
> like many other web frameworks, it treats the database as just another
> component, one that provides data persistence for it, and consequently
> imposes its own constraints the schemas
On Thu, 8 Aug 2019, Adrian Klaver wrote:
Unfortunately it does not:
https://code.djangoproject.com/wiki/MultipleColumnPrimaryKeys
Given that the issue:
https://code.djangoproject.com/ticket/373
is 14 years old does not inspire confidence that it will change anytime soon.
Adrian,
That's reall
On 8/8/19 10:34 AM, Rich Shepard wrote:
On Thu, 8 Aug 2019, Stuart McGraw wrote:
I would be a little cautious about Django.
Specifically IIRC it insists that tables have a single-column primary
keys.
Stuart,
I looked seriously at Django and did not encounter that limitation.
However,
I
On Thu, 8 Aug 2019, Stuart McGraw wrote:
I would be a little cautious about Django.
Specifically IIRC it insists that tables have a single-column primary
keys.
Stuart,
I looked seriously at Django and did not encounter that limitation. However,
I did learn that I'm not a web application de
On 8/8/19 9:55 AM, Stuart McGraw wrote:
On 8/7/19 2:38 PM, Rich Shepard wrote:
On Wed, 7 Aug 2019, Igor Korot wrote:
On top of what already been said - make sure that the product you are
about to start working on will have its requirements clear and concise.
This is a critical process that n
On 8/7/19 2:38 PM, Rich Shepard wrote:
On Wed, 7 Aug 2019, Igor Korot wrote:
On top of what already been said - make sure that the product you are
about to start working on will have its requirements clear and concise.
This is a critical process that needs to be developed in depth. One
criter
On Wed, 7 Aug 2019 at 20:57, stan wrote:
> I am in the process of defining an application for a very small company
> that uses Postgresql for the backend DB. This DB will eventually run on a
> hosted machine. As you imagine all of the employees have Windows machines
> for their normal work asks.
Tom Lane schrieb am 08.08.2019 um 16:10:
> David's point is that the two occurrences of lead() don't mean the
> same thing. A window function is directly tied to the SELECT that
> it is in the select-list of, and its notion of next and previous
> rows is concerned with the set of rows that that SE
Thomas Kellerer writes:
> David Rowley schrieb am 08.08.2019 um 13:03:
>> I think you're confused with what the SELECT with the empty FROM
>> clause does here. In your subquery "id_list" is just a parameter from
>> the outer query. LEAD(id_list) OVER (ORDER BY id) is never going to
>> return anyt
Bryn Llewellyn wrote:
> B.t.w., I’m guessing that the “begin” SQL command that you see in the log
> that I mentioned is actually issued by (some) clients—at least psql and
> Python-on-psycopg2—as an explicit call from the client. In other words, it
> isn’t the server that generates this. D
David Rowley schrieb am 08.08.2019 um 13:03:
>> The following statement tries to find the overlapping values in id_list
>> between the current row and the next row:
>>
>> select id,
>>id_list,
>>lead(id_list) over (order by id) as next_list,
>>array(select u
On Thu, 8 Aug 2019 at 21:06, Thomas Kellerer wrote:
> The following statement tries to find the overlapping values in id_list
> between the current row and the next row:
>
> select id,
>id_list,
>lead(id_list) over (order by id) as next_list,
>array(select
Luca:
On Thu, Aug 8, 2019 at 12:33 PM Luca Ferrari wrote:
> On Thu, Aug 8, 2019 at 11:20 AM nikhil raj wrote:
> > Same when i run this in linux machine i am getting this out in different
> > sort order on the same query.
> A collation problem?
> What does this query do?
> SELECT *
> FROM (VALU
Nikhil ( or is it Raj? ):
On Thu, Aug 8, 2019 at 11:47 AM nikhil raj wrote:
> Here are the detailes.
> Windows :
Zapped image showing windows locale "English-united-states.1252"
> linux :
Zapped image showing Linux locale "En-us.utf-8"
> both are in same version 11.3
> How can i get the sorting o
On Thu, Aug 8, 2019 at 11:20 AM nikhil raj wrote:
> Same when i run this in linux machine i am getting this out in different
> sort order on the same query.
A collation problem?
What does this query do?
SELECT *
FROM (VALUES ('a'), ('___b1'), ('_a1'),('a2'),('a3'),('a5'), ('a2')) t
(val) order
Hi ALL,
I have recently migrated to windows postgres server to linux postgres
server.
while i run this query in windows PG server
SELECT *
FROM (VALUES ('a'), ('___b1'), ('_a1'),('a2'),('a3'),('a5'), ('a2')) t
(val) order by val
I am getting the out put in this sort order
[image: 10.250.200.184
All excellent solutions, may I add Lucee to the list. We call it "the
best web development system no-one knows about".
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 07/08/2019 21:38, Rich Shepard wrote:
> On Wed, 7 Aug 2019, Igor Korot wrote:
>
>> On top of wh
Consider the following dummy table (this is a simplified example from a bigger
query):
create table sample_data (id int, id_list int[]);
insert into sample_data (id, id_list)
values
(1, array[1,2,3]),
(2, array[2,3,4]),
(3, array[4,5,6]);
The following statement
On Wed, Aug 7, 2019 at 11:36 PM Benedict Holland
wrote:
>
> Also, I have never seen a rollback at the start of a proc. A pure
> hypothetical is that it is doing nothing or definitely not what you think it
> is.
That's my point, thanks.
Luca
27 matches
Mail list logo
