View Full Version : postgresql answers


Pages : 1 2 3 4 5 6 7 [8] 9 10 11

  1. postmaster growing to consume all memory
  2. Embedded transactions
  3. crlf and copy
  4. how to enumerate rows ?!?
  5. pg_largeobject and oid mistmach after restore
  6. Executing a query and returning the result set using the SPI
  7. Where is initdb?
  8. Global variables for plpgsql stored procedures
  9. Casting varchar to interval.?
  10. Storing Configuration settings for a database?
  11. About Privileges
  12. Object Relational features in PostgreSQL
  13. COPY, \\copy, and "\357\273\277"\n ^
  14. Multiway associations
  15. I can't upgrade to PostgreSQL 7.4 in RedHat 9.0
  16. on cascade set null works on not null columns
  17. Is there something like an dynamic view ?
  18. pl/pgsql docs 37.4.3. Row Types -- how do I use this function?
  19. force drop of database others are accessing
  20. Calling triggers with arguments
  21. If table A value IS NULL then table B
  22. business references for postgresql
  23. sequence in schema -- broken default
  24. Optimizing SQL: bind variables, prepared stms, histograms
  25. Upcoming events
  26. Nearby zipcodes from a point
  27. psql: relocation error: psql: undefined symbol: PQgetssl
  28. Parsing bug?
  29. regex in plpgsql function
  30. LIVE Coverage of LinuxWorld Conference & Expo | LinuxWorld - where isPostgresql
  31. Want a job?
  32. trust auth in 7.4
  33. Why does the sequence get out of sequence?
  34. varchar_pattern_ops in 7.3.4?
  35. Lost plpgsql function
  36. Question and search for ODBC related postgreSQL questions
  37. Update inside (Insert) Trigger and Unique constraint...
  38. What is holding a connection open.
  39. tablespaces a priority for 7.5?
  40. Compiling postgres-7.4.1
  41. Linux Magazine/Postgres Article
  42. postgresql + apache under heavy load
  43. Idle connections - Too many clients connected already
  44. Ending transaction inside stored function
  45. CTTAS w/ DISTINCT ON crashes backend
  46. SCO Extortion
  47. Referencing subselect returned value
  48. PostgreSQL and Datawarehouse tools
  49. Accessing template0 tables
  50. postGresql Consulting ??
  51. Recursive optimization of IN subqueries
  52. Transaction id
  53. ORM, XPath, and pgxml_dom segfaulting
  54. Alternative to ODBC ?
  55. JDBC Driver moved to gborg.
  56. Can't backup! pg_dump/pg_restore not updated with 7.4.1
  57. Getting rid of duplicate tables.
  58. How to get the requested columns in a rowtype PL/pgSQL function
  59. Attaching files to the database.
  60. Converting from Progress 4GL and DBMS
  61. Very long time to commit or close connections
  62. Introduced PostgreSQL for Windows
  63. Integer ranges in PostgreSQL
  64. Tool to ease development of plpgsql
  65. Tool to ease development of plpgsql
  66. Great change (size of data dir) upgrading postgresql
  67. computed field on a table
  68. Using a Makefile during database development
  69. importing data
  70. Automatic joins?
  71. Automatic joins?
  72. massaging data from multiple timezones
  73. How should I get started?
  74. 7.4 -> 7.4.1 upgrade with customization on freebsd
  75. I got bit by that darn GEQO setting again...
  76. error creating sql function
  77. Tool to ease development of plpgsql
  78. UNICODE-encoded database does not accept umlaut-characters.
  79. Postgresql reporting tool
  80. Potential Problem with PostgeSQL performance on SuSE Linux 9.0
  81. User-specific sequences
  82. plpythonu AKA am I crazy? or....
  83. Problems with \copy and delimiters ','
  84. simple tree in postgress
  85. Adding long text to a database text field generates errors
  86. FAQ (disk space)
  87. serverless postgres, embedded firebird, etc.
  88. Creating GUID
  89. How to become a Windows beta-tester?
  90. Index space reusable?
  91. check date validity
  92. tinterval operators and functions
  93. how to catch the error in procedure ?
  94. transactions in c api (libpq)?
  95. User-specific sequences...
  96. What Version Installed?
  97. why isn't TEXT a key word?
  98. Survey: Motivations to Contribute
  99. How should I get started?
  100. CASE SELECT syntax
  101. Bytea/Large Objects/external files best practices
  102. Bytea/Large Objects/external files best practices
  103. problem starting postmaster as a service
  104. Foreign key question
  105. Returning large select results from stored procedures
  106. parse error in function
  107. fixed-length row
  108. YAGT (yet another GUID thread)
  109. postgresql Error handling in client app
  110. Log_statement behaviour a little misleading?
  111. about postgres odbc on wondows
  112. pg_dump/pg_restore problems with 7.4.1
  113. best practice for use of functions..
  114. Errors after power failure
  115. FW: Postgres: VACUUM
  116. Postgres: VACUUM
  117. Max registers in postgresql 7.4
  118. Quoting for a Select Into - Please Help
  119. Collate is not supported for 7.4
  120. Rights in 7.4
  121. Schemas not created on restore
  122. Detecting database corruption
  123. Using regular expressions in LIKE
  124. Huge Data
  125. Optimising SQL Queries?
  126. COPY FROM STDIN
  127. casting parameters to a function
  128. 7.4.1 packages for RHEL2.1
  129. Incremental Development
  130. serverless postgresql
  131. Trigger Question
  132. Testing Email
  133. dump/restore problem
  134. Error since powerouttage
  135. Error since powerouttage
  136. Nested transaction - I am a bank ??
  137. Pl/Perl speed
  138. sequence incrementing twice
  139. Nested transaction - I am a bank ??
  140. pg_catalog permission problem
  141. Postgress and MYSQL
  142. Best practice? Web application: single PostgreSQL user vs. multipleusers
  143. Best Practice for incremental development
  144. Any real known bugs about wrong selects?
  145. Nested transaction workaround?
  146. Updating the owner of a function
  147. Reallife szenario for GEQO
  148. Help with indexing!
  149. Parse error help needed...
  150. sql insert function
  151. qq- repost
  152. qq
  153. Column qualifier issue
  154. Vacuum Error
  155. Dump/Restore ordering problem?
  156. Connecting using an existing socket (libpq).
  157. unsubscribe
  158. unsubscribe
  159. Granting all table in one command
  160. Dump tables with pg_dump - no or different Owner
  161. Error with tablefunc in postgres 7.4.1
  162. insertion with trigger failed unexpectedly
  163. Precedence of a TRIGGER vs. a CHECK on a column
  164. Compile postgre 7.1 on Redhat 9?
  165. SRF in C
  166. ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index
  167. what we need to use postgresql in the enterprise
  168. how do I get the primary key
  169. How are NULLS stored on disk for PG 7.4?
  170. Using indices with long unique IDs.
  171. Is Mysql Gaining?
  172. Drawbacks of using BYTEA for PK?
  173. CHAR(N) storage requirement
  174. Case sensitivity
  175. psql's "\d" and CLUSTER
  176. Any way to SELECT a list of table names?
  177. Bug with rename bigserial column
  178. Bug in functions returning setof where table has dropped column?
  179. query should use an index?
  180. Query string is too long
  181. unsubscribe
  182. OIDS and its limitations
  183. ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index
  184. Why does this use of accents in psql fail for a Unicode database?
  185. no space left on device
  186. Hierarchical queries
  187. TSearch2 ... ignore word repetition for rank
  188. deferring/disabling unique index
  189. Invalid UNICODE character sequence found(0xc000)
  190. problems dumping from one server 2 another
  191. array faults?
  192. Trouble with MsAccess and records above 13000
  193. Using indices with long unique IDs.
  194. Natural upgrade path for RedHat 9?
  195. Using indices with long unique IDs.
  196. RedHat install question.
  197. SPI question: trying to read from Large Objects from within a function
  198. Simulation output using libpq
  199. full db locking during dump
  200. encrypt
  201. vacuum
  202. int8 version of NUMERIC?
  203. beginner query help
  204. 7.4, 'group by' default ordering?
  205. deferring/disabling unique index
  206. why I can call pg_stat_get_backend_idset directly
  207. Simulation output using libpq
  208. 7.3.3 drop table takes very long time
  209. order by is ambiguous
  210. Optimize query: time of "single * IN(many)" > time of "many * IN(single)"
  211. Compile problem on old Debian Linux with glibc 2.0.7
  212. Open Source Database Rankings
  213. Perl and Python modules problem
  214. Oracle -> Postgres live translation?
  215. Problem with rserv replication
  216. pg_stats question
  217. PHP arrays and postgresql
  218. VACUUM VERBOSE ANALYZE does not work on 7.4.1
  219. 64 Bit Postgresql ports
  220. The script kiddies are busy again ...
  221. Find original number of rows before applied LIMIT/OFFSET?
  222. deadlocks - sharelocks on transactions
  223. Reparse PL/pgSQL Function?
  224. Loading a dumped databse from cd
  225. SPI question (or not): trying to read from Large Objects from within a function
  226. problems with transaction blocks
  227. Query performance question on a large table
  228. DBs and Schemas
  229. Postgresql & 64 Bit Opteron
  230. unsubscribe
  231. create template database
  232. pg_dump and client_encoding
  233. cross-table unique constraint
  234. MVCC for massively parallel inserts
  235. Date column that defaults to 'now'
  236. forking postmaster on my own - not as pguser
  237. plpgsql.so?
  238. release notes/Appendix E in documentation
  239. Slow Performance with 7.4.1
  240. unsubscribe
  241. 7.4.1 Server Not Starting?
  242. History-based (or logged) database.
  243. PostgreSQL 7.4.1 incredibly slow :-(
  244. Cursor Not Found
  245. Anything akin to an Evaluate Statement in Postgresql?
  246. Scripting a new db server setup
  247. Postgresql Errors over ODBC
  248. TPC-C and Postgres
  249. replication choices
  250. Functions Returning Record Datatype
  251. Network Problems over past 48hrs
  252. Foodmart2000 sample database
  253. license issues
  254. license issue
  255. license issue
  256. Passing a comma delimited list to a function
  257. BUG: compiling PL/Python - Semi-SOLVED
  258. Any way to have CREATEUSER privs without having all privs?
  259. 7.4 ERROR: CREATE LOCAL TEMPORARY TABLE ... ON COMMIT DROP inside a function
  260. 7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work
  261. pull_up_subqueries question
  262. Help with PostgreSQL porting project
  263. why the need for is null?
  264. Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1
  265. GetLastInsertID ?
  266. how to read db schema with php
  267. speeding up inserts
  268. measuring disk usage of records
  269. finding my schema (for sequences)
  270. Binaries (rpm) for SuSE 9.0...
  271. Bug and/or feature? Complex data types in tables...
  272. Replication ?
  273. What does count(*) count?
  274. 7.4.1 RPMS
  275. Quotes in dynamic sql
  276. 7.3 dump into 7.2 (my solution)
  277. 'like' refuses to use an index???
  278. Where can I find the "Contrib" page on the PostgreSQL site?
  279. Problem with ecpg
  280. ERROR: cache lookup for type 0 of ... pg.dropped.14........ failed
  281. md5sum function for debian 7.3.2
  282. Any way to disable backslash as a string literal escape character?
  283. PG_Autotune
  284. Select Non Alpha Contents of a Column
  285. website doc search is extremely SLOW
  286. Building dynamic contents from database
  287. Building dynamic contents from database
  288. Out of memory error when doing an update with IN clause
  289. An out of memory error when doing a vacuum full
  290. altering a column
  291. case insensetive UTF-8
  292. phppgadmin, pkey's and indexes
  293. pg_recvbuf errors
  294. simple auto-updating timestamp ?
  295. what about uniqueness of inherited primary keys
  296. Change onership of database and all tables?
  297. Max length of SQL statement
  298. Time varying referential integrity
  299. comparison: smallint & 2^extract(dow from date)
  300. RPM for RedHat 7.0?
  301. dump 7.3 into 7.2?
  302. pg_ctl logfile rotation not working?
  303. Nested Transactions in 7.5??
  304. between
  305. Is my MySQL Gaining ?
  306. Photos of PostgreSQL booth
  307. Postgresql 7.4.1 Compile problem for SCO 5.0.5
  308. Installing Postgres w/RH9
  309. Where do I get Windows libpq and header files?
  310. Parser does not like %ROWTYPE in the RETURNS clause of a function declaration (BUG?)
  311. SELECT INTO broken (?) in PL/pgSQL when using a set returning function in FROM clause (BGUG?)
  312. getting configure options?
  313. PostgreeSQL C header files
  314. getting configure options?
  315. Mirrors that don't suck.
  316. PostgreeSQL C header files
  317. Join Tutorial
  318. Mirrors that don't suck.
  319. ecpg question
  320. PostgreSQL 7.4.1 Released
  321. Join Tutorial
  322. COPY - Ignore Problems
  323. Parser: parse error - please help...
  324. Normalization and regexp
  325. CHECK versus a Table for an enumeration
  326. hardware requirements under Redhat
  327. ecpg question
  328. postmaster and logrotate
  329. PostgreSQL 7.4.1 Released
  330. COPY - Ignore Problems
  331. Parser: parse error - please help...
  332. Normalization and regexp
  333. CHECK versus a Table for an enumeration
  334. hardware requirements under Redhat
  335. postmaster and logrotate
  336. How to hide database structure
  337. restoring database
  338. extracting date FROM timestamp
  339. Tables Referencing themselves As Foreign Keys
  340. questions about tsearch2 (for czech language)
  341. Groff and Weinberg SQL Complete Reference - Sample database?
  342. bug in query planning?
  343. Where can I learn some more about the rule system?
  344. FEATURE REQUEST: let arrays support null values.
  345. Please remove me from the list, thanks
  346. SELECT ... FOR UPDATE
  347. MySQL Gets Functions in Java - Enlightenment Please
  348. Tables referencing each other
  349. DB & Log Files removed...
  350. Regarding Start of postmaster
  351. automatic verifications
  352. dblink_connect fails
  353. 7.1.3 ecpg
  354. PostgreSQL speakers needed for OSCON 2004
  355. Salvage older PostgreSQL data disk - help?
  356. automatic verifications
  357. Select groupping by one column
  358. Has anyone seen an ADO Provider for Postresql?
  359. Duplication to External Server
  360. authentication failed
  361. performance in selecting from very large recordset
  362. How to navigate tree without CONNECT BY?
  363. pqReadData() -- read() failed: errno=32
  364. Which file system do i have to choose?
  365. BLOBS : how to remove them totally
  366. param max_connections
  367. Check this update from the MS
  368. Function Returning SETOF Problem
  369. Triggers for FK on Views - can they be made deferrable?
  370. bind-dlz with postgresql driver ...
  371. Permissions issue?
  372. Deadlocks with plpgsql
  373. copy command problem
  374. Excel, OpenOffice and Postgres
  375. Need to understand PL/PGSQL, Foreign Key Deferable, and Transactions...
  376. md5 function
  377. Sequence name with SERIAL type
  378. restore error - language "plperlu" is not trusted
  379. Sequence question.
  380. Join Issues
  381. update slows down in pl/pgsql function
  382. 7.4 pg_dump and restore (with postGIS/GEOS)
  383. Firebird and PostgreSQL at the DB Corral.
  384. DB with bytea types reload problem
  385. selecting into a variable like @var=select ...
  386. Authentication Question
  387. Postgres respond after toomany times to a query view
  388. passing array as argument and returning an array in plpgsql
  389. UTF support in WIN32 native and Lower/Upper in 7.5 release
  390. Foriegn Key constraints not enforced when using rules
  391. DBF to PostgreSQL
  392. besides dbfdump........ HOW TO DUMP!
  393. FW: database failure..
  394. Relational data model dead?
  395. deadlock detected when inserting data
  396. Changing user
  397. LIMIT modifier
  398. PostgreSQL on Windows Server 2003
  399. dump and sequence initilizing
  400. password authentication failed for ..
  401. Snippets
  402. windows distribution
  403. database failure..
  404. Calculating total amounts per clientid
  405. Why is postgres an ORDMS
  406. 7.5 features
  407. Delete all records NOT referenced by Foreign Keys
  408. Windows Version of PostgreSQL
  409. Perl "with-perl" configuration option
  410. Error with table
  411. Reordering results for a report
  412. Change date format only for one DB
  413. Moving the database from a filesystem to another
  414. experiences with postgres in ia64 and linux
  415. remark on a slowdown of COPY
  416. Uninstall postgres 7.4
  417. Build Problem in 7.3.5 version
  418. make error Mac OS X (ar: illegal option -- s)
  419. ERROR: JOIN/USING types 'integer' and 'character varying' not matched
  420. Is it not datestyle that determines date format output?
  421. Foreign keys and pg_user table
  422. Weird Problem With PostgreSQL 7.3.1 and VB.Net Datagrid
  423. tablespaces in 7.5?
  424. ERROR: did not find '}' at end of input node (again)
  425. Storing Snapshot Data
  426. sequences not renamed with tables
  427. Any commercial shopping cart packages using postgresql?
  428. Redhat 9.0 Service Shutdown
  429. Moving a database between servers
  430. datestyle in postgresql.conf, version 7.4
  431. Disabling or forwarding external connections
  432. "PostgreSQL Error Code(1)"
  433. highest match in group
  434. Wird behavour of foreign keys
  435. versions of PG
  436. PG 7.4 on Tru64 UNIX 4.0 + threads
  437. JDBC function call: PS vs CS
  438. Users and session ids
  439. Strange permission problem regarding pg_settings
  440. initdb reporting error.
  441. Determining what a user can access
  442. Help: ecpg bytea and PQescapeBytea()/PQunescapeBytea()
  443. Help with Turning debugging on/off
  444. OO database?
  445. PG and AIX
  446. Casting Point to Text
  447. Reset oid , starting value=1
  448. Shell access & send email from PLPGSQL?
  449. Oracle to PostgreSQL migration
  450. A problem during restoring database from PostgreSql 6.5.3/7.1.3 to 7.4
  451. OO database?
  452. Is the COMMUTATOR clause required for self commutative operators?
  453. Manual record locking
  454. Inheritance and foreign keys
  455. Pg_Dump of schema?
  456. dblink questions
  457. remove
  458. Turning on/off debugging
  459. Planner question regarding functions
  460. Install that update from the Microsoft Corporation
  461. Look at security update for Microsoft Windows
  462. left join is strange
  463. pgsql 7.4 on minimal environment
  464. Where to find information about implementing full-text-search
  465. spelling errors in query terms
  466. dblink questions
  467. CMS with PostgreSQL
  468. GRANT ON C
  469. user defined variable per session
  470. CREATE RULE problem/question requesting workaround
  471. functions/operators with 2 sets as arguments
  472. dblink questions
  473. corruption diag/recovery, pg_dump crash
  474. CMS with PostgreSQL
  475. 7.3 --> 7.4 C Functions
  476. Feedback? Is there interest in a PostgreSQL-based CRM suitefriendly to shared hosting?
  477. ERRORs after upgrade from 7.2.1 to 7.4 about nonexisting large objects
  478. PSQL 7.4 on debian woody
  479. FW: Postgres 7.4 runing on BSD
  480. Stored FUnctions
  481. CREATE TABLE AS COMMAND
  482. 7.4 Crashed... Why?
  483. max_fsm_pages
  484. function to find last day of month
  485. OpenFTS-perl-0.35 released
  486. update time zone in timestamps
  487. how to restart on OS X
  488. Groups vs. Roles
  489. last update time of a table
  490. xor for text
  491. XOR on strings
  492. are cursors necessary?
  493. unsubscribe
  494. transaction in progress
  495. ecpg -e
  496. Shared hosting configuration advice requested
  497. How to download pgsql
  498. postgresql locks the whole table!
  499. question
  500. Async Query Processing on Solaris
  501. bug in 7.4
  502. last update time of a table
  503. Invalid page header
  504. multiple PostgresQL installations
  505. Async Query Processing on Solaris
  506. PostgreSQL 7.3.5 Now Available ...
  507. Pronouncing PostgreSQL
  508. [Fedora Core 1] yum repositories with 7.4?
  509. bytea, index and like operator
  510. C/C++ access with no postmaster running?
  511. postgresql locks the whole table!
  512. Teach Yourself PostgreSQL book
  513. Autocommit to off
  514. autocommit off
  515. Accessing fields in RECORD data type using variables as field names
  516. Cast text to bytea
  517. Transaction Question
  518. Money data type in PostgreSQL?
  519. DBD::Pg problem
  520. Making a tree with "millions and millions" of dynamic nodes
  521. bytea -> text
  522. Error in select
  523. C Programming with postgres.h - my function crashes the database backend
  524. Invalid page header in block
  525. How to obtain the real problem that avoids postgresql service starting?
  526. PG_DUMP question
  527. Hostname of server
  528. fmgr_info: function 7390843: cache lookup failed
  529. perl(Pg) (S)RPM
  530. pg_dump on one user not whole database
  531. Storing passwords
  532. Specify a column without using its name
  533. I need your help. I'm confused with the files ...
  534. grant not working on pg_class
  535. Undropping a column?
  536. XML & Postgres Functions
  537. Postgresql sql query - selecting rows outside a join
  538. UNICODE problem on 7.4 with COPY
  539. Feature Request for 7.5
  540. PostgreSQL from a newcomers perspective
  541. Bug or Feature - plpgsql odity
  542. Pg module for Perl
  543. Upgrading from 7.2.3 to....??
  544. pg_hba.conf problem
  545. Equivalent to DBMS_JOB
  546. permission errors for set authority and schema public
  547. Drop Cascade of Domains
  548. Domains and function
  549. After upgrade 7.2.1 to 7.4 "ERROR: large object ... does not exist"
  550. [pg 7.4 / Solaris 8] Could not bind socket for statistics collector