View Full Version : postgresql answers
Pages : 1 2
[
3]
4 5 6 7 8 9 10 11
- Adding pgAdminIII Server - Passwords?
- Good page with Oracle x PostgreSQL comparsion
- PostgreSQL and XML
- Danish users
- simple query runs very slowly
- using OLD variable in DELETE trigger
- Please Help with libpq and unicode
- eval function?
- Postgres+XML
- SQL Query
- libpq location?
- pgsql user account in pgadmin doesn't need password
- SuSE Linux and PostgreSQL
- What is future of partitioning?
- PostgreSQL/PHP/UTF-8?
- Oid Type
- The second RFD is in news.groups.
- Table name as parameter in function
- Upcoming Changes to News Server ...
- I need to add a column to a table
- Will B4->B5 require an Initdb?
- Lexical question...
- Bug in queries ??
- PostgreSQL 8.0.0 Beta 5 Now Available
- null value of type java.sql.Time
- primary key and the default index operator class
- Postgres-Windows -Perl DBI
- Foriegn Keys?
- SELECT duplicates in a table
- Storing every scrabble board possible
- Help with syntax for timestamp addition
- null value of type java.sql.Time
- Oid to text...
- Unions, schemas, and design questions...
- timestamp with time zone question...
- COMMIT within function?
- Any good report/form generators for postgresql?
- Wrong string length from unicode database in Borland's app
- Delete very slow after deletion of many rows in dependent table
- Join between databases or (???)
- Unit testing plpgsql code
- I found this great little site
- Posting COPY data with shared sequences
- altre table and large object deletion
- phpPgAdmin problem - this list?
- PostegreSQL 8.0.0 Beta4 Win32
- Phantom user in db--'128'
- How to make lo_import and lo_export to use file on clientlocal machine?
- pgEdit public beta for Macintosh and Windows
- Any equivalent of MSSQL Detach?
- postgres & glibs 1.2
- Odd permission denied message when starting client
- only seeing first of many COPY commands in input file
- Can COPY skip columns?
- index and queries using '<' '>'
- How to make a good documentation of a database ?
- A couple serious errors
- ERROR: Unable to locate type oid 0 in catalog...
- How to know a record has been updated, then reset the flag?
- PROPOSAL: Usenet Discussion Repost
- User-defined types
- Rules WHERE condition
- Tsearch2 and Unicode?
- Knowing when a row was last updated
- error querying temp table in plpgsql function
- PostgreSQL certification
- Q about NAS mounting things
- Controlling maximal on-disk size of a table
- Certifications in military environment
- Transactions in different DB
- How to suppress echo while executing batch files?
- Problems importing Unicode
- Moving from 7.x to 8.0beta4 with a backup
- ERROR: column "id" does not exist
- How to overload POSITION
- question about temp table in function
- Fwd: Problem installing Postgresql on MDK10.0
- out of disk space
- How to deal with almost recurring data?
- How to handle larger databases?
- PL/pgsql - getting row from record
- Transaction in different DB
- How to clear linux file cache?
- PGCLIENTENCODING behavior of current CVS source
- Schemas?
- Preventing connections during vacuum and reindex
- Oracle versus PostgreSQL
- "q" with psql display paging dumps out of psql
- Nairobi time zone fails in 7.4
- I'm sure a good time was had by many...
- Data from Internet direct into PostgeSQL Database??
- relations betwee subclasses in postgersql
- Question about indexes
- suggestion for "psql"
- table configuration tweak for performance gain.
- Error "cannot compare arrays of different element types" when tryingto ANALYZE
- Visual Studio and Postgresql
- shrinking physical space used
- Mysterious Death of postmaster (-9)
- Spam notice
- PostGresql USENET Vote
- sub-query question
- How to use custom functions created by my2pg.pl?
- How many secondary databases can I create?
- query with table alias
- simple query question: return latest
- Want to help on open-source ERP?
- invalid page header in block 52979 of relation "pg_attribute"
- When to switch to Postgres 8.0?
- oid size on 64 bit machine
- DROP DATABASE, but still there
- implicit casting problem
- Problem with showing time diff?
- logging
- checkpoints
- Last value inserted
- New Opteron server from pogo linux
- Vacuum message
- Lionel Lauer 58 Gore Street Fitzroy, Victoria Australia 3065
- making another super user other than postgres
- pg_ctl and stderr
- Can't insert date in field with foreign key
- Modifying FK constraints
- Error connecting using pgadmin from different computer !!
- Analyse - max_locks_per_transaction - why?
- Rolling back an update
- Ping Mike Cox
- Large database
- updateString error in PostgreSQL7.4 with JDBC
- Lost databases
- These Lists Are Being Cut To FOUR
- the column in Update
- unconvertible BIG5 character 0xf9d8
- I'm about to release the next postgresql RFD. Comments wanted.
- Creating DB with pass, but pass not required to connect
- Vacuum hangs
- new data types
- need simple strategy for universal extension table
- FW: Proper nesting of hierarchical objects
- Functions in postgres
- PostGreSQL to Access Updatable recordset
- Linux DBDesigner4 and PostgreSQL
- troubleshooting deadlocks
- Per-Table Transaction Isolation Level?
- server auto-restarts and ipcs
- INTERVAL in a function
- Loading data Binary data and text with newlines ..
- Backend disconnect problems
- Installing pgbench
- Proper nesting of hierarchical objects
- subselect, order by and left join
- technical help
- can you use variables in PostgreSQL rules?
- start postmaster as root : problem
- index not always used when selecting on a date field
- I spoke with Marc from the postgresql mailing list.
- FTP mirror problems
- Visual Designer in linux?
- Sorting based on maximum value over several columns
- SQL question
- Trying to get postgres to use an index
- Mass Import/Generate PKs
- Postresql RFD version 2.0 Help Wanted.
- Report Generation
- Temporarily disable rule, is this possible?
- superuser equality
- Can this be indexed?
- Gborg down?
- Converting number to words
- Copy command and import - MS SQL Server to Postgres
- Are there any PostgreSQL bloggers?
- Retrieve ip client from postgres
- ALERT This mailing list may be voted into a newsgroup
- Trigger Parameter problem
- Using EXECUTE in same manner as SELECT
- ALERT This mailing list may be voted into a newsgroup
- start postmaster as root : problem
- restoring pgdump file file from 7.2 branch to 7.4
- Java / Perl Return codes
- Characters used for pattern matching with like
- Conactenating text with null values
- TSearch2: Problems with compound words and stop words
- Making this group a part of the official comp.* hierarchy.
- how to edit a function from psql?
- RFD: comp.databases.postgresql.general
- create a text file from postgres (like Oracle UTL_FILE package)
- VACUUMING questions...
- Selecting a random row
- visiting Seoul, Korea
- UTF-8 and =, LIKE problems
- oid file, but no pg_class row for it
- Number of months
- Number of months
- pg_xlog
- pg_xlog
- PostgreSQL on Linux PC vs MacOS X
- PostgreSQL on Linux PC vs MacOS X
- MD5 for PostgreSQL 7.3.4
- MD5 for PostgreSQL 7.3.4
- autovacuum redhat startup
- autovacuum redhat startup
- unsubscribe
- unsubscribe
- Batch processing select
- Batch processing select
- Postgres Versions / Releases
- Postgres Versions / Releases
- Subselect Question
- Subselect Question
- SQL Agreate Functions
- SQL Agreate Functions
- Split query
- Split query
- routine reindexing in 7.4.6/8.0?
- routine reindexing in 7.4.6/8.0?
- Rows created by a stored proc prompt Access' dreaded "write conflict"
- Rows created by a stored proc prompt Access' dreaded "write conflict"
- Age of statistics
- Age of statistics
- Calling on all SQL guru's
- Calling on all SQL guru's
- unique problem
- unique problem
- spreading the DB?
- spreading the DB?
- AT TIME ZONE: "convert"?
- AT TIME ZONE: "convert"?
- Numeric type problems
- Numeric type problems
- Functions not dropped.
- dumping on 7.4.6 importing on 7.4.1
- Functions not dropped.
- oracle synchronization strategy
- dumping on 7.4.6 importing on 7.4.1
- PQSQL - binary data question
- oracle synchronization strategy
- PQSQL - binary data question
- Suggested Triggers & Functions Naming Convention?
- Suggested Triggers & Functions Naming Convention?
- Daylight Savings Time handling on persistent connections
- Daylight Savings Time handling on persistent connections
- procedural languages in 7.4.6
- procedural languages in 7.4.6
- Interpolation of environment variables in SQL at runtime?
- Interpolation of environment variables in SQL at runtime?
- 8.0 Beta 4 denying network connections?
- can't shrink relation
- logging queries and time used
- Recommended Procedure for Archiving Table Data
- column updates
- SELECT a value from various tables depending on a column value
- (b)trim anomalies
- tasks
- UTF-8 -> ISO8859-1 conversion problem
- adding missing FROM-clause
- Max length name of a database/schema
- PostgreSQL on Windows
- Creating database problem
- PgSQL8 beta4 ODBC, JDBC and WinXP sk_SK
- {OT?] Auth_PG_grp_group_field directive gives parameter error
- export-import problem
- Upgrading from beta3 to beta4
- Turning a subselect into an array
- Derived tables?
- Issue adding foreign key
- Sorting street addresses
- field incrementing in a PL/pgSQL trigger
- : Unable to load libsqlpg.so
- disabling constraints
- Tables and Indexes
- determine sequence name for a serial
- View's rule on delete problem
- Creating schema copy
- WARNING: column "footype" has type "unknown"
- interval to seconds conversion. How?
- QMail
- Psycopg difficulty...
- Reasoning behind process instead of thread based arch?
- Exact or less specific match ?
- Resource temporarily unavailable
- Array values and foreign keys
- Changing access permissions without re-starting the database
- update data in different database
- (NONE)
- Theory
- pg_autovacuum in 8beta-dev3 small bug
- basic debugging question
- Base type OIDs
- [SECURITY] New set of PostgreSQL RPMS are available for download
- primary key and existing unique fields
- page locking? too many btree indexes...
- Out of memory error
- Any plans on allowing user-defined triggers to be deferrable?
- Bug: 8.0 beta1 either view optimization or pgdump/pgrestore
- compatibilityissues from 7.1 to 7.4
- Strange count(*) implementation?
- Kill a postgres session
- [Fwd: Abrupt close of pgsql backend]
- Theory!!
- list fieldnames in table? (from PHP)
- what could cause inserts getting queued up and db locking??
- PostgreSQL 8.0.0 Beta 4 Now Available
- pg_restore does not restore
- process hang during drop schema
- Error restoring bytea from dump
- shared buffers
- ON DELETE trigger blocks delete from my table
- The reasoning behind having several features outside of source?
- Arrays, placeholders, and column types
- PgSQL MVCC vs MySQL InnoDB
- (NONE)
- How to connect with postmaster through TCP socket
- Sorting, when values are equal....
- dbms
- partial index on a text field
- Function syntax checking
- (S)RPMs for PostgreSQL 7.2.6, 7.3.8 and 7.4.6 are ready
- pqAdmin3
- Memory exhausted on DELETE.
- Permission denied error
- sequence behavior - is this correct
- Comment on timezone and interval types
- COPY data and referential triggers ...
- Problem with 7.4.1 and complicated queries
- repost(gmane): sql update max smartries
- The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.
- how to port Oracle database to PostgreSQL?
- sql update max smartries
- '1 year' = '360 days' ????
- Log
- field incrementing in a PL/pgSQL trigger
- Duplicating a database
- Win installed pgsql 8.0 beta2 dev3
- COPY command with PHP
- Bug or stupidity
- PostgreSQL Security Release(s) for 7.2, 7.3 and 7.4
- OID's
- returning inserted rows, derived tables design
- schema repository
- combining two queries?
- ia64 hostname lookup problem
- unexpected field count in D message
- Problem with query plan
- A Simple Question
- PlPERL and shared libraries on Suse
- PostgreSQL-related job posting
- FKs and deadlocks
- C++ Class Library for ODBC?
- correct example of a functional index usage?
- Row versioning
- Slony-I 1.0.4 Released
- Two questions from the boss (SQL:2003 && scalability)
- Outliers of data
- Is it possible to remove the public schema?
- Information about storge engine in PostgreSQL
- DB modeler
- Linking question
- generic sql question
- inquiry on readline functionality on psql client
- Invalid page header
- table size/record limit
- character encoding problem with delphi
- CREATE TEMPORARY TABLE AS ... ON COMMIT?
- max length bit(x) bit varying(x)
- create table/type
- Query buffer editing on Win32 version of postgresql?
- undefined symbols
- Oracle Varray to Postgres conversion problem
- index not used?
- Sequence question
- union query returning duplicates
- files ending with .1 or .2
- Where clause limited to 8 items?
- How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment
- Problem
- how much ram do i give postgres?
- User Defined Functions/management of OS_Directories
- Segmentation Fault using PHP code
- removing idle connections
- download postgreql problem
- Views + UNION ALL = Slow ?
- delayed input
- Sequence question
- code in docs gives me an error
- OID and PK/FK KEYS
- " CLI describe error: Out of memory while reading tuples."
- About upper() and lower to handle multibyte char
- plpython question
- Sequence question
- vacuum schema
- Database Disappeared
- French paper
- Online & update races
- Online system & transactions
- How to time several queries?
- 8.0.0beta3 vacuum analyze
- How to increase number of connections to 7.2.1
- timezone abbreviation in timestamp string input
- dealing with invalid date
- pgsql function using C++?, or at least C interfacing with C++ lib?
- reusing column labels in select
- Avoiding sequential scans with OR join condition
- plpgsql loop not returning value
- OS X Install
- pgsql cvs
- Multicolumn Indexes
- Any Show Stoppers for v8 libpq talking to v7.x db?
- Changing session ownership in a web app (or how to peel an onion)
- Mathematical operations with NULL values
- unsubscribe
- 7.4 in-lining of SQL functions
- Complex Update Queries with Fromlist
- Count Issues
- Boolean
- dirty reads
- Does PostgreSQL provide anything comparable with MySQL Cluster?
- tcl bindings for 8.0
- Is there an opposite to pg_get_userbyid() ?
- Verifying a user.
- sum 2 arrays of general int type
- IMPORT FROM CTREE to POSTGRESQL
- solaris and ps
- beta3 winxp initdb problems
- any way to remove a password?
- psycopg help
- creating audit tables
- unsubscribe from the mailing list.
- PostgreSQL CE started
- Has anyone tried Date/Darwen/Lorentzos's model for temporal data?
- correct representation of timestamp difference
- Level of replication support?
- Still more pg_clog errors
- Commit / Rollback in PL/pgSQL ?
- ODBC
- converting database to unicode
- Proper Sizing of Shared Buffer Cache
- Date format for bulk copy
- Recovering data from corrupted table. Urgent Help!!
- Management software for Postgresql
- Time at end of transaction
- PostgreSQLv8 native Windows NAMEDATALEN = 128
- could not access status of transaction 4244329
- psql : how to make it more silent....
- adding two tables
- about permissions...
- cost logging
- how to open stat mode in db
- Proposal: GRANT cascade to implicit sequences
- capacity of datatype "text"
- Change primary key in Postgres 7.3?
- memory leak of PQmakeEmptyPGresult??
- LISTEN/NOTIFY for lightweight replication
- error opening pg_clog file
- deadlock with vacuum full on 7.4.5
- How Do I Change The 'Owner' of a Database?
- PostgreSQL v8 NAMEDATALEn >=128
- data dir permissions and ownership
- connection or query affected
- Message-ID as unique key?
- Return resultset from a function
- Confused with LABEL and LOOP
- Rule uses wrong value
- update query confusion
- Need some advice on appropriate PL strategy...
- 'NOW' in UTC with no timezone
- Very slow delete.
- Reiniciar secuencias
- created databases as other users...
- Rule is using wrong values
- CVS broken?
- Reusable pl/pgsql samples ?
- update sequence conversion script
- Get Postgre Status and Information
- Change query priority
- Rule problem
- Testing Inserts, Deletes and Updates before execution ...
- OS not good for database
- external function libraries on non-build machine
- Rules and locking within a transaction?...
- install problem
- Management system for PostgreSQL?
- foreign key constraints, cannot delete
- Explain output question
- pg_restore -l and schema name
- text + text
- interesting! a sequence clashes with data already in that table
- when to use NULL and when to NOT NULL DEFAULT ''
- CGI program cannot access database
- Index problem.... GIST (tsearch2)
- regular expression searches
- Question about timezones
- PSQL undesired transaction behavior when connection is lost.
- 8.0 questions
- Date variables in psql
- pre-sroted table (w/ index)
- flattened tables with normalized tables
- Reading a text file into PostgreSQL
- Alternate interval output function
- unsubscription
- PostgreSQL seems to wait and block all the queries
- Informatica with postgres
- interfaces for python
- Current wisdom wrt fsm on 8.0
- pgpool log errors
- Activestate Perl and DBD-Pg?
- postgres.h location?
- Help on copy function
- passing new.* in trigger
- database constraints
- Commands to browse current connections and processes
- Cache lookup failed for relation, when trying to DROP TABLE.
- two digit years in inserts
- (no subject)
- Determining time of last INSERT/UPDATE/DELETE
- Mirroring databases in v8
- lower/upper support and cyrillic
- SSL connection between PHP4 & PostgreSQL ???
- Verifying Referential Integrity
- problem with pg_restore
- storage representation of DATE and TIME types
- looking for Mac pgEdit beta testers
- Set locale per query?
- Mailing
- Function array_to_string(text[], text) does not exist ???
- more than one instance of pgpool for a backend?
- table localisation
- current transaction is aborted, commands ignored until end of transactionblock
- Single-file databases -- how do they do it?
- pgsql 8 beta document
- Cursors and JDBC
- trouble installing plpgsql
- PostgreSQL 8.0 install woes
- LOST REFERENTIAL INTEGRITY
- Server getting crushed
- mirroring/replication
- weird issues with plpgsql calls.
- Is Win32 port good for operational use?
- SELECT from a set of values really slow?
- Application user login/management
- GnuPG / PGP signed checksums for PostgreSQL 7.4.5, 7.4.4, 7.3.7, 7.3.6, 7.3.5. 7.2.5
- guaranteeing that a sequence never skips
- sequence rename?
- Random not so random
- storing files: blob, toasted text of filesystem?
- Query problem...
- default select ordering
- VACUUM FULL on 24/7 server
- earthdistance is not giving correct results.
- New Student
- newby question