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 »
Active older topics
7 new of 7 - Nov 24
16 new of 16 - Nov 24
5 new of 5 - Nov 24
7 new of 7 - Nov 24
3 new of 3 - Nov 23
15 new of 15 - Nov 23
5 new of 5 - Nov 23
1 new of 1 - Nov 23
3 new of 3 - Nov 23
4 new of 4 - Nov 23
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 17612  Older »
Description: General Discussions about PostgreSQL
 

Client Encoding and Latin characters 
  My database is encoded UTF8. I recently was uploading (via COPY) some census data which included place names with ñ, é, ü, and other such characters. The upload choked on the Latin characters. Following the docs, I was able to fix this with: SET CLIENT_ENCODING TO 'LATIN1'; COPY table FROM 'filename';... more »
By Lee Hachadoorian  - 11:39am - 3 new of 3 messages    

[BUGS] BUG #5211: invalid password 
  ...This is not a bug, so I'm redirecting to the pgsql-general list, where it belongs. :) Change your pg_hba.conf to allow "trust" auth from localhost, restart the server, use the ALTER USER command to change the password to something else, change pg_hba.conf back, then restart the server again. Cheers,... more »
By David Fetter  - 7:48am - 1 new of 1 message    

Partitioning table and dynamic SQL in trigger 
  In our DB we create partition table for each month (our naming convetion is follow , and I would like to create trigger that insert data to appropriate partition table accounting.cdr_y2009m05, accounting.cdr_y2009m06 etc..). What is the best solution to create such trigger? I can create trigger function as follow:... more »
By Michal Szymanski  - 7:22am - 1 new of 1 message    

[COMMITTERS] recover deleted records 
  Hello Have you enabled autovacuum? Pavel p.s. please, don't use pgsql-commiters mailing list for general questions. use pgsql-general. 2009/11/24 Allan Morris Caras <amsca...@yahoo.com>:
By Pavel Stehule  - 5:14am - 3 new of 3 messages    

無料サイトが会えない理由。それは・・・ 
  会┃え┃る┃無┃料┃サ┃イ┃ト┃は┃ ━┛━┛━┛━┛━┛━┛━┛━┛━┛ コ┃コ┃が┃違┃う┃!┃ ━┛━┛━┛━┛━┛━┛ 全国には多数の無料サイトが御座います。 会えた事が御座いますか? 連絡先、携帯番号や直アドレスの交換... more »
By shenghu...@126.com  - 3:32am - 1 new of 1 message    

How identify a long running transaction 
  Using 8.4.1. How can I 1) Get the transaction id of the oldest serializable transaction and the next transaction? 2) A list of all active transactions I have searched the docs and tried Google but I must not be using the right terminology. Also, am I correct in assuming that vacuuming is not blocked by a long... more »
By Bill Todd  - Nov 23 - 1 new of 1 message    

Multicolumn index including tsvector. 
  Hi everyone, In the documentation and past messages to this list, it sounds like the btree_gist and btree_gin modules included in contrib/ in 8.4 should give me the functionality I'm looking for, but I don't seem to be getting the behavior I want. I've made an example table representing something like a simplified version... more »
By Kris Gale  - Nov 23 - 4 new of 4 messages    

get a log of queries that take up a lot of CPU or take a very long time. 
  Is there a way I can get a list of the top 10 longest running queries for the day/week/month or the top 10 queries that took the most CPU? select * from pg_stat_activity only shows the current status.
By Tim Uckun  - Nov 23 - 2 new of 2 messages    

I need help creating a composite type with some sort of constraints. 
  I can create one or more domains, and use those to create the composite type from. But each domain can only be constrained in its own value, I can't constrain element #1's value based on what element ...If I create a domain from a composite, it will complain with a "ERROR: cdt.instant_message is not a valid base type for a domain" error.... more »
By John Oyler  - Nov 23 - 2 new of 2 messages    

C++ and Postgis 
  Hi All, First off sorry for cross-posting. I'm hoping for a bigger audience... :] As for my question: How does one deal with Postgis geom fields in C++ ? Google hasn't offered much help so far. I know I can make a "SELECT astext(my_geom) FROM my_table" and after parsing the resulting text. This seems a bit awkward and time-consuming...... more »
By Pedro Doria Meunier  - Nov 23 - 3 new of 3 messages    

1 - 10 of 17612   « Newer | Older »

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