View Full Version : postgresql answers


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

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