View Full Version : postgresql answers


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

  1. 7.3.4 and 7.4 ORDER in queries
  2. Postgresql on file system EXT2 or EXT3
  3. passing function's output into C function
  4. CREATE TYPE in Postgres 7.3.4
  5. Proposed project: Multimaster, synchronous replication system
  6. Happy Thanksgiving!
  7. disaster recovery
  8. MS-Project 2000 data into a Postgresql database
  9. [Fwd: [Gllug] Next GLLUG Meeting, 6 December 2003]
  10. GnuPG / PGP signed MD5 and SHA1 checksums for PostgreSQL 7.4.0
  11. rules and return values question
  12. aggregate generic ANYARRAY
  13. Tweak postgresql ODBC driver
  14. pg_dump table schema ...
  15. postgres metadata
  16. marking record origin in views
  17. cross table indexes?
  18. TIMEZONE not working?
  19. Java Strings and quote marks
  20. plpgsql question
  21. performance versus order of fields in row
  22. inheritance help
  23. ERROR: get_typdefault
  24. (No Subject)
  25. bug?!: lower() breaks unicode
  26. PostgreSQL is much faster than MySQL, only when...
  27. duplicate primary key entries?
  28. Can I get rid of the schemas?
  29. What is WAL used for?
  30. Help, Australian Time Problem
  31. get_typdefault: failed to ...
  32. Cron-job for checking up on pg_autovacuum
  33. Index on array element
  34. configure --with-java fails
  35. RPM RH9.0 conflict with unixODBC
  36. PostgreSQL certifications?
  37. patch for pg_autovacuum
  38. fairly serious bug with pg_autovacuum in pg7.4
  39. The new autovacuum tool
  40. SRPM (PGDG) will not build
  41. pam authentication for postgres
  42. SQL text of view
  43. autocommit in 7.4
  44. Lock strategies!
  45. Declaring empty, non-NULL array in plpgsql
  46. rounding timestamps
  47. The python module?
  48. 7.4 Python configure hosed
  49. 7.4 Docs in PDF format
  50. partial uniqueness
  51. updated linux startup script?
  52. array iteration?
  53. error loading shared libraries: libpq.so.3
  54. Connecting Openoffice Postgres
  55. Invalid page header in block xxxx
  56. Silent truncation of numeric values.
  57. Open source data modeling tools for PostgreSQL
  58. question about error message
  59. Problem with 7.4 RPMS for Fedora Core 1
  60. Foreign Keys
  61. Pg Dump error
  62. Can't initdb, libdir points to static location
  63. FWD: Take a look at this critical patch
  64. Where is Postgesql ? - MYSQL SURPRISES WITH MAXDB / MySQL appliance forLinux arrives
  65. Execute vacuum
  66. Bug in pg_dumpall
  67. linking postgre to AD
  68. Concatenation in SELECT
  69. tsearch2 column update produces "word too long" error
  70. Concurrent testing PostgreSQL Vs MySQL
  71. Modelling Oracle Sequences
  72. why ORDER BY works wrong in pg7.3.4?
  73. PGSQL on shared hosting
  74. postmaster PANIC?
  75. SuSE PostgreSQL 7.4 RPMS
  76. Psql bug?
  77. SELECT 'pg_catalog.pg_class'::regclass::oid
  78. rounding timestamp
  79. tsearch2 installation
  80. lo_import for bytea columns
  81. pg_hba.conf change in 7.4
  82. Multiuser testing -- PostgreSQL 7.3.4
  83. error durring compilation
  84. tsearch2 installation
  85. ripe whois server and postgresql
  86. lo_import for bytea columns
  87. ERROR: nodeRead: did not find '}' [x2]
  88. pg_hba.conf change in 7.4
  89. "Transaction over connections"
  90. error durring compilation
  91. Multiuser testing -- PostgreSQL 7.3.4
  92. SELECT Question
  93. ripe whois server and postgresql
  94. Is it possible to find a size of a table
  95. Is it possible to find a size of a table
  96. Is it possible find a size of a table
  97. ERROR: nodeRead: did not find '}' [x2]
  98. Export CSV from psql
  99. "Transaction over connections"
  100. Pg_dumpall problem
  101. Two rules on a view do not like each other :-(
  102. SELECT Question
  103. Is it possible to find a size of a table
  104. Is it possible to find a size of a table
  105. Is it possible find a size of a table
  106. Export CSV from psql
  107. ERROR: nodeRead: did not find '}'
  108. pg_aclcheck: invalid user id #
  109. Pg_dumpall problem
  110. Two rules on a view do not like each other :-(
  111. Japanese and PostgreSQL
  112. ERROR: nodeRead: did not find '}'
  113. pg_aclcheck: invalid user id #
  114. core dump
  115. Japanese and PostgreSQL
  116. core dump
  117. Wanted: Trick for granting permissions to users with hyphens
  118. Wanted: Trick for granting permissions to users with hyphens
  119. exclusive access
  120. 7.4 broke psql
  121. Problem with exec sql include
  122. defferable update & unique
  123. Optimizing query
  124. Tunning postgresql
  125. Seeking concise PL/pgSQL syntax diagram
  126. 7.4RC2 vs 7.4
  127. AUTOCOMMIT didn't work...
  128. SQL text of view
  129. Better Unilization of Memory
  130. unix_socket_directory not fully recognized by pg_ctl?
  131. Query Planner Filtering Of Specified Value From 'On Distinct' Clause
  132. problem running postmaster
  133. indexing with lower(...) -> queries are not optimised very well - Please Help
  134. Lock questions
  135. 7.4RC2 --> 7.4
  136. support
  137. Debian packages of 7.4
  138. pgAdmin3 [pgAdminIII] installation SUSE9
  139. Array syntax
  140. Error during check
  141. Quoting Problem in PLPGSQL
  142. how to get historical data?
  143. PLPGSQL Returning Records
  144. building 7.4 with plperl
  145. Detaching from controlling terminal
  146. Stuck processes, viewing the queries inside
  147. tracking down temp files
  148. SuSE RPMs available for PostgreSQL 7.4
  149. PostgreSQL v7.4 Released
  150. pg_constraint missing many entries?
  151. snort, acid and postgres
  152. MultiByte Columns?
  153. Move a table to another schema
  154. Take a minute to make yourself heard ... (PostgreSQL vs ...)
  155. Alternative cluster location
  156. Market Research on Open Source Database Management Software?
  157. MultiByte columns
  158. Retoring non-administrative user databases
  159. how to find version?
  160. vacuum from ecpg
  161. Help with quote escaping in plpgsql
  162. Grant alter privileges
  163. What are these files about?
  164. Updated Documentation
  165. UPGRADING 7.1 TO 7.3.4
  166. Storage consumption
  167. about serial
  168. Can Postgresql run under Windows?
  169. Loggin SQL Statements from JBOSS/JDBC
  170. Conservation of OIDs
  171. Error on initdb with 7.4RC2
  172. Restoring From pg_dumpall (SOLVED)
  173. Restoring From pg_dumpall
  174. GUIDs
  175. Database Corruption ?
  176. Determine if a string is digit
  177. 64 bit compile on Linux SPARC U5
  178. More Praise! 7.4
  179. DOMAIN usability
  180. Curious about exclusive table locks
  181. embedded postgresql
  182. plpgsql return setof integer?
  183. PL/PGSQL functions suddenly not working
  184. how can I change a btree index into a hash index?
  185. serial type vs. sequences
  186. pl/perl function life and variable scope - concurrency problem?
  187. using NOLOCK cause Cartesian joins
  188. dumping sequences
  189. Column Sizes
  190. Perfomance difference between 7.2 and 7.3
  191. Problem with FKEYS
  192. plperl/createlang issue
  193. Failure of make for 7.3.4 on Mac OS 10.3 Panther
  194. More Praise for 7.4RC2
  195. update slow
  196. change conndeferrable in pg_constraint?
  197. PGexec dumps core at pqResultAlloc
  198. Postgre Architecture
  199. procpid in pg_stat_activity but no correspoding backend
  200. Locks information
  201. Proposal for a cascaded master-slave replication system
  202. Functional index definition
  203. RHEL
  204. Changing xml in a database
  205. multibyte support
  206. Problem with create index
  207. ALTER TABLE ADD UNIQUE .....
  208. psql version mismatch
  209. PostgreSQL v7.4 Release Candidate 2
  210. PL/Perl returning multiple rows
  211. Try internet update from MS
  212. [off-topic] Bugtracker using PostgreSQL
  213. Two build problems - openssl and plperl on RedHat
  214. Visual C++ and Postgres
  215. case-sensitive sorting and locale settings?
  216. Dynamic expression evaluation
  217. PGSQL technical documentation
  218. PL/PGSQL help for getting number of rows matched.
  219. starting the server at boot
  220. drop user question
  221. Problem Deleting Referenced records
  222. Tables spanning db's in cluster
  223. disk access measurment
  224. FrontRange GoldMine w/ PostgreSQL
  225. Questions from a beginner!
  226. phpPGAdmin Indexes, what does this do?
  227. Optimiser desicion bringing system to its knees?
  228. Question on Select
  229. SQL-question: returning the id of an insert querry
  230. Tools are disabled, except connect & disconnect
  231. Problem in restoring data
  232. Converting SQL-ASCII encoding database to UNICODE
  233. Help With date/time
  234. performance: time & disk access measurment
  235. Question on Replication
  236. BUG?
  237. postgresql ODBC for Windows!
  238. PostgreSQL, Postgre and Apple
  239. pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'
  240. Problem creating ROWTYPE variable in plpgsql.
  241. Referencing columns from system tables possible?
  242. why does explain tell me I'm using a seq scan?
  243. regarding constant values
  244. phpPGAdmin Indexes, what does this do?
  245. Temp rows - is it possible?
  246. German mailing list
  247. Visio Like Tool....
  248. error when creating rule
  249. DDL for a single schema
  250. Changing the buffer size
  251. Database of electoral results?
  252. on connect trigger?
  253. on connect trigger
  254. int8 primary keys still not using index without manual JDBC driverpatch (7.4RC1)
  255. pg_stat_activity
  256. Optimiser desicion bringing system to its knees?
  257. create function for trigger question
  258. pid of current session?
  259. Insert and obtain the pk
  260. Install files for version 7.4
  261. Default user after upgrade to 7.3?
  262. Fixed column format data
  263. New eRServer patch/fork release
  264. INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE COLUMNS
  265. Sequences without blank holes
  266. Problems with PLPGSQL
  267. PostgreSQL v7.4 Release Candidate 1 compile errors
  268. SQL_ASCII encoding
  269. Select for update and locking problem
  270. Multi-master asynchronous replication
  271. tsearch2 and gist index bloat
  272. Getting time from date field
  273. Question on database structure
  274. Database Design & Application Server Design
  275. invalid command \
  276. How to store pg_constraint's int2[] data type in C++
  277. System crash and trying to run vacuum getting errors
  278. How to know column constraints via system catalog tables
  279. SET AUTOCOMMIT OFF
  280. select/update performance?
  281. Changes in Rel. 7.4
  282. Calculating default values on insert?
  283. access linux command from SQL Query
  284. question
  285. Using SUBSELECT in CHECK expressions
  286. Foreign Key to Inherited table
  287. PostgreSQL v7.4 Release Candidate 1
  288. Problem with Pg_dumpall
  289. Databases with different encodings
  290. Very strange selectproblem
  291. pg7.3.4: pg_atoi: zero-length string
  292. SELECT question
  293. now() problem
  294. Obtain boolean value of expression in PLPGSQL
  295. Query to pg_stat_activity
  296. C functions quicker than Plpgsql?
  297. transposed query?
  298. question
  299. How to use dblink within pl/pgsql function:
  300. Internet based database
  301. slow down on UPDATE using IN statements
  302. plpgsql question
  303. Please help
  304. PostgreSQL License Question
  305. IF EXISTS?
  306. How to set up a table where 2 columns together must be unique?
  307. Install that security package from Microsoft
  308. AS operator and subselect result names: PostgreSQL vs. Oracle
  309. further ino on bigint index and vacuum issues?
  310. Request for Interview Candidates - PG Research Help
  311. COPY
  312. Altering columns order
  313. help from Portugal
  314. sql trees move some element
  315. trim(ing) during load process
  316. org.postgresql.PG_Stream.flush(PG_Stream.java:356)
  317. Where are the database files located?
  318. Attribute 'rtrim' is repeated
  319. table locking.. FK tables locking on insert
  320. Pictures from LinuxWorld Expo in Frankfurt
  321. problem with huge joins
  322. Problem with ecpg
  323. Error Messages / Codes in DBD / JDBC
  324. ALTER Table
  325. ATA disks and RAID controllers for database servers
  326. insert data of composite type
  327. Table Copy/Synchronization
  328. DBD::Pg Err / Errstr
  329. Trigger or Rule ?
  330. Tsearch2 indexing question....
  331. Best Perl Option?
  332. database speed
  333. Need Italian Help!
  334. regular backups - super user
  335. formatting of SQL sent by PHP to postgres
  336. slow query performance
  337. Sending email from PL/pgsql
  338. tsearch ukrainian stemmer dict
  339. nextgencms
  340. sql trees move some element
  341. INSERT performance
  342. duplicates rejected by index reports PGSQL_FATAL_ERROR
  343. pg_ctl vs full restart
  344. Statistics on database structure changes
  345. dump schema schema only?
  346. Trigger delete
  347. backup another server
  348. pgAdmin vs SQL Server Enterprise Manager
  349. Database design question: ugliness or referential integrity?
  350. Cartesian product bug?
  351. N Texas PostgreSQL Consultant Needed
  352. Error size varchar
  353. selecting information from two tables (problem)
  354. Help on update that subselects other records in table, uses joins
  355. PG_RESTORE/DUMP Question
  356. Performace question
  357. slow query performance
  358. JDBC DatabaseMetaData problem
  359. Viewing linked large postgres tables with Access: Running out of memory
  360. Versioning control in PostgreSQL?
  361. SELECT with row>32k hangs over SSL-Connection
  362. Stored procedures from MS Query
  363. retrieve statement from catalogs
  364. unsubscribe
  365. What is an RT index?
  366. Multiple database services and multiple versions on Red Hat Linuxsystems
  367. sequences: cache_value, log_cnt, is_cycled columns
  368. connectby
  369. Queuing in Post
  370. Replication again
  371. table functions + user defined types
  372. function with tablename parameter
  373. Experience with PL/xx?
  374. Slow query
  375. foxpro to postgresql7.1
  376. Question about the Internals
  377. can't get tcl installed properly
  378. Retrieving a column comment
  379. Question regarding Perl, DBI, and fork()
  380. Casing: bug?
  381. Problems using PGAdmin III
  382. Slow performance with no apparent reason
  383. incrementing and decrementing dates by day increments programmatically
  384. explicit casting required for index use
  385. no records returned
  386. Performance failure / automatic restart / cron ?
  387. interesting quote...
  388. DBD::PgPP::CursorResponse
  389. partitioning
  390. where to find minor release info
  391. ./configure error - readline library not found
  392. extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax
  393. Index Usage Question
  394. Timestamp and interval precision
  395. unsubscribe
  396. shared memory on OS X - 7.4beta4
  397. ERROR: Multiple assignments to same attribute... ??
  398. FW: Check the patch from MS Corporation
  399. Desperate help needed for Replication
  400. Hierarchical query's
  401. Clustering for performance and fail over
  402. HTML generation with PL/PgSQL
  403. CLUSTER
  404. Nullable 'Foreign Key-like' Constraint
  405. Setting up DSPACE for Postgres access
  406. Timestamps in Views
  407. PostgreSQL v7.4 Beta5 Available for Testing
  408. Indexes and querys
  409. database files
  410. Adding fields on the fly
  411. setArray
  412. Prepared Statements
  413. plpgsql extract epoch problem
  414. SCSI vs. IDE performance test
  415. Atrybutes ???
  416. poor cpu utilization on dual cpu box
  417. (NONE)
  418. Trigger
  419. Identifier max length
  420. Postgreqsl & Package
  421. Same conditions, different planning?
  422. unexpected query behavior with UTF text
  423. where is pg_views
  424. Cast result set of select into an array for a sub select...
  425. pg_clog / pg_xlog corruption?
  426. Proposed structure for coexisting major versions
  427. max() over some rows but grouped, within one view def - how ?
  428. DBDesigner for Linux
  429. Simple SQL
  430. About TSearch2 Performance
  431. jboss postgresql pk generation
  432. lastval(seq) ?
  433. Timestamp to date conversion...plz help me
  434. create triggers.
  435. Help or Bug?
  436. pgsql error - situation update
  437. (no subject)
  438. Pgsql 7.3.3 on redhat 7.2
  439. Pgsql 7.3.3 on redhat 7.2 machin
  440. postgres 7.3.3 on redhat 7.2
  441. how to use pg_resetxlog
  442. tsearch2 and aspell
  443. Recomended FS
  444. Quick quote for Install
  445. Numeric type
  446. Cannot create new link. Too many open links
  447. tsearch2 question...
  448. Dilbert Experiences a 'Database Manager' moment
  449. convert string function and built-in conversions
  450. plpgsql
  451. Timestamp to date conversion...plz help me
  452. 7.4b4 domain usage and select question
  453. plpgsql: return multiple result sets
  454. How to quote text before inserting into database?
  455. Postgres seems to BE on windowsXP
  456. using cygwin for postgres
  457. How to activate error messages in my language
  458. Difference between check and a small table
  459. selecting table at execution with PL/PgSQL
  460. Help or Bug?
  461. restart and postgres.conf
  462. Using subselects in INSERTs?
  463. Perl and Postgres
  464. basic question
  465. ecpg and blob's
  466. connecting to external database tables outside of the postgres database
  467. XOR logical operator
  468. Disabling referential integrity
  469. pg_atoi
  470. Remote updating
  471. maximum number of client connections?
  472. problem with function to report how many records were changed
  473. ShmemAlloc errors
  474. Maping Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght)
  475. easy way to insert same value into 2 columns
  476. Lost views in a PostgreSQL 7.1. dump file ?
  477. When to use an array datatype?
  478. UPDATE table to a joined query...
  479. Damaged table
  480. Group and grant question
  481. ODBC
  482. is possible to read oracle tables from PostgresSQL
  483. constant time count(*) ?
  484. Getting error codes for failed queries?
  485. VACUUM degrades performance significantly. Database becomes unusable!
  486. Porting Code to Postgresql
  487. How to Create View
  488. Triggers tutorial
  489. Cygwin? or paid version from SRA?
  490. PostgreSQL article in phparchitect
  491. Porting Code to Postgresql
  492. PG clustering
  493. Indexes?
  494. How to Create View
  495. PLPERL function error - utf-8 to iso8859-1
  496. Triggers tutorial
  497. Cygwin? or paid version from SRA?
  498. PostgreSQL article in phparchitect
  499. PG clustering
  500. Indexes?
  501. PLPERL function error - utf-8 to iso8859-1
  502. Table analyzer
  503. Error compiling pgplsh
  504. order by a string
  505. Table analyzer
  506. Error compiling pgplsh
  507. converting varchar date strings to date
  508. order by a string
  509. Question
  510. Excute comnands OS from plpgsql
  511. elog undefined?
  512. converting varchar date strings to date
  513. How to list which tables are available?
  514. Question
  515. spam or crazy mail server changes?
  516. Excute comnands OS from plpgsql
  517. elog undefined?
  518. How to list which tables are available?
  519. spam or crazy mail server changes?
  520. pg_shadow --> passwd
  521. SET within a function?
  522. gborg cvs ?
  523. Index on timestamp to date field
  524. Pgsql on Windows
  525. Create Function... ERROR: language "plpgsql" does not exist
  526. Performance weirdness with/without vacuum analyze
  527. Postgres 7.3.4 install
  528. Upgrading to 7.4beta
  529. Temporary tables and miscellaneous schemas
  530. CREATE INDEX question (how to index on "money" field?)
  531. need for concrete info
  532. previous & next buttons
  533. [Cygwin] Postgresql 7.3.4 Installation Problem
  534. PQnotifies and freeing memory.
  535. "slicing" records
  536. backend exit mystery
  537. Debian experimental packages of PostgreSQL 7.4beta4
  538. log_duration and \timing times repeatably much higher than "Total runtime" from explain analyze
  539. Unable to identify an operator '*=' for types 'character varying[]' and '"unknown"'
  540. Unique Index vs. Unique Constraint
  541. Interfaces that support cursors
  542. libpq.so.3 not found error while use Perl DBI
  543. Execute Function from VB/ADO
  544. problem with pg_dump and restoring sequences
  545. PG tools
  546. process hangs using perl?
  547. undefined reference to 'pg_detoast_datum'
  548. simple remote user access question - pg_hda.conf
  549. question about a select
  550. SQL query problem