View Full Version : postgresql answers


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

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