Home : Bytes IT Community / View Full Version : PostgreSQL

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

  1. Unable to create a PL/PGSL function : Did I miss something ?
  2. benchmarks?
  3. connectby for BYTEA keys
  4. duplicate key violates unique constraint "pg_class_oid_index"
  5. Can anyone recommend accounting software using PGSQL?
  6. SHOW TABLES ?
  7. Syntax (or unavailability of same) for variable join results?
  8. Indexes and sorting
  9. retrieving parts of a resultset
  10. Getting table attributes
  11. PL/Ruby
  12. how can I select into an array?
  13. Run 2 versions of Postgresql on one machine?
  14. Casting 'record' to a composite type.
  15. Starting the Server ?
  16. Upcoming events: Chemnitzer Linux-Tag
  17. pgsql 7.4.1 copy - end-of-copy marker corrupt
  18. Sort order confusion
  19. Analyze not doing anything?
  20. functional index "real world" uses
  21. functional index "real world" uses
  22. : Proper tool to display graphics?
  23. ERROR: column 'xxx' does not exist (under v. 7.4.1)
  24. dblink - custom datatypes don't work
  25. pg_restore and large files
  26. size of mailing lists?
  27. Proper tool to display graphics?
  28. Can LIKE use indexes or not?
  29. dblink: rollback transaction
  30. Improving performance with a Function instead of a View
  31. Predictive or scoring solution for PostgreSQL ?
  32. Wrong week day language
  33. Copying tables between databases
  34. Resize varchar column
  35. Transaction end on error
  36. RETURN NEXT and reversing order
  37. application developers list?? or report engine using postgres?
  38. BLOB problem
  39. Anyone has nls activated on Mac OS X?
  40. problem with jdbc connection to postgesql
  41. Specifying a index
  42. large crontab database design
  43. Multicolumn Indexing using R-Tree
  44. Copy and xml files
  45. BLOB problem
  46. Before ship 7.4.2
  47. recursive query?
  48. Transfer database tables to a schema
  49. cannot extend error
  50. Select Question
  51. Return Value of a Function
  52. Postgresql 7.3 And Redhat Enterprise 3
  53. isolating users from each other
  54. How to kick out automatically stuck in queries
  55. Array in stored procedure
  56. Error with pg_restore (parse error at or near "BY" at character 144
  57. Functions in CHECK constraint not getting dumped before tables.
  58. partial indexes
  59. Search across multiple sources
  60. Does SET STATISTICS lock the table?
  61. Incorrect Results From Select When Using Non-English Characters
  62. Problem with function
  63. Help: System requirements for postgresql 7.4.1
  64. Viewing detailed lock information
  65. How to...
  66. select ... distinct performance
  67. Using PostgreSQL to store ip traffic information
  68. Insert question null/not null serial, etc.
  69. Fw: [JDBC] Trigger function aborts the transaction on exception
  70. Large object insert/update and oid use
  71. Unicode vs SQL_ASCII DBs
  72. PostgreSQL 7.4.1 and pgdb.py
  73. Two joins on same foreign key
  74. DB cache size strategies
  75. Are there commands to enquire about table structure?
  76. Problem with API (libpq) - detailed error codes
  77. IDENT and pg_hda.conf
  78. No Database Drivers
  79. subqueries vs. separate queries
  80. Planner configuration
  81. Grant question
  82. A strange Vacuum error ...
  83. Pl/tcl auto-load problem
  84. Very slow query - why?
  85. Specifying many rows in a table
  86. Single step Sql script GUI editor
  87. 7.3.4 freezing
  88. Sorting is ignoring spaces
  89. Seaching without accents
  90. Interest in database-based email?
  91. Help, I've killed my system?
  92. Fw: postgres DB duplication
  93. Manually authenticating users in pg_shadow
  94. Is autocommit=true bad?
  95. Call a function when a User (dis)connects from the Server/Database
  96. Logging all queries
  97. Looking for mail relays ...
  98. Postgress resumes ...
  99. Adding missing FROM clause - thanks or no thanks?
  100. Increase stored proc. parameters max count
  101. How can the sequence become out of sequence?
  102. Broken Link on techdocs
  103. Permission Problems:-)?
  104. Reloading Template1
  105. Foreign keys on inherited attributes
  106. postmaster growing to consume all memory
  107. Embedded transactions
  108. crlf and copy
  109. how to enumerate rows ?!?
  110. pg_largeobject and oid mistmach after restore
  111. Executing a query and returning the result set using the SPI
  112. Where is initdb?
  113. Global variables for plpgsql stored procedures
  114. Casting varchar to interval.?
  115. Storing Configuration settings for a database?
  116. About Privileges
  117. Object Relational features in PostgreSQL
  118. COPY, \\copy, and "\357\273\277"\n ^
  119. Multiway associations
  120. I can't upgrade to PostgreSQL 7.4 in RedHat 9.0
  121. on cascade set null works on not null columns
  122. Is there something like an dynamic view ?
  123. pl/pgsql docs 37.4.3. Row Types -- how do I use this function?
  124. force drop of database others are accessing
  125. Calling triggers with arguments
  126. If table A value IS NULL then table B
  127. business references for postgresql
  128. sequence in schema -- broken default
  129. Optimizing SQL: bind variables, prepared stms, histograms
  130. Upcoming events
  131. Nearby zipcodes from a point
  132. psql: relocation error: psql: undefined symbol: PQgetssl
  133. Parsing bug?
  134. regex in plpgsql function
  135. LIVE Coverage of LinuxWorld Conference & Expo | LinuxWorld - where isPostgresql
  136. Want a job?
  137. trust auth in 7.4
  138. Why does the sequence get out of sequence?
  139. varchar_pattern_ops in 7.3.4?
  140. Lost plpgsql function
  141. Question and search for ODBC related postgreSQL questions
  142. Update inside (Insert) Trigger and Unique constraint...
  143. What is holding a connection open.
  144. tablespaces a priority for 7.5?
  145. Compiling postgres-7.4.1
  146. Linux Magazine/Postgres Article
  147. postgresql + apache under heavy load
  148. Idle connections - Too many clients connected already
  149. Ending transaction inside stored function
  150. CTTAS w/ DISTINCT ON crashes backend
  151. SCO Extortion
  152. Referencing subselect returned value
  153. PostgreSQL and Datawarehouse tools
  154. Accessing template0 tables
  155. postGresql Consulting ??
  156. Recursive optimization of IN subqueries
  157. Transaction id
  158. ORM, XPath, and pgxml_dom segfaulting
  159. Alternative to ODBC ?
  160. JDBC Driver moved to gborg.
  161. Can't backup! pg_dump/pg_restore not updated with 7.4.1
  162. Getting rid of duplicate tables.
  163. How to get the requested columns in a rowtype PL/pgSQL function
  164. Attaching files to the database.
  165. Converting from Progress 4GL and DBMS
  166. Very long time to commit or close connections
  167. Introduced PostgreSQL for Windows
  168. Integer ranges in PostgreSQL
  169. Tool to ease development of plpgsql
  170. Tool to ease development of plpgsql
  171. Great change (size of data dir) upgrading postgresql
  172. computed field on a table
  173. Using a Makefile during database development
  174. importing data
  175. Automatic joins?
  176. Automatic joins?
  177. massaging data from multiple timezones
  178. How should I get started?
  179. 7.4 -> 7.4.1 upgrade with customization on freebsd
  180. I got bit by that darn GEQO setting again...
  181. error creating sql function
  182. Tool to ease development of plpgsql
  183. UNICODE-encoded database does not accept umlaut-characters.
  184. Postgresql reporting tool
  185. Potential Problem with PostgeSQL performance on SuSE Linux 9.0
  186. User-specific sequences
  187. plpythonu AKA am I crazy? or....
  188. Problems with \copy and delimiters ','
  189. simple tree in postgress
  190. Adding long text to a database text field generates errors
  191. FAQ (disk space)
  192. serverless postgres, embedded firebird, etc.
  193. Creating GUID
  194. How to become a Windows beta-tester?
  195. Index space reusable?
  196. check date validity
  197. tinterval operators and functions
  198. how to catch the error in procedure ?
  199. transactions in c api (libpq)?
  200. User-specific sequences...
  201. What Version Installed?
  202. why isn't TEXT a key word?
  203. Survey: Motivations to Contribute
  204. How should I get started?
  205. CASE SELECT syntax
  206. Bytea/Large Objects/external files best practices
  207. Bytea/Large Objects/external files best practices
  208. problem starting postmaster as a service
  209. Foreign key question
  210. Returning large select results from stored procedures
  211. parse error in function
  212. fixed-length row
  213. YAGT (yet another GUID thread)
  214. postgresql Error handling in client app
  215. Log_statement behaviour a little misleading?
  216. about postgres odbc on wondows
  217. pg_dump/pg_restore problems with 7.4.1
  218. best practice for use of functions..
  219. Errors after power failure
  220. FW: Postgres: VACUUM
  221. Postgres: VACUUM
  222. Max registers in postgresql 7.4
  223. Quoting for a Select Into - Please Help
  224. Collate is not supported for 7.4
  225. Rights in 7.4
  226. Schemas not created on restore
  227. Detecting database corruption
  228. Using regular expressions in LIKE
  229. Huge Data
  230. Optimising SQL Queries?
  231. COPY FROM STDIN
  232. casting parameters to a function
  233. 7.4.1 packages for RHEL2.1
  234. Incremental Development
  235. serverless postgresql
  236. Trigger Question
  237. Testing Email
  238. dump/restore problem
  239. Error since powerouttage
  240. Error since powerouttage
  241. Nested transaction - I am a bank ??
  242. Pl/Perl speed
  243. sequence incrementing twice
  244. Nested transaction - I am a bank ??
  245. pg_catalog permission problem
  246. Postgress and MYSQL
  247. Best practice? Web application: single PostgreSQL user vs. multipleusers
  248. Best Practice for incremental development
  249. Any real known bugs about wrong selects?
  250. Nested transaction workaround?
  251. Updating the owner of a function
  252. Reallife szenario for GEQO
  253. Help with indexing!
  254. Parse error help needed...
  255. sql insert function
  256. qq- repost
  257. qq
  258. Column qualifier issue
  259. Vacuum Error
  260. Dump/Restore ordering problem?
  261. Connecting using an existing socket (libpq).
  262. unsubscribe
  263. unsubscribe
  264. Granting all table in one command
  265. Dump tables with pg_dump - no or different Owner
  266. Error with tablefunc in postgres 7.4.1
  267. insertion with trigger failed unexpectedly
  268. Precedence of a TRIGGER vs. a CHECK on a column
  269. Compile postgre 7.1 on Redhat 9?
  270. SRF in C
  271. ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index
  272. what we need to use postgresql in the enterprise
  273. how do I get the primary key
  274. How are NULLS stored on disk for PG 7.4?
  275. Using indices with long unique IDs.
  276. Is Mysql Gaining?
  277. Drawbacks of using BYTEA for PK?
  278. CHAR(N) storage requirement
  279. Case sensitivity
  280. psql's "\d" and CLUSTER
  281. Any way to SELECT a list of table names?
  282. Bug with rename bigserial column
  283. Bug in functions returning setof where table has dropped column?
  284. query should use an index?
  285. Query string is too long
  286. unsubscribe
  287. OIDS and its limitations
  288. ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index
  289. Why does this use of accents in psql fail for a Unicode database?
  290. no space left on device
  291. Hierarchical queries
  292. TSearch2 ... ignore word repetition for rank
  293. deferring/disabling unique index
  294. Invalid UNICODE character sequence found(0xc000)
  295. problems dumping from one server 2 another
  296. array faults?
  297. Trouble with MsAccess and records above 13000
  298. Using indices with long unique IDs.
  299. Natural upgrade path for RedHat 9?
  300. Using indices with long unique IDs.
  301. SPI question: trying to read from Large Objects from within a function
  302. RedHat install question.
  303. Simulation output using libpq
  304. full db locking during dump
  305. encrypt
  306. vacuum
  307. beginner query help
  308. int8 version of NUMERIC?
  309. 7.4, 'group by' default ordering?
  310. deferring/disabling unique index
  311. why I can call pg_stat_get_backend_idset directly
  312. Simulation output using libpq
  313. 7.3.3 drop table takes very long time
  314. order by is ambiguous
  315. Optimize query: time of "single * IN(many)" > time of "many * IN(single)"
  316. Compile problem on old Debian Linux with glibc 2.0.7
  317. Open Source Database Rankings
  318. Perl and Python modules problem
  319. Oracle -> Postgres live translation?
  320. Problem with rserv replication
  321. PHP arrays and postgresql
  322. pg_stats question
  323. VACUUM VERBOSE ANALYZE does not work on 7.4.1
  324. 64 Bit Postgresql ports
  325. The script kiddies are busy again ...
  326. Find original number of rows before applied LIMIT/OFFSET?
  327. deadlocks - sharelocks on transactions
  328. Reparse PL/pgSQL Function?
  329. Loading a dumped databse from cd
  330. SPI question (or not): trying to read from Large Objects from within a function
  331. problems with transaction blocks
  332. Query performance question on a large table
  333. DBs and Schemas
  334. Postgresql & 64 Bit Opteron
  335. unsubscribe
  336. create template database
  337. pg_dump and client_encoding
  338. cross-table unique constraint
  339. MVCC for massively parallel inserts
  340. Date column that defaults to 'now'
  341. forking postmaster on my own - not as pguser
  342. plpgsql.so?
  343. release notes/Appendix E in documentation
  344. Slow Performance with 7.4.1
  345. unsubscribe
  346. 7.4.1 Server Not Starting?
  347. History-based (or logged) database.
  348. PostgreSQL 7.4.1 incredibly slow :-(
  349. Cursor Not Found
  350. Anything akin to an Evaluate Statement in Postgresql?
  351. Scripting a new db server setup
  352. Postgresql Errors over ODBC
  353. TPC-C and Postgres
  354. replication choices
  355. Functions Returning Record Datatype
  356. Network Problems over past 48hrs
  357. Foodmart2000 sample database
  358. license issues
  359. license issue
  360. license issue
  361. Passing a comma delimited list to a function
  362. BUG: compiling PL/Python - Semi-SOLVED
  363. Any way to have CREATEUSER privs without having all privs?
  364. 7.4 ERROR: CREATE LOCAL TEMPORARY TABLE ... ON COMMIT DROP inside a function
  365. 7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work
  366. pull_up_subqueries question
  367. Help with PostgreSQL porting project
  368. why the need for is null?
  369. Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1
  370. GetLastInsertID ?
  371. how to read db schema with php
  372. speeding up inserts
  373. measuring disk usage of records
  374. finding my schema (for sequences)
  375. Binaries (rpm) for SuSE 9.0...
  376. Bug and/or feature? Complex data types in tables...
  377. Replication ?
  378. What does count(*) count?
  379. 7.4.1 RPMS
  380. 7.3 dump into 7.2 (my solution)
  381. Quotes in dynamic sql
  382. 'like' refuses to use an index???
  383. Where can I find the "Contrib" page on the PostgreSQL site?
  384. Problem with ecpg
  385. ERROR: cache lookup for type 0 of ... pg.dropped.14........ failed
  386. md5sum function for debian 7.3.2
  387. Any way to disable backslash as a string literal escape character?
  388. PG_Autotune
  389. Select Non Alpha Contents of a Column
  390. website doc search is extremely SLOW
  391. Building dynamic contents from database
  392. Building dynamic contents from database
  393. Out of memory error when doing an update with IN clause
  394. An out of memory error when doing a vacuum full
  395. altering a column
  396. case insensetive UTF-8
  397. phppgadmin, pkey's and indexes
  398. pg_recvbuf errors
  399. simple auto-updating timestamp ?
  400. what about uniqueness of inherited primary keys
  401. Change onership of database and all tables?
  402. Max length of SQL statement
  403. Time varying referential integrity
  404. comparison: smallint & 2^extract(dow from date)
  405. RPM for RedHat 7.0?
  406. dump 7.3 into 7.2?
  407. pg_ctl logfile rotation not working?
  408. Nested Transactions in 7.5??
  409. between
  410. Is my MySQL Gaining ?
  411. Photos of PostgreSQL booth
  412. Postgresql 7.4.1 Compile problem for SCO 5.0.5
  413. Installing Postgres w/RH9
  414. Where do I get Windows libpq and header files?
  415. Parser does not like %ROWTYPE in the RETURNS clause of a function declaration (BUG?)
  416. SELECT INTO broken (?) in PL/pgSQL when using a set returning function in FROM clause (BGUG?)
  417. getting configure options?
  418. PostgreeSQL C header files
  419. getting configure options?
  420. PostgreeSQL C header files
  421. Mirrors that don't suck.
  422. Join Tutorial
  423. Mirrors that don't suck.
  424. ecpg question
  425. PostgreSQL 7.4.1 Released
  426. Join Tutorial
  427. COPY - Ignore Problems
  428. Parser: parse error - please help...
  429. Normalization and regexp
  430. CHECK versus a Table for an enumeration
  431. hardware requirements under Redhat
  432. ecpg question
  433. postmaster and logrotate
  434. PostgreSQL 7.4.1 Released
  435. COPY - Ignore Problems
  436. Parser: parse error - please help...
  437. Normalization and regexp
  438. CHECK versus a Table for an enumeration
  439. hardware requirements under Redhat
  440. postmaster and logrotate
  441. How to hide database structure
  442. restoring database
  443. extracting date FROM timestamp
  444. Tables Referencing themselves As Foreign Keys
  445. questions about tsearch2 (for czech language)
  446. Groff and Weinberg SQL Complete Reference - Sample database?
  447. bug in query planning?
  448. Where can I learn some more about the rule system?
  449. FEATURE REQUEST: let arrays support null values.
  450. Please remove me from the list, thanks
  451. SELECT ... FOR UPDATE
  452. MySQL Gets Functions in Java - Enlightenment Please
  453. Tables referencing each other
  454. DB & Log Files removed...
  455. Regarding Start of postmaster
  456. automatic verifications
  457. dblink_connect fails
  458. 7.1.3 ecpg
  459. PostgreSQL speakers needed for OSCON 2004
  460. Salvage older PostgreSQL data disk - help?
  461. automatic verifications
  462. Select groupping by one column
  463. Has anyone seen an ADO Provider for Postresql?
  464. Duplication to External Server
  465. authentication failed
  466. performance in selecting from very large recordset
  467. How to navigate tree without CONNECT BY?
  468. pqReadData() -- read() failed: errno=32
  469. Which file system do i have to choose?
  470. BLOBS : how to remove them totally
  471. param max_connections
  472. Check this update from the MS
  473. Function Returning SETOF Problem
  474. Triggers for FK on Views - can they be made deferrable?
  475. bind-dlz with postgresql driver ...
  476. Permissions issue?
  477. Deadlocks with plpgsql
  478. copy command problem
  479. Excel, OpenOffice and Postgres
  480. Need to understand PL/PGSQL, Foreign Key Deferable, and Transactions...
  481. md5 function
  482. Sequence name with SERIAL type
  483. restore error - language "plperlu" is not trusted
  484. Sequence question.
  485. Join Issues
  486. update slows down in pl/pgsql function
  487. 7.4 pg_dump and restore (with postGIS/GEOS)
  488. Firebird and PostgreSQL at the DB Corral.
  489. DB with bytea types reload problem
  490. selecting into a variable like @var=select ...
  491. Authentication Question
  492. Postgres respond after toomany times to a query view
  493. passing array as argument and returning an array in plpgsql
  494. UTF support in WIN32 native and Lower/Upper in 7.5 release
  495. Foriegn Key constraints not enforced when using rules
  496. DBF to PostgreSQL
  497. besides dbfdump........ HOW TO DUMP!
  498. FW: database failure..
  499. Relational data model dead?
  500. deadlock detected when inserting data
  501. Changing user
  502. LIMIT modifier
  503. PostgreSQL on Windows Server 2003
  504. dump and sequence initilizing
  505. password authentication failed for ..
  506. Snippets
  507. windows distribution
  508. database failure..
  509. Calculating total amounts per clientid
  510. Why is postgres an ORDMS
  511. 7.5 features
  512. Delete all records NOT referenced by Foreign Keys
  513. Windows Version of PostgreSQL
  514. Perl "with-perl" configuration option
  515. Error with table
  516. Reordering results for a report
  517. Change date format only for one DB
  518. Moving the database from a filesystem to another
  519. experiences with postgres in ia64 and linux
  520. remark on a slowdown of COPY
  521. Uninstall postgres 7.4
  522. Build Problem in 7.3.5 version
  523. make error Mac OS X (ar: illegal option -- s)
  524. ERROR: JOIN/USING types 'integer' and 'character varying' not matched
  525. Is it not datestyle that determines date format output?
  526. Foreign keys and pg_user table
  527. Weird Problem With PostgreSQL 7.3.1 and VB.Net Datagrid
  528. tablespaces in 7.5?
  529. ERROR: did not find '}' at end of input node (again)
  530. Storing Snapshot Data
  531. sequences not renamed with tables
  532. Any commercial shopping cart packages using postgresql?
  533. Redhat 9.0 Service Shutdown
  534. Moving a database between servers
  535. datestyle in postgresql.conf, version 7.4
  536. Disabling or forwarding external connections
  537. "PostgreSQL Error Code(1)"
  538. highest match in group
  539. Wird behavour of foreign keys
  540. versions of PG
  541. PG 7.4 on Tru64 UNIX 4.0 + threads
  542. JDBC function call: PS vs CS
  543. Users and session ids
  544. Strange permission problem regarding pg_settings
  545. initdb reporting error.
  546. Determining what a user can access
  547. Help: ecpg bytea and PQescapeBytea()/PQunescapeBytea()
  548. Help with Turning debugging on/off
  549. OO database?
  550. PG and AIX