Hello all,
18.05.2016 20:09, Ненашев Илья Николаевич wrote:
I has wasted a lot of time today has trying to find my autogenerated
indexes for primary keys, which are not shown in PGAdmin III browser
tree, until write and execute
SELECT * FROM pg_indexes i WHERE i.tablename = ;
end have seen a
I has wasted a lot of time today has trying to find my autogenerated
indexes for primary keys, which are not shown in PGAdmin III browser
tree, until write and execute
SELECT * FROM pg_indexes i WHERE i.tablename = ;
end have seen a real state of things.
I expect from database admin tool to dis
Andreas Pflug wrote:
> We deliberately do *not* support anything that psql does. psql bears a
> lot of ancient stuff, since it has developed from very early pgsql
> versions. psql works one level below pgAdmin3, showing all the raw stuff
> regardless whether it's useful nowadays or not, e.g. const
In phpPgAdmin, we list them separately as well, however it did require
some thinking. In the end I decided to display things in the way the
SQL spec lays them out. All constraints together, etc.
And do you display indexes which are automatically generated by PRIMARY
KEY constraint?
No. The ind
Christopher Kings-Lynne wrote:
>> I can't completely agree with you. I use only PostgreSQL, but I used to
>> help my colleague working with Oracle (he was a novice), and I looked at
>> his result of EXPLAIN (it was different from what PostgreSQL gives, but
>> quite clear). I am not sure that in eve
I can't completely agree with you. I use only PostgreSQL, but I used to
help my colleague working with Oracle (he was a novice), and I looked at
his result of EXPLAIN (it was different from what PostgreSQL gives, but
quite clear). I am not sure that in every database engine PRIMARY KEY
constraint i
> -Original Message-
> From: Constantin Stefanov [mailto:[EMAIL PROTECTED]
> Sent: 11 February 2004 09:52
> To: Andreas Pflug
> Cc: Dave Page; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Indexes generated for primary
> key are not show
>
> Andreas Pf
Andreas Pflug wrote:
> Well it's not really hard, just some things to think of. And the longer
> I think about it, and looking at your example, I'd say people analyzing
> a query should know a little what pgsql is doing, e.g. that unique and
> primary constraints include an index. Thus I tend to s
Constantin Stefanov wrote:
I do not suggest PgAdmin to become 'psql with GUI'. They are different
applications. But in some questionable issues I would suggest to use
psql as a reference, because it constains almost everything that is
needed for everyday work.
In case I explained PgAdmin does not
Constantin Stefanov wrote:
As for quick solution I would suggest checking with psql - if it can
shows something, then PgAdmin should have an option to show it. I think
many people use psql and it has almost all features needed for working
with PostgreSQL (but it is less convenient than PgAdmin). A
> -Original Message-
> From: Constantin Stefanov [mailto:[EMAIL PROTECTED]
> Sent: 09 February 2004 12:54
> To: Dave Page
> Cc: Andreas Pflug; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Indexes generated for primary
> key are not show
>
> I think
Dave Page wrote:
> The primary question remains though, why should we expose implementation
> details of something like a primary key when we already show the primary
> key itself? It's not like you cannot see the columns in it or anything.
> Should we by the same argument show the triggers that i
> -Original Message-
> From: Constantin Stefanov [mailto:[EMAIL PROTECTED]
> Sent: 09 February 2004 10:25
> To: Dave Page
> Cc: Andreas Pflug; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Indexes generated for primary
> key are not show
>
> Wel
Dave Page wrote:
>>Why should such duplication be avoided? There is both
>>constraint (primary key) and index.
>
> Because if any generated SQL contains both object, it will be an invalid
> script, not to mention the fact that you cannot properly recreate
> constraints just by recreating the in
> -Original Message-
> From: Constantin Stefanov [mailto:[EMAIL PROTECTED]
> Sent: 09 February 2004 09:03
> To: Andreas Pflug
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Indexes generated for primary
> key are not show
>
> Why should such dupli
Andreas Pflug wrote:
>> I have PgAdmin III 1.0.2 and PostgreSQL 7.4.1.
>> When I create a table with primary key constraint on it, PostgreSQL
>> automatically creates an index on that column (or columns), which is
>> then shown in psql with \di command.
>> But PgAdmin does not show that index in
>>
Constantin Stefanov wrote:
Hello.
I have PgAdmin III 1.0.2 and PostgreSQL 7.4.1.
When I create a table with primary key constraint on it, PostgreSQL
automatically creates an index on that column (or columns), which is
then shown in psql with \di command.
But PgAdmin does not show that index in
..
17 matches
Mail list logo
