Description:
General Discussions about PostgreSQL
|
|
|
Index question on postgres
|
| |
Hi All - I have query in production and test. The tables in both the environment has the same structure ,indexes and constraints. But the in the test and the prod the explain plan is totally different. In test environment the query is taking long time and noticed that indexes are not being... more »
|
|
|
create table if does not exists
|
| |
...The table will be named "mytable" rather than 'MYTABLE'. Postgres lowercases names (tables, fields etc) unless you put them in quotes ("LikeThis") - but then you always have to quote them like that. If you change your check to be where table_name='mytable' it should get picked up correctly.
|
|
|
PG Index
|
| |
Hi All - Is there way to the list of indexes created for all the tables in postgres? can you please help Regards Venkat
|
|
|
After a crash all my tables got wiped, but still using disk space.
|
| |
Hello all, im having a problem with a crashed database and im looking for help to try recover any data from my last backup. Thats the situation, i found this error on postgresql logs 15 days ago: invalid memory alloc request size 4294967295 Then, 10 minutes later i got on my logs: ...server process terminated by signal 11... more »
|
|
|
please help
|
| |
dear sir could you please help ? I have postgres installed in mac and want to connect it from window XP, I get error, can you please help what is needed to get connected to mac server postgres ? Server [localhost]: 10.1.1.9 Database [postgres]: viewods Port [5432]: 5433 Username [postgres]: sho psql: FATAL: no pg_hba.conf entry for host "10.1.1.86", user "sho", database "v... more »
|
|
|
Writable CTE queries
|
| |
Are Writable CTE queries defined by the SQL standard, or are they and extension?
|
|
|
Ideas and critics are welcome
|
| |
Hi all. I've put together the ideas I used to solve a problem of mine with table partitioning. A small article (no code yet) is here: [link] And I'd like to get some feedback from you. Many thanks in advance.
|
|
|
pg.dropped
|
| |
Hi all, I have a deja vu or I had this very problem before. Now I use 8.4.2 and it happened again. After dropping a column from table, there is still entry in pg_attribute filip@la_dev=# select * from pg_attribute where attrelid = (select oid from pg_class where relname='thetable') order by attnum desc limit 1;... more »
|
|
|
Pro*C versus {ecpg and PostgreSQL}
|
| |
Dear list, I am migrating an Oracle database to PostgreSQL and the last step I must perform is to convert several Pro*C programs into PostgreSQL embedded SQL. I work on AIX 5.3 TL9 64-bits, on which I have built PostgreSQL 8.3.8 in 64-bits too. I am a newbie in Embedded SQL and I am facing several problems / questions.... more »
|
|
|
|
