View Full Version : answers

Pages : 1 2 3 4 5 6 7 [8] 9 10 11
  1. SELECT INTO broken (?) in PL/pgSQL when using a set returning function in FROM clause (BGUG?)
  2. getting configure options?
  3. PostgreeSQL C header files
  4. getting configure options?
  5. PostgreeSQL C header files
  6. Mirrors that don't suck.
  7. Join Tutorial
  8. Mirrors that don't suck.
  9. ecpg question
  10. PostgreSQL 7.4.1 Released
  11. Join Tutorial
  12. COPY - Ignore Problems
  13. Parser: parse error - please help...
  14. Normalization and regexp
  15. CHECK versus a Table for an enumeration
  16. hardware requirements under Redhat
  17. ecpg question
  18. postmaster and logrotate
  19. PostgreSQL 7.4.1 Released
  20. COPY - Ignore Problems
  21. Parser: parse error - please help...
  22. Normalization and regexp
  23. CHECK versus a Table for an enumeration
  24. hardware requirements under Redhat
  25. postmaster and logrotate
  26. How to hide database structure
  27. restoring database
  28. extracting date FROM timestamp
  29. Tables Referencing themselves As Foreign Keys
  30. questions about tsearch2 (for czech language)
  31. Groff and Weinberg SQL Complete Reference - Sample database?
  32. bug in query planning?
  33. Where can I learn some more about the rule system?
  34. FEATURE REQUEST: let arrays support null values.
  35. Please remove me from the list, thanks
  36. SELECT ... FOR UPDATE
  37. MySQL Gets Functions in Java - Enlightenment Please
  38. Tables referencing each other
  39. DB & Log Files removed...
  40. Regarding Start of postmaster
  41. automatic verifications
  42. dblink_connect fails
  43. 7.1.3 ecpg
  44. PostgreSQL speakers needed for OSCON 2004
  45. Salvage older PostgreSQL data disk - help?
  46. automatic verifications
  47. Select groupping by one column
  48. Has anyone seen an ADO Provider for Postresql?
  49. Duplication to External Server
  50. authentication failed
  51. performance in selecting from very large recordset
  52. How to navigate tree without CONNECT BY?
  53. pqReadData() -- read() failed: errno=32
  54. Which file system do i have to choose?
  55. BLOBS : how to remove them totally
  56. param max_connections
  57. Check this update from the MS
  58. Function Returning SETOF Problem
  59. Triggers for FK on Views - can they be made deferrable?
  60. bind-dlz with postgresql driver ...
  61. Permissions issue?
  62. Deadlocks with plpgsql
  63. copy command problem
  64. Excel, OpenOffice and Postgres
  65. Need to understand PL/PGSQL, Foreign Key Deferable, and Transactions...
  66. md5 function
  67. Sequence name with SERIAL type
  68. restore error - language "plperlu" is not trusted
  69. Sequence question.
  70. Join Issues
  71. update slows down in pl/pgsql function
  72. 7.4 pg_dump and restore (with postGIS/GEOS)
  73. Firebird and PostgreSQL at the DB Corral.
  74. DB with bytea types reload problem
  75. selecting into a variable like @var=select ...
  76. Authentication Question
  77. Postgres respond after toomany times to a query view
  78. passing array as argument and returning an array in plpgsql
  79. UTF support in WIN32 native and Lower/Upper in 7.5 release
  80. Foriegn Key constraints not enforced when using rules
  81. DBF to PostgreSQL
  82. besides dbfdump........ HOW TO DUMP!
  83. FW: database failure..
  84. Relational data model dead?
  85. deadlock detected when inserting data
  86. Changing user
  87. LIMIT modifier
  88. PostgreSQL on Windows Server 2003
  89. dump and sequence initilizing
  90. password authentication failed for ..
  91. Snippets
  92. windows distribution
  93. database failure..
  94. Calculating total amounts per clientid
  95. Why is postgres an ORDMS
  96. 7.5 features
  97. Delete all records NOT referenced by Foreign Keys
  98. Windows Version of PostgreSQL
  99. Perl "with-perl" configuration option
  100. Error with table
  101. Reordering results for a report
  102. Change date format only for one DB
  103. Moving the database from a filesystem to another
  104. experiences with postgres in ia64 and linux
  105. remark on a slowdown of COPY
  106. Uninstall postgres 7.4
  107. Build Problem in 7.3.5 version
  108. make error Mac OS X (ar: illegal option -- s)
  109. ERROR: JOIN/USING types 'integer' and 'character varying' not matched
  110. Is it not datestyle that determines date format output?
  111. Foreign keys and pg_user table
  112. Weird Problem With PostgreSQL 7.3.1 and VB.Net Datagrid
  113. tablespaces in 7.5?
  114. ERROR: did not find '}' at end of input node (again)
  115. Storing Snapshot Data
  116. sequences not renamed with tables
  117. Any commercial shopping cart packages using postgresql?
  118. Redhat 9.0 Service Shutdown
  119. Moving a database between servers
  120. datestyle in postgresql.conf, version 7.4
  121. Disabling or forwarding external connections
  122. "PostgreSQL Error Code(1)"
  123. highest match in group
  124. Wird behavour of foreign keys
  125. versions of PG
  126. PG 7.4 on Tru64 UNIX 4.0 + threads
  127. JDBC function call: PS vs CS
  128. Users and session ids
  129. Strange permission problem regarding pg_settings
  130. initdb reporting error.
  131. Determining what a user can access
  132. Help: ecpg bytea and PQescapeBytea()/PQunescapeBytea()
  133. Help with Turning debugging on/off
  134. OO database?
  135. PG and AIX
  136. Casting Point to Text
  137. Reset oid , starting value=1
  138. Shell access & send email from PLPGSQL?
  139. Oracle to PostgreSQL migration
  140. A problem during restoring database from PostgreSql 6.5.3/7.1.3 to 7.4
  141. OO database?
  142. Is the COMMUTATOR clause required for self commutative operators?
  143. Manual record locking
  144. Inheritance and foreign keys
  145. Pg_Dump of schema?
  146. dblink questions
  147. remove
  148. Turning on/off debugging
  149. Planner question regarding functions
  150. Install that update from the Microsoft Corporation
  151. Look at security update for Microsoft Windows
  152. left join is strange
  153. pgsql 7.4 on minimal environment
  154. Where to find information about implementing full-text-search
  155. spelling errors in query terms
  156. dblink questions
  157. CMS with PostgreSQL
  158. GRANT ON C
  159. user defined variable per session
  160. CREATE RULE problem/question requesting workaround
  161. functions/operators with 2 sets as arguments
  162. dblink questions
  163. corruption diag/recovery, pg_dump crash
  164. CMS with PostgreSQL
  165. 7.3 --> 7.4 C Functions
  166. Feedback? Is there interest in a PostgreSQL-based CRM suitefriendly to shared hosting?
  167. ERRORs after upgrade from 7.2.1 to 7.4 about nonexisting large objects
  168. PSQL 7.4 on debian woody
  169. FW: Postgres 7.4 runing on BSD
  170. Stored FUnctions
  171. CREATE TABLE AS COMMAND
  172. 7.4 Crashed... Why?
  173. max_fsm_pages
  174. OpenFTS-perl-0.35 released
  175. function to find last day of month
  176. update time zone in timestamps
  177. how to restart on OS X
  178. Groups vs. Roles
  179. last update time of a table
  180. xor for text
  181. XOR on strings
  182. are cursors necessary?
  183. unsubscribe
  184. transaction in progress
  185. ecpg -e
  186. How to download pgsql
  187. Shared hosting configuration advice requested
  188. postgresql locks the whole table!
  189. question
  190. Async Query Processing on Solaris
  191. bug in 7.4
  192. last update time of a table
  193. Invalid page header
  194. multiple PostgresQL installations
  195. Async Query Processing on Solaris
  196. PostgreSQL 7.3.5 Now Available ...
  197. Pronouncing PostgreSQL
  198. [Fedora Core 1] yum repositories with 7.4?
  199. bytea, index and like operator
  200. C/C++ access with no postmaster running?
  201. postgresql locks the whole table!
  202. Teach Yourself PostgreSQL book
  203. Autocommit to off
  204. autocommit off
  205. Accessing fields in RECORD data type using variables as field names
  206. Cast text to bytea
  207. Transaction Question
  208. Money data type in PostgreSQL?
  209. DBD::Pg problem
  210. Making a tree with "millions and millions" of dynamic nodes
  211. bytea -> text
  212. Error in select
  213. C Programming with postgres.h - my function crashes the database backend
  214. Invalid page header in block
  215. How to obtain the real problem that avoids postgresql service starting?
  216. PG_DUMP question
  217. Hostname of server
  218. fmgr_info: function 7390843: cache lookup failed
  219. perl(Pg) (S)RPM
  220. pg_dump on one user not whole database
  221. Storing passwords
  222. Specify a column without using its name
  223. I need your help. I'm confused with the files ...
  224. grant not working on pg_class
  225. Undropping a column?
  226. XML & Postgres Functions
  227. Postgresql sql query - selecting rows outside a join
  228. UNICODE problem on 7.4 with COPY
  229. Feature Request for 7.5
  230. PostgreSQL from a newcomers perspective
  231. Bug or Feature - plpgsql odity
  232. Pg module for Perl
  233. Upgrading from 7.2.3 to....??
  234. pg_hba.conf problem
  235. Equivalent to DBMS_JOB
  236. permission errors for set authority and schema public
  237. Drop Cascade of Domains
  238. Domains and function
  239. After upgrade 7.2.1 to 7.4 "ERROR: large object ... does not exist"
  240. [pg 7.4 / Solaris 8] Could not bind socket for statistics collector
  241. Executing Shell Command
  242. Restore-point?
  243. Restore-point?
  244. help transfer ring blobs using perl
  245. renaming a database
  246. cross table indexes?
  247. Try these internet package from MS
  248. plpgsql string concatanation
  249. ip of the user doing an insert
  250. Convert integer to sql server datetime
  251. XQL and PostgreSQL
  252. 7.3.4 and 7.4 ORDER in queries
  253. Postgresql on file system EXT2 or EXT3
  254. passing function's output into C function
  255. CREATE TYPE in Postgres 7.3.4
  256. Proposed project: Multimaster, synchronous replication system
  257. Happy Thanksgiving!
  258. disaster recovery
  259. MS-Project 2000 data into a Postgresql database
  260. [Fwd: [Gllug] Next GLLUG Meeting, 6 December 2003]
  261. GnuPG / PGP signed MD5 and SHA1 checksums for PostgreSQL 7.4.0
  262. rules and return values question
  263. aggregate generic ANYARRAY
  264. Tweak postgresql ODBC driver
  265. pg_dump table schema ...
  266. postgres metadata
  267. marking record origin in views
  268. cross table indexes?
  269. TIMEZONE not working?
  270. Java Strings and quote marks
  271. plpgsql question
  272. performance versus order of fields in row
  273. inheritance help
  274. ERROR: get_typdefault
  275. (No Subject)
  276. bug?!: lower() breaks unicode
  277. PostgreSQL is much faster than MySQL, only when...
  278. duplicate primary key entries?
  279. Can I get rid of the schemas?
  280. What is WAL used for?
  281. Help, Australian Time Problem
  282. get_typdefault: failed to ...
  283. Cron-job for checking up on pg_autovacuum
  284. Index on array element
  285. configure --with-java fails
  286. RPM RH9.0 conflict with unixODBC
  287. PostgreSQL certifications?
  288. patch for pg_autovacuum
  289. fairly serious bug with pg_autovacuum in pg7.4
  290. The new autovacuum tool
  291. SRPM (PGDG) will not build
  292. pam authentication for postgres
  293. SQL text of view
  294. autocommit in 7.4
  295. Lock strategies!
  296. Declaring empty, non-NULL array in plpgsql
  297. rounding timestamps
  298. The python module?
  299. 7.4 Python configure hosed
  300. 7.4 Docs in PDF format
  301. partial uniqueness
  302. updated linux startup script?
  303. array iteration?
  304. error loading shared libraries: libpq.so.3
  305. Connecting Openoffice Postgres
  306. Invalid page header in block xxxx
  307. Silent truncation of numeric values.
  308. Open source data modeling tools for PostgreSQL
  309. question about error message
  310. Problem with 7.4 RPMS for Fedora Core 1
  311. Foreign Keys
  312. Pg Dump error
  313. Can't initdb, libdir points to static location
  314. FWD: Take a look at this critical patch
  315. Where is Postgesql ? - MYSQL SURPRISES WITH MAXDB / MySQL appliance forLinux arrives
  316. Execute vacuum
  317. Bug in pg_dumpall
  318. linking postgre to AD
  319. Concatenation in SELECT
  320. tsearch2 column update produces "word too long" error
  321. Concurrent testing PostgreSQL Vs MySQL
  322. Modelling Oracle Sequences
  323. test
  324. why ORDER BY works wrong in pg7.3.4?
  325. PGSQL on shared hosting
  326. SuSE PostgreSQL 7.4 RPMS
  327. postmaster PANIC?
  328. Psql bug?
  329. SELECT 'pg_catalog.pg_class'::regclass::oid
  330. rounding timestamp
  331. tsearch2 installation
  332. lo_import for bytea columns
  333. pg_hba.conf change in 7.4
  334. error durring compilation
  335. Multiuser testing -- PostgreSQL 7.3.4
  336. tsearch2 installation
  337. ripe whois server and postgresql
  338. lo_import for bytea columns
  339. ERROR: nodeRead: did not find '}' [x2]
  340. pg_hba.conf change in 7.4
  341. Multiuser testing -- PostgreSQL 7.3.4
  342. "Transaction over connections"
  343. error durring compilation
  344. SELECT Question
  345. ripe whois server and postgresql
  346. Is it possible to find a size of a table
  347. Is it possible to find a size of a table
  348. Is it possible find a size of a table
  349. ERROR: nodeRead: did not find '}' [x2]
  350. Export CSV from psql
  351. "Transaction over connections"
  352. Pg_dumpall problem
  353. Two rules on a view do not like each other :-(
  354. SELECT Question
  355. Is it possible to find a size of a table
  356. Is it possible to find a size of a table
  357. Is it possible find a size of a table
  358. Export CSV from psql
  359. ERROR: nodeRead: did not find '}'
  360. pg_aclcheck: invalid user id #
  361. Pg_dumpall problem
  362. Two rules on a view do not like each other :-(
  363. Japanese and PostgreSQL
  364. ERROR: nodeRead: did not find '}'
  365. pg_aclcheck: invalid user id #
  366. core dump
  367. Japanese and PostgreSQL
  368. core dump
  369. Wanted: Trick for granting permissions to users with hyphens
  370. Wanted: Trick for granting permissions to users with hyphens
  371. exclusive access
  372. 7.4 broke psql
  373. Problem with exec sql include
  374. defferable update & unique
  375. Optimizing query
  376. Tunning postgresql
  377. Seeking concise PL/pgSQL syntax diagram
  378. 7.4RC2 vs 7.4
  379. AUTOCOMMIT didn't work...
  380. SQL text of view
  381. Better Unilization of Memory
  382. unix_socket_directory not fully recognized by pg_ctl?
  383. Query Planner Filtering Of Specified Value From 'On Distinct' Clause
  384. problem running postmaster
  385. indexing with lower(...) -> queries are not optimised very well - Please Help
  386. Lock questions
  387. 7.4RC2 --> 7.4
  388. support
  389. Debian packages of 7.4
  390. pgAdmin3 [pgAdminIII] installation SUSE9
  391. Array syntax
  392. Error during check
  393. Quoting Problem in PLPGSQL
  394. how to get historical data?
  395. PLPGSQL Returning Records
  396. building 7.4 with plperl
  397. Detaching from controlling terminal
  398. Stuck processes, viewing the queries inside
  399. tracking down temp files
  400. SuSE RPMs available for PostgreSQL 7.4
  401. PostgreSQL v7.4 Released
  402. snort, acid and postgres
  403. pg_constraint missing many entries?
  404. MultiByte Columns?
  405. Move a table to another schema
  406. Take a minute to make yourself heard ... (PostgreSQL vs ...)
  407. Alternative cluster location
  408. Market Research on Open Source Database Management Software?
  409. MultiByte columns
  410. Retoring non-administrative user databases
  411. how to find version?
  412. vacuum from ecpg
  413. Help with quote escaping in plpgsql
  414. Grant alter privileges
  415. What are these files about?
  416. Updated Documentation
  417. UPGRADING 7.1 TO 7.3.4
  418. Storage consumption
  419. about serial
  420. Can Postgresql run under Windows?
  421. Loggin SQL Statements from JBOSS/JDBC
  422. Conservation of OIDs
  423. Error on initdb with 7.4RC2
  424. Restoring From pg_dumpall (SOLVED)
  425. Restoring From pg_dumpall
  426. GUIDs
  427. Database Corruption ?
  428. Determine if a string is digit
  429. 64 bit compile on Linux SPARC U5
  430. More Praise! 7.4
  431. DOMAIN usability
  432. Curious about exclusive table locks
  433. embedded postgresql
  434. plpgsql return setof integer?
  435. PL/PGSQL functions suddenly not working
  436. how can I change a btree index into a hash index?
  437. serial type vs. sequences
  438. pl/perl function life and variable scope - concurrency problem?
  439. using NOLOCK cause Cartesian joins
  440. dumping sequences
  441. Column Sizes
  442. Perfomance difference between 7.2 and 7.3
  443. Problem with FKEYS
  444. plperl/createlang issue
  445. Failure of make for 7.3.4 on Mac OS 10.3 Panther
  446. More Praise for 7.4RC2
  447. update slow
  448. change conndeferrable in pg_constraint?
  449. PGexec dumps core at pqResultAlloc
  450. Postgre Architecture
  451. procpid in pg_stat_activity but no correspoding backend
  452. Locks information
  453. Proposal for a cascaded master-slave replication system
  454. Functional index definition
  455. RHEL
  456. Changing xml in a database
  457. multibyte support
  458. Problem with create index
  459. ALTER TABLE ADD UNIQUE .....
  460. psql version mismatch
  461. PostgreSQL v7.4 Release Candidate 2
  462. PL/Perl returning multiple rows
  463. Try internet update from MS
  464. [off-topic] Bugtracker using PostgreSQL
  465. Two build problems - openssl and plperl on RedHat
  466. Visual C++ and Postgres
  467. case-sensitive sorting and locale settings?
  468. Dynamic expression evaluation
  469. PGSQL technical documentation
  470. PL/PGSQL help for getting number of rows matched.
  471. starting the server at boot
  472. drop user question
  473. Problem Deleting Referenced records
  474. Tables spanning db's in cluster
  475. disk access measurment
  476. FrontRange GoldMine w/ PostgreSQL
  477. Questions from a beginner!
  478. phpPGAdmin Indexes, what does this do?
  479. Optimiser desicion bringing system to its knees?
  480. Question on Select
  481. SQL-question: returning the id of an insert querry
  482. Tools are disabled, except connect & disconnect
  483. Problem in restoring data
  484. Converting SQL-ASCII encoding database to UNICODE
  485. Help With date/time
  486. performance: time & disk access measurment
  487. Question on Replication
  488. BUG?
  489. postgresql ODBC for Windows!
  490. PostgreSQL, Postgre and Apple
  491. pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'
  492. Problem creating ROWTYPE variable in plpgsql.
  493. Referencing columns from system tables possible?
  494. why does explain tell me I'm using a seq scan?
  495. regarding constant values
  496. phpPGAdmin Indexes, what does this do?
  497. Temp rows - is it possible?
  498. German mailing list
  499. Visio Like Tool....
  500. error when creating rule
  501. DDL for a single schema
  502. Changing the buffer size
  503. Database of electoral results?
  504. on connect trigger?
  505. on connect trigger
  506. int8 primary keys still not using index without manual JDBC driverpatch (7.4RC1)
  507. pg_stat_activity
  508. Optimiser desicion bringing system to its knees?
  509. create function for trigger question
  510. pid of current session?
  511. Insert and obtain the pk
  512. Install files for version 7.4
  513. Default user after upgrade to 7.3?
  514. Fixed column format data
  515. New eRServer patch/fork release
  516. INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE COLUMNS
  517. Sequences without blank holes
  518. Problems with PLPGSQL
  519. PostgreSQL v7.4 Release Candidate 1 compile errors
  520. SQL_ASCII encoding
  521. Select for update and locking problem
  522. Multi-master asynchronous replication
  523. tsearch2 and gist index bloat
  524. Getting time from date field
  525. Question on database structure
  526. Database Design & Application Server Design
  527. invalid command \
  528. How to store pg_constraint's int2[] data type in C++
  529. How to know column constraints via system catalog tables
  530. System crash and trying to run vacuum getting errors
  531. SET AUTOCOMMIT OFF
  532. select/update performance?
  533. Changes in Rel. 7.4
  534. Calculating default values on insert?
  535. access linux command from SQL Query
  536. question
  537. Using SUBSELECT in CHECK expressions
  538. Foreign Key to Inherited table
  539. PostgreSQL v7.4 Release Candidate 1
  540. Problem with Pg_dumpall
  541. Databases with different encodings
  542. Very strange selectproblem
  543. pg7.3.4: pg_atoi: zero-length string
  544. SELECT question
  545. now() problem
  546. Obtain boolean value of expression in PLPGSQL
  547. Query to pg_stat_activity
  548. C functions quicker than Plpgsql?
  549. transposed query?
  550. question