Home : Bytes IT Community / View Full Version : PostgreSQL

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

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