Re: [GENERAL] Sequence reset

On Mon, Aug 23, 2010 at 12:04, SUNDAY A. OLUTAYO wrote: > How can I reset a sequence column due to deletion of some rolls? ALTER SEQUENCE sequence_name RESTART 1; -- - Rikard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://w

Re: [GENERAL] MySQL versus Postgres

On Fri, Aug 6, 2010 at 04:41, John Gage wrote: [...] > So, perhaps what is needed in any sort of battle with MySQL is an > introductory documentation that gives specific examples of how to achieve > "oh wow!" worthwhile results quickly with Postgres. Bruce Momjian's book is an excellent primer:

[GENERAL] Embedded text column versus referenced text

I am in the design phase of a new db so I cannot test queries using explain/analyze yet, but regarding performance, is there any difference in doing this: CREATE TABLE something (name text, age smallint, ...other columns..., comment text); compared to this: CREATE TABLE comments (id serial prima

Re: [GENERAL] New DB-design - help and documentation pointers appreciated

On Sat, Jul 3, 2010 at 03:51, Craig Ringer wrote: [...] > You've hit one of those areas where SQL databases kind of suck. You'll > have to use one of the well understood workarounds like EAV and live > with their limitations, or find a database better suited to the data. Thanks for the feedback

[GENERAL] New DB-design - help and documentation pointers appreciated

Greetings. I'm on the verge designing a new database for electrical components, and I am in need of help. I have designed 3-4 small databases earlier, but these suffer from bad design and I cannot afford bad design for this database (which I surmise will be the biggest I will ever create). My olde

Re: [GENERAL] Table appears on listing but can't drop it

On Fri, Jan 8, 2010 at 17:44, Sam Mason wrote: > There's an extra space at the beginning of the "skynet" line, could it Is there a particular reason space is allowed in name identifiers? I see nothing but confusion if a space exists. -- - Rikard - http://bos.hack.org/cv/ -- Sent via pgsql-g

Re: [GENERAL] How many records to delete ?

On Wed, Jan 6, 2010 at 22:03, shulkae wrote: [...] > I have thousands of records. What is the optimum number of records to > delete in one delete command Optimum in which way? -- - Rikard - http://bos.hack.org/cv/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Auto Vacuum Daemon

On Wed, Dec 2, 2009 at 13:46, wrote: > Is it fine to do that or should we manually perform vacuum and analyze. > > Will it automatically take care of vacuuming the tables and analyzing them? Have a look at this wiki-page that was posted by Craig on this list a few days ago: http://wiki.postgre

Re: [GENERAL] Postgres Dump out of order

On Wed, Dec 2, 2009 at 08:16, Helio Campos Mello de Andrade wrote: > - Postgres generated dump was created out of "foreing key" order and when i > try to recreate my database structures, data and functions. I think there's some information missing here. What happens when you recreate your data

Re: [GENERAL] Strange "bug" in dump ?

On Sat, Nov 28, 2009 at 12:59, Denis BUCHER wrote: [...] > There is a "E" before the street field ! > > This is an extract of the dump : > > 'ST311PHANIE ROBERT', NULL, E'RTE DES TATTES D\\''OIE 5', Sounds like escape quoting to me. You can read about it at

Re: [GENERAL] pg_standby instructions

On Fri, Nov 27, 2009 at 14:19, akp geek wrote: [...] > TypeError: iteration over non-sequence > I am not able to interpret any thing from the above message. Can you please > give me some thoughts I can't say anything about the application itself, but the cryptic message means that the variable

Re: [GENERAL] date_trunct() and start of week

On Fri, Nov 27, 2009 at 08:13, Thomas Kellerer wrote: [...] > I'm just curious which setting defines whether monday or sunday is > considered the "first day in a week" Read 9.9.2 on http://www.postgresql.org/docs/8.1/static/functions-datetime.html and you will see that even if you find such sett

Re: [GENERAL] Books, the lulu.com scam

On Sat, Nov 21, 2009 at 18:10, Yordan Radunchev wrote: [...] > Why should one buy a book? Books are invaluable reading material when "number two" is due. Laptops and on line-documentation doesn't stand a chance in that particular case. Also, I prefer laying down in the sofa reading a book. Using

Re: [GENERAL] Can anyone help setting up pgbouncer?

On Tue, Nov 17, 2009 at 09:13, Nick wrote: > Here's my output. Is it a permission error writing to etc? [...] All files that are tried to be opened (in read only-mode) are successful, but there's a lack of an strace-message prior to pgbouncer's error message. For that particular strace-output,

Re: [GENERAL] createdb errors and more

On Mon, Nov 16, 2009 at 17:55, Reno Bladergroen wrote: > I installed pgsql according to the manual, generated a data folder, changed > ownership to postgres, switched user postgres and initialized the database. > starting the database is also successful (status says running). [...] I assume y

Re: [GENERAL] Can anyone help setting up pgbouncer?

On Sat, Nov 14, 2009 at 00:17, Nick wrote: > Thanks Richard, I updated my users.txt file to include quotes (it > didn't) which fixed the broken auth file error, but now im getting > this... > > 1518 ERROR unconfigured_file: No such file or directory [...] If you are on a system with strace, try