|
Mailing List Archive For pgsql-general@postgresql.org Feb 2008 By Subject- [GENERAL]
- [GENERAL] "advanced" database design (long)
- [GENERAL] "pg_ctl: cannot be run as root"
- [GENERAL] "RETURN QUERY" mystery
- [GENERAL] .Net Development Issues
- [GENERAL] 8.2/8.3 incompatibility
- [GENERAL] 8.3 and uuid: unable to run uuid-ossp.sql
- [GENERAL] 8.3 Feature List mentions Slony 2.0
- [GENERAL] 8.3.-build fails due parse error in VERSION script
- [GENERAL] 8.3: where's the replacement tsearch2 module?
- [GENERAL] [Church group] Chinese New Year Celebration Dinner this Friday (02/08/2008)
- [GENERAL] [HACKERS] Reverse key index
- [GENERAL] [OT] "advanced" database design (long)
- [GENERAL] [pgsql-advocacy] PostgreSQL Certification
- [GENERAL] [pgsql-advocacy] PostgreSQL Certification -- wind it up, please.
- [GENERAL] [pgsql-advocacy] PostgreSQL professionals group at LinkedIn.com
- [GENERAL] [pgsql-www] greylisting no longer working?
- [GENERAL] [Pljava-dev] pljava.dll - bogus error
- [GENERAL] A couple PostgreSQL 8.3 related Fulltext-Search questions
- [GENERAL] a newbie question on table design
- [GENERAL] Alter Domain Type
- [GENERAL] Alter Temporary table in Stored Procedure
- [GENERAL] Alternative to tableoids?
- [GENERAL] Analogue to SQL Server UniqueIdentifier?
- [GENERAL] Approaches for Lookup values (codes) in OLTP application
- [GENERAL] Are indexes blown?
- [GENERAL] arrays of floating point numbers / linear algebra operations into the DB
- [GENERAL] Auto incrementing primary keys
- [GENERAL] Automatic partitioning,
- [GENERAL] backup tableoids (pg_class.oid) ?
- [GENERAL] catalog info for sequences
- [GENERAL] Change column type to numeric
- [GENERAL] character conversion problem about UTF-8-->SHIFT_JIS_2004
- [GENERAL] commit fails, rollback needed?
- [GENERAL] Complex query optimization
- [GENERAL] composite type vs table
- [GENERAL] Conditional ordering operators
- [GENERAL] Constraint name for named NOT NULL constraints is ignored
- [GENERAL] Constraint violations don't report the value that violates
- [GENERAL] Continual uptime while loading data ... COPY vs INSERTS within a transaction.
- [GENERAL] copy question - fixed width?
- [GENERAL] cursor vs. for _row in select...
- [GENERAL] DB design: How to store object properties?
- [GENERAL] DBA Book - Not "postgresql book - practical or something newer?"
- [GENERAL] DBD::Pg 2.0.0 released
- [GENERAL] deadlock while re-indexing table
- [GENERAL] deadlock with truncate and foreing keys
- [GENERAL] Deferred constraints and locks...
- [GENERAL] Different host aliases in SLONY configuration table
- [GENERAL] Does has_table_privilege() have a case bug
- [GENERAL] Dump schema without the functions
- [GENERAL] dynamic crosstab
- [GENERAL] Empty to NULL conversion - Ruby - Postgres ?
- [GENERAL] encoding does not match server's locale
- [GENERAL] end of life for pg versions...
- [GENERAL] Error in PlPython procedure
- [GENERAL] ERROR: COPY quote must be a single ASCII character
- [GENERAL] ERROR: expected just one rule action
- [GENERAL] ERROR: relation with OID 1322527 does not exist
- [GENERAL] Execute
- [GENERAL] failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6
- [GENERAL] Feedback on PLJava
- [GENERAL] first message: SELECT <column> FROM <t
- [GENERAL] Forgot to dump old data before re-installing machine [solved]
- [GENERAL] Fossology Install & Config Issues...
- [GENERAL] free ETL tool using postgreSQL, new major release
- [GENERAL] fsync=off & shutdown => crash?
- [GENERAL] full text index and most frequently used words
- [GENERAL] Full text search and count
- [GENERAL] function or temporary table or what?
- [GENERAL] Function returning subset of columns from table (return type)
- [GENERAL] Fwd: Question about the enum type
- [GENERAL] Good F/OSS license summary
- [GENERAL] greylisting no longer working?
- [GENERAL] help optimizing query
- [GENERAL] How can exe files such as 'pg_dump' be called from stored functions?
- [GENERAL] how to add array of objects to a record
- [GENERAL] How to cope with low disk space
- [GENERAL] how to list column names.
- [GENERAL] How to make update rapidly?
- [GENERAL] How to return a large String with C
- [GENERAL] How to return a large String with C (solved)
- [GENERAL] How to track query execution time
- [GENERAL] How to view temp tables
- [GENERAL] hyperthreading and pqlib
- [GENERAL] I can't restart postgres
- [GENERAL] INDIANNIC : POSTGRES WINDOWS INSTALLATION
- [GENERAL] Initdb failed in PostgreSQL 7.3.21
- [GENERAL] initdb problem with Windows Installer for PostgreSQL 8.2.4
- [GENERAL] Install problem w/8.3 on windows 2000 : application failed to initialize properly (0xc0000022)
- [GENERAL] installation problem
- [GENERAL] installing in another directory
- [GENERAL] is a unique key on null field bad?
- [GENERAL] Is my db dead ?
- [GENERAL] Is news.postgresql.org down?
- [GENERAL] Is PG a moving target?
- [GENERAL] Is PostGreSql's Data storage mechanism "inferior"?
- [GENERAL] Issue with Centos 5, Postgres 8.3 (RHEL5 build), timezones
- [GENERAL] JDBC and Postgresql 8.0 - cpu usage question
- [GENERAL] Kernel kills postgres process - help need
- [GENERAL] Language Code to Language name conversion for use in pg_ts_config?
- [GENERAL] lazy validation on complex criterion
- [GENERAL] Lets get the 8.3 Announcement on the front page of Digg
- [GENERAL] loading files into tables
- [GENERAL] Lockless pg_buffercache
- [GENERAL] Log query statistics
- [GENERAL] longest prefix match
- [GENERAL] Mac ordering with locales
- [GENERAL] Maximum realistic number of database user accounts?
- [GENERAL] Mechanics of Select
- [GENERAL] Metadata/ODBC query
- [GENERAL] Migration of /data from 32bit to 8.2 64bit
- [GENERAL] MS library files
- [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP
- [GENERAL] mutli row/table constraints
- [GENERAL] need help optimizing query
- [GENERAL] Need help with decoding of sql array from WAL files version 7.4.17
- [GENERAL] nntp interface not working?
- [GENERAL] No pgxs.mk with win32 binaries
- [GENERAL] offline*
- [GENERAL] oids
- [GENERAL] Oracle Analytical Functions
- [GENERAL] Order of SUBSTR and UPPER in statement
- [GENERAL] Out of Memory errors while running pg_dump
- [GENERAL] out-of-line (TOAST) storage ineffective when loading from dump?
- [GENERAL] Pains in upgrading to 8.3
- [GENERAL] partitioning and postgres,
- [GENERAL] password option in pg_dumpall
- [GENERAL] Perceived weaknesses of postgres
- [GENERAL] performance issues on windows with 8.3.0?
- [GENERAL] Performance problems with Postgresql/ZFS/Non-global zones on Solaris?
- [GENERAL] PG quitting sporadically!!
- [GENERAL] pg_dump, pg_restore.
- [GENERAL] pg_restore fails for postgis data dump
- [GENERAL] pg_restore seems slow
- [GENERAL] pg_restore, search_path and operator class
- [GENERAL] pg_stat_activity xact_start and autovacuum
- [GENERAL] pgplsql and arrays
- [GENERAL] PGSQL ERROR: FATAL: terminating connection due to administrator command
- [GENERAL] pl/java tutorials
- [GENERAL] PL/PGSql function within a view definition
- [GENERAL] POLL: Women-sized t-shirts for PostgreSQL
- [GENERAL] Possible tiny issue with pg_dump.exe on windows
- [GENERAL] Postgres with daemontools or similar
- [GENERAL] PostgreSQL 8.3 on Debian, Ubuntu
- [GENERAL] PostgreSQL 8.3 XML parser seems not to recognize the DOCTYPE element in XML files
- [GENERAL] PostgreSQL 8.3.0 RPMs are available for download
- [GENERAL] postgresql book - practical or something newer?
- [GENERAL] PostgreSQL Certification
- [GENERAL] PostgreSQL Conference East: Talks announced
- [GENERAL] PostgreSQL does not support updateable cursors
- [GENERAL] PostgreSQL on a CompactFlash
- [GENERAL] postgresql-8.3.0-1-binaries-no-installer: gssapi32.dll missed ?
- [GENERAL] PostgreSQL/PHP Application Server
- [GENERAL] PostgreSQLDirect versus Npgsql
- [GENERAL] Problem in using C API - libpq
- [GENERAL] problem with ORDER BY
- [GENERAL] Query output into a space delimited/location sensitive file
- [GENERAL] Query using cursors using 100% CPU
- [GENERAL] Querying the schema for column widths - what syntax do I use?
- [GENERAL] Question about CLUSTER
- [GENERAL] question about PANIC: hash table "Shared Buffer Lookup Table" corrupted
- [GENERAL] Question about the enum type
- [GENERAL] Question for Postgres 8.3
- [GENERAL] questions about very large table and partitioning
- [GENERAL] Regex query not using index
- [GENERAL] REINDEX on large DB vs. DROP INDEX/CREATE INDEX
- [GENERAL] Reload only specific databases from pg_dumpall
- [GENERAL] Renaming a constraint
- [GENERAL] Request for help with database of Kenyan election violence
- [GENERAL] returning a resultset from a function
- [GENERAL] Returning large bytea chunk
- [GENERAL] Reverse key index
- [GENERAL] SELECT CAST(123 AS char) -> 1
- [GENERAL] select...into non-temp table raises 'duplicate key ... pg_type_typname_nsp_index'
- [GENERAL] selective backup and restore
- [GENERAL] Set server behaviors on a per-session basis?
- [GENERAL] shared buffer hash table corrupted
- [GENERAL] show time consumed by query in psql
- [GENERAL] Simplest syntax (or a UI?) to rename columns and sequences and constraints (etc)?
- [GENERAL] Some Autovacuum Questions
- [GENERAL] SPI-functions and transaction control
- [GENERAL] SPI_ERROR_CONNECT
- [GENERAL] standby questions
- [GENERAL] Storing images as BYTEA or large objects
- [GENERAL] Strict-typing benefits/costs
- [GENERAL] Subquery Factoring ?
- [GENERAL] Suggestions for schema design?
- [GENERAL] Suncoast Postgres User Group
- [GENERAL] temp sequence
- [GENERAL] temp table in 8.3
- [GENERAL] temp table question
- [GENERAL] Test text value as interval
- [GENERAL] the feasibility of sending email from stored procedure in Postgres
- [GENERAL] Timestamp indexes (why ">" or "between" does not use index?)
- [GENERAL] Trigram performance penalty on varchar?
- [GENERAL] Trouble with Mixed UTF-8 and Latin1 data
- [GENERAL] Trying to understand encoding.
- [GENERAL] ts_headline
- [GENERAL] TSearch2 Migration Guide from 8.2 to 8.3
- [GENERAL] tsearch2 text::TSVECTOR cast not working for me on Pg 8.1.6
- [GENERAL] type casting in 8.3
- [GENERAL] uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"
- [GENERAL] Universal libpq.a ?
|