View Full Version : postgresql answers


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

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