View Full Version : postgresql answers
Pages : 1 2 3 4 5 6 7 8
[
9]
10 11
- Making a tree with "millions and millions" of dynamic nodes
- bytea -> text
- Error in select
- C Programming with postgres.h - my function crashes the database backend
- Invalid page header in block
- How to obtain the real problem that avoids postgresql service starting?
- PG_DUMP question
- Hostname of server
- fmgr_info: function 7390843: cache lookup failed
- perl(Pg) (S)RPM
- pg_dump on one user not whole database
- Storing passwords
- Specify a column without using its name
- I need your help. I'm confused with the files ...
- grant not working on pg_class
- Undropping a column?
- XML & Postgres Functions
- Postgresql sql query - selecting rows outside a join
- UNICODE problem on 7.4 with COPY
- Feature Request for 7.5
- PostgreSQL from a newcomers perspective
- Bug or Feature - plpgsql odity
- Pg module for Perl
- Upgrading from 7.2.3 to....??
- pg_hba.conf problem
- Equivalent to DBMS_JOB
- permission errors for set authority and schema public
- Drop Cascade of Domains
- Domains and function
- After upgrade 7.2.1 to 7.4 "ERROR: large object ... does not exist"
- [pg 7.4 / Solaris 8] Could not bind socket for statistics collector
- Executing Shell Command
- Restore-point?
- Restore-point?
- help transfer ring blobs using perl
- renaming a database
- cross table indexes?
- Try these internet package from MS
- plpgsql string concatanation
- ip of the user doing an insert
- Convert integer to sql server datetime
- XQL and PostgreSQL
- 7.3.4 and 7.4 ORDER in queries
- Postgresql on file system EXT2 or EXT3
- passing function's output into C function
- CREATE TYPE in Postgres 7.3.4
- Proposed project: Multimaster, synchronous replication system
- Happy Thanksgiving!
- disaster recovery
- MS-Project 2000 data into a Postgresql database
- [Fwd: [Gllug] Next GLLUG Meeting, 6 December 2003]
- GnuPG / PGP signed MD5 and SHA1 checksums for PostgreSQL 7.4.0
- rules and return values question
- aggregate generic ANYARRAY
- Tweak postgresql ODBC driver
- pg_dump table schema ...
- postgres metadata
- marking record origin in views
- cross table indexes?
- TIMEZONE not working?
- Java Strings and quote marks
- plpgsql question
- performance versus order of fields in row
- inheritance help
- ERROR: get_typdefault
- (No Subject)
- bug?!: lower() breaks unicode
- PostgreSQL is much faster than MySQL, only when...
- duplicate primary key entries?
- Can I get rid of the schemas?
- What is WAL used for?
- Help, Australian Time Problem
- get_typdefault: failed to ...
- Cron-job for checking up on pg_autovacuum
- Index on array element
- configure --with-java fails
- RPM RH9.0 conflict with unixODBC
- PostgreSQL certifications?
- patch for pg_autovacuum
- fairly serious bug with pg_autovacuum in pg7.4
- The new autovacuum tool
- SRPM (PGDG) will not build
- pam authentication for postgres
- SQL text of view
- autocommit in 7.4
- Lock strategies!
- Declaring empty, non-NULL array in plpgsql
- rounding timestamps
- The python module?
- 7.4 Python configure hosed
- 7.4 Docs in PDF format
- partial uniqueness
- updated linux startup script?
- array iteration?
- error loading shared libraries: libpq.so.3
- Connecting Openoffice Postgres
- Invalid page header in block xxxx
- Silent truncation of numeric values.
- Open source data modeling tools for PostgreSQL
- question about error message
- Problem with 7.4 RPMS for Fedora Core 1
- Foreign Keys
- Pg Dump error
- Can't initdb, libdir points to static location
- FWD: Take a look at this critical patch
- Where is Postgesql ? - MYSQL SURPRISES WITH MAXDB / MySQL appliance forLinux arrives
- Execute vacuum
- Bug in pg_dumpall
- linking postgre to AD
- Concatenation in SELECT
- tsearch2 column update produces "word too long" error
- Concurrent testing PostgreSQL Vs MySQL
- Modelling Oracle Sequences
- why ORDER BY works wrong in pg7.3.4?
- PGSQL on shared hosting
- postmaster PANIC?
- SuSE PostgreSQL 7.4 RPMS
- Psql bug?
- SELECT 'pg_catalog.pg_class'::regclass::oid
- rounding timestamp
- tsearch2 installation
- lo_import for bytea columns
- pg_hba.conf change in 7.4
- Multiuser testing -- PostgreSQL 7.3.4
- error durring compilation
- tsearch2 installation
- ripe whois server and postgresql
- lo_import for bytea columns
- ERROR: nodeRead: did not find '}' [x2]
- pg_hba.conf change in 7.4
- "Transaction over connections"
- error durring compilation
- Multiuser testing -- PostgreSQL 7.3.4
- SELECT Question
- ripe whois server and postgresql
- Is it possible to find a size of a table
- Is it possible to find a size of a table
- Is it possible find a size of a table
- ERROR: nodeRead: did not find '}' [x2]
- Export CSV from psql
- "Transaction over connections"
- Pg_dumpall problem
- Two rules on a view do not like each other :-(
- SELECT Question
- Is it possible to find a size of a table
- Is it possible to find a size of a table
- Is it possible find a size of a table
- Export CSV from psql
- ERROR: nodeRead: did not find '}'
- pg_aclcheck: invalid user id #
- Pg_dumpall problem
- Two rules on a view do not like each other :-(
- Japanese and PostgreSQL
- ERROR: nodeRead: did not find '}'
- pg_aclcheck: invalid user id #
- core dump
- Japanese and PostgreSQL
- core dump
- Wanted: Trick for granting permissions to users with hyphens
- Wanted: Trick for granting permissions to users with hyphens
- exclusive access
- 7.4 broke psql
- Problem with exec sql include
- defferable update & unique
- Optimizing query
- Tunning postgresql
- Seeking concise PL/pgSQL syntax diagram
- 7.4RC2 vs 7.4
- AUTOCOMMIT didn't work...
- SQL text of view
- Better Unilization of Memory
- unix_socket_directory not fully recognized by pg_ctl?
- Query Planner Filtering Of Specified Value From 'On Distinct' Clause
- problem running postmaster
- indexing with lower(...) -> queries are not optimised very well - Please Help
- Lock questions
- 7.4RC2 --> 7.4
- support
- Debian packages of 7.4
- pgAdmin3 [pgAdminIII] installation SUSE9
- Array syntax
- Error during check
- Quoting Problem in PLPGSQL
- how to get historical data?
- PLPGSQL Returning Records
- building 7.4 with plperl
- Detaching from controlling terminal
- Stuck processes, viewing the queries inside
- tracking down temp files
- SuSE RPMs available for PostgreSQL 7.4
- PostgreSQL v7.4 Released
- pg_constraint missing many entries?
- snort, acid and postgres
- MultiByte Columns?
- Move a table to another schema
- Take a minute to make yourself heard ... (PostgreSQL vs ...)
- Alternative cluster location
- Market Research on Open Source Database Management Software?
- MultiByte columns
- Retoring non-administrative user databases
- how to find version?
- vacuum from ecpg
- Help with quote escaping in plpgsql
- Grant alter privileges
- What are these files about?
- Updated Documentation
- UPGRADING 7.1 TO 7.3.4
- Storage consumption
- about serial
- Can Postgresql run under Windows?
- Loggin SQL Statements from JBOSS/JDBC
- Conservation of OIDs
- Error on initdb with 7.4RC2
- Restoring From pg_dumpall (SOLVED)
- Restoring From pg_dumpall
- GUIDs
- Database Corruption ?
- Determine if a string is digit
- 64 bit compile on Linux SPARC U5
- More Praise! 7.4
- DOMAIN usability
- Curious about exclusive table locks
- embedded postgresql
- plpgsql return setof integer?
- PL/PGSQL functions suddenly not working
- how can I change a btree index into a hash index?
- serial type vs. sequences
- pl/perl function life and variable scope - concurrency problem?
- using NOLOCK cause Cartesian joins
- dumping sequences
- Column Sizes
- Perfomance difference between 7.2 and 7.3
- Problem with FKEYS
- plperl/createlang issue
- Failure of make for 7.3.4 on Mac OS 10.3 Panther
- More Praise for 7.4RC2
- update slow
- change conndeferrable in pg_constraint?
- PGexec dumps core at pqResultAlloc
- Postgre Architecture
- procpid in pg_stat_activity but no correspoding backend
- Locks information
- Proposal for a cascaded master-slave replication system
- Functional index definition
- RHEL
- Changing xml in a database
- multibyte support
- Problem with create index
- ALTER TABLE ADD UNIQUE .....
- psql version mismatch
- PostgreSQL v7.4 Release Candidate 2
- PL/Perl returning multiple rows
- Try internet update from MS
- [off-topic] Bugtracker using PostgreSQL
- Two build problems - openssl and plperl on RedHat
- Visual C++ and Postgres
- case-sensitive sorting and locale settings?
- Dynamic expression evaluation
- PGSQL technical documentation
- PL/PGSQL help for getting number of rows matched.
- starting the server at boot
- drop user question
- Problem Deleting Referenced records
- Tables spanning db's in cluster
- disk access measurment
- FrontRange GoldMine w/ PostgreSQL
- Questions from a beginner!
- phpPGAdmin Indexes, what does this do?
- Optimiser desicion bringing system to its knees?
- Question on Select
- SQL-question: returning the id of an insert querry
- Tools are disabled, except connect & disconnect
- Problem in restoring data
- Converting SQL-ASCII encoding database to UNICODE
- Help With date/time
- performance: time & disk access measurment
- Question on Replication
- BUG?
- postgresql ODBC for Windows!
- PostgreSQL, Postgre and Apple
- pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'
- Problem creating ROWTYPE variable in plpgsql.
- Referencing columns from system tables possible?
- why does explain tell me I'm using a seq scan?
- regarding constant values
- phpPGAdmin Indexes, what does this do?
- Temp rows - is it possible?
- German mailing list
- Visio Like Tool....
- error when creating rule
- DDL for a single schema
- Changing the buffer size
- Database of electoral results?
- on connect trigger?
- on connect trigger
- int8 primary keys still not using index without manual JDBC driverpatch (7.4RC1)
- pg_stat_activity
- Optimiser desicion bringing system to its knees?
- create function for trigger question
- pid of current session?
- Insert and obtain the pk
- Install files for version 7.4
- Default user after upgrade to 7.3?
- Fixed column format data
- New eRServer patch/fork release
- INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE COLUMNS
- Sequences without blank holes
- Problems with PLPGSQL
- PostgreSQL v7.4 Release Candidate 1 compile errors
- SQL_ASCII encoding
- Select for update and locking problem
- Multi-master asynchronous replication
- tsearch2 and gist index bloat
- Getting time from date field
- Question on database structure
- Database Design & Application Server Design
- invalid command \
- How to store pg_constraint's int2[] data type in C++
- System crash and trying to run vacuum getting errors
- How to know column constraints via system catalog tables
- SET AUTOCOMMIT OFF
- select/update performance?
- Changes in Rel. 7.4
- Calculating default values on insert?
- access linux command from SQL Query
- question
- Using SUBSELECT in CHECK expressions
- Foreign Key to Inherited table
- PostgreSQL v7.4 Release Candidate 1
- Problem with Pg_dumpall
- Databases with different encodings
- Very strange selectproblem
- pg7.3.4: pg_atoi: zero-length string
- SELECT question
- now() problem
- Obtain boolean value of expression in PLPGSQL
- Query to pg_stat_activity
- C functions quicker than Plpgsql?
- transposed query?
- question
- How to use dblink within pl/pgsql function:
- Internet based database
- slow down on UPDATE using IN statements
- plpgsql question
- Please help
- PostgreSQL License Question
- IF EXISTS?
- How to set up a table where 2 columns together must be unique?
- Install that security package from Microsoft
- AS operator and subselect result names: PostgreSQL vs. Oracle
- further ino on bigint index and vacuum issues?
- Request for Interview Candidates - PG Research Help
- COPY
- Altering columns order
- help from Portugal
- sql trees move some element
- trim(ing) during load process
- org.postgresql.PG_Stream.flush(PG_Stream.java:356)
- Where are the database files located?
- Attribute 'rtrim' is repeated
- table locking.. FK tables locking on insert
- Pictures from LinuxWorld Expo in Frankfurt
- problem with huge joins
- Problem with ecpg
- Error Messages / Codes in DBD / JDBC
- ALTER Table
- ATA disks and RAID controllers for database servers
- insert data of composite type
- Table Copy/Synchronization
- DBD::Pg Err / Errstr
- Trigger or Rule ?
- Tsearch2 indexing question....
- Best Perl Option?
- database speed
- Need Italian Help!
- regular backups - super user
- formatting of SQL sent by PHP to postgres
- slow query performance
- Sending email from PL/pgsql
- tsearch ukrainian stemmer dict
- nextgencms
- sql trees move some element
- INSERT performance
- duplicates rejected by index reports PGSQL_FATAL_ERROR
- pg_ctl vs full restart
- Statistics on database structure changes
- dump schema schema only?
- Trigger delete
- backup another server
- pgAdmin vs SQL Server Enterprise Manager
- Database design question: ugliness or referential integrity?
- Cartesian product bug?
- N Texas PostgreSQL Consultant Needed
- Error size varchar
- selecting information from two tables (problem)
- Help on update that subselects other records in table, uses joins
- PG_RESTORE/DUMP Question
- Performace question
- slow query performance
- JDBC DatabaseMetaData problem
- Viewing linked large postgres tables with Access: Running out of memory
- Versioning control in PostgreSQL?
- SELECT with row>32k hangs over SSL-Connection
- Stored procedures from MS Query
- retrieve statement from catalogs
- unsubscribe
- What is an RT index?
- Multiple database services and multiple versions on Red Hat Linuxsystems
- sequences: cache_value, log_cnt, is_cycled columns
- connectby
- Queuing in Post
- Replication again
- table functions + user defined types
- function with tablename parameter
- Experience with PL/xx?
- Slow query
- foxpro to postgresql7.1
- Question about the Internals
- can't get tcl installed properly
- Retrieving a column comment
- Question regarding Perl, DBI, and fork()
- Casing: bug?
- Problems using PGAdmin III
- Slow performance with no apparent reason
- incrementing and decrementing dates by day increments programmatically
- explicit casting required for index use
- no records returned
- Performance failure / automatic restart / cron ?
- interesting quote...
- DBD::PgPP::CursorResponse
- partitioning
- where to find minor release info
- ./configure error - readline library not found
- extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax
- Index Usage Question
- Timestamp and interval precision
- unsubscribe
- shared memory on OS X - 7.4beta4
- ERROR: Multiple assignments to same attribute... ??
- FW: Check the patch from MS Corporation
- Desperate help needed for Replication
- Hierarchical query's
- Clustering for performance and fail over
- HTML generation with PL/PgSQL
- CLUSTER
- Nullable 'Foreign Key-like' Constraint
- Setting up DSPACE for Postgres access
- Timestamps in Views
- PostgreSQL v7.4 Beta5 Available for Testing
- Indexes and querys
- database files
- Adding fields on the fly
- setArray
- Prepared Statements
- plpgsql extract epoch problem
- SCSI vs. IDE performance test
- Atrybutes ???
- poor cpu utilization on dual cpu box
- (NONE)
- Trigger
- Identifier max length
- Postgreqsl & Package
- Same conditions, different planning?
- unexpected query behavior with UTF text
- where is pg_views
- Cast result set of select into an array for a sub select...
- pg_clog / pg_xlog corruption?
- Proposed structure for coexisting major versions
- max() over some rows but grouped, within one view def - how ?
- DBDesigner for Linux
- Simple SQL
- About TSearch2 Performance
- jboss postgresql pk generation
- lastval(seq) ?
- Timestamp to date conversion...plz help me
- create triggers.
- Help or Bug?
- pgsql error - situation update
- (no subject)
- Pgsql 7.3.3 on redhat 7.2
- Pgsql 7.3.3 on redhat 7.2 machin
- postgres 7.3.3 on redhat 7.2
- how to use pg_resetxlog
- tsearch2 and aspell
- Recomended FS
- Quick quote for Install
- Numeric type
- Cannot create new link. Too many open links
- tsearch2 question...
- Dilbert Experiences a 'Database Manager' moment
- convert string function and built-in conversions
- plpgsql
- Timestamp to date conversion...plz help me
- 7.4b4 domain usage and select question
- plpgsql: return multiple result sets
- How to quote text before inserting into database?
- Postgres seems to BE on windowsXP
- using cygwin for postgres
- How to activate error messages in my language
- Difference between check and a small table
- selecting table at execution with PL/PgSQL
- Help or Bug?
- restart and postgres.conf
- Using subselects in INSERTs?
- Perl and Postgres
- basic question
- ecpg and blob's
- connecting to external database tables outside of the postgres database
- XOR logical operator
- Disabling referential integrity
- pg_atoi
- Remote updating
- maximum number of client connections?
- problem with function to report how many records were changed
- ShmemAlloc errors
- Maping Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght)
- easy way to insert same value into 2 columns
- Lost views in a PostgreSQL 7.1. dump file ?
- When to use an array datatype?
- UPDATE table to a joined query...
- Damaged table
- Group and grant question
- ODBC
- is possible to read oracle tables from PostgresSQL
- constant time count(*) ?
- Getting error codes for failed queries?
- VACUUM degrades performance significantly. Database becomes unusable!
- Porting Code to Postgresql
- How to Create View
- Triggers tutorial
- Cygwin? or paid version from SRA?
- PostgreSQL article in phparchitect
- Porting Code to Postgresql
- PG clustering
- Indexes?
- How to Create View
- PLPERL function error - utf-8 to iso8859-1
- Triggers tutorial
- Cygwin? or paid version from SRA?
- PostgreSQL article in phparchitect
- PG clustering
- Indexes?
- PLPERL function error - utf-8 to iso8859-1
- Table analyzer
- Error compiling pgplsh
- order by a string
- Table analyzer
- Error compiling pgplsh
- converting varchar date strings to date
- order by a string