View Full Version : postgresql answers


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

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