Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
pgsql . general
This is a Usenet group - learn more
Find or start a Google Group about general.
Group info
Language: English
Group categories: Not categorized
More group info »
Related Groups
SQL and How to Write or Improve Queries in PostgreSQL
Low activity, Usenet
PostgreSQL from an Administrative Perspective
Low activity, Usenet
How to Speed up SQL Queries and the PostgreSQL Server
Low activity, Usenet
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 17980  Older »
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 »
By akp geek  - Jan 7 - 7 new of 7 messages    

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.
By Chris  - Jan 7 - 1 new of 1 message    

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
By akp geek  - Jan 7 - 1 new of 1 message    

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 »
By Samuel Abreu de Paula  - Jan 7 - 2 new of 2 messages    

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 »
By Shu Ho  - Jan 7 - 2 new of 2 messages    

Writable CTE queries 
  Are Writable CTE queries defined by the SQL standard, or are they and extension?
By Richard Broersma  - Jan 7 - 3 new of 3 messages    

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.
By Vincenzo Romano  - Jan 7 - 1 new of 1 message    

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 »
By Filip Rembiałkowski  - Jan 7 - 3 new of 3 messages    

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 »
By Alexandra Roy  - Jan 7 - 1 new of 1 message    

Use C++ to iterate integer array returned from stored procedure 
  ...not exactly. however you do have the libpqtypes library which extends libpq to deal with arrays: [link] note, libpqtypes requires postgres 8.4 (or 8.3 with patched libpq). PGarray arr; int ntups; res = PQexecf(conn, "SELECT * FROM get_array_test()"); PQgetf(res, 0, "%int4[]", 0, &arr);... more »
By Merlin Moncure  - Jan 7 - 3 new of 3 messages    

1 - 10 of 17980   « Newer | Older »

XML      
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2010 Google