Anton Andreev wrote:
> When I create a check constraint in PgAdmin3 1.8.4 on a Postgresql
> 8.3.3: ((A and B) or (C and D))
> I get with create script: (A and B or C and D) which is wrong.
No, it isn't - both are the same.
AND has higher operator precedence than OR, see
http://www.postgresql.org
Dear list,
we are considering to use pgAdmin for job scheduling.
When you configure an SQL job step, you can configure a database
on which the script should run, but you cannot specify a database user.
We'd like to define schedules for various database users, and
while it would be possible to wo
bhanu udaya wrote:
>>> What is the best way of doing case insensitive searches in postgres using
>>> Like.
>>
>> Table "laurenz.t"
>> Column | Type | Modifiers
>> +-+---
>> id | integer | not null
>> val | text | not null
>> Indexes:
>> "t_pkey" PRIMARY KEY, btree (id)
>>
>
John R Pierce wrote:
> if the postgresql server was running when that file backup was made(*),
> its pretty much worthless, it will have data corruption and errors
> throughout.
Well, it would be better than nothing.
You can pg_resetxlog and manually clean up the inconsistencies.
That's better tha
If you try to connect to a database while REFRESH MATERIALIZE VIEW for a
materialized view in the database is in progress, the interface will
"hang" (the window remains blank and does not react to the mouse).
This is probably caused by the ACCESS EXCLUSIVE locks that are held
during REFRESH MATERI
I wrote:
> If you try to connect to a database while REFRESH MATERIALIZE VIEW for a
> materialized view in the database is in progress, the interface will
> "hang" (the window remains blank and does not react to the mouse).
>
> This is probably caused by the ACCESS EXCLUSIVE locks that are held
>
I am running pgAdmin 4 1.0-beta1 on Windows 7.
This is the foreign table as displayed with psql:
test=> \d typetest1
Foreign table "laurenz.typetest1"
Column | Type | Modifiers | FDW Options
+--+---+-
id |
I am using pgAdmin 4 1.0-beta1 (downloaded from pgadmin.org) on Windows 7.
When I try to SELECT a bytea column, like in the following:
SELECT decode('mama', 'escape');
I get a message like this:
500 Internal Server Error
Internal Server Error
The server encountered an internal error and was
I am using pgAdmin 4 1.0-beta1 (downloaded from pgadmin.org) on Windows 7.
I get an error message like this:
500 Internal Server Error
Internal Server Error
The server encountered an internal error and was unable to complete your
request. Either the server is overloaded or there is an error in
Dave Page wrote:
> Please log any additional issues directly at
> https://redmine.postgresql.org/projects/pgadmin4/issues/new to save me
> a step :-)
Gladly.
Wouldn't it be good to mention https://redmine.postgresql.org/projects/pgadmin4/
on https://www.pgadmin.org/support/ ?
Yours,
Laurenz Albe
10 matches
Mail list logo
