Home > Archive > PostgreSQL Discussion > June 2005









Pages: [1] 2

Posts(3)June 30, 2005, 8:23 pmoptimizer not optimizing
Posts(6)June 30, 2005, 8:23 pmRecovering a broken database
Posts(2)June 30, 2005, 8:23 pmError while installing Slony 1.1.0 for PostGreSql version 7.3.4
Posts(1)June 30, 2005, 8:23 pmget the SALT
Posts(2)June 30, 2005, 1:24 pmError while installing Slony 1.1.0 for PostGreSql version 7.3.4
Posts(6)June 30, 2005, 1:24 pmPossible move away from PG
Posts(5)June 30, 2005, 9:23 amExplain Analyse never returns .. maybe a bug
Posts(1)June 30, 2005, 3:23 am会えるんです
Posts(2)June 30, 2005, 3:23 amMemory tuning for linux (Suffering CRS...)
Posts(1)June 29, 2005, 8:24 pmrules and table renaming
Posts(6)June 29, 2005, 8:24 pmCVS Build - No Doc
Posts(1)June 29, 2005, 8:24 pmUNSUBSCRIBE
Posts(5)June 29, 2005, 8:24 pmnull constraints and defaults
Posts(4)June 29, 2005, 8:24 pmNeed help writing SQL statement
Posts(1)June 29, 2005, 1:24 pmhow use pg_dump/pg_restore
Posts(2)June 29, 2005, 1:24 pmPassing a table name to a function for dynamic queries....
Posts(6)June 29, 2005, 11:23 amAdvice on merging two primary keys...
Posts(1)June 29, 2005, 11:23 amCharacter conversion...
Posts(2)June 29, 2005, 9:23 amfaking writable views as tables
Posts(5)June 29, 2005, 9:23 amtruncate all tables?
Posts(2)June 29, 2005, 9:23 am8.1 Out parameter question
Posts(1)June 29, 2005, 7:23 amRe: rule as on insert to view with multiple fk referencing the same table
Posts(2)June 29, 2005, 7:23 amRe: Foreign key to a view (UNION of two or more tables),
Posts(20)June 29, 2005, 7:23 amautomating backup ?
Posts(2)June 29, 2005, 3:23 amConnection local variables?
Posts(4)June 28, 2005, 8:23 pmBuilding Latest (8.1)
Posts(2)June 28, 2005, 1:23 pmUser authorization
Posts(1)June 28, 2005, 11:23 amPostgres SQL server hosting
Posts(6)June 28, 2005, 11:23 amGenerate a list of (days/hours) between two dates
Posts(2)June 28, 2005, 11:23 amERROR: "TZ"/"tz" not supported
Posts(3)June 28, 2005, 9:23 amperformance for insert / update
Posts(1)June 28, 2005, 7:23 amPerformance Tuning Best Practices for 8
Posts(2)June 28, 2005, 3:23 amproblems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4
Posts(14)June 28, 2005, 3:23 amPostmaster Out of Memory
Posts(9)June 27, 2005, 8:23 pmFinding points within 50 miles
Posts(2)June 27, 2005, 8:23 pmIndexes not used - what am I missing?
Posts(1)June 27, 2005, 8:23 pmVacuum analyze question on estimated rows
Posts(2)June 27, 2005, 1:23 pmRe: DANGER Windows version might hurt you
Posts(1)June 27, 2005, 11:23 amRe: Web application development on Win32, deployment on
Posts(4)June 27, 2005, 11:23 amWeb application development on Win32, deployment on Linux
Posts(3)June 27, 2005, 11:23 amInfix Function?
Posts(1)June 27, 2005, 11:23 amStatus of pg_dump
Posts(2)June 27, 2005, 9:23 amnumber of records returned by cursors
Posts(2)June 27, 2005, 9:23 amTablespaces across same raid...
Posts(4)June 27, 2005, 9:23 amMacOSX, fink, missing readline/readline.h
Posts(9)June 27, 2005, 9:23 amPostfix/Maildrop and too many connections issues
Posts(2)June 27, 2005, 7:23 amWindows XP installation problem
Posts(14)June 27, 2005, 7:23 amWin32 users?
Posts(5)June 27, 2005, 7:23 amHow to compare the schemas ?
Posts(1)June 27, 2005, 3:23 amvacuum error
Posts(3)June 27, 2005, 3:23 amRaid and tablespaces configuration
Posts(2)June 25, 2005, 8:23 pmplpgsql function changes?
Posts(2)June 25, 2005, 11:23 amRe: PL/pgSQL function to validate UPC and EAN barcodes
Posts(27)June 25, 2005, 3:23 amPostgreSQL Certification
Posts(1)June 25, 2005, 3:23 amPL/pgSQL function to validate UPC and EAN barcodes - works! Improvements?
Posts(5)June 24, 2005, 8:23 pmstartup time
Posts(2)June 24, 2005, 8:23 pmRe: Postgres 8.0 windows processes, field testing, and
Posts(5)June 24, 2005, 11:24 amfields and foreign keys
Posts(3)June 24, 2005, 11:24 amcreate rule ... as on insert
Posts(2)June 24, 2005, 9:23 amproblem calling psql from another program
Posts(6)June 24, 2005, 9:23 amNon-unique index performance
Posts(2)June 24, 2005, 9:23 amPostgres 8.0 windows processes, field testing, and Hibernate
Posts(1)June 24, 2005, 9:23 amLibpq question
Posts(2)June 24, 2005, 9:23 amProblem with catching my own exception messages.
Posts(1)June 24, 2005, 7:23 amRe: Postgres 8.0 windows processes, field testing, and
Posts(9)June 24, 2005, 3:23 amPropogating conditions into a query
Posts(3)June 24, 2005, 3:23 ammulti-languages in a table
Posts(4)June 24, 2005, 3:23 amVacuum causing crashes
Posts(1)June 23, 2005, 8:23 pmIs there a standard database model for poker?
Posts(3)June 23, 2005, 8:23 pmPerl DBI issue
Posts(1)June 23, 2005, 8:23 pmRe: setting up PostgreSQL on Linux RHL9 to allow ODBC
Posts(7)June 23, 2005, 8:23 pmCorrupted index
Posts(3)June 23, 2005, 1:23 pmHelp me urgently
Posts(1)June 23, 2005, 1:23 pmLoopback IDENT authentication broken in FC4
Posts(3)June 23, 2005, 1:23 pmplpgsql and schema
Posts(4)June 23, 2005, 1:23 pmTX semantics backward compatibility
Posts(7)June 23, 2005, 11:23 amplpgsql constraint checked data fails to restore
Posts(2)June 23, 2005, 9:23 amPerformance counters?
Posts(4)June 23, 2005, 9:23 amChanging password for the postgres user?
Posts(7)June 23, 2005, 9:23 ammultiple action rules
Posts(3)June 23, 2005, 7:23 amhelp about the function
Posts(1)June 23, 2005, 7:23 amRe: setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows
Posts(2)June 23, 2005, 3:23 amRe: setting up PostgreSQL on Linux RHL9 to allow ODBC connections
Posts(1)June 23, 2005, 3:23 amRe: setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows
Posts(6)June 23, 2005, 3:23 amVacuum advice
Posts(4)June 22, 2005, 8:23 pmPROBLEM: Function does not exist
Posts(3)June 22, 2005, 8:23 pmSetting global vars for use with triggers
Posts(2)June 22, 2005, 8:23 pmdump/restore bytea fields
Posts(2)June 22, 2005, 1:23 pmClustering and replication options
Posts(2)June 22, 2005, 1:23 pmtable and column information from cursor?
Posts(3)June 22, 2005, 1:23 pmProblem on function returning setof custom type
Posts(1)June 22, 2005, 11:23 amsetting up PostgreSQL on Linux RHL9 to allow ODBC connections from
Posts(3)June 22, 2005, 11:23 amProblems upgrading to 7.4.8 from 7.2.4
Posts(1)June 22, 2005, 11:23 amhow to xml on debian?
Posts(8)June 22, 2005, 11:23 am8.03 postgres install error
Posts(17)June 22, 2005, 7:23 amMaking the DB secure
Posts(3)June 22, 2005, 7:23 amis this a bug ?
Posts(1)June 22, 2005, 3:23 amRe: scroll cursor bug or me?
Posts(2)June 22, 2005, 3:23 amANN: PG Lightning Admin for PostgreSQL 8.x Released
Posts(3)June 21, 2005, 8:23 pmEscape handling in strings
Posts(1)June 21, 2005, 8:23 pmメウ髟阡札標魎孔踉捌由
Posts(4)June 21, 2005, 8:23 pmDebugging PL/pgSQL
Posts(6)June 21, 2005, 1:23 pmScripting issues
Posts(2)June 21, 2005, 1:23 pmHELP!!! Corrupt Database!
Posts(1)June 21, 2005, 1:23 pmCONVOLUTED CROSS-TAB ? UNION ? INTERSECT ? 16.9 second performance.... Is there a better way ???
Posts(1)June 21, 2005, 11:23 amindex selection by query planner
Posts(6)June 21, 2005, 9:23 amrenumber id's in correct order (compact id's)
Posts(3)June 21, 2005, 9:23 amExplain analyze gives no info
Posts(7)June 21, 2005, 9:23 amdealing with file size when archiving databases
Posts(6)June 21, 2005, 9:23 amproblems with types after update to 8.0
Posts(4)June 21, 2005, 9:23 amcompilation postgresql/solaris error
Posts(3)June 21, 2005, 9:23 amHowto repair template1
Posts(5)June 21, 2005, 3:23 amAccess is denied during initdb
Posts(1)June 21, 2005, 3:23 amRe: failed to find conversion function from "unknown" to ...
Posts(2)June 21, 2005, 3:23 amusers, address record restrictions
Posts(2)June 21, 2005, 3:23 amRe: PostgreSQL Developer Network
Posts(4)June 21, 2005, 3:23 amExternal (asynchronous) notifications of database updates
Posts(2)June 20, 2005, 8:24 pmerror during pg_dump
Posts(4)June 20, 2005, 8:24 pmOIDS
Posts(1)June 20, 2005, 8:24 pmInformation retrieval
Posts(2)June 20, 2005, 8:24 pmOdd performance issue
Posts(3)June 20, 2005, 8:23 pmuser/groups query ?
Posts(1)June 20, 2005, 8:23 pmError during pg_dump
Posts(2)June 20, 2005, 8:23 pmpg_hba problem
Posts(2)June 20, 2005, 8:23 pmWhy can't I install in a terminal session?
Posts(2)June 20, 2005, 11:23 amHelp! What has changed in the internal structure of PostgreSQL?
Posts(1)June 20, 2005, 11:23 amRe: Help! What has changed in the internal structure of
Posts(1)June 20, 2005, 9:23 amRe: Help! What has changed in the internal structure of
Posts(5)June 20, 2005, 9:23 amForeign key to a view (UNION of two or more tables), any alternative?
Posts(2)June 20, 2005, 9:23 amrestore large database
Posts(1)June 20, 2005, 9:23 am(2) failed to find conversion function from "unknown" to ...
Posts(11)June 20, 2005, 7:23 amBacking up multiple databases
Posts(6)June 20, 2005, 7:23 amsubqueries
Posts(3)June 20, 2005, 7:23 amunicode and =
Posts(1)June 20, 2005, 7:23 amfailed to find conversion function from "unknown" to ...
Posts(3)June 20, 2005, 3:23 amInsert behavior in transaction
Posts(1)June 19, 2005, 7:23 amSort Ignoring Spaces
Posts(1)June 19, 2005, 3:23 amAnyone use pgcluster in production?
Posts(1)June 19, 2005, 3:23 amALTER FUNCTION semantics
Posts(2)June 19, 2005, 3:23 amPgAdmin 1.2.2 on MacOS X with PG 8.0.3
Posts(3)June 18, 2005, 1:23 pmReplication
Posts(6)June 18, 2005, 11:23 amViewing non-system objects in psql
Posts(2)June 18, 2005, 9:23 amError defining composite types and returning ROWTYPEs
Posts(1)June 18, 2005, 9:23 amReplication
Posts(2)June 18, 2005, 7:23 amRe: libpq.so.3 problem, PostgreSQL >= 8.0.2 and RPM
Posts(4)June 18, 2005, 3:24 amDeleting a rule?
Posts(2)June 17, 2005, 8:24 pmError column "sys" does not exist
Posts(1)June 17, 2005, 8:24 pmRe: Help: chinese character set support (EUC_TW to/from
Posts(6)June 17, 2005, 1:24 pmpg_dumpall
Posts(1)June 17, 2005, 1:24 pm再びお伝えします。
Posts(6)June 17, 2005, 11:24 ampgavd status
Posts(1)June 17, 2005, 11:24 amRe: Help: chinese character set support (EUC_TW to/from
Posts(4)June 17, 2005, 11:24 amquery plan in pg7.4 vs 8.0.3
Posts(1)June 17, 2005, 11:24 amChange to make strings SQL-standard
Posts(2)June 17, 2005, 11:24 amHelp: chinese character set support (EUC_TW to/from BIG5 conversion)
Posts(3)June 17, 2005, 11:24 amMultiple COPYs
Posts(1)June 17, 2005, 9:23 amPostgreSQL 8.0.3 : initdb fails with the time zone value WAT0 on HP-Unix platforms
Posts(1)June 17, 2005, 9:23 amExperiencing problems with stored procedures
Posts(2)June 17, 2005, 9:23 ampsql: FATAL: database "template1" is not currently accepting connections
Posts(7)June 17, 2005, 7:24 amHungry postmaster
Posts(1)June 17, 2005, 3:25 amRe: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM
Posts(1)June 17, 2005, 3:25 amencoding problems and float
Posts(1)June 17, 2005, 3:25 amRe: psql: FATAL: database "template1" is not currently accepting
Posts(1)June 16, 2005, 8:24 pmRe: Extremely slow performance with 'select *' after insert of 37,000 records
Posts(1)June 16, 2005, 8:24 pmRe: Extremely slow performance with 'select *' after insert
Posts(4)June 16, 2005, 8:24 pminfo on strange error messages on postgresql
Posts(1)June 16, 2005, 1:23 pmExtremely slow performance with 'select *' after insert of 37,000
Posts(2)June 16, 2005, 11:24 ampg_restore won't create database
Posts(3)June 16, 2005, 9:23 amDATATYPE for HEX
Posts(3)June 16, 2005, 7:23 amExecuting SQL Script
Posts(2)June 16, 2005, 7:23 amDynamic SQL
Posts(1)June 16, 2005, 7:23 amPostgreSQL log analyzer
Posts(7)June 16, 2005, 7:23 amenebling regular user to create new users ?
Posts(1)June 16, 2005, 3:24 amCould not open service manager
Posts(6)June 16, 2005, 3:24 amHow to set an expiration date for a WHOLE user account
Posts(4)June 16, 2005, 3:24 amInstallation on latest version of Suse Linux
Posts(3)June 15, 2005, 8:24 pmplpgsql - TIMESTAMP variables in EXTRACT
Posts(2)June 15, 2005, 8:24 pmINHERITS and planning
Posts(15)June 15, 2005, 8:24 pmreturn two elements
Posts(3)June 15, 2005, 8:24 pmgraphic client
Posts(9)June 15, 2005, 1:24 pmCurrent transaction ID?
Posts(1)June 15, 2005, 11:24 amplpgsql cursors, fetching more than one row
Posts(2)June 15, 2005, 11:24 amchanging the sequence for a table
Posts(4)June 15, 2005, 11:24 amPostgreSQL Client Aplications ?
Posts(1)June 15, 2005, 11:24 amretrieving information about users and groups
Posts(1)June 15, 2005, 11:24 amvacuumdb suggestions?
Posts(2)June 15, 2005, 11:24 amslow parsing of queries with joins
Posts(3)June 15, 2005, 11:24 amReporting tools
Posts(6)June 15, 2005, 9:23 amDeadlock Problem
Posts(3)June 15, 2005, 9:23 amDatabase became very slow(Help PLS)
Posts(4)June 15, 2005, 9:23 amConsultants
Posts(3)June 15, 2005, 7:23 amuser groups
Posts(2)June 15, 2005, 7:23 amBest approach setting up PostgreSQL
Posts(2)June 15, 2005, 7:23 amhow to return a result set from a stored procedure
Posts(3)June 15, 2005, 7:23 ampostgresql rpms (7.4.2, 7.4.5, 7.4.8) for redhat 8.0
Posts(1)June 15, 2005, 3:24 amメウ髟阡札標魎孔踉捌由
Posts(1)June 15, 2005, 3:24 amRe: [SPAM] Current transaction ID?
Posts(2)June 15, 2005, 3:24 am(NONE)
Posts(4)June 15, 2005, 3:24 amPG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Posts(2)June 15, 2005, 3:24 amBad pg_xlog with no redo

Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com