|
Mailing List Archive For pgsql-general@postgresql.org Oct 2007 By Subject- [GENERAL]
- [GENERAL] "Concatenate" two queries - how?
- [GENERAL] "timer" script from SAMS book or equivalent?
- [GENERAL] (Never?) Kill Postmaster?
- [GENERAL] 2 versions running & using pg_dumpall
- [GENERAL] 3 tables join update
- [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit
- [GENERAL] 8.2.4 selects make applications wait indefinitely
- [GENERAL] 8.2.5 -> 8.3 beta tsearch2 help
- [GENERAL] 8.3 beta problems
- [GENERAL] 8.3b1 in production?
- [GENERAL] <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected
- [GENERAL] [ANN]VTD-XML 2.2
- [GENERAL] [HACKERS] CVS and Eclipse
- [GENERAL] [OT] xkcd - A webcomic of romance, sarcasm, math, and language
- [GENERAL] [PGSQL v8.2.5] Similar queries behave differently
- [GENERAL] a failover scenario
- [GENERAL] A few questions
- [GENERAL] Abbreviation list
- [GENERAL] active connections
- [GENERAL] Aggregate View and Conditions taking FOREVER
- [GENERAL] alter database tablespace
- [GENERAL] ALTER TRIGGER Before / After?
- [GENERAL] Am I overseen ?
- [GENERAL] Architecture diagram!
- [GENERAL] Array intersection
- [GENERAL] atomic commit;begin for long running transactions , in combination with savepoint.
- [GENERAL] Auto-partitioning?
- [GENERAL] Automatic schema updates
- [GENERAL] Automating Backup & Restor
- [GENERAL] Automating Backup & Restore
- [GENERAL] autovacuum and locks
- [GENERAL] AutoVacuum Behaviour Question
- [GENERAL] Backup single database roles and ACLs
- [GENERAL] Base Backups from PITR Standby
- [GENERAL] Bitmap Heap scan 8.1/8.2
- [GENERAL] Calculation of per Capita on-the-fly - problems with SQL syntax
- [GENERAL] can I define own variables?
- [GENERAL] can someone please tell me how to unsubscribe from this group - thanks
- [GENERAL] Can't access Cluster
- [GENERAL] can't compile Pl/Java
- [GENERAL] cases in rules problem
- [GENERAL] change format of logging statements?
- [GENERAL] CHAR SETS
- [GENERAL] Checking empty array
- [GENERAL] Coercing compound types to use generic ROW comparison operators
- [GENERAL] Collation sequence and use of operatings system's locale
- [GENERAL] command to view the tables
- [GENERAL] conditional alter table add ?
- [GENERAL] configure password
- [GENERAL] Connection & logging Problems
- [GENERAL] Constraints involving a system table
- [GENERAL] contrib / fuzzystr documentation
- [GENERAL] convert binary string to datum
- [GENERAL] Convert bytea to Float8
- [GENERAL] COPY for .CSV files problem
- [GENERAL] corrupt database?
- [GENERAL] Create artificial key without temp sequence
- [GENERAL] create visual query in web applications
- [GENERAL] createdb argument question
- [GENERAL] Crosstab Problems
- [GENERAL] current_user changes immediately after login
- [GENERAL] CVS and Eclipse
- [GENERAL] CVS Commands
- [GENERAL] Data cube in PostgreSQL
- [GENERAL] data statistic functions
- [GENERAL] Database reverse engineering
- [GENERAL] datestyle question
- [GENERAL] day of week
- [GENERAL] db errors
- [GENERAL] DB upgrade
- [GENERAL] dblink and hostname resolution problem
- [GENERAL] deadlock detected, only selects (not select-for-update)
- [GENERAL] Declare Cursor
- [GENERAL] Default Ubuntu post-install Qs (PG v7.4)
- [GENERAL] Delete/Update with order by
- [GENERAL] Design Question (Time Series Data)
- [GENERAL] Detailed logging, but only for one user?
- [GENERAL] Determine query run-time from pg_* tables
- [GENERAL] Determining oldest WAL for Archiving PITR Standby
- [GENERAL] Determining oldest WAL for Archiving PITR Standby - SOLVED
- [GENERAL] Did pg_dumpall and imported, NEED TO START OVER
- [GENERAL] different date-time in base and in system
- [GENERAL] Disable triggers per transaction 8.2.3
- [GENERAL] disjoint union types
- [GENERAL] downloading and installing postgreSQL
- [GENERAL] drop table cascade doesn't drop manual sequences
- [GENERAL] DROP VIEW lasts forever
- [GENERAL] DST problem on pg 8.2.5
- [GENERAL] Dump of table structure is not consistent
- [GENERAL] Easier string concat in PL funcs?
- [GENERAL] Embedding code in Postgres source code
- [GENERAL] Error while database creation
- [GENERAL] ERROR: Could not access status of transaction ####
- [GENERAL] ERROR: could not open file "pg_subtrans...
- [GENERAL] ERROR: invalid byte sequence from psql - Works perfectly from pgAdmin III query window
- [GENERAL] ERROR: variable not found in subplan target lists
- [GENERAL] execute pg_dump via python
- [GENERAL] Execution plan caching
- [GENERAL] Explicit Named Indexes for Constraints
- [GENERAL] Extracting Index Creation Script
- [GENERAL] extracting multiple results from a set of tuples
- [GENERAL] FATAL: could not reattach to shared memory
- [GENERAL] Feature Request - Defining default table space for Indexes in Conf file
- [GENERAL] Feature request: SSL Client Cert Authentication
- [GENERAL] Fetch
- [GENERAL] Find clusters containing a schema?
- [GENERAL] Find min year and min value
- [GENERAL] find out data types using sql or php
- [GENERAL] Find out encoding of data
- [GENERAL] Finding number of rows deleted in a stored procedure
- [GENERAL] fmgr_info_cxt_security() modifies variable?
- [GENERAL] Foreign Key for PHP serialized data - possible?
- [GENERAL] foreign keys and memory consumption
- [GENERAL] Fragments in tsearch2 headline
- [GENERAL] function and passing the table name to be used with SQL stmnt
- [GENERAL] function result cache for pl/pgsql
- [GENERAL] Generating sql to capture fully qualified table names???
- [GENERAL] Generating sql to capture fully qualified table names??? - THANKS
- [GENERAL] Generating subtotal reports direct from SQL
- [GENERAL] Generating TRUNCATE orders
- [GENERAL] generating UPDATE SET ... WHERE PK = ...
- [GENERAL] Geographic data sources, queries and questions
- [GENERAL] German soundex
- [GENERAL] getting list of tables from command line
- [GENERAL] good sql tutorial
- [GENERAL] google
- [GENERAL] GRANT error
- [GENERAL] Group By question
- [GENERAL] Guideline on use of temporary tables
- [GENERAL] How can I easily and effectively support (language) translation of column values?
- [GENERAL] how can I shut off "more"?
- [GENERAL] How install postgreSQL in another drive than C:?
- [GENERAL] How to ALTER a TABLE to change the primary key?
- [GENERAL] how to configure postgresql to display messages in italian
- [GENERAL] How to convert rows into HTML columns?
- [GENERAL] how to ignore invalid byte sequence for encoding without using sql_ascii?
- [GENERAL] How to make LIKE to use index in "abc%" query?
- [GENERAL] How to set config param temporarily?
- [GENERAL] How to speedup intarray aggregate function?
- [GENERAL] How to transfer from place to plase without backup/restore
- [GENERAL] how to truncate/purge the pg_xlog directory?
- [GENERAL] how to unsubscribe from this group?
- [GENERAL] How to use 'toast'
- [GENERAL] How to view the SQL that Pg actually executes?
- [GENERAL] I want to search my project source code
- [GENERAL] importing large files
- [GENERAL] Importing MySQL dump into PostgreSQL 8.2
- [GENERAL] improvement proposition
- [GENERAL] Inconsistence in transaction isolation docs
- [GENERAL] INDEX and JOINs
- [GENERAL] Index Usage
- [GENERAL] Indexes & Primary Keys (based on the same columns)
- [GENERAL] Inheritance fixing timeline? (Was "Inherited FK Indexing")
- [GENERAL] Inheritance foreign key unexpected behaviour
- [GENERAL] Inheritance problem when restoring db
- [GENERAL] initdb: file "/usr/local/share/postgresql/snowball_create.sql" does not exist
- [GENERAL] insert continue on error
- [GENERAL] INSERT RETURNING
- [GENERAL] Install dblink on postgres server on windows
- [GENERAL] install failed with "not NTFS filesystem"
- [GENERAL] Install fails on Debian sid
- [GENERAL] Install plJava
- [GENERAL] Invalid error message when user has nologin attibute
- [GENERAL] Investigating memory leak of trigger library using valgrind
- [GENERAL] It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username
- [GENERAL] jdbc: ERROR transaction is read-only
- [GENERAL] Join between tables of two or more databases
- [GENERAL] keeping an index in memory
- [GENERAL] Large Result and Memory Limit
- [GENERAL] Lifting WHERE conditions out of inner select
- [GENERAL] Locale collation issues
- [GENERAL] Logging deadlocked statements?
- [GENERAL] looking for some real world performance numbers
- [GENERAL] max_*, shared_buffers, and shared memory
- [GENERAL] Migration questions for upcoming 8.3 release and fts
- [GENERAL] Missing files under pg_data following power failure
- [GENERAL] more problems with count(*) on large table
- [GENERAL] move databases files location
- [GENERAL] move whole schema to a new tablespace
- [GENERAL] multiple row insertion
- [GENERAL] Multiple versions on same box
- [GENERAL] Need advice on keeping backup database up to date
- [GENERAL] need help with rebuilding postgresql
- [GENERAL] newbie question
- [GENERAL] newbie: update timestamp trigger?
- [GENERAL] nonstandard use of
- [GENERAL] Normalized Tables & SELECT [was: Find "smallest common year"]
- [GENERAL] Not able to insert binary Data having NULL
- [GENERAL] not work in IE
- [GENERAL] ORDER BY - problem with NULL values
- [GENERAL] Order-independent multi-field uniqueness constraint?
- [GENERAL] ordering rows
- [GENERAL] Out of memory with ODBC
- [GENERAL] Partitioned table limitation
- [GENERAL] Partitioned tables, rules, triggers
- [GENERAL] Partitioning: how to exclude unrelated partitions?
- [GENERAL] Perhaps silly question about empty search_path
- [GENERAL] PG windows service issues
- [GENERAL] PG/Tcl and Expect?
- [GENERAL] pg_cancel_backend() does not work with buzz queries
- [GENERAL] pg_dump
- [GENERAL] pg_dump - schema diff compatibility
- [GENERAL] pg_dump auto login
- [GENERAL] pg_dump SERIAL and SEQUENCE
- [GENERAL] pg_dumpall's subseq IMPORT ERRORS
- [GENERAL] pg_restore
- [GENERAL] PG_TRY(), PG_CATCH()....
- [GENERAL] Pgaccess
- [GENERAL] pgadmin's pgagent job scheduler
|