Sponsored Links

comp.databases.postgresql comp.databases.postgresql

Page 7 of 12

Threads in Forum : comp.databases.postgresql

Rating Thread / Thread Starter	Last Post	Replies	Views
drop database not working ( 1 2 3 4 ) Tomcat 5.5, Java 1.5, Postgres 8.2. I use jndi to access resources. When I try to delete a database, listed in the context.xml, I get the message:... Sylar surfer	06-20-2008 11:52 AM Sylar Surfer	32	168
Determine length of bitfield ( 1 2 3 4 ) Hello list, I'm currently trying to insert data into a table which contains a bit(32) field. However, the "32" bits should be kept variable, that... Johannes Bauer	06-16-2008 07:20 AM Laurenz Albe	32	197
English help: name a boolean value that means "if it makes senseto calculate the sum of the field" ( 1 2 3 4 5 ... Last Page) Dear all I have a db table for all fields used in a calculation. id field_name ------------- 01 Telephone Number 02 Number of Children ... ... Zhang Weiwu	06-16-2008 02:50 AM Zhang Weiwu	96	339
unique index considering nulls as equal ( 1 2 ) Hi, i have a table with the columns id, pid, nodetext which represent a tree. Root elements are signed by providing NULL for pid, i.e. 1 NULL... Thomas Winkler	06-12-2008 04:33 AM Thomas Winkler	16	86
Oraclite in need of help Hi! I am an Oracle DBA in need of PgSQL documentation. Where can I find the documentation describing: 1) PostgreSQL data and index block formats 2)... Mladen Gogala	06-11-2008 05:50 AM Mladen Gogala	0	74
Windows installation & secondary logon (using 8.2 on win server 2003) Our company embeds postgres in our product and we've run into a small installation problem... a few of our customers... Carl Zwanzig	06-09-2008 02:40 PM Carl Zwanzig	0	70
Simple asynchronous replication - anything? ( 1 2 ) Hello... I spent some time looking for - what I thought - simple and frequently used thing: some solution to asynchronously pull changes from... Marcin Kasperski	06-06-2008 06:51 PM Marcin Kasperski	16	92
Translation from textfields Hello, first, sorry for a little bit off topic. We plan a database and need also a translation from some text. We have textfields in multiple... Andreas Kraftl	06-04-2008 02:32 AM Laurenz Albe	8	62
Internal functions show up in PostgreSQL DB All, Not sure what happened here, but 'internal functions' now just up when I do a restore from a previous pg_dump file that I have. Functions such... Titus Barik	05-28-2008 02:16 PM Titus Barik	8	58
Replication with Slony-I Hello all, my doubt is related with replication in Postgres using Slony-I. I read the manuals and understood that the postgres slave (client) should... EBMB	05-28-2008 01:54 PM EBMB	0	46
In-memory PostgreSQL database ( 1 2 3 4 5 ... Last Page) Howdy all, I'm using PostgreSQL as the server for several of my applications, but unit testing the application by setting up and SQLite... Ben Finney	05-26-2008 08:11 AM dnoyeB	232	585
Change datadir ( 1 2 3 ) Hello, I have a newly installed postgresql-8.3 on a debian 4.0 machine. I installed it from backports.org. What is the best way to change the... Andreas Kraftl	05-26-2008 02:39 AM Laurenz Albe	24	190
Duplication remove Example TABLE AAA Data1,Data2,Data3,Data4 11,1,3,4 22,2,2,4 33,2,2,4 44,2,2,4 55,3,4,5 Paolo Holzl	05-16-2008 03:02 AM Laurenz Albe	8	63
the phantom record Hi, I have two real tables in a database, I am comparing some values and can notice that queries that are supposed to return the same values differs... Coniglio Sgabbiato	05-12-2008 10:04 AM Coniglio Sgabbiato	8	65
noob postgres download, what file? http://www.postgresql.org/ftp/ what do i need to download exactly? isnt there one buttont o click to download everything necessary? i will use it... globalrev	05-10-2008 11:33 AM Roland Walter	8	49
format interval as days ( 1 2 3 ) Hi! I'd like to represent an interval like '1 day 1h 2m 12s' in days, in this case 25 Apparently SELECT to_char(interval '1 day 1h 2m 12s', '... Patrick Scharrenberg	05-09-2008 05:45 AM Patrick Scharrenberg	24	159
Software for database design Hello, which Software is recommanded to use to design the database? Perfect would be an offline design-tool which can transform to the... Andreas Kraftl	05-09-2008 04:07 AM Andreas Kraftl	0	50
psql commandline use ( 1 2 3 4 5 ... Last Page) Hi, I mostly use PG from command line, I wish to get a command that enable me to see already defined functions, procedures, triggers etc etc. I... Coniglio Sgabbiato	05-04-2008 12:30 PM Coniglio Sgabbiato	56	258
How to get all tables+rows which have a foreignkey reference to arow ( 1 2 ) Hi, MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given... Thomas Guettler	04-30-2008 03:50 AM Coniglio Sgabbiato	16	92
pg_restore: Ignore ALTER .. OWNER TO ... Hi, is it possible to restore a dump and ignore all ALTER .. OWNER TO ... statements? I try to run pg_restore -1 ... (single transaction) to be... Thomas Guettler	04-30-2008 03:30 AM Laurenz Albe	8	49
weird question ( 1 2 ) Hi, due to compatibility with legacy database codes I need to catenate two numeric fields filling the gaps with zeros. For example take a table with... Coniglio Sgabbiato	04-29-2008 07:55 AM Coniglio Sgabbiato	16	125
Possible: using ordinal number instead of column name ( 1 2 ) Hi there, to have it easier using one trigger doing similar things on different tables I was wondering if it would be possible to use the ordinal #... Anton Huber	04-28-2008 03:40 AM Laurenz Albe	16	93
convert character varying to int ( 1 2 3 4 5 ) Hi, I'm using postgres sql 8.1x anyone can help convert a character varying to int? I have a table with : attribute \| character... RJ	04-21-2008 05:06 AM Andreas Kretschmer	48	196
passing password to psql, pg_restore etc.? ( 1 2 3 4 ) Hello. How to pass password in these commands, without beeing prompted, and without pgpass.conf? psql -h localhost -p 5432 -U postgres -f... Skeptik	04-11-2008 03:00 PM Skeptik	32	213
Re: pg_trgm ( 1 2 ) Marian Aldenhövel <marian (AT) mba-software (DOT) de> wrote: I looked at the package you downloaded, and it really does only contain one contrib... Laurenz Albe	04-10-2008 09:47 AM Laurenz Albe	15	140
how can i get postgresql installer source code? hi folks: what tools does postgresql use to make it installer? NSIS or Installshield (Install anywhere?) . How can i get these installer source code?... zhenchen17	04-07-2008 04:11 AM Laurenz Albe	8	54
REVOKE does not work! ( 1 2 3 4 5 ... Last Page) Hi, I created a new role as owner of a new schema that is different from the public one. The new role wasn't created as superuser. Some time after I... Coniglio Sgabbiato	04-04-2008 12:24 PM Coniglio Sgabbiato	64	237
Calling C DLL functions from PostgreSQL (PGSQL) I ahev written a win32 D DLL and exposed its functions so I can call it from PG. However, I want to export the function names by ordinal, rather than... Ronald Raygun	04-03-2008 04:11 AM Ronald Raygun	0	44
Updating multiple tables "simultaneously" ( 1 2 3 4 5 ) I want to be able to update several tables "simultaneously". I have a data entity that is stored accross multiple tables, in a normalised db schema... Ronald Raygun	04-01-2008 07:58 AM Andreas Kretschmer	48	211
How to re-order fields in table? ( 1 2 3 4 5 ... Last Page) Hi, How can I change columns order in an existing table? I went through PG manual, also asked google but could not find answer, anyone... Dariusz Pelka	03-28-2008 04:34 AM Marco Mariani	64	281
tsearch2: List of lexemes and their count Hi, How can you get all lexemes of an indexed column and how often they occur? This would help me to find words which should be added to the stop... Thomas Guettler	03-26-2008 04:26 AM Laurenz Albe	8	43
Postgre insert without duplicate ( 1 2 3 ) Insert in a big table without duplicate is very slow. I cannot recreate the table for example using distinct. Making an insert using in o exists is... Paolo Holzl	03-21-2008 07:00 AM Laurenz Albe	24	124
Better index Table AAA ID (PrimaryKey) Progres (Integer) DateAndTime (datetime) xxx (Integer) to execute this select on a big table SELECT... Paolo Holzl	03-21-2008 06:51 AM Laurenz Albe	8	77
VACUUM interruption Of the times the execution of VACUUM asks for too time therefore I want to interrupt. Now to do it I shutdown the system. It exists a better system... Paolo Holzl	03-21-2008 06:40 AM Laurenz Albe	8	65
Update inner join ( 1 2 3 4 ) In SQL Server is it possible to create an update inner join without use of slow IN or EXIST. In postgresql is it possible? -- Paolo Holzl	03-20-2008 06:42 AM Paolo Holzl	32	167
PL/Perl and transactions ( 1 2 ) Hello! I need to do SELECT and DELETE as a single atomic operation. Is it possible to use transactions in Postgresql PL/Perl functions? If yes, how?... Vesa-Matti Kari	03-14-2008 04:09 AM Vesa-Matti Kari	16	92
Running PostgreSQL without installation? ( 1 2 3 4 5 ... Last Page) On 14 Feb., 13:34, Toby A Inkster <usenet200... (AT) tobyinkster (DOT) co.uk> wrote: write that we use Java. I have a look at the JDBC driver for... moin	03-13-2008 05:00 AM moin	56	223
automated schema chart generation from postgres - does it exist? ( 1 2 3 ) Hi all, First of all, sorry for the bad English, I'm Italian. I like to create and manage tables, relation, and whatsoever db object from... Coniglio Sgabbiato	03-10-2008 12:43 PM Coniglio Sgabbiato	24	128
client library installation ( 1 2 3 ) Hi, I cannot find out from postgresql.org the tar.gz client library installation from linux, does someone knows the procedure to install only... Coniglio Sgabbiato	03-10-2008 10:06 AM Laurenz Albe	24	123
drop table 'foo%' ... I want to drop all tables which start with a common prefix. I found this solution. Are there better/different ones? psql -t -d mydb -c "SELECT 'DROP... Thomas Guettler	03-04-2008 05:44 AM Laurenz Albe	8	56
Data model Hello All, I would like to know if someone could to lead me a good free software tool to make my logical database models. I am using "DBDesigner",... eduardo.bmbarbosa@gmail.com	02-27-2008 09:22 AM Sascha Bohnenkamp	8	89
advice needed for update of a table ( 1 2 ) Hi, I want to update one table of my database and I would like to know what is the fastest way to do it. I'm using postgresql version... luislupe@gmail.com	02-26-2008 07:19 PM luislupe@gmail.com	16	97
Column Data Type Hi, I looking for a way to dynamically find the data type of a column in table1, so I can then dynamically add a column in table2 of the same data... Dan	02-26-2008 10:24 AM Laurenz Albe	8	74
Postgresql user name doesn't match login We have a peculiar situation on one HP-UX site. We have a function which tests for user name, but the user name it sees is not the same as the login... Al Balmer	02-26-2008 10:04 AM Laurenz Albe	8	39
alter table alter column: from integer to serial? Hi, how to update a primary key column from type integer to type serial? foo=# alter table footable alter column id type serial; FEHLER: Typ... Thomas Guettler	02-23-2008 06:07 PM HansH	8	53
Stored Procedure Salve a tutti, sono Christian e questo è il mio primo post Vole chidervi come implementare le stored procedure (o semplicemente procedure) in... sbrandollo	02-19-2008 11:22 AM sbrandollo	0	85
Have AMD64 with pg8.2. Have backup of 8.0/i32 db dir. Any ideas? Hello, The problem as in the title: I am currently using some ubuntu/AMD64 with postgresql 8.2 on the board. And it just turned out that I need to... Marcin Kasperski	02-16-2008 05:19 AM Marcin Kasperski	0	62
gui function Is postgresql has gui function? If it is, would anyone please shed a light how to start up? Thanks. moongeegee	02-12-2008 04:57 PM Ben Finney	8	41
txid_current() and dump/restore Hi, from: http://www.postgresql.org/docs/8.3/interactive/functions-info.html ''' txid_current() bigint get current transaction ID The internal... Thomas Guettler	02-11-2008 11:10 AM Thomas Guettler	0	81
social security concerns Matt, Alex: I asked my mother and found out that my sister never actually divorced her Muslim ex-husband. She is drawing "widow" social security or... Joe Stateson	02-08-2008 10:52 AM Lew	8	54

Page 7 of 12

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off