View Full Version : postgresql answers


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

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