View Full Version : postgresql answers


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

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