View Full Version : postgresql answers
Pages : 1 2 3 4 5 6 7 8 9
[
10]
11
- Question
- Excute comnands OS from plpgsql
- elog undefined?
- converting varchar date strings to date
- How to list which tables are available?
- Question
- spam or crazy mail server changes?
- Excute comnands OS from plpgsql
- elog undefined?
- How to list which tables are available?
- spam or crazy mail server changes?
- pg_shadow --> passwd
- SET within a function?
- gborg cvs ?
- Index on timestamp to date field
- Pgsql on Windows
- Create Function... ERROR: language "plpgsql" does not exist
- Performance weirdness with/without vacuum analyze
- Postgres 7.3.4 install
- Upgrading to 7.4beta
- Temporary tables and miscellaneous schemas
- CREATE INDEX question (how to index on "money" field?)
- need for concrete info
- previous & next buttons
- [Cygwin] Postgresql 7.3.4 Installation Problem
- PQnotifies and freeing memory.
- "slicing" records
- backend exit mystery
- Debian experimental packages of PostgreSQL 7.4beta4
- log_duration and \timing times repeatably much higher than "Total runtime" from explain analyze
- Unable to identify an operator '*=' for types 'character varying[]' and '"unknown"'
- Unique Index vs. Unique Constraint
- Interfaces that support cursors
- libpq.so.3 not found error while use Perl DBI
- Execute Function from VB/ADO
- problem with pg_dump and restoring sequences
- PG tools
- process hangs using perl?
- undefined reference to 'pg_detoast_datum'
- simple remote user access question - pg_hda.conf
- question about a select
- SQL query problem
- Table partitioning for maximum speed?
- Parent Id
- Procedure for adding a column
- Postgres 7.4 : ECPG not Thread-safe
- relation vs table...
- Locale bug?
- help with large objects in 7.3.4
- int1?
- autoupdate sequences after copy
- Updated plPerl with trigger support available
- Cross database foreign key workaround?
- reset xlog on 7.1 ?
- Displaying a float8 as a full-length number
- question on setof record returning plpgsql function
- problems retrieving images in 7.3.4
- Humor me: Postgresql vs. MySql (esp. licensing)
- (NONE)
- Humor me: Postgresql vs. MySql (esp. licensing)
- UPDATE and outer joins
- Replication Bundled with Main Source.
- How to delete unclosed connections?
- install; readline error with 7.3.4
- Does postgresql support HKSCS ?
- refential integrity to multiple tables ??
- PL/PGSQL for permutations?
- Assigning Values to Arrays
- "select count(*) from contacts" is too slow!
- some question about column constraints
- Postgresql-7.3.4 rpm's for suse?
- Problems defining a primary key !!
- Data partitioning?
- using copy to load odd characters
- concenation of strings and null values
- COPY COMMAND
- Invalid page header in block
- Try on this corrective patch which came from the Microsoft Corp.
- creating index's on functions.
- databse design tutorial
- Call for Speakers / Presenters
- Generating a SQL Server population routine
- Adding Indexes to Functions
- triggers and schemas
- orphaned psql's
- Nested SPI_exec's
- Tree traversing. Like Oracle START WITH...CONNECT BY
- Cannot create database
- Translators wanted for PostgreSQL
- plpgsql insert from rowtype
- group by
- Help with photo album database...
- updating records
- Slow SELECT
- migrate from postgres to mysql
- RE : mod_auth_pgsql 2.0.1 don't close the backend connection
- PostgreSQL Beta4 Tag'd and Bundle'd ...
- book on advanced postgresql?
- Discussion about inheritance
- administration with pgaccess
- LC_COLLATE=C not working
- pg_restore takes ages
- anyone give me some good liniks to ...
- pg_dump integrity question
- migrate from postgres to mysql
- dump table question
- return next in recursive function
- Adding missing FROM-clause entry in subquery
- Can SQL return a threaded-comment-view result set?
- Type of application that use PostgreSQL
- BLOBs, pg_dump & pg_restore
- Server recommendations
- remote psql
- Migrating Access to Postgres
- Views and Rules???
- Is the use of array as PL/PGSQL function arguments ?
- Current time inside Transactions
- psql error: cannot open libpq.so.3
- adressing column
- <no subject>
- ENTREPRENEURS NEEDED
- Did not find any relation named...
- Stored procedures with variable number of args ?
- psql error: cannot open libpq.so.3
- Divide by zero...
- Functional index performance question
- Problem with lock?
- pg_hba.conf
- PGAdmin III 1.0.0 Released
- psql error:cannot open libpq.so.3
- Is there any way to force analyze to run on a whole table?
- validation of postgresql functions
- Postgres vs. Progress performance
- Resources for Progress conversion...
- Seeking insight from heavy lifters
- Access - can't close Form
- Where is libpq++ on redhat 9?
- Access - can't close Form
- Conditional row grained + FK dependency oriented lazy replication
- Seeking insight from heavy lifters
- Edward
- numeric rounding
- Where are user-defined types stored/viewed
- finding memory leaks in extensions
- Time problem again?
- PostgreSQL SSL communication with SecureTcpClient (Ssl v 3.0)
- Modification Dates
- Result set granularity..
- query
- transaction timeout
- ODBC will not be supported by Microsoft in the future
- Is it safe to use DEFAULT currval()
- PostgreSQL Delphi
- RT with PostgreSQL .
- downloading latest source from cvs
- Schema backup
- CASE tools
- hide the owner table
- Escape sequence for unicode characters
- how to include equalfuncs.c?
- non local access to database
- vacuum full failing in 7.3
- Client authentication
- A conditional DROP TABLE function
- MySQL-to-PostgreSQL
- Multilingual db
- Building PostgreSQL non-default Block size
- MPI interface
- Good way to insert/update when you're not sure of duplicates?
- performance hit when joining with a view?
- populate table with large csv file
- Transactions to localhost
- Triggers and COPY
- German translation of PostgreSQL documentation
- To inherit or not to inherit
- PostgreSQL at OSCON 2004
- sequence's plpgsql
- 7.3.3 again - fixed
- Help again with 7.3
- Is this "order by" logic right
- pltcl problem
- data directory growing huge
- Accessing tables from different databases
- OO and RDBMS
- FW: See these correction pack
- how smart is is pg with shared_buffers?
- "Expiring" transactions?
- BSD License
- Especial delimiters caracter
- Problem with ORDER BY and random() ?
- pg_tables column descriptions
- Ora2Pg question
- Questions about my ifnull function
- Inheritance and query plans
- How to get the total number of rows returned by query when using a cursor?
- PostgreSQL query failed: ERROR: pg_atoi: zero-length string
- table size
- GET LAST ID INSERT
- TList.Sort
- Foreign key constraint accepted even when not same data type
- Foreign key constraint accepted even when not same data type
- DSN-Less
- DSN-LESS
- DSN-Less
- mod_auth_pgsql & encryption
- See this important package
- encoding and LIKE/ILIKE matching
- How to find LIMIT in SQL standard
- encoding and LIKE/ILIKE matching
- cannot insert or update
- psql and \lo_import
- unsubscribe
- Toad
- Triggers/perform oddity between 7.2 and 7.3
- about the pstate node
- detecting a NULL box
- Question about connection java and Postgresql in Linux
- add constraints to views
- anyone use Ora2Pg?
- Identify dropped columns in PLTCL
- colunms & comments & inheritance
- recent viri and worms
- An idea for IPU ( We need another acronymn! )
- Access Ingres database
- 'order by' does "wrong" with unicode-chars (german umlauts)
- DDL diff utility?
- query distribution
- Trouble with some concepts
- adding on delete cascade constraint?
- Zend survey result about dbms...
- Outer Join help please
- Column defaults fail with rules on view
- pgindented tsearch2 for 7.3.4
- About Pgdump
- This mail list and its policies
- Sequences
- Job Opening
- PostgreSQL versus MySQL
- Image data type equivalent in postgresql
- I dont know the error with updtae
- Scalability (both vertical and horizontal)?
- Cannot Delete
- Problem in Function returning Cursors - Postgres Sql 7.2
- varchar vs. text
- Sort order is different on Windows and Linux
- High-volume shop uses PostgreSQL
- 7.3.2 client connecting to 7.2.1 server problem
- psql and blob
- Bug while installing in AIX 5.1
- Weird query plan
- Why does adding SUM and GROUP BY destroy performance?
- Where are PL/pgSQL functions stored?
- psql and blob
- More general datafiles ?
- backend crashing despite tsearch2 patch
- Problems requiring a GROUP BY clause on update?
- transaction abortion
- Database Recovery Procedures
- Red Hat 9 Postgres
- Question.
- char o varchar
- Error trigger
- update field using substrings of another field
- 4D to PostgreSQL tools
- CONCAT function
- How to ALTER VARCHAR datatype to TEXT ?
- date_part('timezone_hour')
- Idea for improving speed of pg_restore
- Rules question
- Odd behaviour -- Index scan vs. seq. scan
- after postgres upgrade - ERROR: current transaction is aborted
- encoding and parser: error?
- Initalizing PostgreSQL Database
- Updates with NULL
- Mirrors
- Fox Trot bows to us
- The NT services Cygwin PostgreSQL installatio
- is General Bits Issue # 43 correct?
- function call
- How to remove CLUSTERs and 'partitioning tables'
- Cyclic foreign key dependency & table inheritance
- Cyclic foreign key dependency & table inheritance
- MD5() function not available ??
- MD5() function not available ??
- Space
- Space
- pg 7.3.4 and linux box crash
- pg 7.3.4 and linux box crash
- installation of postgres 7.3.4 rpm
- installation of postgres 7.3.4 rpm
- how to replicate database
- how to replicate database
- "another command is already in progress" error
- "another command is already in progress" error
- New DBTools Manager 2.2.0
- New DBTools Manager 2.2.0
- case-insensitive database
- case-insensitive database
- BEA Weblogic 8.1?
- BEA Weblogic 8.1?
- pgSql Memory footprint
- pgSql Memory footprint
- Why do I need to pass value for Serial type in Insert/Update?
- Why do I need to pass value for Serial type in Insert/Update?
- Regarding constraint database
- Regarding constraint database
- PostGreSql database features questions
- PostGreSql database features questions
- Serial type currval
- Serial type currval
- (NONE)
- (NONE)
- I need examples of stored procedures returning datasets
- I need examples of stored procedures returning datasets
- difference when using 'distinct on'
- difference when using 'distinct on'
- Between(Interval of two dates) in Postgres
- Between(Interval of two dates) in Postgres
- Table OraclexPostgresql
- Table OraclexPostgresql
- Converting database-encoding from SQL_ASCII to UNICODE?????
- Converting database-encoding from SQL_ASCII to UNICODE?????
- Codepage Win1252
- Codepage Win1252
- how can i use SELECT to find a substring of a column's data?
- how can i use SELECT to find a substring of a column's data?
- library version problem, 7.3.2, php, redhat linux
- library version problem, 7.3.2, php, redhat linux
- selecting random rows
- selecting random rows
- Function to convert
- Function to convert
- Connecting to postgres from a romote machhine
- Connecting to postgres from a romote machhine
- "another command is already in progress" error (fwd)
- "another command is already in progress" error (fwd)
- How to avoid inlining subquery result columns
- How to avoid inlining subquery result columns
- Create index in PG table with vb6
- Create index in PG table with vb6
- Questions about erserver
- Questions about erserver
- query-question
- I need a SQL...
- how to replicate database
- query-question
- I need a SQL...
- PostgreSQL for AMD64
- how to replicate database
- PostgreSQL for AMD64
- pgsql and Qt apps
- (NONE)
- 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
- A Question About Insertions -- Performance
- pgsql and Qt apps
- (NONE)
- 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
- A Question About Insertions -- Performance
- Release date
- message type 0x50
- C API, PQconnectdb and options Q.
- Release date
- message type 0x50
- message type 0x50
- 7.4 defaulting to ipv6 ?
- help with TCL function
- C API, PQconnectdb and options Q.
- plpgsql doesn't coerce boolean expressions to boolean
- message type 0x50
- 7.4 defaulting to ipv6 ?
- Question about conccurrency control and Insert
- Constructing column from different individual fields in same row.
- help with TCL function
- plpgsql doesn't coerce boolean expressions to boolean
- SUMMARY mysql -> psql
- State of Beta 2
- Kill -9 Postmaster and Temporary Tables
- Adding header nam to any table
- Help needed in Replicating pgsql
- PL/PerlU problems executing other scripts
- bolb data type
- Temp tables and copy
- Question about conccurrency control and Insert
- How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
- Constructing column from different individual fields in same row.
- SUMMARY mysql -> psql
- State of Beta 2
- Find overlapping time intervals, how?
- Kill -9 Postmaster and Temporary Tables
- Adding header nam to any table
- Help needed in Replicating pgsql
- PL/PerlU problems executing other scripts
- bolb data type
- to_timestamp and to_date fails in postgresql 7.1.3
- Temp tables and copy
- arbitrary data scheme
- How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
- Find overlapping time intervals, how?
- to_timestamp and to_date fails in postgresql 7.1.3
- arbitrary data scheme
- Kill -9 Postmaster and Temporary Tables
- do child tables inherit indexes?
- encoding again
- any chance of "like ANY (array[])" like the "= ANY (array[])" syntax?
- Picture with Postgres and Delphi
- Oracle and regular expressions ???
- ECPG bug or development choice
- German special characters Problem
- mysql create table -> psql
- SRF question
- Views and Limits
- Good open source mailing list system PHP / Postgresql
- Another pimple on the type system
- inserting an apostrophe
- SRF question
- compiling libpq without 'main'
- Cannot createdb
- Inquiry From Form [pgsql]
- How do I unsubscribe
- why does count take so long?
- Can I use PostgreSQL to develop a self-organizing database system?
- Code insertion
- Unix domain instead of TCP socket connections with JDBC.
- v7.4b2 : How can I use COMMENT ON for Large Objects ?
- Does "vacuum analyze" contain "vacuum"?
- 7.4 binary version
- Reasonable Configuration
- Needed function IF(expr, expr, expr)
- ODBC Issue
- decrypted pwd
- Grant and wildcards
- aggregate function
- C functions
- Left join
- Detailed error message information
- Inquiry From Form [pgsql]
- unique heritage
- default EXECUTE privilege
- Views with Where Clauses
- Problem with to_date/to_char
- Pagination - 1 or 2 queries?
- notify problem
- Seq scan of table?
- Backup?
- searching archives should be a weeeee bit faster ...
- More than 1024 connections from the same c-client
- FYI: Avoiding write conflict errors in MS Access clients
- postmaster processes
- IP from conexion
- Activate Index
- tsearch2 and unexpected exists
- Change connection (IP, or Databasename)
- WHERE boolean = true -> failure
- Missing system views?
- Replaceing records
- More than 1024 connections from the same c-backend
- descending Indexes
- PLPGSQL
- FATAL 2: open of /var/lib/postgres/data/pg_clog/0004 failed: No such file or directory
- The following statement now fails on 7.3.4
- table constraint or trigger?
- XA Resource Manager
- automatic update
- Query
- Crosstab function Problem
- Use of oids
- Index not being used ?
- setting last_value of sequence
- Inquiry From Form [pgsql]
- [SOLVED] Socket command type E unknown
- TCL trigger doesn't work after deleting a column
- How many memory size takes numeric(3,0) ?
- OffsetNumber offnum (LOCKTag)
- is it possible to do this? have a subselect that returns two columns
- Access to an element of array NEW in TCL
- identifying rows locked in row level locking
- identifying rows locked in row level locking
- syntax error in eRServer.pm line 69
- What is the good equivalent for ENUM ?
- Recursive Selects
- Output from PLPGSQL
- ERROR: PLPGSQL does not exist
- Localization (for dates) Oracle vs. Postgresql
- Oracle decode Function in Postgres
- pg_dump incorrect sequence value
- Debian Woody 7.3.4 packages?
- Querying $libdir
- Comparing dates
- how to call a TCL function from within a plpgsql trigger?
- Tomcat Connection Pool?
- web hosting postgres
- Pass parameters to a TCL function
- identifying each individual tuple locked
- Table name lengths...
- Any way to Convince postgres to push join clause inside subquery aggregate?
- absolute value fro timestamps
- segfaults / backend crashing
- postmaster segfault with tsearch2?
- LAST_DAY Function in Postgres
- Problems with GRANTING SELECT to a table
- ADD_Months Function in Postgres
- automatic update
- pgadmin3 on Gentoo
- Optimizer picks an ineffient plan
- adding SERIAL to a table
- sort ignoring the, a, ...
- Field collection in trigger
- Field collection in trigger
- French translation
- Where is the tool to migrate a mysql db to a PostgreSQL db ?
- delivering database stand-alone
- Getting last inserted SERIAL
- Prevent from Deletion
- how to group by a joined query?
- About GPL and proprietary software
- SELECT Question
- cursor bug
- Database corupption on pg 7.3.3
- Btrieve
- Commercial postgresql
- Drop All Foreign Keys ? PostgreSQL 7.2.1
- After install 7.3.4, I got a 7.3.3 ver. no?
- pg_autovacuum
- psql buffering
- view function details
- Errors sending Blob to DB
- LOCK.tag(figuring out granularity of lock)--
- Optimizer isn't perfect
- Errors sending Blob to DB
- PostgreSQL upgrade -> fails to start server
- Visual database structure browser for postgresql?
- Unsubscribe from the list
- Install PostgreSQL on AIX 5.1
- Join question
- backends
- Vacuuming and already vacuumed table?
- erserver 1.2 problem
- left outer join terrible slow compared to inner join
- Date Time Function / Age
- Arrays and Indices / Foreign Keys
- Problems with transactions and sequences
- Database Replication
- tsearch: how to get a list of stopwords?
- Problem with tsearch and stopwords
- mysql to pgsqwl migration
- Problem compiling tablefunc module in contributions
- postgres vs mysql
- Question Join/Subselect
- before trigger problem
- Localization Oracle vs. Postgresql