Discussions - pgsql.general

	Will there be an official pg_migrator release?
	Hi, the project page of pg_migrator still shows it as a release candidate. Will there be an official release of it, now that 8.4 is out of the door? Including Windows binaries? Regards Thomas By Thomas Kellerer - 5:03pm - 2 new of 2 messages

Documentation - PgAdmin

Hi, Congratulations on the release of version 8.4. I am surprised that pgAdmin's help link is now directed to the documentation website of postgresql. The embedded help CHM was not packaged with it. This implies that anytime one needs help on a simple syntax, one must connect to the internet. Was this by design or omission?... more »

By db.subscripti...@shepherdhill.biz - 4:27pm - 2 new of 2 messages

	Function Issue and casting
	Hi friends, It's my first time I'm writing to the list. All days I enjoy the list! I declare a function, and when I want to call this, it fails. My function: CREATE OR REPLACE FUNCTION alta_docente(integer,varchar,v archar,varchar,bigint,varchar, integer) RETURNS VOID AS $body$ declare codigo integer;... more » By Juan Pablo Cook - 1:47pm - 3 new of 3 messages

	Start automatically a function at startup of postgresql server
	Dear Sirs, Is it possible to start a function (a my function) when the server postgres is started? and how I can do? Best regards. Domenico Formenton By "dfx@dfx.it" - 4:51am - 2 new of 2 messages

1С: Бухгалтерия 8. Бухгалтерский и налоговый учет хозяйственных операций

13.О7 - 17.071С: Бухгалтерия 8. Типовая конфигурация. Бухгалтерский и налоговый учет хозяйственных операций   Четыре девять пять (это код) четыре четыре пять тридцать два шесть шесть... more »

By Бухгалтеру √ 1С - 3:41am - 1 new of 1 message

Новации - дата вступления в силу и какие счета фактуры надо переделать

Счета-фактуры - кардинальные изменения. Внесены изменения в Правила ведения журналов учета полученных и выставленных счетов-фактур, книг покупок и книг продаж при расчетах по налогу на добавленную стоимость... more »

By Бухгалтеру о счетах-фактурах - 1:54am - 1 new of 1 message

	Pls help
	2009/7/4 Roseller A. Romanos <don2_...@yahoo.com>: ...you cannot copy postgres data files from one computer to second. PostgreSQL is not MySQL. Use pg_dump instead or copy statement. 1. on PC1 pg_dump -t yourtable yourdatabase > yourtable.sql 2. copy yourtable.sql file from PC1 to PC2 3. on PC2 psql yourdatabase < yourtable.sql... more » By Pavel Stehule - 12:40am - 8 new of 8 messages

Практические аспекты формирования и представления полугодовой бухгалтерской отчетности

Практические аспекты формирования и представления бухгалтерской отчетности за первое полугодие 2009 г, обзор изменений, вступивших в силу с 2009г8- Iюlя.2009 г. (Код Москвы)792 2I 22; ЧЧ5-З9-68,... more »

By Бухгалтеру √ полугодовой отчет - Jul 3 - 1 new of 1 message

Store derived data or use view?

I have a table which stores the absolute longitude of a planetary position, eg: MERCURY --------------- 157.65 SATURN ------------- 247.65 When 2 planets are a certain distance apart there is an 'aspect', eg. 90 degrees is a "square" aspect I wish to record these aspects for different user profiles and eventually do searches for users who have the same aspect(s). Would it be better, in terms of search speed/efficiency, to calculate and store the aspect data, eg. Mercury/Saturn square, or should I just store the longitude data and create a view with the calculated aspects? I anticipate a large dataset of users so search speed/efficiency is very important.... more »

By gvimrc - Jul 3 - 4 new of 4 messages

REINDEX "is not a btree"

Hello! I got into a situation I don't know how the get out .. First, I could not access to my biggest database in postgre anymore because it suddenly gave the error (after long time working with no problems) ...After trying with several backups with no success, I did a vacuum and I tried to REINDEX the database (in the standalone back-end).... more »

By Vanessa Lopez - Jul 3 - 2 new of 2 messages